Version 18.1
1. Updated local settings and project file storage for future development compatibility
2. Added ‘Column Select’ as a Quick Select option
3. Added Systems Tree support for the following:
- Postgres – Indexes, Sequences
- Databricks – User Defined Functions
- Teradata – User Defined Types
- SQL Server – Sequences
- Azure/Synapse - Sequences
- Greenplum – Indexes
- Vertica – Stored Procedures, User Defined Functions, Sequences, External Tables
- Snowflake – User Defined Functions, Sequences, External Tables
- MySQL – Indexes, Stored Procedures, User Defined Functions
4. Added System Tree displayed database filter for the following:
- Postgres, Databricks, Azure/Synapse, Vertica, Snowflake, MySQL
5. Fixed an issue where an initial install of Nexus may generate blank (non-default) settings
6. Added ability to automatically drop connections between queries
7. Added ability to define connections without username/password for greater authentication method compatibility (Kerberos, etc.)
8. General bug fixes
Version 18.0
1. Added enhanced utility-based data set migration
2. Expanded data set drag/drop into tree
3. Locked letter case on drag/drop table creation
4. Better date/timestamp migration handling
5. Pushed concurrent split limits to exports/imports functions
6. Changed threading method in data migration functions
7. Fixed bug in data movement options where some settings where not being honored
8. General data migration bug fixes
9. Expanded Super Join Builder analytics support
10. Better table and column naming letter case handing in Super Join Builder temporary table creation
11. Locked letter case on Super Join Builder table creation
12. General Super Join Builder big fixes
13. Added system name to history search
14. Updated build dependency list
15. Bizstar bug fix (certain functions containing single quotes not being saved)
16. Fixed bug in server-based partitioned quantile calculations
17. Fixed bug in server-based grouping set calculations
18. Fixed server-based rank calculations on server returning nulls
19. General Bizstar bug fixes
20. Minor theme appearance changes
Version 17.6
1. Added Databricks as a database type
2. Added Upload to DBFS import type (to Databricks)
3. Several other additional migration types added
4. Join Builder processing update
5. Added options search
6. General bug fixes
Version 17.5
1. Join Builder UI update
2. Several additional federated join types added
3. Added theme creation and editing to Nexus
4. Updated Result Set Filtering feature set
5. Fixed issue with Named Parameters over multiple queries not being correctly applied
6. General bug fixes
Version 17.0
1. Several additional data movement methods added (definition conversion, data export, data import)
- Movement from Teradata, Netezza, Oracle, SQL Server, DB2, Greenplum, Excel, Vertica, MySQL, Postgres, SAP Hana, SQLite, Snowflake, Yellowbrick, BigQuery, Access, Hadoop, Redshift, and Azure
- Movement to Teradata, Netezza, Oracle, SQL Server, DB2, Greenplum, Vertica, MySQL, Postgres, SAP Hana, SQLite, Snowflake, Yellowbrick, BigQuery, Access, Hadoop, Redshift, and Azure
2. Added ability to retain editor text on exit
3. Added ability to hide editor floating menu
4. Added ability to open multiple .sql files (same window or multiple windows)
5. Added ability to return blob fields as files
6. Bug fixes in data movement
7. General bug fixes
Version 16.0.84
1. Bug fixes
Version 16.0.73
1. Added support for lowercase Netezza systems
2. Added ability to view query results in new tab
3. Bug fixes
Version 16.0.70
1. New Ribbon layout
2. Added Themes (standard, dark mode, etc.)
3. Data migration – more table level options added
4. Export/backup local for Yellowbrick and Snowflake added
5. Import/restore local for Yellowbrick and Snowflake added
6. Export/backup cloud (AWS/Azure/Google) for Yellowbrick and Snowflake added (beta)
7. Import/restore cloud (AWS/Azure/Google) for Yellowbrick and Snowflake added (beta)
8. Bug Fixes
Previous Version Changes:
Version 15.5.88
1.Fixed issue wtih displaying Teradata macros and stored procedures.
2.Fixed missing assembly issue on data export.
Version 15.5.87
1. Added Salesforce as a data source.
2. Added data movement from Salesforce to Azure Synapse.
3. Added data movement from Salesforce to DB2.
5. Added data movement from Salesforce to Oracle.
6. Added data movement from Salesforce to SAP Hana.
7. Added Access as a data source.
8. Added Access to cache tree.
9. Added data movement from Access to SQL Server.
10. Added data movement from Access to Azure Synapse.
11. Added data movement from Access to DB2.
12. Added data movement from Access to Oracle.
13. Added data movement from Access to SAP Hana.
14. Added data movement from S3 to Yellowbrick.
15. Added S3 to yellowbrick support for ybrelay to support orc, parquet and other semi-structured files.
16. Added data movement from Greenplum to Redshift.
17. Added data movement from Redshift to Greenplum.
18. Added bulk copy option for data movement from SQL Server to Greenplum.
19. Added bulk copy option for data movement from SQL Server to Redshift.
20. Added bulk copy option for data movement from Oracle to Greenplum.
21. Added bulk copy option for data movement from Oracle to Redshift.
22. DDL Conversion has been integrated into the same control as data movement.
23. Added comments for DDL conversion to Yellowbrick.
24. Added sort on DDL converstion from Netezza to Yellowbrick.
25. Added rows and bytes per transaction to Yellowbrick data movement.
26. Added external encoding option for NZ External Tables to Yellowbrick.
27. Made changes to the Super Join builder as hub joining Teradata.
28. Added Snowflake create table in the Super Join Builder.
29. Fixed generic connection issue when data source has no catalog.
30. Fixed issue on how we pull catalogs for generic odbc connection.
31. Fixed S3 to Yellowbrick display issue in flat file loader.
32. Fixed metadata issues on Greenplum version 6.
33. Changes to how Nexus collects metadata for some systems.
34. Changes to how Nexus converts multiple table structures for DDL conversion.
Version 15.5.20
1. Google BigQuery is now supported in the query tool and data movement.
2. Added data movement from Teradata To Google BigQuery.
3. Fixed missing table name issue in SQLite.
4. Added end of transmission (Ctrl+D) as a delimiter option for direct data export.
5. Fixed ldap issue when pulling databases for hound dog compress.
6. Added ON_ERROR to Snowflake data movement.
7. Added analytic comparison from Snoflake to Netezza comparison.
8. Fixed PERIOD(DATE) issue in compare.
9. Fixed INTERVAL and PERIOD data types when moving data using TPT Export and Direct Data Export.
10. Fixed timestamp, time an date conversion from Greenplum to Teradata.
11. Fixed view DDL issue for SQL Server.
12. Fixed missing member excpetion when dragging and dropping answer sets into various data sources.
13. Fixed issue when there is a non-numeric in Teradata's version number.
14. Fixed issue when displaying timestamp when using the Teradata 17.x ODBC driver.
15. Fixed issue adding data sources when the version number is null.
16. Fixed issue moving VARCHAR UNICODE data from Teradata.
17. Fixed autosave issue which was causing Nexus to freeze in some circumstances.
18. Fixed issue determining if a postgres table already exists.
19. Fixed issue writing flat file when moving data from Oracle to MySQL using SqlPlus/Parallel Table Import
20. Updated copyright information and specs in readme file.
21. General bug fixes.
Version 15.5.1
1. Fixed issue with Timestamp with Time Zone format if multiple columns have this data type.
2. Fixed user impersonation issue on Nexus Server when moving data from SQL Server to Yellowbrick.
3. General bug fixes.
Version 15.5.0
1. Amazon Athena is now supported.
2. Added Yellowbrick import from flat file and Excel.
3. Export from Yellowbrick using ybunload has been added.
4. Nexus now supports ybrelay from Hadoop to Yellowbrick via Linux.
5. Added data movement from Netezza to Yellowbrick.
6. Added data movement from Teradata to Yellowbrick.
7. Added data movement from Yellowbrick to Teradata.
8. Added Netezza external table export as an option in the database mover.
9. SQL*Plus has been added as an export option when moving from Oracle to Yellowbrick.
10. Bulk Copy is now a supported movement type from various systems to Yellowbrick.
11. Added an ELT option to the table options panel and other enhancements.
12. Manual index selection was added for Yellowbrick data movement.
13. A new system tree node has been added for one-click execution of query favorites and federated queries.
14. Nexus will now try to find the user's most used databases or schemas and show them first.
15. Data movement between Netezza and Snowflake can now be scheduled.
16. Fixed date and timestamp issues when moving to Yellowbrick using gpfdist.
17. OS Connections can now be authenticated via a key file.
18. Data movement logging has been improved to show timing.
19. Yellowbrick tree enhancements.
20. Postgres tree enhancements.
21. Added XML file on server for version check.
22. MyDatabase fixes.
23. Database export control has been redesigned.
24. Removed "key" table from this file.
25. Nexus Server general UI work.
26. Removed several unused resources.
27. General bug fixes.
Version 15.1.0
1. Added Yellowbrick query support
2. Added movement to Yellowbrick from Teradata, Oracle, SQL Server, Azure SDW, DB2, SAP Hana, Hadoop, Greenplum, Redshift, Yellowbrick, Netezza, Snowflake, MySQL, and PostgreSQL.
3. Added movement to MySQL from Oracle, SQL Server, Azure SDW, DB2, SAP Hana, Hadoop, Greenplum, Redshift, Yellowbrick, Netezza, Snowflake, and PostgreSQL.
4. Added data import from S3 to Teradata.
5. General Nexus Server fixes.
6. General Super Join Builder fixes.
7. General Data Movement fixes.
8. General bug fixes.
Version 15.0.10
1. Added data movement from Teradata to PostgreSQL.
2. Added data movement to Teradata from MySQL (Stream and Load operators).
3. Added data movement from MySQL To MySQL.
4. Added data movement from MySQL to Teradata.
5. Added Teradata view DDL at database level.
6. Added MySQL result set drag and drop support.
7. Added PostgreSQL result set drag and drop support.
8. Updated compress value selection connection.
9. Added multi object drop control.
10. Added letter case selection to Universal ODBC Connection.
11. Added Snowflake to Super Join Builder.
12. Added MySQL to Teradata to Super Join Builder.
13. Added Scheduled Queries to NexusCore.
14. Added Scheduled Queries Save to MySQL and PostgreSQL to NexusCore.
15. Added logging views to NexusCore control panel.
16. Updated logging views to NexusCore control panel.
17. Added Scheduled process calendar view.
18. Added Scheduled process day view to NexusCore control panel.
19. Added AWS session token support.
20. Bulk Copy to PostgreSQL column case issue fixed.
21. PostgreSQL to Snowflake column case issue fixed.
22. Fixed issue pasting into active query window.
23. Super Join Builder visual scaling issue fix.
24. Super Join Builder remote table save fixes.
25. Fix for NexusCore database error when checking process logs.
26. Fixes to error with display of NexusCore calendar.
27. Fixed issue w/generic MySQL explain display type.
28. Bug fixes and enhancement for import and export.
29. gpfdist interaction fixes.
30. Fix for multiple previous scheduled processes being displayed.
31. General NexusCore fixes.
32. General Super Join Builder fixes.
33. General Data Movement fixes.
34. General bug fixes.
Version 14.2.0
1. Added data movement from SQL Server to Snowflake.
2. Added data movement from Teradata to Snowflake.
3. Added data movement from Oracle to Snowflake.
4. Added data movement from Azure SQL Data Warehouse to Snowflake.
5. Added data movement from SAP Hana to Snowflake.
6. Added data movement from Netezza to Snowflake.
7. Added data movement from Redshift to Snowflake.
8. Added data movement from Greenplum to Snowflake.
9. Added data movement from Postgres to Snowflake.
10. Added data movement from Db2 to Snowflake.
11. Added data movement from Netezza to Redshift.
12. Added data movement from Netezza to Oracle.
13. Fixed issue with YAML/GPFDIST setting in data mover UI.
14. Fixed some drop down boxes which didn't match user-defined sorting.
15. Added Netezza to Oracle to Scheduler.
16. Added Netezza to Redshift to Scheduler.
17. Fixed issue with a stale external table name property in data movement.
18. Fixed case-sensitivity issue for hub systems in the Super Join Builder.
19. Minor UI changes in the data source connection form.
20. Fixed issue where continuing database mover after error would result in processing issues.
21. Fixed issue with BCP export to Greenplum.
22. Updated copyrights to 2020.
23. General bug fixes.
Version 14.1.0
1. Answer sets dragged and dropped to a MySQL table node will create the table using CDW's BulkCopy.
2. When moving data to Snowflake an option was added to allow splitting of export file into multiple files to assist parallel loading.
3. Added Snowflake support to NexusCore.
4. Fixed an error when building select list for some data movement types.
5. Fixed Greenplum quoting of reserved words in data movement.
6. Added new Greenplum keywords for syntax highlighting.
7. Fixed NULL reference issue related to yaml object creation for Greenplum data movement.
8. Fixed issue where default where clause could be created incorrectly in the Super Join Builder.
9. Fixed issue in Nexus core which could strip indexes in DDL conversion for data movement table creation.
10. Fixed object name case issue in Greenplum data movement.
11. Small updates to NexusCore settings UI.
12. Updated compression sample syntax to allow greater sample range.
13. Added -z switch to tbuild command line to allow removing checkpoint files completely.
14. Import and export NULL in database mover should be set to the same value to avoid user mismatch.
15. BizStar bug fixes.
16. Garden of Analytics bug fixes.
17. Added data analytics quick launch bar.
18. Added additional cache tree scannable systems.
19. Other general bug fixes.
Version 14.0.0.2
1. Fixed missing assembly issue in the Wow64 version.
2. Optimized query to pull compression candidates in the compression module.
Version 14.0.0
1. The database data movement control has been re-designed.
2. Added basic support for MySQL.
3. Added basic support for Snowflake.
4. Added data movement from Teradata to Greenplum.
5. Added data movement from Oracle to Greenplum.
6. Added data movement from SQL Server to Greenplum.
7. Added data movement from Hadoop to Greenplum.
8. Added data movement from Greenplum to Greenplum.
9. Added data movement from Teradata to MySQL.
10. Added data movement from Teradata to Snowflake.
11. Added data movement from Greenplum to DB2.
12. Added data movement from DB2 to Redshift.
13. Added data movement from Greenplum to Hadoop.
14. Added data movement from Redshift to Redshift.
15. Added DDL conversion from Teradata To MySQL.
16. Added DDL conversion from Teradata to Snowflake.
17. Added object search capabilities via Nexus cache to system tree and data movement.
18. Fixed conversion issue from Netezza NCHAR to Teradata CHAR
19. Added new spreadsheet control with pivot table support.
20. Added new query toolstrip for quick access to analytic features.
21. Added additional threading to the system tree.
22. Users can now resize text on the main query window with CTRL + Mouse Wheel.
23. Several syntax changes to Quick Select and Query Templates for easier execution.
24. Quick Select will position cursor at the end of the inserted SQL.
25. System combo box and drop down will adjust to match text size.
26. Updated the reordering of tree nodes to match the system tree text size and color.
27. Updated many of the system tree icons.
28. Added additional licensing constraints. Current contracts will not be affected.
29. Trial license has been changed to 7-days on Nexus.
30. Updated .NET Data Providers for DB2, Oracle, Teradata and SAP Hana.
31. Fixed cascade issue in GUI when moving to Redshift.
32. Fixed issue in data movement due to a threading issue when resetting the form.
33. Data movement to Teradata now supports INSERT, UPDATE, STREAM and LOAD operators.
34. Added configuration of license properties to NexusCore through the server.
35. Added properties file to control timeout on licensing.
36. Fixed issue handling special characters in passwords on Teradata.
37. Fixed obfuscation issue with modify and create user statements on Teradata.
38. Modified start-up of Nexus to improve performance.
39. Partial passwords appearing in Sqoop log will now be hidden.
40. Added error handling for loading of corrupt auto-save files.
41. Fixed display issue with null column attributes in Redshift.
42. Fixed default schema issue when creating an Oracle connection.
43. Fixed issue with integer variable overflowing when row count of query goes over max integer size.
44. Fixed issue where a missing bin file could throw an error when opening the settings panel.
45. Fixed schema append on target table name when moving data from schema-based systems.
46. Fixed SJB issue where decimals were too long in metadata controls.
47. Additional debugging and messaging added to NexusCore joins.
48. Fixed Teradata to Oracle index conversion issue.
49. Fixed a null issue in byte arrays data returned from the data reader.
50. Fixed index conversion issue when moving from Teradata to SQL Server.
51. Made several stability updates to NexusCore.
52. Resolved an issue with "phantom join" on NexusCore using the demo database.
53. NexusCore will now automatically create ODBC entries needed for data movement.
54. Fixed several issues when moving data from Greenplum to SQL Server and Oracle.
55. Added coalesce to quick export and data movement export to export NULL values as specific text.
56. Added cross-system joins to NexusCore.
57. Added Greenplum flat file loader.
58. Made several performance improvements related to memory consumption.
59. Fixed issue moving NCHAR data from SQL Server to Teradata.
60. Fixed issue moving NUMBER(*) data type from Oracle to Teradata.
61. Byte Arrays such as BLOBS will be converted to hexadecimal when direct data exporting to a flat file.
62. Added SyncLock in Super Join Builder to prevent local SQL SERVER CE database access errors.
63. Added several Super Join builder GUI fixes.
64. Added Super Join Builder analytics fix.
65. Fixed issue with adding saved joins in the Super Join Builder.
66. Implemented drag and drop on existing table to create join in Super Join Builder.
67. Fixed secondary connection issue when trying to change databases.
68. Greenplum connected database will now display in the database drop down.
69. Updated wire protocol drivers to the latest hot fixes.
70. Added additional warnings to DDL conversion when a query returns no columns due to access rights.
71. Added additional options for TEXT to VARCHAR conversion for Postgres to SQL Server.
72. Fixed timeout issue on BizStar for Hadoop hive queries.
73. Fixed issue display NUMERIC data with no precision or scale in Postgres.
74. Fixed issue with schema combo box population in data movement.
75. Fix several DB2 z/OS bugs.
76. Updated DB2 z/OS system tree and menu items.
77. General bug fixes.
Version 13.1.43
1. Removed progress bar and help text on single node scans in hierarchy to help with display issues on some systems.
2. Fixed Postgres mixed-case issue which was affecting data movement from Postgres to SQL Server in some instances.
3. Added additional error checking in hierarchy.
4. Fixed Netezza create table naming issue on data movement.
Version 13.1.41
1. Modified hierarchy to pull all table and views and not restrict on access rights.
2. Fixed Postgres cross-database connection issues in query window and data movement from Postgres.
3. Users can now change their database in Postgres using the database drop down. Populate this via My Databases.
4. Fixed secondary crash after an error had already occurred due to an improperly formatted Message Box in the spreadsheet control.
5. Fixed an obfuscation issue with hierarchy settings.
6. Fixed a minor issue with system node order after adding a new system and the user had already sorted their system tree.
7. Minor spreadsheet revision to fill button.
Version 13.1.39
1. Nexus tree search is now available on all supported systems.
2. Nexus Spreadsheet is now available. Right-click on any result set and select "Send to Spreadsheet...".
3. Users can now re-order tree nodes by right-clicking on the Systems tree and selecting "Reorder data sources...".
4. Auto-recovery feature for SQL has been added.
5. SmartCompress has been removed from Nexus. Use Hound Dog Compress.
6. Use CTRL+minus and CTRL+SHFT+minus quick keys to comment and uncomment SQL.
7. Users can now reference a file in data movement to populate DNS entries used by Teradata Parallel Transporter.
8. Updated IBM DB2 .NET to fix issue when moving decimals from Oracle to DB2 and NULL is the first value in the table.
9. Fixed issues moving CHAR(N CHAR) and NCHAR data from Oracle to Teradata.
10. Fixed index generation issue when converting DDL from Teradata to Oracle and SQL Server.
11. Fixed threading issue when pulling columns into the Super Join Builder.
12. Fixed several issues with activating generic licenses offline.
13. Updated licensing provider to the latest version.
14. Added "New Feature" popup to help users see what is new in the current release.
15. Hound Dog Compression can now generate CREATE TABLE in addition to ALTER compression SQL.
16. Added additional column attributes to ALTER TABLE statement in Hound Dog Compress to avoid update errors when adding compression.
17. Added threading to the pivot control.
18. Fixed an issue pivoting data when the sort condition contained columns not in the sort list.
Version 13.0.11
1. .NET Framework 4.5.2 is now a requirement for Nexus Chameleon.
2. The new NexusCore Server and messaging is now supported on the Nexus Chameleon client.
3. Added server scheduler button which will allow scheduling data movement on server between Teradata, SQL Server and Netezza.
4. New flat file/Excel loader will load data in bulk onto Teradata, Netezza or SQL Server.
5. Added single-table and database data movement from Postgres to Netezza.
6. Several new advanced options have been added to the single-table mover for data movement to Teradata.
7. Added Python editor. Python for Windows is required to use this feature which can be downloaded from Python.org.
8. Updated almost every control in Nexus to the latest .NET 4.5 version.
9. Fixed unique table naming issues in database mover.
10. Fixed an issue where the main query toolbars were not remember their last position.
11. Fixed illegal character issue in script path when using TPT for data movement.
12. Fixed display issue when using mouse scroll wheel in the database mover.
13. Fixed data movement issue relating to database with spaces in their name moving to Teradata.
14. The Greenplum tree has been updated.
15. Fixed performance issue when pulling Apache Drill schemas.
16. Fixed threading issue with direct data export when using it on multiple-tabs.
17. Fixed several issues relating to displaying the password dialog when a password is not saved.
18. Changed processing in data movement to better handle when DDL conversion fails.
19. Fixed several issues relating to blank default databases in database drop down.
20. Garden of Analysis databases can no longer be modified externally via Nexus.
21. Removed and cleaned up old assemblies which are no longer used.
22. Removed dynamic graph tab from Garden of Analysis.
23. Removed old SmartReplica code as data movement classes are used in its place.
24. Removed old SmartCompress. Use Hound Dog Compress now.
25. Removed TeraTrivia.
26. Added export dialog to allow user to choose export options such as column headers and delimiters.
27. Added threading to query grid Save As...
28. Added Error Limit parameter to data movement on Teradata.
29. Added informational dialog when user selects direct data export.
30. Under Tools > Options > Data Movement a place was added to allow a user to reference a file which
contains DNS entries and are used to populate the Teradata TDPID drop down.
31. Updated IBM Db2 .NET driver to fix NULL value issue when moving decimal values from Oracle.
32. Modified how we pull some metadata on Db2 z/OS.
33. Fixed some cross-threading issues when switching tabs in the main query editor.
34. Updated licensing code.
35. Code signing file has been updated.
Version 12.1.1
1. Added Compare/Sync from Netezza to Teradata.
2. Added Netezza to Teradata in the Super Join Builder.
3. Added the ability to configure shared memory when moving data using TPT.
4. Added WHERE clause to compare/sync database compare.
5. Updated readme and copyright information.
6. NUMBER(*,) will now display as NUMBER in Oracle system tree.
7. Fixed issue moving Oracle number data type without precision and scale to Teradata using data mover.
8. Fixed issue with cancellation of flat file mover.
9. Fixed issue moving data from Excel to other data sources when column contains a space.
10. Fixed tdpid as nothing issue when using remote execution and fastload.
11. Updated Netezza Join Builder Database Create SQL.
12. Fixed issue executing macros from Macro Builder.
13. Fixed issue executing queries with parameters.
Version 12.0.1
1. Added single-table and database movement from Netezza to Teradata.
2. Netezza tree updates.
3. Fixed issue with password dialog popping up when hitting Execute Query.
4. Added way to format date in the query grid via Tools > Options.
5. Added aggregate analytics to the Super Join Builder for Teradata.
6. Added logon mech controls to single-table data mover.
7. Modified layout in single table for same system Teradata moves to hide scripting controls when doing same-system data move.
8. Added source logon mechanisms on Teradata for database mover.
9. Fixed delete rows issue for Teradata in database mover.
10. Changing schema in drop down on main toolbar will run SET CATALOG command on Netezza now.
11. Added stop button to single-table data mover.
12. Updated SQL Server assemblies.
13. Updated Teradata .NET driver to 15.11.
Version 12.0.0
1. Added BizStar module to Nexus which allows user to share results sets, create multi-step tasks and
2. Added PrestoDB as supported data source.
3. Added Apache Drill as a supported data source.
4. Added Apache Impala as a supported data source.
5. Added single and database data movement from Teradata to Redshift.
6. Added single and database data movement from Hive to Azure.
7. Added Azure, Hive and Teradata to the database compare module.
8. Added support Hive to Azure support in Super Join Builder.
9. Added Explain button options for Hive.
10. Updated parser and keyword highlighting to Hive.
11. Fixed issue pasting text to Nexus with non-breaking spaces.
12. Fixed issue moving multiple tables from Hadoop to Teradata in the database mover.
13. Selecting Hadoop as your data source connection will allow you to select your Hadoop sub project such as Hive, Impala or Drill.
14. Fixed toolbar format issue when unable to connect to data source on query window open.
15. DB2 DDL pulled using db2look will return execution errors now.
16. Fixed text case issue in database mover when converting source to target table.
17. Added logic to data movement avoid deleting and dropping a table at the same time.
18. Clicking New Query button will open a new query window with Teradata default database instead of the selected database in the database drop down.
19. Fixed threading and cancellation issues during data movement.
20. Fixed issues displaying user as databases in Teradata database combo boxes.
21. Fixed issue with button not appearing for Hive data source in the Super Join Builder.
22. Fixed issue with Azure views in the Super Join Builder.
23. Fixed issue where show/hide history settings were not being retained.
24. Updated Wire Protocol ODBC drivers with hotfix 7.16.x.
25. Revised Sqoop options in the database mover.
26. Added progress bar and visual cues for process completion to single-table data mover.
27. Added execute parallel button to SQL Server systems.
28. Added data movement login info in the Super Join Builder.
29. Fixed batch execute issue using PRINT command.
30. Updated Readme file.
Version 11.1.2
1. Added Azure SQL Data Warehouse to Teradata in the single-table mover.
2. Added Azure SQL Data Warehouse to Teradata in the database mover.
3. The Super Join Builder now supports joins from Azure SQL Data Warehouse to Teradata.
4. Metrics for Azure SQL Data Warehouse have been added to the Super Join Builder.
5. NoPI tables are now displayed in the WHERE tab of the Super Join Builder.
6. Fixed a parsing issue when running multi-statement SQL requests on Hadoop.
7. Fixed an issue creating cubes in the Super Join Builder when the Teradata Calendar table had been added.
8. Fixed an issue in the Super Join Builder where columns in the WHERE clause tab were not being added to data movement.
Version 11.1.1
1. Added data movement from Redshift to DB2 in the single-table data mover.
2. Added several analytic functions to the in-memory Garden of Analysis such as ListAgg.
3. Removed the Indexes on Redshift node and split it into two separate nodes for Distribution Key and Sort Keys.
4. Added Constraints, References and Referenced By nodes to the Redshift system tree.
5. Primary Key will now be highlighted with an different icon in the Redshift system tree.
6. The distribution key column will now be colored blue in the Redshift tree.
7. Column compression will now be shown as a column attribute in the Redshift system tree.
8. Added table-level refresh to Redshift system tree.
9. Fixed data source re-connection issue when Redshift ODBC driver connection state is "Starting...".
10. Fixed issue moving Date columns from Redshift to Teradata.
11. Fixed issues where comments were not being sent to the driver. This can be turned on or off in Tools > Options.
12. View alias issue in the Super Join Builder which was causing WHERE clause items to not populate has been fixed.
13. Changed text "serial number" to "activation key" globally.
14. Added program bit-type to information copied to clipboard in Help > About.
Version 11.1.0
1. Added Hadoop to Teradata, SQL Server, Oracle and DB2 in the single-table data mover.
2. Added Hadoop to Teradata in the database mover.
3. Added first-phase custom SQL in Super Join Builder.
4. Updated Hadoop indexes and partition display in system tree.
5. Updated Teradata Aster partition and constraints display in system tree.
6. Direct Data Export is tied to each query window now.
7. Added DB2 metrics to the Super Join Builder.
8. Fixed timestamp fractional display issue for timestamps with over 7 fractional seconds.
9. Fixed issue saving to Tableau format when using Direct Data Export.
10. Fixed issue when video help XML file is empty.
11. Removed hard-coded USEREGIONALSETTINGS=Y in Teradata connection string to help with localization.
12. Modified test connection for Hadoop to make connections more stable.
13. Fixed QueryGrid foreign server alias mismatch error in the Super Join Builder.
14. Fixed licensing issues on some wire-protocol drivers.
15. Added additional logging on scheduled batch processes.
16. Removed external table node in Teradata Aster system tree.
17. Fixed Recent File List error when saving to a text file.
18. Quick Select from Hadoop will no longer show partition columns.
19. Fixed comma-separated values file compression issue.
20. Updated Hadoop Super Join Builder demo for Hadoop.
21. Hadoop query syntax errors in the Super Join Builder are fixed.
22. QueryGrid query syntax errors in the Super Join Builder are fixed.
23. Modified My Schemas on Teradata Aster to allow filtering of schemas in system tree.
24. Fixed numeric formatting issue in Hound Dog Compression.
25. Fixed localization issue with pulling Teradata version number in Hound Dog Compression.
26. Fixed Teradata Aster reconnection issues when loading objects in the Super Join Builder.
27. Fixed formatting issue in Hound Dog Compress for float data types.
28. Fixed regression issues with TD13 compression.
29. Removed partition check for systems earlier than Teradata 14.1 in Hound Dog Compression.
30. Fixed DDL NULL column issue in SAP Hana when converting tables from other systems.
31. Excluding non-index partition columns from Hound Dog Compression.
32. The array data type will show in the Teradata system tree.
33. Fixed "object not set to a reference of an object" error in the Super Join Builder when using QueryGrid.
Version 11.0.1
1. Added Greenplum to Teradata data movement options.
2. Added Greenplum to SQL Server data movement options.
3. Added Greenplum to Oracle data movement options.
4. Added Greenplum to Azure SQL Data Warehouse data movement options.
5. Added DB2 to Teradata data movement options.
6. Added DB2 to SQL Server data movement options.
7. Added DB2 to Oracle data movement options.
8. Added DB2 to Azure SQL Data Warehouse data movement options.
9. Added DB2 to SAP Hana data movement options.
10. Added DB2 to DB2 data movement options.
11. Added Teradata to DB2 data movement options.
12. Added Teradata to SAP Hana data movement options.
13. Added Teradata to Hadoop data movement options using Sqoop.
14. Added SQL Server to DB2 data movement options.
15. Added Oracle to DB2 data movement options.
16. Added Oracle to SAP Hana data movement options.
17. Added Oracle to Hadoop data movement options using Sqoop.
18. Added SQL Server to SAP data movement options.
19. Added SQL Server to Hadoop data movement options using Sqoop.
20. Added Azure SQL Data Warehouse to DB2 data movement options.
21. Added Azure SQL Data Warehouse to Azure SQL Data Warehouse movement options.
22. Added Azure SQL Data Warehouse to SAP Hana data movement options.
23. Added SAP Hana to Oracle data movement options.
24. Added SAP Hana to SQL Server data movement options.
25. Added SAP Hana to Azure SQL Data Warehouse data movement options.
26. Added SAP Hana to DB2 data movement options.
27. Added SAP Hana to SAP Hana data movement options.
28. Added Hadoop to Oracle data movement options.
29. Added Hadoop to SQL Server data movement options.
30. Added Hadoop to DB2 data movement options.
31. Added Excel import to Oracle.
32. Added Excel import to Teradata.
33. Added Excel import to SQL Server.
34. Added Excel import to Azure SQL Data Warehouse.
35. Added Excel import to DB2.
36. Added Excel import to SAP Hana.
37. Added table data type conversions for all new data movement options.
38. Scheduler has been redesigned
39. New way to schedule queries via the scheduler.
40. Super Join Builder queries and data movement can now be scheduled.
41. Comparisons between systems can now be scheduled.
42. Data movement between systems can now be scheduled.
43. Teradata Compression can now be scheduled.
44. Updated the DB2 system tree.
45. Updated the Greenplum system tree.
46. Added support for SAP Hana in the system tree.
47. Added support for Postgres in the system tree.
48. Nexus will now handle objects in Hadoop tree based on if they are a table or view.
49. Added several new objects to the Oracle system tree.
50. Fixed issue on SQL Server with My Databases filter menu on system tree.
51. Fixed Vertica issue displaying multiple items in system tree.
52. Fixed query issues with DB2 9.5 system tree.
53. Made changes to how Excel data types are displayed in the system tree.
54. Fixed several issues displaying system information in Netezza system tree.
55. Super Join Builder joins can be saved.
56. Added support for QueryGrid to Super Join Builder.
57. Added Hadoop support in the Super Join Builder.
58. Updates to Redshift in Super Join Builder.
59. Added Greenplum support in the Super Join Builder.
60. Fixed cube tables error in the Super Join Builder.
61. Added Greenplum to database compare module.
62. Added Redshift to database compare module.
63. Added new AWS product keys for government region.
64. Turned off all internet calls for AWS government region.
65. Updated Amazon Product Codes for New AWS government region.
66. Nexus can now export data results to Tableau (.tde) format.
67. Logon Mechanism crash fix when creating a data source.
68. OS Polling Integration to facilitate data movement.
69. Added lexer for SAP Hana and Postgres.
70. Optimized the code to set the correct lexer for all systems.
71. Fixed conversion bug between Teradata and SQL Server.
72. Fixed bug joining tables in the Garden of Analysis
73. Updated copyright to 2017 globally.
74. Added Greenplum demo database.
75. Fixed issues with Hadoop data type conversions to other systems.
76. Moved the data movement log to its own tab in the ODBC Stream Loader.
77. Fixed several Redshift issues in the Super Join Builder.
78. Updated Greenplum keywords in the parser.
79. Added Execute as Batch option to Oracle queries.
80. Fixed bug when formatting .Net datatable with an undefined schema.
81. Fixed a Greenplum drag and drop issue to include schema.
82. Added the ability to change the user’s password on some system after connection.
83. Create Unique Table control will no longer remain visible when changing tabs in database movement.
84. Fixed issue pulling the SQL Server system number.
85. Fixed several bugs moving to Oracle using Bulk Copy.
86. Fixed issue with My Database returning an unclear error when there are no databases in the list.
87. Super Join Builder Hub progress bar will close when there is an error changing hubs.
88. Fixed issue with Redshift distribution columns in the Super Join Builder.
89. Excel issues with empty passwords should be fixed.
90. Changes to advanced options on single-table mover when doing BulkCopy to support multiple data sources.
91. Made changes to log header Bulk Copy options to support multiple data sources.
92. Fixed issues pulling column in the data mover for Azure SDW.
93. Added better row count reporting to data movement class.
94. Added internal column mapping and fixed several bugs moving to Oracle using BulkCopy.
95. Direct data export will no longer trim spaces on data.
96. Comparisons which use Oracle as a target system are fixed.
97. Fixed drag and drop table issues for Oracle, DB2 and SQL Server.
98. Added help buttons for compression, movement, comparison, single-table mover and scheduling.
99. Updated batch console messaging.
100. Checking for null target system object during execution on TPT ODBC Stream Loader.
101. Fixed Find and Replace crash when underlying window is closed.
102. Enhanced temp table dropping during database compares.
103. The batch executable is not being code signed.
104. Added help videos to Nexus on main Nexus form.
105. Fixed treeview scrolling and selection in compare/synch module.
106. Added percent rank to Super Join Builder analytics.
107. Bug fixes to Super Join Builder Analytics.
108. Added percent rank to Super Join Builder.
109. Updated Progress Data Direct Drivers to the latest version.
110. Added DDL and stored procedures to DB2 tree.
111. Fixed issues related to INTEGERDATE versus ANSIDATE in data movement add-ons.
112. Better temp table dropping on Super Join Builder data movement.
113. Enabled Excel import in blank SJB form.
114. Added pop-up help dialogs with video links to our YouTube videos.
115. Added properties menu item to DB2 tree.
116. Fixed Find and Replace crash when underlying query window is closed before dialog.
117. Allowing now for multiple stored procedures to be executed.
118. Added User Defined Types Node to DB2.
119. Added help button to single-table movers, compression, compare and scheduling.
120. Fixed issue with toolbar explain drop down.
121. Fixed case issues in the Super Join Builder when moving to different databases.
122. Fixed drag and drop issue for Oracle, DB2 and SQL Server.
123. Clarified Sync option text.
124. Updated default batch value to 50,000 on data moves using Bulk Copy.
125. Added Bring to Front on utility forms like single-table data mover.
126. Fixed Greenplum drag and drop.
127. Fixed issue converting CHAR(N CHAR) and CHAR(N BIT) on Oracle to other data sources.
128. Added additional connection checks on system tree.
129. Better handling of closed connections on data movers and compare.
130. Updated Nexus user documentation.
131. Updated ReadMe file.
Version 10.0.0
1. The Super Join Builder will now allow you to join data between Teradata, SQL Server and Oracle. In addition, it allows you to choose which system to perform the join on using the Super Join Builder hub system. If you don't want move data between systems, you may also join the data locally in the Garden of Analysis.
2. Added data movement from Redshift to SQL Server.
3. Added data movement from Redshift to Oracle.
4. Added data movement from Redshift to Teradata.
5. Added data movement from Teradata to Azure SQL Data Warehouse.
6. Added data movement from SQL Server to Azure SQL Data Warehouse.
7. Added data movement from Oracle to Azure SQL Data Warehouse.
8. Added data and database compare and sync between Teradata, SQL Server and Oracle.
9. Added DDL conversions from Redshift to Teradata.
10. Added DDL conversions from Redshift to SQL Server.
11. Added DDL conversions from Redshift to Oracle.
12. Added DDL conversions from Teradata to Azure SQL Data Warehouse.
13. Added DDL conversions from SQL Server to Azure SQL Data Warehouse.
14. Added DDL conversions from Oracle to Azure SQL Data Warehouse.
15. Added DDL conversions from Azure SQL Data Warehouse to Oracle.
16. Added DDL conversions from Azure SQL Data Warehouse to SQL Server.
17. Open all rows formatting bug fixed.
18. Fixed null comparison bug in Garden of Analysis.
19. Major updates to the Oracle system tree to add functionality.
20. Fixed issue with My Databases not getting sorted correctly in the system tree.
21. Metadata tab in Super Join Builder will not show table size and row count.
22. Super Join Builder menu will show system icons on every menu item.
23. ERwin assemblies have been updated to the latest version.
24. SQL Server Parallel Data Warehouse has been replaced in the data source connection dialog by Azure SQL Data Warehouse.
25. Updated several join builder demo database scripts.
26. Fixed issue closing Pivot Table tabs in the main query window.
27. Fixed issue with decimal data over 29 precision being left justified. It should be right justified.
28. Updated Teradata keywords in query window syntax highlighter.
29. Fixed crash in Garden of Analysis when only empty tables have been added.
30. Fixed Super Join Builder issue pulling column data for Hadoop.
31. Fixed Oracle "Ambiguous Column" error in the Super Join Builder.
32. Added progress bar and disabling buttons during data movement in the Super Join Builder.
33. Added remote table creation to the Super Join Builder.
34. Fixed DDL issue when moving data from Teradata to Teradata with compression.
35. Added schemas to the drop down in the main query form for Oracle data sources to allow to change default schema.
36. Fixed issues with localization on integer and decimal data types in the query result set grid.
37. Fixed issues with data type length, precision and scale internally on Redshift.
38. Moved status bar in table profiler in the dashboard to the top of each graph so it can be more easily seen.
39. Added authentication to Teradata Parallel Transporter Easy Loader.
40. Added TD1 and TD2 and authentication types to Teradata data source connection dialog.
41. Fixed issue connecting to Teradata via TD2 authentication type.
42. Added system name to the Super Join Builder metadata on custom joins.
43. Updated Oracle keywords in query window syntax highlighter.
44. Fixed formatting issue with Norwegian decimals. Teradata has an issue displaying these in ODBC driver (multiplies everything by 100).
45. Removed DBA, ETL, Dashboard and Bisualize buttons from main menu.
46. Added TeraTrivia! button for Teradata data sources to the main menu.
47. Added the ability to join answer sets in the Garden of Analysis.
48. Several bug fixes to the Garden of Analysis.
49. Fixed NUMBER conversion issue from Teradata to Oracle when converting DDL.
50. Fixed precision and scale display issues on several Oracle data types.
51. Oracle .NET driver issues should be resolved.
52. Fixed crash when editing rows in "Open all Rows" on Oracle systems.
53. Fixed issue in SmartScript Quick Export where zero was returned for decimal value with a precision over 18.
54. Added password when creating SQL Server CE database from add data source connection.
55. Impala ODBC drivers will now show up in the drop down when adding a Hadoop data source.
56. Thumbnail view links of Dashboard in the Garden of Analysis will no longer error if there have been no charts generated.
57. Added Contact Us link Web > Contact Us.
58. Updated documentation which may be found under Help > User Guide.
Version 9.9.5
1. Fixed issue identifying wire protocol drivers when the default registry key for system DSNs does not exist.
2. Added CLUSTERED INDEXSTORE support to Azure SQL Data Warehouse DDL pull.
3. Added blue coloring to hash column in system tree on Azure SQL Data Warehouse.
4. Added NOLOCK hint when moving data from SQL Server.
5. WHERE clause is working again in the single-table ODBC stream loader.
6. Add compatibility check box in ODBC stream loader for DATETIME columns when moving SQL Server to Teradata on some systems.
7. Added unique naming logic to database mover and fixed identically named schema issue.
8. Fixes to Garden active result settings.
9. Added dwloader for loading data onto Azure SQL Data Warehouse.
10. Improved error catching in the Garden of Analysis.
11. Fixed issue creating custom joins in the Super Join Builder on the same data.
Version 9.9.4
1. Tdpid is no longer required in data movement tools.
2. Added insert/select to same-system data movement.
3. Added unhandled exception logging under %appdata%/Coffing Data Warehousing/Nexus Portal/UnhandledException.log.
4. Fixed issues comparing objects on pre-14.10 and 14.10 and higher Teradata systems.
5. Added progress indicator to Hound Dog compression.
6. Multiple bug fixes in Hound Dog compression.
7. Greenplum Chameleon driver will now appear in DSN drop downs.
8. Fixed issue pulling column information using Chameleon Greenplum driver.
9. Added support for uniqueid, varchar(max) and nvarchar(max) SQL Server data types when moving data to Teradata.
10. The system tables folder will no longer disappear on SQL Server when opening the DDL conversion tool.
11. Added timeout property when moving data from Teradata to SQL Server.
12. Fixed "No row at position 0" when loading columns from SQL Server in the ODBC Stream Loader to Teradata.
13. Removed row counter due to performance impacts.
14. Added several connection tests in the Super Join Builder to avoid some processing completing on some system and not completing on others due to a broken connection.
15. Updated tbuild requirement information in the ODBC Stream Loader.
16. License checks on floating licenses will favor the machine-level key.
17. Fixed issue loading Greenplum Chameleon driver via the ODBC Manager.
18. Fixed issue moving Number(*,) data from Oracle to Teradata.
Version 9.9.3
1. Cross-system joins have been added to the Super Join Builder allowing the joining of Oracle and SQL Server objects to Teradata.
2. Embedded Progress(r) DataDirect drivers in Nexus prefaced as "Nexus Chameleon" in the ODBC Manager.
3. Fixed several bugs in the Garden of Analysis.
4. Added option to remove Garden of Analysis tab.
5. Fixed issue with SQL Server and duplicate entries in trees with only one or two objects.
6. Fixed several DDL conversions issues from Oracle to Teradata.
7. Number data types from Oracle will now convert to Teradata 13 systems when moving data.
8. Removed logic for NO PRIMARY INDEX for data conversion from SQL Server to Teradata.
9. Fixed duplicate issue when adding custom joins in the custom join builder.
10. Fixed issue loading Oracle columns in the custom join builder.
11. Fixed error in building select statement in single-table data mover.
12. Added Truncate column option to ODBC Stream Loader.
13. Fixed issue where numeric sliders were above or below max value in the Quick Export utility.
14. Added error handling when opening sandbox to catch null object issues.
15. Added row count display when returning rows.
16. Fixed several issues relating to row limits on several data source no being honored.
17. Fixed DB2 .NET driver issues.
18. NUMBER data type will now show precision and scale in Oracle Tree.
19. Fixed issue displaying timestamp fractional seconds on Oracle
20. Fixed issue displaying decimals with a precision over 29 in .NET.
21. Added SQL_CLASS create script for Oracle under Tools > Option > Join Builder.
22. Fixed a couple of bugs in the Joins tab in the Super Join Builder related to changing and displaying joins.
23. Several enhancements on how we determine relationships in the Super Join Builder.
24. Cubing a table in the Super Join Builder should no longer add duplicate tables.
25. Added next generation database level compression tool.
26. Made several changes to how we pull Teradata version information. This should fix an issue displaying extended object names.
27. SmartSync will no longer show erroneous differences when tables are the same when comparing pre-14.10 systems to 14.10 or higher systems.
28. Added recent file list under the File menu.
Version 9.9.2
1. Fixed issue in Teradata Quick Export with decimals with higher than 18 precision.
2. Added keyword "period" to Teradata reserved words.
3. Fixed issue displaying extended column names on some Teradata systems.
4. Fixed issue where changing source schema was still loading tables and views for the old schema in the ODBC Stream Loader.
5. Views on the source system are converted to tables on the target system in the ODBC Stream Loader.
6. Fixed error when trying to display databases in the ODBC Stream Loader for DataDirect drivers using Windows Authentication.
7. The Stream Loader will not attempt to load databases and fail if the DSN is empty.
8. Fixed issue with LDAP authentication in the ODBC Stream Loader when moving data with FastLoad (Warp Speed).
9. Added several advanced charts and fixed several bugs in the Garden of Analysis.
10. Fixed DDL pull using DataDirect drivers for SQL Server.
11. DateTime2 data types are now getting highlighted in the syntax parser.
12. DateTime2 data types will now display fractional seconds in the System Tree.
13. DateTime2(7) will no longer display a time zone in the result set.
14. Fixed an issue deleting LOG and ERROR tables in the Stream Loader.
15. Fixed SQL Server BIT to BYTEINT conversion in the Stream Loader.
16. Fixed SQL Server conversion from DateTime2 to Timestamp in the Stream Loader.
17. Fixed SQL Server conversion from DateTimeOffset to Timestamp with Time Zone in the Stream Loader.
Version 9.9.1
1. Added ODBC Stream Load which will move data from SQL Server to Teradata using TPT and DataDirect ODBC drivers.
2. Added Quick Export Utility which uses Teradata TPT and bulk exports data into delimited files from Teradata.
3. Added Garden of Analysis which allows users to further analyze data and build charts and graphs from answer sets.
4. Added TPT Easy Loader GUI. Easy loader allow you to load and move data between Teradata systems.
5. Added SQL Server Bulk Copy GUI which will import and export in bulk on SQL Server.
6. If license deactivation fails and the the computer name in the license is empty we'll use the machine name.
7. Fixed issue with double brackets the converted DDL when converting table structures/DDL to SQL Server.
8. Fixed an issue converting DATE data types on Teradata to SQL Server when converting table structures/DDL.
9. The Vertica prompt to return user-defined row limit as opposed to all rows is working again.
10. Fixed endless data reader loop when executing a stored procedure on SQL Server.
11. Fixed issue pulling DDL on SQL Server using DataDirect ODBC drivers.
12. Fixed issues displaying fractional seconds and/or time zone offset on timestamp(0) and timestamp(1) with time zone data types.
13. An issue with building the connection string in the Oracle OLE DB data provider has been resolved.
14. An issue returning the row counts for non-queries has been resolved.
15. SmartCompress is handling column names which are reserved words now.
16. Third-party licensing errors have been resolved.
17. Resolved an issue where executing a query using F5 was causing queries to be sent to the database twice.
18. Fixed Windows Authentication issue in the SQL Server .NET Driver.
19. Fixed issue pulling DDL when using Windows Authentication on SQL Server.
20. SmartCompress error involving multi-partitioned indexes is fixed.
21. Moved the Teradata standalone utilities under their own menu in the system tree.
22. SmartCompress error involving partitioned primary indexes is fixed.
23. Fixed issue displaying Asterdata bitmap in some drop down menus.
24. Fixed localization issue when getting Teradata version number for cultures where decimal separator is a comma.
25. Users with evaluation keys over 90 days are allowed again.
26. Fixed issue with users not being able to change their keys who have an evaluation key over 90 days.
27. Removed some older Microsoft assemblies which we no longer use.
28. Increased max table size for SmartCompress trial to 25GB.
29. Added new TPT menu items and put standalone utilities (BTEQ, FastExport etc.) under their own tool strip menu item in the system tree.
Version 9.8.2
1. Added Amazon Web Services licensing.
2. Added floating licensing for Windows Server.
3. Fixed issue pulling view columns on DB2 Unix platforms.
4. The services and stats_table flat files have been added to the Hadoop class database load.
5. Fixed naming and datatype issues in the Hadoop Super Join Builder demo database.
6. Hadoop ODBC drivers currently do not return data on Explain queries and we are now handling this condition in the Super Join Builder.
7. Create View syntax has been fixed for Hadoop in the Super Join Builder.
8. Hadoop ODBC drivers return errors on Show Index statements when there are no indexes on the table. This condition is now being handled in the Super Join Builder.
9. Fixed issue deleting a row using "Open All Rows...".
10. Fixed issue with columns not showing when opening SmartSync.
11. Fixed an error retrieving columns on Teradata view for 14.0 or lower systems.
12. Removed old OLAP builder, please use Super Join Builder.
13. A data source will no longer need to be selected in Bisualize when opening a workbook.
14. Fixed issue with Bisualize documentation opening correctly in the pivot control.
15. Fixed issue loading long objects name for Teradata 14.10 or higher systems in Bisualize.
16. Teradata version is now saved with the connection item. This was causing some add-ons to not display long object names on Teradata 14.10 or higher systems.
Version 9.8.1
1. Added Teradata Asterdata as a data source.
2. Added Excel as a data source.
3. Fixed an issue in Bisualize where you couldn't open an Excel spreadsheet without first selecting a data source in the launcher.
4. Updated copyright to 2014 globally.
5. Added new CoffingDW logos inside of Nexus.
6. Added confirmations to SmartSync synchronizations.
7. Fixed issues displaying joins in the Super Join Builder Joins tab.
8. Change model database create script for Redshift to create sql_class and sql_views schemas instead of one sql_class database.
9. Fixed how indexes columns rollup under the WHERE clause tab in the Super Join Builder for Teradata.
10. Super Join Builder will now report orphaned model objects when using the "Add Joins" menu in some instances.
11. Fixed an assembly load error in SmartSchedule.
Version 9.8.0 (internal build)
1. Added new licensing and removed the old.
2. SmartCompress will run in a "trial mode" when not licensed which limits compressible tables to those under 1GB.
3. Help > What's New will direct users to our website. https://www.coffingdw.com/whats-new
4. Help > About has been modified to show licensed add-on.
5. Assemblies in assembly list on Help > About are now sorted alphabetically.
6. Help > Register Product and Help > Transfer License have been modified for new licensing provider.
7. Support for simple 1 to 1 views have been added to the Super Join Builder model loader.
8. Fixed error for pulling Teradata columns when column ColumnUDTName does not exist.
9. Removed the Query Designer from Nexus. This has been replaced by the Super Join Builder.
10. Data source drop down in data connection dialog now displays icon next to name.
11. Fixed issue recollecting statistics during a SmartCompress on Teradata 14 and higher systems.
Version 9.7.3
1. Added DDL conversion from Netezza to SQL Server PDW.
2. Added DDL conversion from Oracle to SQL Server PDW.
3, Added DDL conversion from Netezza to Hadoop.
4. Added DDL conversion from Netezza to Teradata.
5. Added clarification to the export feature "Include all results in a single file...".
6. Fixed an issue saving a configuration file when a user uses a comma as their thousand separator in their Control Panel > Region and Language settings.
7. Remove Nexus cubes node under tables. Use the Super Join Builder to create cubes now.
8. Fixed several issues in Teradata dashboard.
Version 9.7.2
1. Added DDL conversion from Vertica to Hadoop.
2. Added DDL conversion from Kognitio to Hadoop.
3. Added DDL conversion from Redshift to Hadoop.
4. Added DDL conversion from ParAccel to Hadoop.
5. Objects in the Vertica system tree will no longer have the schema prefixing them. Schemas now have their own node in the tree.
6. Removed the schema prefixing the object name in the "Show All Objects..." form on Vertica.
7. When deleting an object from the "Show All Objects..." form the menu will now close and the form will refresh to update all objects.
8. Users can Bisualize answer sets on 64-bit. If all prerequisites are not installed they will be prompted to download and install them.
9. Max record prompt will no longer appear twice when a user selects to not return all records on certain data sources.
10. When a user mouses over a system tree node the system name will be appended to the dock panel text.
11. Removed 8 character check on in Teradata on the tdpid when defining a .NET data source.
Version 9.7.1
1. Added DDL conversion from Teradata to Kognitio.
2. Added DDL conversion from Teradata to Hadoop.
3. Added table options to DDL conversion tool.
4. Added drag and drop to the DDL conversion tool.
5. Re-sizing the DDL Converter form will now re-size tree view controls.
6. Added additional metadata such as size to certain Kognitio data type.
7. Fixed issue with setting default data source on query window open.
8. Fixed several threading issues relating to setting the default data source and expanding the data source at start up.
9. Fixed object not set to a reference of an object when trying to edit Nexus Macro SQL with no parameters.
10. Cleaned up broken links to the new website.
11. Teradata .NET data source no longer needs to reference hosts file and can be longer than 8 characters.
12. Users will no longer be prompted to log on when password is saved as empty on Hadoop, Kognitio and Sybase.
13. Fixed issues with loading the student_table and the sales_table for the Hadoop SQL_CLASS database.
Version 9.7.0
1. Added Teradata to SQL Server PDW DDL conversion.
2. Fixed regression issue when opening DDL converter.
3. Updated Nexus.lic file to point to new server.
4. Updated Help > Register Products form.
5. Fixed Teradata Number issue when * is specified for Number data type.
6. Right-clicking on the Databases and Users node in the system tree when set to Hierarchy in Teradata will no longer return an error.
7. Fixed an error pulling the Hive version number on HortonWorks Hadoop systems.
8. An empty user name and password will no longer throw and error when connecting to Hadoop. It will also not trigger the enter password form.
Version 9.6.3
1. Added the distribution key for Redshift and ParAccel to the WHERE clause tab in the Super Join Builder.
2. Added DDL conversions from Teradata to Redshift, ParAccel and Vertica.
3. Fixed error when opening DDL Builder from My Databases view.
4. Errors when loading Nexus should no longer get pushed to the back.
5. Nexus will no longer try to connect to the target data source when builder SQL_CLASS scripts from Tools > Options > Join Builder.
Version 9.6.2
1. Removed a compression optimization step which was causing a high amount of compression candidates to be filtered out on wide tables.
2. Added Number, Period and User-Defined type support to the Teradata system tree.
Version 9.6.1
1. Added support for Amazon Redshift.
2. Fixed nomenclature issue with SQL Server PDW.
Version 9.6.0
1. Added new GUI to Super Join Builder objects tab. Users can move and resize objects now. Lines are also being drawn between objects to show relationships.
2. Users can move and resize object in the Super Join Builder now.
3. Lines are now being drawn between objects to show relationships.
4. Added explain button to the Super Join Builder. Explains will load in the Metadata tab.
5. Added "Arrange Objects" button to Super Join Builder to reset and auto-layout objects.
6. Renamed "Models Directory" to "Nexus Model Store" in Tools > Options.
7. Fixed several issues relating to loading views.
8. When a model is deleted in Model Management that model is removed from all connection which have that model as an active model.
9. Fixed an issue saving Super Join Builder settings.
10. Attached models should be recognized for systems without schemas in the Super Join Builder.
Version 9.5.3
1. Fixed SmartCompress NULL value regression issue which occurred when all values in a column were NULL.
Version 9.5.2
1. Fixed SmartCompress NULL value issue.
Version 9.5.1
1. Default smallest table size filter for SmartCompress has been changed to 1 which will show all tables in a database.
2. Added NoPI support to SmartScript.
3. No Primary Index "indexes" (NoPI) are now shown in the Teradata system tree.
4. You can now view properties for indexes in Teradata by right-clicking on the index.
Version 9.5.0
1. Added a beta release of a model loader which will allow you to load your CA ERwin® models into Nexus. Nexus will encrypt them and then users can create join SQL using the Super Join Builder and the relationships contained in the models.
2. Fixed issue with Direct Data Import when inserting NULL values.
3. Removed AIDBA from Nexus.
4. Fixed issue with TeraTrivia database path not getting set properly.
5. Nexus setup project versioning will no longer include the date as part of the schema. Instead a revision number will be used.
Version 9.4.0
1. Added Hadoop as a supported data source.
2. Added Hadoop to the Super Join Builder.
3. Added Hadoop to SmartSchedule.
4. Added SQL Server and SQL Server Enterprise to SmartSchedule.
5. If Bypass HOSTS file is checked in Tools > Options under SmartReplica and the TDPID is left empty in the SmartReplica connection the ODBC DSN name will no longer be used as the TDPID. This will allow scripting connections to be entered without a TDPID. This should work as long as the default TDPID on your system will resolve to the Teradata boxes IP.
6. Fixed crash issues with Teradata DBQL history button.
Version 9.3.1
1. Fixed a nomenclature issue in SmartReplica which was causing replications to fail.
2. Fixed issue with auto expand and default data source check boxes not getting set when a user modifies a data source.
Version 9.3.0
1. Add-ons can now be activated without installing a separate license.
2. Fixed conversion issues with SQL Server converting to Teradata, Netezza and Greenplum.
3. Fixed drag and drop case-sensitivity issue for column name in Kognitio.
4. Kognitio sessions in system tree will now have grey, red, yellow and green icons depending on their state.
5. New keywords added to the Kognitio text lexer.
6. ParAccel tree has been redesigned to include schemas as a separate tree node.
7. Added refresh, drop and rename menu items to new ParAccel schema nodes.
8. Added system and user-defined functions to the ParAccel tree.
9. System sequences are now showing correctly in Netezza when selecting "Show all objects" from the tree.
10. Fixed text highlighting issue on Teradata SHOW object commands.
11. Fixed several issues relating to conversion from Oracle to Teradata.
12. Minor updates to SQL Server Bulk Insert.
13. Fixed several issues with SQL Server Bulk Copy.
Version 9.2.2
1. The session node will no longer disappear when disconnecting and reconnecting a Kognitio data source.
2. Abort session and abort query command have been fixed to work with non-SYS users.
Version 9.2.1
1. Fixed a crash in Nexus which was caused when query duration "ticks" were set to a negative number.
2. Session information in Kognitio now works for non-SYS users.
3. Clicking on "Hashed" in the Kognitio Image Builder will now deselect Random and Replicated by default.
4. ATL + F6 will no longer trigger an Explain (F6 only).
5. AT NOW has been appended to the query to retrieve sessions in Kognitio in order to prevent locking.
Version 9.2.0
1. Added support for Kognitio.
2. Added support for ParAccel.
3. Added support for Sybase.
4. Added support for Vertica.
5. Query history times will now display to the thousandth of a second.
6. Added query time to the result set tab tooltip.
Version 9.1.7 (internal build)
1. Fixed issue in custom join builder where new join was not showing up in the menu of the parent join object.
2. Fixed issue with DDL Conversion launcher which always converted to the same data source.
3. Fixed toggling issue in Super Join Builder.
Version 9.1.6
1. Fixed unable to write to read only value issue in Pivot Control.
2. Fixed issue with in-memory OLAP analytics in Super Join Builder.
3. Made some changes to the password verification form to handle null passwords for certain systems and users.
4. Set a data source tab color to white will no longer cause the data source text to appear invisible in drop down buttons.
5. Query tab tooltips now update on mouse over event causing them to update properly when tab info changes.
6. Data source tooltips are updated when a data source is saved or modified to reflect a change in the user name.
7. Added newer Excel option to SmartSchedule export options.
Version 9.1.5
1. Fixed several issues relating to adding custom joins in the Super Join Builder.
2. LDAP and non-LDAP connections are now possible in Teradata without having to change settings in Tools > Options.
3. Fixed several issues relating to Direct Data Import.
Version 9.1.4
1. BIGINT issue in SmartCompress is resolved.
2. A text value of 'NULL' in SmartCompress will no longer be treated as a NULL value.
3. Teradata indexes are now being rolled up into a single line per index.
Version 9.1.3
1. Fixed a corruption issue with the SmartSchedule form.
Version 9.1.2
1. Fixed drag and drop issue in macro builder.
2. Fixed issue in macro builder where delimiter was not getting saved into macro objects on rare occasions.
3. Fixed history row count issue in Teradata where user has bundled queries turned on.
Version 9.1.1
1. Optimized the return of an answer set when a user selects to not return the entire result set in Teradata and Netezza.
2. Fixed an issue in SQL Server which would return one less answer set than expected for batch queries.
Version 9.1.0
1. Users can now drag and drop tables and views into the Super Join Builder to create custom joins.
2. The Super Join Builder will remember custom joins if the user chooses.
3. The Super Join Builder's "Add Join" menu will now display both custom (blue text) and logical joins (black text) to the user.
4. Users can delete custom joins by selecting them in the join menu right-clicking and selecting "Delete Custom Join".
5. Added a tooltip to the Super Join Builder menu which will display the text of the selected join to the user.
6. Added a Super Join Builder button on the query toolbar which will open an empty Super Join Builder.
7. Several issue have been fixed relating to aliasing objects in the Super Join Builder.
8. Row counts for Teradata queries which utilize a data reader will now display the total number of records affected.
9. Query parameters with the same name will no longer need to be entered more than once per query in a multi-statement request.
10. Issues with direct exporting to Excel 2007 and Excel 97-2003 formats have been fixed.
11. The data reader will no longer remain open when an Execute Stored Procedure command fails on SQL Server and SQL Server PDW.
12. Right-clicking on the column node in a DB2 system tree will allow you to sort columns by column name or column id.
Version 9.0.2
1. Unchecking the Replace Object option in SmartReplica for Teradata will no longer cause no scripts to be created.
2. All Export/Save As... options for the data grid should be working normally again.
3. The users computer's bit-type is not displayed on the Help > About form.
Version 9.0.1
1. Resolved a parser issue relating to unqualified data set table.
2. Fixed an issue in which Teradata SHOW commands were being returned in a single cell instead of as formatted text.
Version 9.0.0
1. Super Join Builder (beta) added to Nexus for Teradata, Netezza, SQL Server, SQL Server PDW and SQL Server CE.
Go to Tools > Options > Joins to get demo database create scripts. For help with setup contact helpdesk@coffingdw.com.
2. Added support for latest Excel format.
3. Cancel button has been re-written to prevent some long running queries from freezing Nexus.
4. Disconnect from data source button will no longer remain active when a user tries to connect to a data source and fails.
5. Fixed several bugs when trying to disconnect from a data source in specific instances.
6. Nexus will no longer return unhandled exception when returning results to a form which no longer exists.
7. Fixed several issues relating to large decimal, money and smallmoney data types.
8. The data table load method in the .NET framework was not properly returning all rows affected for the Teradata data reader so we are using our own method.
9. Updated Teradata .NET driver to version 14.0.
10. Fixed rename table issue in SQL Server CE.
11. Fixed localization issue with the Teradata version check in SmartCompress.
12. And issue converting numbers to double data type in SmartCompress on Teradata 13.10 system has been fixed.
13. Fixed a parsing issue when Teradata style comments appear in strings ('*/' and '/*').
14. Help > User Guide inside of Nexus will now download the user guide from our server if not present.
15. Added logins to SQL Server tree.
16. Added users to SQL Server tree.
17. Added roles to SQL Server tree.
18. Added statistics to SQL Server tree.
19. Password screen should no longer get hidden behind the Nexus splash screen.
20. SmartCompress now allows varchar compression on Teradata version 13.10 or higher.
21. "Disable Varchar Compression" can be check in Tools > Options > SmartCompress to not compress varchar on Teradata 13.10 or higher systems.
22. Updated assembly information and documentation to the current year.
23. The data source connection dialog has been redesigned slightly.
24. Data source color will now be set by default in the data source connection dialog.
Version 8.6.0 (Microsoft Build)
1) Added support for AU3 syntax highlighting and request execution.
2) Adjusted existing objects in the Nexus system tree to utilize modified metadata views
2) Full support for existing View DDL functionality using modified metadata and syntax, and collation options
3) Added support for Tabular Data Stream (TDS) connectivity.
4) Removes dependencies on DWSYS database.
5) Added statistics node to system tree on SQL Server and SQL Server PDW data sources.
6) Added indexes node to system tree on SQL Server and SQL Server PDW data sources.
7) Added roles node to system tree on SQL Server and SQL Server PDW data sources.
8) Added “users” node to system tree on SQL Server and SQL Server PDW data sources.
9) Added logins node to system tree on SQL Server and SQL Server PDW data sources.
Version 8.5.0
1) SmartCompress now allows varchar compression on Teradata version 13.10 or higher.
2) Fixed an issue getting the schema for Netezza data sources in SmartSync.
3) Improved AI DBA logging to User Interface.
4) Fixed AI DBA crash related to threading.
5) Encrypted AI DBA Password.
6) Fixed AI DBA log file timestamp issues.
7) Updated Teradata .NET Data Provider to latest version.
8) Added AI DBA Manager node to Tools > Options.
9) Also added AI DBA button to DBA Drop Down on Teradata systems.
10) Fixed multi-PPI issue in SmartCompress
11) Removed a semi-colon from a canned Oracle query which was throwing and invalid character error.
12) There is a known error with the 64-bit Oracle database which causes an "Arithmetic overflow" error in the 64-bit ODBC driver. Oracle patch 11.2.0.2 should fix this issue, until then to work around this issue use either .NET or OLE DB Oracle 64-bit drivers.
13) Updated Infragistics Controls to latest version.
Version 8.4.0
1) No longer supporting old Firebird database history. SQL Server CE replaced Firebird as our history database in Nexus version 2.6.
2) User settings will now persist in the new history form.
3) Updated assemblies for grid control and Bisualize.
4) Removed several unsigned assemblies which were no longer needed.
5) Added TOP 100 query to SQL Server query templates.
Version 8.3.0
1) Added support for WHILE loops and additional batch processing in SQL Server and SQL Server PDW
2) Opening a new file will now open in a new query window unless the window is empty and is not set to be saved.
3) Issue where Nexus ignored "Save on Exit" settings has been resolved.
4) You can now overwrite your serial number by going to Tools > Register Products and clicking on the book icon next to the Nexus text.
5) Users will now be warned before their license is about to expire.
6) Several bug fixes were made to the Nexus certification test preparation modules.
Version 8.2.0
1) Added support for batch command using BEGIN and END statement and SQL Server and SQL Server PDW.
2) Added support for PRINT command in SQL Server and SQL Server PDW.
3) Fixed an issue after executing the USE command where Nexus was displaying an extra bracket in the system drop down for the database name.
Version 8.1.0
1) Fixed Scroll to Control issue in some child forms.
2) Fixed password issues with Dashboard, ETL and DBA launch pads.
3) Added certification test preparation module.
4) Added DBA drop down button.
5) Fixed several SmartSync SQL syntax issues.
6) Reworked the Smart DB Admin view and DDL builder.
7) (0) Changed Query Designer button name to Joins.
8) Added several options to Query History button.
9) Added support to SQL Server PDW to SmartSync.
10) Added SQL Server PDW Loader tool.
11) The DBA drop down only need to be clicked once now to open.
Version 8.0.2
1) Fixed an "object not set to an instance of an object" in licensing modules.
Version 8.0.1
1) Users can now see time remaining on their license by going to Help > Register Products.
2) Addressed an issue with SQL Server PDW users unable to transfer/deactivate their license.
3) The password form in the ETL launch pad will no longer appear multiple times for users who have no stored password.
4) View DDL will now display properly in SQL Server PDW after metadata change.
5) Tools > Options should now display correctly for users who have changed their display DPI settings.
Version 8.0.0
1) Added SQL Server support to SmartSync add-on.
2) Added ETL button to main Nexus toolbar which will allow easy access to many Nexus add-ons.
3) Added Query History button to main Nexus toolbar.
4) Added Dashboard button to main Nexus toolbar. Non-supported data sources will be disabled.
5) Result Set Database button was rename to Sandbox.
6) Fixed an issue when tabs were returned in the dataset which would cause the grid component to crash.
7) Decimal precision for aliased columns will now match the precision of the underlying data type.
8) Added support for DBCC commands in SQL Server PDW.
9) Fixed object connection issue in Data Import tool.
10) Changed Nexus support number to 1-513-300-0341.
Version 7.2.2
1) Removed licensing requirement for Bisualize, SmartDBAdmin, Data Cleanser, Macro Builder and SmartScript.
2) Moved Results Database and Query Designer to the main query toolbar.
3) Removed Quick Query Toolbar.
4) Moved "Lock for Access" button to Query Helper toolbar.
5) Fixed query grid bug which caused loss of functionality in the grid.
Version 7.2.1
1) Added column selection and mapping feature to SQL Server Bulk Copy tool.
2) Bulk Copy will now choose INSERT/SELECT over Bulk Copy when source and target table are on the same system.
3) Removed licensing for Data Cleanser tool.
Version 7.2.0
1) Added SQL Server Bulk Copy tool.
2) Added SQL Server Bulk Insert tool.
3) The add data sources form will now resize to accommodate smaller monitors.
4) SQL Server PDW users should now be able to connect through the .NET data provider.
5) Bisualize now supports saving to Excel workbooks.
6) New result set databases should not be automatically added to the Systems tree.
7) Users should now be able to overwrite an existing result set database without receiving an error.
8) Resolved an issue where the save progress form would not close when saving a result set to Microsoft Access.
9) Users can now change the database name when building DDL with SmartDBAdmin.
Version 7.1.5 (Microsoft build)
1) Fixed an issue in the parser which did not ignore double-dash comments inside of single quotes string literals.
2) Fixed an issue connecting to SQL Server through the .NET Data Provider.
3) Users will now receive a free 90-day trial of Bisualize with Nexus.
4) Crash relating to early version of text editor assemblies has been resolved (32-bit only).
Version 7.1.4 (Microsoft build)
1) Special build for Microsoft to fix word wrap crash.
Version 7.1.3
1) Added support for Bisualize on SQL Server Parallel Data Warehouse
2) Object not set to an instance of an object error fixed on OLAP builder.
3) Turning word wrap on in Tools > Options will no longer throw an unhandled exception.
4) Disconnecting and reconnecting to a Netezza data source will no longer issue a USE command which is not supported by Netezza.
Version 7.1.2
1) Direct data import tool will now prompt for a password if the password has not been saved in the data source.
Version 7.1.1
1) Nexus will now escape closing brackets when they appear inside of an object name. This applies to SQL Server, SQL Server CE and SQL Server Parallel Data Warehouse databases.
2) Cut and paste issue with Unicode data in rich text format has been resolved.
3) Erratic behavior in the text edit when parsing long Unicode strings with brackets has been resolved.
4) The alter login check box and label are no longer obscuring the password text box when modifying a data source connection in SQL Server Parallel Data Warehouse.
5) Added new Nexus Query Chameleon logo and splash screen.
Version 7.1.0
1) Added direct data import tool as beta.
2) Fixed issues with moving data via drag and drop and NULL values.
Version 7.0.14
1) Nexus will now return an error when executing a store procedure on a system which does not support stored procedures.
Version 7.0.13
1) Replicated table DDL is getting pulled correctly from SQL Server PDW after SQL Server PDW metadata change.
Version 7.0.12
1) Syntax error in the password clause of a CREATE or ALTER LOGIN statement on SQL Server PDW will no longer cause Nexus to crash.
2) Undocking the history window will no longer cause Nexus to crash.
3) Binary columns will be displayed in their hexadecimal representation.
4) User names up to 128 characters are now supported.
5) Fixed an error setting the schema when Netezza was the target object in a SmartReplica process.
6) Fixed an issue where Timestamp(0) on Teradata was causing SmartReplica to fail on Teradata to Netezza transfers in SmartReplica.
7) Resolved several issues relating to saving and loading files into the text editor in Unicode.
8) Resolved a parsing error relating to comments inside of object delimiters.
9) When saving to a single-tabbed Excel workbook in Nexus the tab name in the workbook will match the tab name of the result set getting exported.
10) Changed the way Nexus pulls system view information in order to get around a Metadata issue.
Version 7.0.11
1) Icons for hashed and replicated tables are being displayed correctly after SQL Server PDW metadata change.
Version 7.0.10
1) Resolved a SQL history sort issue on start up.
2) DDL is getting pulled correctly from SQL Server PDW after SQL Server PDW metadata change.
3) Removed drop and rename commands for system objects in SQL Server 2005 or later and SQL Server PDW data sources.
4) Nexus now pulls view DDL from SQL Server data sources.
Version 7.0.9
1) Binary and Varbinary data type are now being displayed correctly with their column length for SQL Server PDW.
Version 7.0.8
1) Fractional precision has been restored on DateTime and DateTime2 data types.
2) Disconnecting and reconnecting a query window will refresh the database drop down with the current databases defined in the "My Databases" list.
Version 7.0.7
1) Resolved two issues with database dropdown box for SQL Server PDW.
2) Fixed an issue in the distribution clause of DDL for replicated tables.
Version 7.0.6
1) Added NZLoad utility to SmartScript add-on.
2) Fractional seconds are now supported in query result set.
3) Resolved an issue in SQL Server PDW to allow users to connect to a default database other than dwsys.
4) Password in Create and Alter login statements on SQL Server PDW is now obfuscated.
5) Dropping tables on SQL Server PDW with brackets in the name will no longer throw an error.
6) Datetime2 data type is now displaying fractional in SQL Server PDW system tree and DDL.
7) SQL Server PDW DDL now shows Non-Clustered index CREATE statements.
8) Non-clustered indexes are now shown under in the SQL Server PDW system tree.
9) Non-clustered index create statements are now shown in SQL Server PDW DDL.
10) Multi-column index columns are now being bundled when presented in the SQL Server and SQL Server PDW system trees.
11) Sort order is now being shown for indexes in the SQL Server and SQL Server PDW system trees.
12) Fixed an issue relating to duplicate columns in the distribution or partition phrases in SQL Server PDW DDL.
13) SQL Server DDL is now presenting additional table information.
Version 7.0.5
1) Fixed issue with private deployment of SQL Server Compact Edition 3.5 SP2 assemblies as described in Microsoft KB 974247.
2) Null Boolean values in Netezza will no longer throw an error.
Version 7.0.4
1) Added new Nexus Chameleon logos.
2) Addressed several issues in the system tree for SQL Server 2000 systems.
3) Updated SQL Server Compact Edition to version 3.5 SP2.
4) Fixed an issue with the data sources form which caused controls to move at higher DPI settings.
Version 7.0.3
1) Fixed an issue where splash screen was not closing on Vista systems.
Version 7.0.2
1) Cancelling registration will no longer push the splash screen in front of the welcome form.
Version 7.0.1
1) Changed TopMost property of the welcome form so the Splash screen would not cover it up.
Version 7.0.0
1) Nexus is now routing unhandled exceptions through Windows Error Reporting.
2) Users disconnecting and connecting from a query window will inherit any changed data source settings.
3) Fixed issue with creating stored procedures on SQL Server.
4) Modifications to splash screen to handle changes in user DPI settings.
5) Release candidate for SQL Server Parallel Data Warehouse.
Version 6.5.0
1) Added Stored Procedures to SQL Server tree.
2) Added Functions to SQL Server tree.
3) Added Triggers to SQL Server tree.
4) Added support for database names with spaces in SQL Server.
5) Nexus now separates system object from user objects in SQL Server tree.
6) Changed Nexus by Tera-Tom name to Nexus Query Chameleon.
7) Updated splash screen, logos and images in Nexus to reflect Nexus Query Chameleon theme.
8) Removed user account control when Nexus starts.
9) Increased the combo box size in SmartSync to hold long object names.
10) Fixed error in Bisualize where opening multiple child forms would cause a program error if user placed a dimension or measure outside of the child form.
11) Changed Metacensus in Help > About > Register Products to AIDBA and fixed an error validating the AIDBA.lic file when clicking the hyperlink.
12) Fixed an issue in our Teradata text parser where cut and paste was losing formatting such as tabs.
13) Fixed an "object not set to reference of an object" error which was occurring when closing an object properties form.
14) The object properties form menu event are now pulling column information correctly in order to build dynamic SQL.
15) Fixed an issue where the USE command was not populating the Databases drop down in SQL Server.
Version 6.4.0
1) Nexus will now install both 32-bit and 64-bit versions of SQL Server Compact Edition in the Application folder. This fixes intermittent issues with SQL Server CE on 64-bit Nexus.
2) Licensing has been improved. New users will no longer need to replace the Nexus.lic file when moving to a subscription edition of Nexus. In addition, to renew Nexus users only need to enter a code and not manually replace their licensing file.
3) Several issues with DDL creation in Netezza have been resolved.
4) The Netezza "Quick Select" option in Netezza is now including the schema information.
5) An issue has been resolved where column information was not being populated in the Query Builder when opened from the System Tree.
Version 6.3.4
1) Fixed issue with Bisualize default directories not being created on startup.
2) Check for updates issues have been resolved.
3) Assembly not found issue when a user selects Tools > Options has been resolved (64-bit beta).
Version 6.3.3
1) Fixed parsing issue in SmartCompress on Multi-Level Partitioned Primary Indexes.
2) Null text is now rendered correctly for all data types in the data grid.
3) Fixed licensing issue with Bisualize.
Version 6.3.2
1) Fixed various issues in the Query Builder for Netezza, Teradata, Oracle and DB2.
Version 6.3.1
1) BEGIN TRANSACTION parse error fixed.
2) RESTORE HEADERS in SQL Server now returning header row information.
3) Multiple INSERT issue fixed where double-hyphens in a string literal were causing Nexus to send the INSERTs as one request.
4) An issue where users could no longer view text files saved in a previous version of Nexus has been fixed.
Version 6.3.0
1) The advanced tab in AI DBA has been removed. Build metadata repository functionality has been moved to the main AI DBA toolbar and users can change the main AI DBA directory (includes the log file location) via Tools > Options and clicking on the AI DBA tree node.
2) Log file entries in AI DBA have been changed to no longer reference MetaCensus.
3) Users are now able to Undo and Redo comments added through the comment button on the main Nexus toolbar.
4) Made another modification to RTF cut and paste to get around issue that one company is having using this function.
5) All of our assemblies are now signed. If you experience any problems with this contact helpdesk@coffingdw.com.
Version 6.2.0
1) Added single quotes to DateTime to avoid syntax errors on updates.
2) An issue regarding cutting and pasting Rich Text Format into external programs has been resolved.
3) Oracle recycle bin tables are no longer throwing an error in AIDBA.
4) The system tree for SQL Server 2008 is pulling from the most recent SQL Server metadata views.
Version 6.1.3
1) Fixed Connection Timeout issues on Teradata and Oracle in AIDBA.
2) Fixed a Command Text issue for Oracle data drivers in AIDBA.
3) Set default timeout for new data source connections in AIDBA.
4) The required .NET framework version had reverted back to .NET 2.0. We changed this back to .NET 3.5 SP1.
5) We're now digitally signing the NexusSetup.msi file.
Version 6.1.2
1) An issue with NULL data types in Edit and Replace for Teradata has been resolved.
Version 6.1.1
1) A date issue with Edit and Replace for Teradata has been resolved.
Version 6.1.0
1) Corrected an assembly versioning issue on the DB2 .Net Data Provider.
2) Edit and Replace is now handling timestamps with a time of 12:00:00 AM correctly in Teradata.
Version 6.0.2
1) A SmartSync issue was resolved where timestamps of 0001-01-01 00:00:01 were being formatted like the time data type and causing a program error.
2) Macro builder users who are not admin can no longer move macros or folders in the macro builder tree.
3) Two SQL syntax issues have been fixed in the Data Cleanser relating to the building of table UPDATE statements.
4) Updated the SQL Server CE database to version 3.5 SP1.
5) Updated to the latest versions of the .NET data providers for Oracle and Teradata.
6) Updated our licensing software to the latest version.
Version 6.0.1
1) Users can now edit their query path and history path string manually in their Tools/Options settings.
2) Users will no longer get a corruption error when trying to open the Bisualize documentation.
3) Fixed an issue where Timestamps were not being formatted correctly in some queries in Teradata.
Version 6.0.0
1) Saving an explain plan using the Save All option for Excel will no longer cause an error.
2) A false ODBC driver not found validation error in SmartReplica was occurring. We removed this check as it wasn't needed and are now returning ODBC driver not found errors from the database.
3) An issue where non-decimal numbers were appearing with a decimal on a result set grid export to Excel has been resolved.
4) Hints in Oracle are working now.
5) All functions are now appearing under the Functions node in the Teradata tree.
6) Fixed a web service issue where users were not being informed about latest Nexus version.
7) Added limited support for authentication in Teradata. This must be turned on via Tools > Options > Application > Connectivity.
8) Decimal precision issue for Teradata fixed for main query tool and edit in place feature.
Version 5.3.1
1) Added .NET Framework 3.5 sp1 as a requirement for running Nexus. If you do not have this framework or higher you will not be able to run Nexus.
2) Added a Nexus Universal license to licensing schemes.
3) Fixed several case sensitivity issues with SmartReplica relating to Netezza object names.
Version 5.3.0
1) Bisualize users can now open workbooks created by other users.
2) Sensitive information such as user name, password and connection strings are now encrypted in Bisualize.
3) Bisualize users will be required to validate their logon information if the data source, user name or password does not match that of the workbook they are trying to open.
4) Users are now able to open new workbooks connected to a new data source through the Bisualize tool using the New Workbook menu item.
5) Tooltips have been added to each tab in Bisualize to show the tab name, data source type and data source name.
6) Users can now delete multiple objects at the same time through the Object Management menu item in Bisualize.
7) Issue in Bisualize regarding connecting through OLE DB have been resolved.
8) SQL Syntax errors have been addressed for the ALTER compression option in SmartCompress.
9) A help link has been added to AIDBA when trying to connect to a SQL Server repository.
10) A query timeout issue in AIDBA when pulling data from Teradata has been fixed.
Version 5.2.0
1) Bisualize now supports saving of multiple visualizations in a workbook format. In Bisualize, go to Help > Documentation to understand all the changes.
2) Bookmarks and Comments have been collapsed into their own buttons on the query toolbar.
3) Removed data binding on cell change event to the grid in the macro builder. This was causing the cell to lose focus after an edit was made.
Binding is now done on saves of the data grid only.
Version 5.1.1
1) Fixed an error in which the Bisualize default directory was not getting created.
2) Fixed an issue which caused the history and favorites tables to not get created when Nexus first runs.
In addition, if these tables are ever deleted from this database they will automatically get rebuilt when Nexus restarts.
Version 5.1.0
1) Added support for Netezza stored procedures in the system tree.
2) Updated Netezza SQL parser and syntax highlighter.
Version 5.0.4
1) An issue related to the proper sorting of date fields in Bisualize has be fixed.
2) Attributes and measures can now be removed from their respective shelves in Bisualize.
Version 5.0.3
1) Users who have the thousand separator for numeric values in the grid will now be able to Bisualize from the data grid without adverse results.
2) A verification prompt will now occur when a user attempts to close Bisualize.
3) Error handling has been enhanced to catch out of memory errors.
4) Bisualize will no longer crash due to a temporary directory not existing.
5) Header rows are now required for CSV and Excel files.
Version 5.0.2
1) Users will no longer receive the error "object reference not set to an instance of an object" on drag and drop events if the user had a previous failed connection attempt.
2) The "Connect!" button has been changed to read "Bisualize!" and the icon has changed since in some instances you are already connect to the data source when you click "Connect!".
Version 5.0.1
1) Users will no longer be prompted to enter a password if they do not have one saved.
2) The Teradata database combo box in Bisualize will only contain databases and not users. Any user not listed in the combo box can still be accessed via custom SQL.
3) The database combo boxes in Bisualize will now be sorted alphabetically.
4) SQL Server Compact Edition will no longer appear in the Bisualize database combo box as it is currently not supported.
Version 5.0.0
1) Added Bisualize the new Nexus data visualization tool. Users can access this by clicking the "Bisualize" button on the main Nexus toolbar or by right-clicking on any answer set and selecting "Bisualize query result set".
Bisualize is supported on Netezza, Oracle, DB2, SQL Server, DATAllegro, Greenplum, Neoview and Teradata.
2) If a valid license file is not found when opening Nexus, the user will now be prompted to try again. This is a workaround to an issue we're experiencing with our third-party licensing tool which caused an invalid "license not found" error to fire.
3) The default macro directory is not being set properly for users the very first time they use the Nexus Macro Builder tool.
Version 4.4.0
1) Added Nexus data cleanser for Netezza, SQL Server, Greenplum and Teradata under table menu. A license if required to use this feature. Call 1.877.837.2328 for a free trial.
2) Macro builder admins can now add required dynamic macro conditions for the end user to enter in order for them to be able to run the macro.
3) Added pivot table option to result set menu.
4) A new SQL Server Compact edition database file has been added named SQL_Class.sdf under C://Program Files/Coffing Data Warehousing/Data/.
Those users who have purchased CDW SQL books can connect to this database and use it to practice all the SQL examples in our books.
5) Users will no longer be prompted to save an answer set to multiple workbooks when not saving to Excel.
6) Data type matching on the drag and dropping of an answer set in Nexus has been improved for all databases.
7) Case sensitivity issues have been fixed on the CREATE TABLE portion of the drag and drop feature.
8) AIDBA will no longer fail on the first run. This was a result of a NULL value in MC_Sync Stats.
9) Users can now rebuild the AIDBA source system database.
10) Duplicate records in AIDBA MC_SyncStats have been fixed.
11) Quick select was enhance to fix case sensitivity issues on different database platforms.
12) SQL Server Quick Select object names now adhere to SQL Server conventions.
Version 4.3.0
1) Added dynamic macro builder option to the macro builder.
2) Added Nexus cube builder.
3) A new query window will open when a user runs a macro and a query window is not already open.
4) Slightly increased the height and width of the charts in the data profiler to accommodate different font sizes.
5) Allowing user to resize dashboard header to give them more space.
6) Users can now CAST COUNT(*) as BIGINT from the query template menu in Teradata.
7) Multiple result set tab can be saved in one workbook in Excel.
8) Added Macro Builder Admin license.
9) Select * was failing when column contained a date of 0000-01-01. The .NET framework only support dates after 0001-01-01.
The fix is to update your dates before 0001-01-01 to 0001-01-01 or later.
10) Quick Select was failing when DDL contained lowercase letters for Netezza. Quotes will now be added around lowercase DDL columns in Netezza to avoid this.
11) Users can now change their default Macro directory via Tool > Options.
Version 4.2.2
1) Fixed case-sensitivity issue of result-set drag drop for Netezza databases.
Version 4.2.1
1) Fixed case-sensitivity issue in Teradata to Netezza replication.
2) Fixed typo on the table-level DDL conversion form.
Version 4.2.0
1) Added DDL conversion from Teradata to Greenplum at the table-level and the object level.
2) Added DDL conversion from Oracle to Greenplum at the table-level and the object level.
3) Added DDL conversion from SQL Server to Greenplum at the table-level and the object level.
4) Added DDL conversion from DB2 to Greenplum at the table-level and the object level.
5) Fixed issue with System DDL conversions which would run a table-level conversion when system-level had been selected.
6) Query toolbar buttons will no longer become disabled when an inactive query window is closed.
7) The VARCHAR(MAX) data type will be displayed correctly in the SQL Server System tree.
Version 4.1.0
1) Added DDL conversion from Oracle to SQL Server at the table-level and the object level.
2) Added DDL conversion from DB2 to SQL Server at the table-level and the object level.
3) Users will no longer receive and error when saving SQL from the main query window.
4) Running the table-level DDL converter will no longer produce duplicate indexes in the DDL.
5) Removed "System" button from Help > About to enhance security for Citrix users.
6) Multiple DDL conversions at the table level were not in the correct order when appended to the query window. This has been corrected.
Version 4.0.0
1) Added the ability to convert DDL for all tables in a database.
2) Added DDL conversion from Teradata to SQL Server.
3) Added DDL conversion from Teradata to Oracle.
4) Corrected issue with Teradata COMMENT command to retrieve comment from database.
5) Fixed issue in DDL conversion where indexes were being skipped if the user had not expanded the index node on the table tree.
Version 3.7.0
1) Added Nexus Macro Builder
2) Fixed an "instance of object not found error" in the Favorites tree view.
Version 3.6.0
1) Added data profiling tool to the Nexus Dashboard.
2) Added scrollbar option to 2D resource usage charts.
3) Added a progress bar for data set saves to MS Access.
4) Pressing only the Shift or F1-F12 in a query window will no longer trigger Nexus reporting that the query has changed.
5) Corrected an issue where if a data set column was named after a database keyword, dragging and dropping a result set to another database would not work.
Version 3.5.1
1) Corrected issue in SmartReplica system tree which caused some objects to be skipped.
Version 3.5.0
1) Added Performance and Charting capabilities through new Nexus Dashboard
2) Fixed divide by zero error on space gauges
3) Fixed numeric overflow issue on space gauges
Version 3.4.0
1) Corrected issue with SEL not being recognized when using locking for access button and running query explains.
2) Modified results grid to not insert column headers when copying/pasting if export/include column headers is not checked.
3) Added query designer to table right-click menu; allows user to have table preselected in designer when designer opens.
4) Corrected issue with query result records not being returned past the user defined minimum for SQL Server, SQL Server CE, DB2, and Greenplum queries.
5) Modified query results saver to run on a separate application thread to allow user to continue working in program without waiting for results to finish exporting.
6) Corrected issue with copying of byte data during query results saving when targeting SQL Server CE or SQL Server data sources.
7) Added user options to restrict program from sending screenshots and/or error information via background email to helpdesk.
8) Added ability in SmartCompress to compress in-place (ALTER) tables.
Version 3.3.0
1) Corrected startup issue on new installations related to history/favorites database changes in prior release.
2) Added space gauges for Teradata databases/users properties.
3) Added OLAP builder for Teradata, Netezza, and Oracle.
Version 3.2.3
1) Modified Quick Select and Quick View features to launch SQL in new window if data source is different than the currently open query window.
2) Corrected issue with precision and scale not appearing on SQL Server numeric columns in systems tree.
3) Corrected issue in query results utility with copying of tables with no decimal columns into SQL Server CE.
4) Upgraded licensing component to latest version to address operating system issues.
5) Added option in query designer to auto-create joins based on like column names.
6) Corrected issue with error occurring in query designer when user returns to previously viewed query designer and attempts to remove a table.
Version 3.2.2
1) Added refresh button to query history right-click menu.
2) Corrected issue with query results database not creating properly for SQL Server CE.
Version 3.2.0.x
1) Upgraded version of SQL Server Compact Edition from 3.1 to 3.5.
2) Increased allowed maximum size of query history database from 2 GB to 4 GB.
3) Added ARCMAIN support to SmartScript.
4) Corrected issue with some window tabs not being coloring per their system.
5) Added CTRL-E shortcut to toggle between query window text and results.
6) Added ability to view DDL for SQL Server tables.
7) Corrected various issues with SQL Server related to connection string not containing default database name.
8) Corrected issue with duplicate columns listing in systems tree for some SQL Server tables.
9) Corrected issue with data editor not functioning correctly for some SQL Server tables.
10) Corrected issue with SQL Server and Oracle columns incorrectly showing decimal values in system tree.
11) Corrected issue with error during delete of multiple items from object list window.
12) Added icon to delete objects menu item on object list window.
13) Added support for SQL Server Compact Edition.
14) Improved error handling for cut/copy/paste operations in query editor.
15) Corrected issue with returning results from ODBC DB2 queries that contain LOB columns.
16) Added query results export/save feature.
17) Added ability to convert DDL from SQL Server to Netezza.
18) Added ability to convert DDL from DB2 to Netezza.
19) Various modifications to support the future release of the Netezza OLE DB Data Provider driver.
20) Added note to application connectivity in user options to warn user that all drivers must be pre-installed before using application.
21) Added feature to system configuration window to allow user to copy settings from a pre-existing data source connection.
Version 3.1.3.x
1) Added column id as compare option for columns on SmartSync.
2) Corrected issue with sort of size column on SmartCompress window causing unhandled error to occur when user clicks, after filter applied.
3) Corrected issue with column names in tree view on SmartCompress window sometimes disappearing when collapsed and expanded.
4) Corrected issue with time not appearing on Oracle date data types in query results.
5) Corrected issue with Roles not appearing in systems tree when refreshing a DATAllegro connection.
6) Corrected issue in SmartCompress with truncation of DDL occurring due to null characters.
7) Corrected issue with extra line breaks occurring in some Teradata macro and proc definitions when using View DDL from right-click menu.
8) Corrected issue in with SmartCompress with compress values with single quotation in the value.
9) Corrected version related issue with loading of Netezza event rules in systems tree.
10) Corrected issue in SmartCompress with creation of secondary indexes when word "INDEX" is in the primary index name.
11) Added the copying of table comments in SmartCompress from original table to newly compressed table.
12) Changed SmartCompress to eliminate excluded candidates from ranking process, rather than ranking and then deleting candidates.
13) Corrected issue with creation of tables in SmartReplica where a table has a column of the same name as the table.
14) Added ability to add more than one database to query designer.
Version 3.1.0.x
1) Modified systems dropdown box to sort system names alphabetically.
2) Added dropdownlist functionality to New Query button to allow user to select system before opening query window.
3) Changed "open in new window" right-click menu option on both history grid and favorites to open window using the connection in the system current active window. For favorites, if no query window is open, then it defaults to selected system node.
4) Corrected issue with bookmark buttons not enabling when selecting "mark all" from query editor find window.
5) Added right-click menu option to query history grid to allow export/saving of history data to various file types.
6) Added ability to compact query history from options menu.
7) Added user prompt when wrong DATAllegro password is entered, allowing user to re-enter password.
8) Upgraded grids, tabs, trees, charts, and reports components to latest version.
9) Added close button to individual tabbed windows, removed close button from right of tabs.
10) Added hot tracking to tabbed windows.
11) Corrected issue with error message appearing when user creates first ever data source connection (only upon new installation).
Version 3.0.0.x
1) Changed Query Builder name to Query Syntax Builder.
2) Added query designer.
3) Increased allowed maximum size of query history database from 256 MB to 2 GB.
4) Corrected issue with columns not appearing in systems tree for SQL Server connections.
5) Corrected issue with color coding word list incomplete for DB2.
6) Corrected issue with loading of roles for DATAllegro.
7) Corrected issue with SQL comment parser.
Version 2.9.0.x
1) Corrected issue with UTF8 encoded ODBC connections where systems tree does not properly load.
2) Corrected issue with Data Slices on system information not loading properly for some Netezza users.
3) Added Greenplum support.
4) Added ability to create and delete roles for DATAllegro.
5) Added ability to create a DATAllegro user.
6) Added ability to specify default database for Netezza data source connection.
7) Corrected issue with null handling on Teradata help table command when opening results in separate window.
8) Various modifications to support the future release of the Netezza OLE DB Data Provider driver.
Version 2.8.2.x
1) Removed backups from tree for Netezza systems less than release 4.
2) Added the ability to create a Netezza user.
Version 2.8.1.x
1) Corrected compress issue with long partition statements.
Version 2.8.0.x
1) Corrected compress issue with identity columns.
2) Added various Netezza admin features (query history, active queries, data slices, table distribution, backup history, etc.) to system tree.
3) Enhanced compress to use single connection rather than multiple connections to improve performance.
Version 2.7.3.x
1) Modified about window to include e-mail and web links.
2) Corrected issue with open of save dialog boxes into My Documents folder on Citrix.
3) Changed Replica to use my documents folder as default script execution location instead of program files directory.
Version 2.7.2.x
1) Corrected issue in SmartCompress with multiple updates of values in temporary compression table.
2) Added ability to create group for Netezza.
Version 2.7.1.x
1) Corrected issue with ODBC DSN refresh and add new buttons appearing on Metadata Repository Connection window via AI DBA.
2) Corrected issue with re-opening AI DBA after encountering connection failure.
3) Added validations for connection timeout and AI DBA catalog on Metadata Repository Connection window.
Version 2.7.0.x
1) Modified query cancellation message to reflect that Nexus is submitting a cancellation request, rather than actually performing the cancellation.
2) Added AI DBA features.
3) Modified CSV and TXT direct data export to write to disk directly.
4) Modified Netezza DDL generator to handle version 4 changes.
Version 2.6.6.x
1) Upgraded licensing component to resolve minor installation issue.
2) Upgraded query editor component to latest version.
Version 2.6.5.x
1) Corrected issue with properties appearing as a menu item for DATAllegro views; this is not yet supported.
2) Added columns to systems tree for DATAllegro views.
3) Corrected issue with initialization of datagrid when user option is set to show results in new window and null values occur in result set.
4) Corrected issue with NOT NULL not appearing on DATAllegro table columns.
5) Updated list of Teradata keywords.
6) Corrected issue with handling of format keyword on decimal formatting in Teradata SQL.
7) Corrected issue with parsing of comments when double-dash comment is at end of line.
8) Added ability to save comments to table in Teradata table builder.
9) Corrected licensing conflict between MetaCensus and SmartReplica.
10) Corrected issue with edit menu items not enabling on SmartScript windows.
11) Corrected issue with Find window not appearing when focus is on history window and user selected find from main edit menu.
12) Corrected issue with timestamp requiring size on Teradata table builder.
13) Corrected issue with comment parser adding extra character when SQL text contains single quotes.
14) Corrected issue with date not appearing with time on data editor window for datetime data types.
15) Corrected issue with PPI not being created on TD FastLoad scripts from SmartReplica.
16) Added edit data feature for views.
17) Modified data editor to commit row changes only upon row change, not when switching windows or clicking other controls.
18) Added SQL Server support.
Version 2.6.4.x
1) Corrected issue with duplicate column names causing error on certain queries where the same column name existed more than twice.
2) Corrected international time format issue on history and favorites Firebird to SQL Server CE conversion routine.
3) Modified edit source/target data source window to change HOSTS file reference to TDP ID.
4) Modified edit source/target data source window to allow copying from source system when using OLEDB or the .NET Data Provider.
5) Corrected issue with usage of OLEDB and Teradata .NET Data Provider when performing intersystem data transferring in SmartReplica.
6) Corrected issue with loading of query history when using both history grid and tree when user does not have a root history node.
7) Added F10 as shortcut key to cancel a running query.
8) Added properties window for DATAllegro tables to show table information and row counts.
9) Corrected issue with Add to My Databases button not working for all systems other than Teradata.
10) Corrected issue with loading of databases drop down on query toolbar that occurred when changing systems and launching new queries.
11) Modified order of systems in systems list to appear in order of system description rather than system name.
12) Corrected issue with name and size columns not sorting on compress window.
13) Modified text wrapping on name and size columns on compress window to prevent text wrapping.
14) Added MetaCensus Management Console.
15) Modified to allow compression of table without table suffix.
16) Modified DDL creation of Netezza to remove double quote qualifications from database, table, and column names, unless they contain spaces.
17) Upgraded grids, tabs, trees, and charts components to latest version.
18) Modified query tab counter, when user option to keep query results is selected, to start count based on the highest number currently on results window.
19) Corrected issue with loading of query builder SQL due to Firebird conversion error.
20) Added ability to choose ACCESS or READ (default) lock for SmartCompress when copying table data for source table.
21) Re-ordered database types in dropdown lists to appear in alphabetical order.
Version 2.6.3.x
1) Modified register products window to pre-populate user name and organization name into each add-on registration window.
2) Corrected issue with licensing component that caused errors with fixed expiration dates.
Version 2.6.2.x
1) Corrected issue with licensing component that caused fixed expiration dates to expire sooner than designated.
Version 2.6.1.x
1) Corrected issue with SQL Server CE query builder conversion when no query builder table is present.
Version 2.6.0.x
1) Corrected issue with copied text losing formatting when pasting into query editor.
2) Modified default button on query results limit message box to NO instead of YES.
3) Corrected issue with Edit My Databases button not functioning on Oracle data sources.
4) Corrected various bugs preventing My Databases feature from functioning for Netezza data sources.
5) Modified parser to substitute carriage return/line feed characters on Teradata queries with carriage return. Resolves issues with extra spaces being inserted in macros/views via .NET Data Provider and with ODBC apostrophes in macro comments.
6) Corrected issue with query editor text not auto-indenting on next line when user presses the enter key.
7) Added user option for query history to log actual row count when user requested query limit is reached (Teradata only).
8) Added SmartDBAdmin component, which contains database view builder, database object DDL, database table collect stats, and database table select count(*).
9) Modified the database dropdown list to load the "My Databases" list at startup for default data source connection.
10) Modified the database dropdown list to load the "My Databases" list when the dropdown list is changed to another system.
11) Corrected issue with matching parentheses not highlighting in query editor.
12) Changed underlying query history and favorites database from Firebird to SQL Server 2005 Compact Edition.
13) Deprecated user query history option for maximum number of rows of query history saved.
14) Added scale to table builder for decimal data types.
15) Corrected various minor user interface bugs on table builder.
16) Modified MultiLoad builder to prevent user from selecting more than one table on an MLOAD DELETE.
17) Added DDNAME to FastLoad Type combobox.
18) Removed individual cell and row validation errors from table builder window and moved edits to save button to improve usability.
19) Corrected issue with "lock for access button" appending lock on non-select explains (Teradata only).
20) Modified Teradata ODBC connections to support regional settings (to handle decimals and thousand separator).
21) Removed product images from splash screen and replaced with text.
22) Corrected error with batch scheduler that occurred when a space was in the data source or user name.
23) Corrected error with loading of Nexus with no default data source when multiple data sources are specified.
24) Corrected error with Teradata biginteger data type mapping to byteinteger in the system tree columns list.
25) Corrected error with Teradata udt data type not mapping in the system tree columns list.
26) Added button in Tools/Options/Application/General to reset default window settings.
27) Added button in Tools/Options/Application/General to reset default user options settings.
28) Added Tools/Options/Application section and moved Connectivity, Online, and Help underneath Application settings.
29) Added query results and query history user option to disable tool tip on cell text overflow.
30) Corrected issue with date conversion on loading of Nexus history for null values in date field.
31) Added database time (DB Time) to query history to show actual database execution time of query.
32) Corrected error in message label on SmartSync compare data window that showed source table name instead of target name.
33) Corrected issue with Teradata explain keyword being removed out of SQL text when explains are executed from menu toolbar.
34) Added table builder functionality for DATAllegro and Netezza.
35) Added batch scheduler option to SmartSync objects window.
36) Modified query window to bypass validation of catalog and allow query execution in situations where catalog may not be present (DB2 MVS).
37) Added “What's New” menu item to Help menu, to get to this document.
38) Added menu item in query window to copy selected text to new query window.
39)Modified query tab counter, when user option to keep query results is selected, to start count from pre-existing number, rather than a count of the tabs (which could result in duplicate tab names).
40) Added find button to main toolbar.
41) Corrected issue with find, copy, and select all main menu items not functioning when cursor positioned in grid results.
42) Corrected issue with system tree nodes not loading correctly loading the first time a data source connection is created for Netezza or DATAllegro.
Version 2.5.0.x
1) Modified DATAllegro connection to handle additional ODBC drivers.
2) Added ability to specify default database on DATAllegro connections.
3) Changed "null character" in user options to "null text" to allow for length of more than one null character.
4) Added FastLoad, FastExport, BTEQ, MultiLoad, TPump wizards (part of SmartScript component).
5) Upgraded query editor component to latest version.
6) Upgraded grids, tabs, trees, and charts components to latest version.
7) Added query editor user option to allow user to copy text to clipboard as RTF (to preserve syntax coloring).
8) Modified systems tree to load table columns and indexes upon clicking folders, rather than on clicking of table.
9) Corrected issue with numeric formats on compression window and compression user options for systems with international settings.
10) Modified window mdi tabs to only show a total of 30 characters in tab text.
11) Added tooltips to all window mdi tabs. Query editor tabs will contain connection information in addition to window title.
12) Added create table window.
13) Added direct data export button to query toolbar.
14) Added CTRL-F4 shortcut key to close active window mdi tab.
15) Added CTRL-SHIFT-F4 shortcut key to close all window mdi tabs.
16) Added CTRL-ALT-SHIFT-F4 shortcut key to close all window mdi tabs but active tab.
17) Added DB2 support query editor and systems tree.
18) Corrected issue with multiple prompts for same named parameter on query editor window.
19) Corrected issue with the appending of newline characters to parsed query statements; newline character was removed.
20) Corrected issue with --, /*, and */ being removed from parsed SQL when encased in single quotes.
21) Added user option for line modifications in query editors (turned on by default).
22) Corrected issue with date format for non-USA countries on scheduler window.
23) Corrected tooltip on copy comments option on replica window.
24) Added COMMIT and RELEASE to list of commands words that do not prompt user for tab rename, or render a tab result.
25) Modified compress custom values to allow spaces.
26) Modified error handling on options menu to display error messages in message box when user clicks OK.
27) Modified loading of splash screen to improve startup time.
28) Corrected issue with Oracle OLEDB driver validation in SmartReplica.
29) Corrected issue with Copy Comments option in SmartReplica being enabled for non-Teradata systems (this feature is currently for Teradata only).
30) Corrected issue with drag and drop of all columns from tree to query editor.
31) Modified query cancel process to execute on separate thread to prevent application hang-up when query system cancellation error occurs.
32) Added calculator to tools menu.
33) Corrected issue with truncation of time from DATAllegro date data type.
34) Corrected issue with sort order on tables in systems tree for DATAllegro.
35) Added Collect Statistics to Teradata query templates on system tree.
36) Added Build Secondary Indexes to Teradata query templates on system tree.
37) Added Copy Table with Data to Teradata query templates on system tree.
38) Added Copy Table with No Data to Teradata query templates on system tree.
39) Added APPLY to list of Teradata key words.
40) Corrected issue with parser executing extra semicolons as a SQL statement.
41) Corrected issue that resulted in selection of only top line of text when selecting block of text in query editor window with mouse.
42) Modified quick select, query favorites, query editor, query builder to insert text into query window at cursor position rather than appending to bottom of editor window.
43) Added button on Tools/Options window to allow user to backup user's Nexus configuration files.
44) Added user option to allow user to specify the column alias on drag/drop into query editor.
45) Added serial number and additional assemblies to about window.
46) Added different color bookmarks to query toolbar which allows user to switch bookmark colors.
47) Added ability to set export delimiter in user options to a custom/user-defined delimiter (which is not in preset list).
48) Added user option to disable all syntax coloring.
49) Corrected issue with viewing of Oracle object DDL.
50) Upgraded Teradata .NET Data Provider from version 1.1 to version 1.2.
51) Corrected issue with change database combobox for Teradata where periods and other characters not handled in database/user name; changed to surround database/user with double quotes.
52) Corrected issue with change database combobox that caused change command to execute twice in the background.
53) Corrected issue with change database command in query window where failed change command was updating menu bar combobox (should only update on success).
54) Added data validations to max records to return in query results user options.
55) Added query results user option to stop query automatically when max records to return is exceeded.
56) Modified right-click menu labels from Compress, Copy, Compare to SmartCompress, SmartReplica, SmartSync.
57) Corrected issues on query scheduler window with data source combobox not correctly displaying corresponding database type information when database type was changed.
Version 2.1.1.x
1) Corrected issue with alt key, caps lock key, and other keys from causing query editor to detect a false change.
2) Corrected issue with save prompt on exit of query window where window is exited if use clicks yes to save file, but then presses cancel on save file dialog.
3) Modified web service calls to use the user's default credentials, in order to handle proxy connections.
4) Corrected issue with opening table with data editor that contains decimal data when user option for displaying thousand separators is enabled.
5) Corrected issue with resetting the active cell in a data editor when a null value is inserted.
6) Corrected issue on data editor window with updating a decimal data type with a null value.
Version 2.1.0.x
1) Added select/unselect all option to SmartSync compare objects window.
2) Corrected issue with displaying of incorrect data results when user query contained multiple change database statements and identical query syntax.
3) Modified selection process in query editor window to select all text on first and last lines when user presses up/down arrow on either first or last line.
4) Corrected issue with numeric overflow during compression process on very large tables.
5) Modified loading of objects under a database/user in systems tree to allow for right-click menu to appear even upon encountering an error while loading object columns/indexes.
6) Added ability to view object DDL in Netezza via right-click menu for tables, views, and synonyms.
7) Corrected issue with query toolbar buttons disabling when launching an external application explain.
8) Corrected issue with quick-query aggregate functions where item not surrounded with syntax if user had selected the text.
9) Moved ALL button on aggregate functions from bottom of list to top of the list.
10) Added Quick View option to query templates.
11) Added "materialized" to Netezza keywords.
12) Moved Netezza system and management tables/views to bottom of list in systems tree.
13) Modified user options for null color and negative numbers in red to be disabled by default, with users needing to manually enable. This improves the performance of returning large result sets.
14) Corrected issue with displaying of column numeric size for Netezza on systems tree.
15) Modified behavior of auto-complete box to keep list open when mouse cursor leaves the query window text area.
16) Color-coded Teradata primary indexes as blue and secondary indexes as green in system tree.
17) Added table distributions to system tree for Netezza tables.
18) Color-coded Netezza distribution columns as blue in system tree.
19) Corrected issue with auto-sizing of columns based on query results not functioning.
20) Added icons for quick select and view DDL on systems tree.
21) Added ability to convert Teradata and Oracle DDL to Netezza DDL (SmartReplica license required).
22) Added ability to convert Oracle DDL to Teradata DDL (SmartReplica license required).
23) Added right-click option to insert null value into data editor grid.
24) Corrected various issues with user option to not save system password, where password was being saved to file when different configuration items were updated.
25) Added ability to change expired Teradata passwords on .NET Data Provider and OLE DB connections.
26) Corrected DDL truncation issue on compression of tables with large partitioning statements.
27) Added Netezza sequences to systems tree.
28) Corrected issue with switching systems combobox where incorrect data source was loaded when underlying data source was the same but descriptions were different.
29) Added Netezza users to systems tree.
30) Added Netezza group to systems tree.
31) Modified EXPLAIN to EXPLAIN VERBOSE on explain button for Netezza systems.
32) Corrected SQL syntax error that occurred when generating compression graphs when using .NET Data Provider for Teradata.
33) Corrected issue with refresh user right-click button not executing.
34) Corrected issue with blank item being added to change database combobox on Netezza systems.
35) Corrected issue with query execute not re-enabling when user tries to execute a blank window.
36) Corrected issue with query window locking up, due to column auto-resize, when user executes queries on multiple windows very quickly.
37) Added DATAllegro support.
38) Added $#_ to the list of column characters in the replacement variable syntax.
39) Added data types, replacement variables, and keywords to the list of colored syntax that can be changed in the user options for the query editor.
40) Corrected issue with truncation of decimals when thousand separator user option is selected.
41) Corrected issue with query scheduler when using Teradata .NET Data Provider or OLEDB which prevented query from scheduling.
Version 2.0.1.x
1) Corrected issue with system color-code getting set to gray upon modification of data source connection without color assigned.
2) Modified to collapse server treenode during server refresh.
3) Corrected backward compatibility issue with translation of Oracle privilege sets and previous Nexus release that caused error upon startup.
4) Corrected issue with editing history query when in grid only mode.
5) Corrected issue with loading SQL history in both grid/tree mode.
6) Added user option to toggle qualification of column name with object name on drag/drop into query window.
7) Added user option to toggle qualification of object name with database name on drag/drop into query window.
8) Added user option to toggle automatic selection of "Lock for Access" on query toolbar (Teradata only).
9) Corrected issue with first line of text in query window (even when not highlighted) always being pre-selected as name of favorite query.
10 Corrected issue with query execution (occurred when user clicked execute or pressed F5 more than once, very quickly) that allowed user to execute query while another query is executing.
11) Corrected issue with query scrolling through all results when user requested to stop execution at their preset limit (Teradata only).
12) Modified undo and redo buttons to enable/disable depending on list of actions.
Version 2.0.0.x
1) Added data source name to compare results (in addition to source and target labels) on compare objects window.
2) Added timeout and deadlock retry attempt option to compare object window.
3) Added link to about window to copy support information to clipboard.
4) Corrected issue with nodes on query tree expanding and then collapsing when user first clicks the + to the left of the node.
5) Added user option to turn off tree-view of query history. New installations of Nexus will default to grid only.
6) Added query date index to firebird history table to improve query time and memory usage on startup.
7) Reduced splash screen display time on initial startup to improve startup time.
8) Modified query to history table to select smaller set of rows to improve startup time.
9) Added icons for Teradata and Oracle systems.
10) Added support for generic ODBC connections.
11) Added tooltip to system tree node to show data source and user id.
12) Modified compress process to exclude gathering of varchar columns in data demographics when no varchars where selected for conversion to char.
13) Corrected issue with compression on table with PPI where partitioned column was a candidate for compression, and should have been excluded.
14) Modified appearance of about window and added sales contact information.
15) Corrected issue with double-dash separator being treated as a comment on a format statement and being removed when SQL is being parsed.
16) Updated Firebird database and ADO.NET drivers to latest releases.
17) Added user option to host help file/users guide locally on computer.
18) Corrected open connection issue with dropping a Netezza database.
19) Modified clear query window button to allow user to undo clear operation.
20) Added toolbar with save button on database, user, object, and table windows.
21) Added save button to toolbar on replica window.
22) Added ability to create database on Netezza.
23) Added ability to drop database on Netezza.
24) Added ability to view database properties and modify owner on Netezza.
25) Added sample button to query helper toolbar for Teradata.
26) Corrected issue with deleting custom value from top of custom value tree in compress.
27) Added support for Oracle .NET Data Provider (ODP.NET) and OLEDB Data Provider.
28) Added connection method type to query window status bar.
29) Added ability to set privilege to SYSDBA or SYSOPER on Oracle connections when using ODP.NET or OLEDB.
30) Modified systems tree structure to persist single connection to system in order to eliminate redundant open/close connections and improve performance.
31) Modified SQL parser to handle semicolons (by removing them) in Oracle queries when executing sequentially.
32) Corrected truncation issue on compression candidate report on count, savings, and cost columns.
33) Modified systems tree to load objects in background thread in order to improve responsiveness of GUI.
34) Modified query editor print routine to disregard trailing spaces when printing lines in order to prevent line breaks on printouts from appearing.
35) Added print button to main toolbar.
36) Improved error handling on web browser window.
37) Modified systems tree to load database objects when user selects object type level, instead of database level, to improve performance.
38) Corrected issue with spacing on all quick query keywords, where the trailing space is sometimes truncated.
39) Corrected issue with deleting of all query history not functioning.
40) Modified query text editor output windows to allow to set result font and to display user selected result font.
41) Renamed text on "Set History Font" button to "Set History Grid Font" on query result history options menu.
42) Modified drag/drop of Netezza objects from tree into query window to contain double periods (..) between databases and object names.
43) Modified data editor window to reset edited value back to original value upon data validation error.
44) Removed "alter table" functionality from right-click menu on systems tree; feature has been indefinitely deprecated.
45) Modified query templates (quick select, select, update, delete, insert) to encase database and table names with double-quotes.
46) Modified object list window to appear when user right clicks on either database/user node or object type node (ie, Tables) instead of by double-clicking database node or object type nodes.
47) Corrected issue with query appearing to never finish executing on queries that yield no results (for example, executing a commented out query).
48) Corrected issue in SmartSync with comparison of single column tables where invalid update statement were being created.
49) Added validation checking to synchronization features in SmartSync to prevent user from attempting synchronization with invalid options, after the validated synchronization was completed.
50) Modified query window disconnect routine to cancel any running query in active window before performing disconnect.
51) Corrected issue with error upon trying to open a compression report when the base data tables are empty.
52) Corrected issue with copy from source link on SmartReplica and SmartSync data source window for Netezza systems.
53) Improved error handling on query window to detect disconnection from server and prompt user for reconnection.
54) Corrected issue with error preventing SmartSync from comparing Netezza to Teradata data.
55) Corrected issue with system color-code getting removed upon modification of data source connection.
56) Corrected cross-database issue with opening all rows/data editor for Netezza that occurred in certain situations.
57) Modified export all results to same file option to be limited to only text and csv files.
Version 1.5.3.x
1) Corrected issue with handling of missing TPT dependencies in Replica.
2) Added additional Netezza object types to systems tree (external table, synonym, materialized view, system table, system view, management table, management view).
3) Corrected issue with objects not appearing on object list window for Netezza when user is not in default database.
4) Added ` and % to user delimiter list.
5) Corrected issue with separator text bar appearing at top of exported files.
6) Corrected issue with duplicate prompting for named parameter replacement when parameter appears more than once.
7) Corrected issue with similar named parameter names (example: ?a, ?abc) causing the wrong parameters to be renamed.
8) Added options to compare definition window to remove carriage returns from definitions and trim spaces from definitions.
9) Corrected issue with databases combo not loading when switching from system to object comparison on object compare window.
10) Added options to compare definition window to remove line feed from definitions.
11) Corrected issue with apply button appearing upon loading of package into replica window.
12) Corrected truncation issue on compression saving report when numbers exceeded 999,999,999.
Version 1.5.2.x
1) Modified summary/aggregate results on query results window to display the same display formatting as the column.
2) Added index number as part of default compare key for indexes on compare object window.
3) Added ability to right-click and copy summary data results on compare object window.
4) Corrected issue with record count limit being triggered on 256th record on Netezza queries.
5) Corrected issue with canceling of query running in TD .NET Data Provider after user limit has been reached.
6) Added system color-coding to windows and systems tree.
7) Added ability to perform database and user comparisons at the system level in SmartSync.
8) Changed description of "Rename" checkboxes on replica window to "Same name as source".
9) Removed "Get Columns" checkbox from replica window; this feature is not useful until future features are implemented.
10) Renamed "Comparison Difference Threshold" to "Default Compare Difference Threshold" on user options/compare menu.
11) Renamed compare, replica, and compress descriptions on options menu to include product names.
12) Corrected issue with query named parameters not handling uppercase letters or underscore characters.
13) Added support for multiple IP addresses/DBCNames in Teradata ODBC connections.
14) Modified to store TD connection type as a user setting instead of an application setting.
15) Modified version update check to call web service instead of direct database call.
16) Modified error handling on compare objects routine to proceed to next compare instead of aborting entire process.
17) Renamed existing User Headers on compare objects window to User Details.
18) Added new User Headers comparison on compare objects window that uses TD dbc.databases view instead of dbc.users.
19) Added show line numbers option to compare objects window.
20) Corrected bug with handling of format statement in query window.
21) Corrected spelling of data quantity on target system right-click menu on replica window.
22) Modified loading of databases and objects comboboxes on compare objects window to load comboboxes based on compare level selection.
23) Corrected issue with query timer not pausing when user is prompted to return more rows/cancel.
24) Added ability to compare system roles and profile on compare objects window.
25) Corrected issue with history window not closing upon user selection of view/query history, after a SQL statement has been executed.
26) Added ability to close results tabs on compare objects window.
27) Added message on compare data window to prompt user to select a Nexus system when previewing target synchronization SQL.
28) Corrected performance issue on compare data and compare objects window that resulted in all objects being loaded whenever databases combobox was changed by user.
29) Added status bar with timer and message on compare objects window.
30) Added stop/cancel button on compare objects window.
31) Changed default query timeout from 3 minutes to 10 minutes.
32) Removed query timeout on compare data and objects windows.
33) Added creator name to all rights compare options on compare objects window.
34) Added database filter to system compare option on compare objects window.
35) Corrected issue with null Teradata interval values not being handled on query requests.
36) Corrected issue with red X occurring on query editor window when line positions exceeds line length.
37) Corrected issue with selecting refresh on data sources window before source type is selected.
38) Added ability to export results directly to flat file on object compare window.
39) Added ability to connect to ODBC user DSNs.
40) Modified to clear all grouping columns when user unselects "group by" option on grids.
41) Added output log to object compare window.
42) Added error handling for invalid data for data type in TD columns.
43) Modified data result grids to handle multi-line data in cells.
44) Added option on query menu to export query results data directly to a file.
45) Added query window, systems tree, data editor, and batch scheduler support for Oracle.
46) Corrected issue on object list window with load failing due to selection list getting TD optimizer failure on query.
47) Corrected issue on object compare window with only tables being returned on object header compare.
48) Added user option to replace carriage return in results data with blanks upon data export.
49) Added ability to export results to Microsoft Access database.
50) Added object type filtering to object compare window.
51) Added line number to compare key on object compare window for object definition comparison.
Version 1.5.1.x
1) Added partition to the list Teradata key words.
2) Added source and target system labels to object compare results tab in SmartSync.
Version 1.5.0.x
1) Pre-filled name of query results tab into save dialog box.
2) Corrected issue with comment commands returning result grid; changed so grid will not appear.
3) Modified data source connection create window to require user to select a database/source type.
4) Corrected issue with diagnostic commands returning result grid; changed so grid will not appear.
5) Added diagnostic to the list valid Teradata commands.
6) Modified cancellation routine on data editor window to improve speed of canceling the command when user chooses to stop streaming of data.
7) Modified Nexus to support Netezza's various case identifiers in versions 3.0.x and 3.1.x.
8) Added cancel button to data sources window.
9) Added option on data sources window to automatically expand the system connection in the systems tree on application startup.
10) Modified systems tree to prevent collapsing of expanded tree node on double click.
11) Modified object list window to only close and reopen when database or object level is double clicked.
12) Added icons to data edit menu options.
13) Renamed SmartSync menu items from "Compare object data..." to "Compare data...".
14) Upgraded Teradata .NET Data Provider from Version 1.0 to Version 1.1.
15) Selecting of current_timestamp issue resolved, related to upgrade latest Version of TD .NET Data Provider 1.1.
16) Corrected issue with calculation of total space saved percentage on compress savings report.
17) Upgraded reporting component to latest version.
18) Added save to PDF option to report viewer window for compression reports.
19) Corrected mismatch issue with data editor when using .NET Data Provider.
20) Corrected open reader issue with data editor when using .NET Data Provider.
21) Updated product labels for SmartCompress, SmartReplica, SmartSchedule, and SmartSync.
22) Upgraded query editor component to latest version.
23) Upgraded grids, tabs, trees, and charts components to latest version.
24) Added query/syntax builder feature to query windows.
25) Added ability to use named parameters in query window, which prompt user for value.
26) Added user option to turn off handling of named parameters in queries
27) Added user option to turn off handling of format statement in queries.
28) Corrected issue with handling of empty character type for byte data in Unicode conversion routine.
29) Changed compress database/table tree to show primary index columns in blue.
30) Modified compress to prevent user from modifying non-compressible data types and primary indexes.
31) Modified systems tree to allow user to add database/user to My Databases list in hierarchy mode.
32) Corrected issue with character and column position counter on query window when backspacing.
33) Corrected issue with closing of results tabs while query is executing and user has keep results option selected.
34) Added object compare tool to SmartSync.
35) Corrected issue with closing query window while query is still running, which was resulting in an application error.
36) Added option to SmartSync that allows user to display messages and results grids or messages only.
37) Modified SQL execution to handle unsupported/non-ANSI Teradata data types, such as interval and second.
38) Added query menu item (on main toolbar) to change user's system password.
39) Corrected issue with random occurring during loading of web browser.
40) Improved error handling on drawing of query window text to prevent red-X from occurring.
41) Corrected issue on intersystem data comparisons that caused threshold limit to not operate correctly.
42) Corrected issue with query history/favorites database not being found on first time/clean install loading of Nexus.
43) Corrected issue with toolbar not being disabled in certain instances when all mdi children windows are closed.
Version 1.4.1.1
1) Modified driver validation process to bypass Teradata ODBC driver check if Netezza ODBC driver is installed.
Version 1.4.1.0
1) Corrected bug with generation of multi-column statistics in replica.
2) Corrected bug with execution of parallel queries which resulted in "object reference not set to instance of an object" message to appear.
3) Modified tooltip length on query results tabs to not exceed more than 1000 characters; this helps to prevent flashing of tooltip.
4) Modified startup routine to update application configuration with user's selected connectivity method when a difference is detected between the two.
5) Modified text length on query error message box to not exceed more than 300 characters; this helps to message box from being too big for the screen.
6) Corrected issue with right-click menu not appearing on query history tree.
7) Added compressible values custom list to compress to allow in inclusion and exclusion of specific values.
8) Added data editor support for Netezza.
9) Added cross-database support for Netezza.
10) Added rename and drop object functionality for Netezza.
11) Modified edit data window to use datareaders for TD OLEDB and TD .NET Data Provider.
12) Corrected issue with launching of Visual Explain when using either TD OLEDB and TD .NET Data Provider (needed to pass CLI parameter).
13) Added SmartSync support for Netezza.
14) Added user option to prompt to name query results tabs.
15) Added right-click option on query results tabs to append original query to current window or to open in new query window.
16) Corrected docking issue with system and query trees that resulted in error upon startup.
17) Corrected issue with flickering of object groupbox on replica window upon clicking of next object.
18) Modified replica to display specific error messages on create/replace procedure failures.
19) Corrected issue with invalid query duration on create/replace procedure commands from query window.
20) Added Batch Query Scheduler support for Netezza.
21) Corrected issue with apply button appearing on replica window when right-click options are selected on object settings.
22) Modified replica target tree right-click menu to only show table options when table items are present.
23) Added button to copy source connection information on choose a system window.
24) Added checkbox to Replica offering the option to copy object comments from source.
25) Added combobox to Replica offering the option to copy / override "FallBack" setting from source.
26) Removed Validate Dependencies checkbox from replica launch window.
27) Unprotected Generate Statistics checkbox on replica launch window.
28) Added query results user option to remove "locking row for access" message from query history.
Version 1.4.0.1
1) Corrected bug with time logging on non-query (create statements) executions from query window which caused error message to appear.
2) Corrected bug with replace object checkbox on replica window which caused the apply button not to appear when the box was checked by the user.
Version 1.4.0.0
1) Modified replica default setting for MCMC from Y to N.
2) Modified data edit window to suppress error message if user closes window while data is still loading.
3) Modified drag/drop of column names to return focus to query window upon drop of column into window.
4) Corrected issue with user selected open/save query folder not being persisted in memory.
5) Modified error handling on cell editor window to suppress error messages that might occur when attempting to pre-load based on cell contents.
6) Corrected issue with timestamps not displaying time value when time is 00:00:00.
7) Modified to prevent user from changing database via query toolbar when connection is disconnected.
8) Pointed Help/User Guide to Coffing Data Warehousing on-line/web help.
9) Corrected issue with query window re-connections that occurred when user switched from other Nexus windows back to the query window.
10) Modified "Select a System" message in systems combobox to read "Select..." due to size restrictions.
11) Added button on status strip of query window that allows user to quickly expand either the query editor or results panels.
12) Added ability to left/right double click query window to allows user to quickly expand either the query editor or results panels.
13) Modified invalid password error handler to prompt user for new password.
14) Added user query history option that bundles all SQL statements together as one history item, rather than individually.
15) Modified column header "Error" on history grid to "Message".
16) Modified column header "Error" on history tree view message area to "Message".
17) Added user query history option to import queries from SQL Assistant.
18) Modified history id column to be invisible during Nexus startup.
19) Converted remaining tool strip buttons into tool strip menu items.
20) Upgraded subset window to format query results.
21) Modified systems tree selection process to prevent reloading of databases and object with no children objects.
22) Added short-cut keys descriptions to menu item labels on main menu and right-click menus.
23) Added minimize button to replica launch window.
24) Corrected issue with time appearing in date values in CSV, XLS, and user delimited exported files.
25) Added initial support for the Netezza data warehouse.
26) Improved error handling on replica launch window to handle message passing when the application is minimized or out of focus.
27) Modified query history to store query duration on SQL error.
28) Added execute parallel button to main query toolbar.
Version 1.3.0.4
1) Corrected error handler to trap new TD error messages on invalid password.
2) Added ability to add multiple data source connections for the same data source.
3) Added ability to move location of history/favorites database file via tools/options menu.
4) Corrected issue with globalization of date formats for non-USA countries on query results window (non-tabbed floating).
5) Added user option to display thousand separators in query results for numeric data.
6) Modified query results to right justify data in numeric columns.
7) Added query editor user option that allows user to specify the default folder for saved queries.
8) Modified call to options overrides to occur regardless of new or previous installation.
9) Modified data source window to clear out password and user textboxes when data source is changed via combobox.
10) Corrected issue with sort order on databases and tables comboboxes in compare.
11) Corrected issue with query result datagrids not automatically scrolling when clicking (without releasing) the down and up buttons.
12) Added user option to specify number of decimals for float columns in query results.
13) Moved log on compression window to separate tab.
14) Modified compress process to redirect user to log tab while compress job is executing.
15) Added compression option to delete data from staged table upon table compression (to free perm space).
16) Added right-click menu option on results and history grid to turn off column sorting by clicking header.
17) Added right-click menu option on results grids, and new window, to allow the formatting of column data.
18) Corrected issue with missing right-click menu options on text query output windows that occurred after the message tab was clicked.
Version 1.3.0.3
1) Corrected registry path lookup issue with connection to Teradata Visual Explain.
2) Enhanced compare to allow comparison of views.
3) Added ability to sort database object lists by attribute columns.
4) Added right-click option on systems tree to allow renaming of database/user objects.
5) Corrected issue with row limit message appearing on non-select queries.
6) Corrected issue with record counts on deletes in query history.
7) Corrected issue with creation of Replica/Archive folder when Replica folder is already created.
8) Changed references on compare window from table to object to reflect that either tables or views can be compared.
9) Corrected issue with in-line comment not being parsed correct in query window.
10) Corrected issue with code complete which occurred when user typed a period as the first character in line.
11) Corrected issue with .NET Data Provider and OLEDB connections not returning all rows after being prompted by user in query window.
12) Corrected issue with globalization of date formats for non-USA countries.
13) Added confirmation box to options window when connection method is changed which allows user to cancel.
14) Added Control+Minus as comment short key in query editor.
15) Added Control+Shift+Minus as uncomment short key in query editor.
16) Added option to export/save all differences in SmartSync to one Excel workbook.
17) Modified about window to display .NET Data Provider Version number from installation directory DLL instead of Windows registry.
18) Corrected formatting of tooltip on account textbox in database properties window.
19) Added V2R6.x access right types and descriptions.
20) Corrected modal and drag issue with viewing the log in notepad via the replica launch window.
Version 1.3.0.2
1) Corrected issue with right click menu on query window results not displaying all menu items once user right clicks on message tab.
2) Modified query results tab control to select tab when user right clicks on header of tab.
3) Corrected issue with duplicate objects appearing when refreshing database/user in systems tree.
4) Corrected issue with single quote inside of string not being encased in SmartSync.
5) Corrected threading issue with executing scripts in replica without creating scripts.
6) Corrected casting of decimal issue with compression charts which occurred on large sum amounts.
7) Corrected issue with locking for access being re-appended when a query from query history (which already has locking for access) is selected and executed.
8) Modified ODBC connections to handle alternate port numbers (TDMST Port Number).
Version 1.3.0.1
1) Corrected issue with file open option being disabled on replica window.
2) Renamed file menu item "Open Query" to "Open" to be more generic for other windows.
3) Changed default file extension from .txt to .sql on query open and save menu items.
4) Corrected Unicode column length sizing issue in replica BTEQ scripts; column length was double the correct value.
5) Corrected issue in replica with Unicode handling in FastLoad scripts; columns are now defined in scripts that contain Unicode data.
6) Corrected issue with query not canceling upon user cancel request when query is still in parsing phase.
Version 1.3.0.0
1) Corrected issue with locking for access (when selected by user) not being appended to query history.
2) Modified to return focus to query editor upon query completion.
3) Added support for UDFs in systems tree.
4) Added compare table data feature.
5) Modified tooltips on history/favorites tree to use comments rather than SQL (SQL is sometimes too large).
6) Modified "Drop Compress Duplicates" label on Compress window to read "Drop Prior Compressed Table".
7) Added compress percent savings by column chart.
8) Added compress savings and cost by column chart.
9) Removed reference to data source in history database connection string.
10) Added option in replica to delete existing data in table when automatic create is NOT selected.
11) Retooled unexpected error email process.
12) Changed Nexus icon.
13) Corrected issue with right-click menu items query results not resetting when new queries are executed.
14) Corrected issue with red X occurring on query editor window when line positions are negative numbers.
15) Corrected issue with user id not appearing on query history edit window.
16) Modified query history grid to select underlying cell upon mouse right click.
17) Modified to disable query open button when query window is not active window.
18) Added copy, cut, paste, undo, and redo buttons to main toolbar.
19) Modified copy functionality on data editor window to not copy column header in addition to the data.
20) Modified cursor to display hourglass when loading compress reports and graphs.
21) Modified query history to show edit query window whenever any cell other than SQL is double-clicked.
22) Modified query history edit window so that query name is the first in the tab order.
23) Added window options to close all windows, close active window, and close all windows but active window.
24) Added links in web menu to CDW forum and bookstore.
25) Added product logos and links for SmartCompress, SmartReplica, and SmartSync on main toolbar.
26) Added right-click copy option to driver’s box on about window.
27) Added ability to refresh database/user when in hierarchy view of systems tree.
Version 1.2.0.4
1) Corrected issue with source file host name not populating in replica.
2) Corrected issue with special characters in host names not being handled in replica.
Version 1.2.0.3
1) Corrected issue with duplicate ranking on float values in compress process.
2) Modified connection string to version control database.
3) Added support e-mail to about window.
4) Corrected issue with save button on toolbar not re-enabling when replica window is activated.
5) Modified append data option in replica to bypass table create statement.
6) Removed message box that appears when replica completes.
7) Added View Log button on replica launch window that appears when completed.
8) Modified replica launch window status label to reflect number of errors.
9) Added replica user options to allow for audio notification of replica completion.
10) Added replica user options to allow for visual notification of replica completion.
11) Modified replica target system window to populate password textbox on window open.
12) Added cache of target replica systems in memory to minimize user from having to re-type connections on subsequent replica windows.
13) Added window to allow editing of source system hosts information from replica window.
14) Added host name to replica system windows to allow user to have different data source and host names.
15) Modified "Data Source*" description on data source, replica system, and query scheduler window to read "ODBC System DSN" instead of "Data Source*" when in ODBC mode.
16) Corrected issue where selecting "no" on return more query data when limit is reached was not returning the rows before the limit.
17) Modified Copy Objects and Merge Objects labels on replica windows to read "Copy into Package" and "Merge into Package".
18) Moved rename database and object checkboxes on replica window below textboxes and added "Rename" descriptions.
19) Corrected issue with handling of "RequestText" column name from show table command during compress process.
20) Added Replica batch scheduler.
21) Modified replica launch window to be fixed rather than sizable.
22) Corrected issue on replica window with automatic create option displaying replace message on confirmation.
23) Added additional instructions to hosts example window.
Version 1.2.0.2
1) Corrected issue with duplicate ranking on some tables during compression process.
2) Corrected issue with exporting to package from Replica when selecting database not already in source list.
3) Various icon modifications and additions throughout application.
4) Modified appearance of Replica target system window.
5) Modified log routine to accommodate other processes in addition to Compress.
6) Added batch scheduler for queries.
7) Modified Replica target system selection window to prevent override typing of data source name.
Version 1.2.0.1
1) Modified error messages that appear when license invalid for Replica.
2) Corrected tab order on MetaCensus window.
3) Modified to automatically drop-down databases list on Replica comparison tab when clicking to perform initial load.
4) Modified to convert all Replica flags in user settings to upper case upon user save.
5) Removed OLEDB check for Replica.
6) Moved system check to launch window instead of main replica window.
7) Added automatic version detection to startup, new user option to toggle on/off, and help menu item.
8) Modified edits on history user option settings to disallow negative numbers.
9) Modified edits on Replica settings to bypass directory edits unless changed by user.
10) Added error handling on history and favorites conversion routine to handle duplicate rows.
11) Corrected issue in compress with value ordered indexes.
12) Modified compress rebuild secondary index process.
13) Added validation for datasource on replica target system window.
Version 1.2.0.0
1) Renamed "Forced" checkbox on query editor options menu to read "Force Toolbars".
2) Added scrollbars to compress window to handle smaller screen resolutions and when application is not maximized.
3) Added query result user options to allow user to continue and prompt to continue on query error.
4) Added query result user options to allow for audio notification of query completion.
5) Added query result user options to allow for visual notification of query completion.
6) Added compress user options to allow for audio notification of compress completion.
7) Added compress user options to allow for visual notification of compress completion.
8) Moved query result user options for fonts and colors to new section on options windows.
9) Replaced history and favorites files with back-end database.
10) Modified to return focus to query window when history item is selected.
11) Added "quick select" option for tables and views from systems tree right-click menu.
12) Corrected formatting issue with drag/drop of history and favorites.
13) Added user option to lower case auto complete code.
14) Added Replica functionality into Nexus.
15) Added Shift-Delete hotkey to delete current line of text in query window.
16) Corrected issue with closing Nexus via File/Exit menu.
17) Added error message when history or favorites are unable to load.
18) Corrected issue with replica settings now being initialized on first-time setup of Nexus.
19) Added error message when user options are unable to load.
Version 1.1.1.3
1) Added data types and column lengths to columns on systems tree.
2) Corrected issue with the length on Unicode data types on systems tree.
3) Added "is sample" column to compress candidate report.
4) Added more calls to garbage collection to speed up memory freedom after a new query has been executed.
5) Corrected issue with executing help table/help column in query window.
6) Corrected issue with default data source names not loading correctly when names begin with same characters.
7) Added combobox to allow user to change database from list.
8) Added row count to status bar on query window.
9) Modified to suppress confirm delete message box on history grid when max rows reached.
10) Corrected issue with truncation of blocksize and journal information from new table DDL in compress process.
Version 1.1.1.2
1) Corrected performance bug that occurred when user selected NO on returning rows of data where row count exceeded specified limit.
2) Modified SQL parser to prevent comments from transmitting to database except for create, replace, and explain statements.
3) Upgraded Infragistics components to latest release (Version 2006 Volume 2).
4) Enhanced to allow column headers to be copied into Excel when copying/pasting all rows from sql results data grid.
5) Fixed bug with sql duration calculation on ODBC queries.
6) Corrected issue with transposed compression and source table rowcounts on compression savings report.
7) Added increased calls to garbage collection to speed up memory freedom after a new query has been executed.
8) Modified view databases/users with permspace and by database type to query from databases view instead of dbase table.
9) Removed extra tabs from query history that occurred when user drag and dropped into window.
10) Added driver information to “About” window.
11) Corrected issue with auto-complete not appearing for same database name under different systems.
12) Corrected issue with auto-complete not appearing when clicking control and space bar keys.
13) Added columns to auto-complete list.
14) Upgraded Qwhale components to latest release (Version 1.42).
15) Modified compress to handle tables with names plus suffix of 30 characters.
16) Corrected issue with writing to compression space savings report table using compress/replace option.
17) Modified View DDL option to refresh rather than cache existing DDL.
Version 1.1.1.1
1) Added user option for compressible column max threshold.
2) Modified apply button on compress window to appear boldfaced and in red.
3) Added ability to view database properties in compress menu via right-click menu.
4) Added ability to set compressible column threshold at database level and table levels via right-click menu.
5) Modified user options window to refresh compress window values upon change of defaults.
Version 1.1.1.0
1) Corrected issue with Show DDL window not displaying all lines of DDL text.
2) Added compression feature to allow user to choose if they wish to move data, or just create new table.
3) Modified MDI parent to allow window to be moved to negative left and top positions.
4) Corrected issue with Delete Reports feature on compress window; reports were not deleting.
5) Added ability to delete multiple items from history by selecting multiple lines and selecting delete from right click menu.
6) Added ability to open multiple items from history by selecting multiple lines and selecting open from right click menu.
7) Corrected issue with opening query from history when user has not selected actual sql text and opened via right click menu.
8) Corrected issue with opening query from history into separate window; it did not function when selected from grid.
9) Corrected issue with generating stored procedures; procedures with nested loops were not always created successfully.
10) Added compression feature to allow user to specify max compressible value threshold per column.
11) Added compression feature to allow user to convert VARCHAR columns to CHAR.
12) Enhanced password prompt window to show user name in addition to the system.
13) Added separate query status bar to each query window. Status bar includes system, user, system type, query status, query timer.
14) Removed query timer and status from application status bar.
15) Added line, column, and character position numbers to application status bar.
16) Modified the Modify Data Source window to allow user to open hosts file or ODBC connection window.
17) Corrected issue with stored procedure REPLACE statement; statement was truncating.
18) Modified CALL statement for procedures to return out and in/out parameters as result set.
19) Corrected issue with selected text on compress window trees being transparent on certain user's computers.
20) Corrected issue with row count in compress where large row count needed to be cast into larger data type.
21) Modified menu descriptions for data sources to read as data source connection instead of data source.
22) Added functionality that prepopulates user name for ODBC sources on data source creation window, using windows registry.
23) Modified error message for root database on data source creation to be more descriptive.
24) Added ability to copy and select all text from right click window on query output message tab.
25) Added CTRL+N as shortcut key to open new query window.
Version 1.1.0.0
1) Changed OLEDB connections to not use connection pooling.
2) Corrected issue with canceling query when using ODBC mode.
3) Corrected issue with extra pop-up menu that appeared when right clicking in query editors.
4) Added compression functionality throughout Nexus.
5) Corrected issue with some databases/users missing from hierarchy view in systems tree.
6) Improved error handling on systems tree.
7) Added exception handler window for unhandled exceptions.
8) Added config keys for error handling.
9) Added indexes tab to object properties.
Version 1.0.0.9
1) Corrected issue with updating timestamp values from data editor.
2) Corrected issue with updating rows with null values from data editor.
Version 1.0.0.8
1) Corrected issue with re-query on first set of returned rows when selecting all data after prompt.
2) Improved query logic to display to user the number of rows that will be returned up front, when exceeding specified limit, rather than after the data is retrieved.
3) Added execute parallel functionality.
4) Added ability to edit data rows in place for tables.
5) Corrected issue with undocking history window and then closing. History window has been locked down to prevent undocking.
6) Corrected issue with query timer. Timer was resetting after each minute during query execution.
7) Corrected issue with applying user option settings. Windows without the respective settings were causing Nexus to fail.
8) Corrected issue with results tab/window with blank datagrid appearing when performing a create, insert, update, delete, drop, or replace command (changed so it would not display).
9) Corrected issue where stored procedures could not be created if they did not terminate with "end;". If delimiter is not found, it will execute until end of sql text in window.
10) Corrected issue with missing pictures on object list window and code completion.
11) Added check for ODBC, OLEDB, and CLI on startup and when changing user options. Will prompt user if driver is not installed or Version is not supported by Nexus.
12) Modified query window to not include control key as criteria for determining if a user made a change to the text
13) Corrected issue with timestamps not display time in query results.
Version 1.0.0.7
1) Modified query window to keep track of its own status toolstrip messages. When user toggles between windows, the status toolstrip will display the last know messages for that query window.
2) Added elapsed time to status toolstrip, which is displayed during query execution.
3) Modified initial settings for query window so that line numbers are displayed by default rather than having the user set the option manually.
4) Modified auto-indent/un-indent feature to function without requiring user to select text.
5) Added ability to rename results tab view right click menu.
6) Modified data source combobox on query toolbar to prevent user from typing the name of a data source, which prevents users from selecting an invalid data source.
7) Modified right-click on individual cell in results data to automatically select cell underneath mouse cursor.
8) Added Nexus logo to splash screen; removed existing title text.
9) Added ability to split query window, horizontal or vertical, once text exceeds the available query window space (same time that scroll bars appear).
10) Added "lock for access" button to quick query toolbar, which automatically appends locking row for access to each select query.
11) Modified Coffing Data Warehousing logo so mouse cursor will indicate that it is a website link.
12) Fixed bug that prevented query sql and result text from being printed from results window.
13) Fixed bug that caused user to default to DBC database in new query windows; default is now either the user's default database, or the user itself.
14) Added query menu to main menu bar; query menu is similar to query toolbar, but cannot is fixed (cannot be hidden via user options).
15) Added Nexus logo to about window; changed back color to white.
16) Added ability to launch Teradata Visual Explain from Nexus, using either the selected query text or all text in query window, from either query toolbar or query menu.
17) Added new query button to file menu.
18) Added close button (for the current child window) to file menu.
19) Moved close all button from windows menu to file menu.
20) Removed options button from query toolbar.
21) Replaced results and history datagrid view with ultragrid.
22) Removed "hide selected column(s)" button from right-click menu on results.
23) Added "column chooser" to right-click menu on results to allow user to select/unselect columns using a window.
24) Added ability to export results to Microsoft Excel.
25) Added print preview function (and set as default) when printing results from grids.
26) Added enhanced find capability for results grids.
27) Added "access" to reserved/color-coded words list.
28) Added user option to set alternating row colors on results and history.
29) Added "aggregates" button to right-click menu on results and history.
30) Added "filter" button to right-click menu on results and history.
31) Added "group by" button to right-click menu on results and history.
32) Renamed "results columns" button to right-click menu on results and history to "columns"
33) Added "freeze columns" button to right-click menu on results and history columns.
34) Added "rows" button to right-click menu on results and history.
35) Added "freeze rows" button to right-click menu on results and history/rows.
36) Modified save results window to appear at center of screen rather than center of parent, to fix display problem that occurs when user is closing when application is minimized.
37) Modifications to error handling on query window exit and application exit.
38) Fixed bug that occurred when deleting history item from grid, without selecting tree node first.
39) Added user option to toggle on/off the column group by box.
40) Modified to prevent save to csv, txt, or delimited when results have been grouped; will save only as excel.
41) Added shortcut keys for find, select all, copy on results and history areas.
42) Increased size of options window.
43) Modified history grid to handle F5 key as query execute.
44) Added ability to select all rows in results and history by clicking in top-left area (left of columns, above rows)
45) Added user option to toggle on/off auto-sizing of columns based on data.
46) Added user option to toggle on/off displaying negative numbers in red.
47) Removed functionality where query text is selected when clicking on corresponding results tab.
48) Added HAVING button to quick query toolbar.
49) Added Known Issues section to readme.txt
Version 1.0.0.6
1) Corrected missing comma on the first line of output from Aggregates/All functionality.
2) Removed comma on the last line of output from Aggregates/All functionality.
3) Fixed bug with table properties/statistics; error message was not being handled when no statistics were defined on table. Only occurred using ODBC driver.
Version 1.0.0.5
1) Fixed bug with application exit upon changing data connection method.
2) Modified so that status bar message is cleared upon subsequent query execution and message is displayed to indicate that query is executing.
3) Added LTRIM, RTRIM to reserved words list.
4) Fixed bug with line breaks being eliminated when drag-dropping favorites or history.
5) Added ability to close all results tabs via the right-click menu on results tab.
6) Fixed bug with deleting history or favorite from tree view.
7) Fixed bug with object cast to string which occurred only in obfuscated version.
8) Added additional error handling to all menu item routines to improve error reporting.
9) Added Quick Query menu bar to provide user with query syntax shortcuts.
Version 1.0.0.4
1) Added ability to select entire column by clicking on column header.
2) Added ability to sort by multiple items via the right-click menu on the results datagrid.
3) Added user option to not display column headers.
4) Added user option to not display row headers.
5) Added user option to not display grid lines.
6) Added ability to hide columns from result set via right-click menu on result datagrid.
7) Added ability to show all columns from result set via right-click menu on result datagrid.
8) Modified so that all user configuration files are opened in read-only mode to prevent deadlocks with other open instances of Nexus.
9) Set syntax outline option to true as the default instead of false when upon new file creation (in past version, this was done only in one case).
10) Fixed bug when executing a "show select * from..." statement.
11) Fixed bug with the row count in history when executing more than one statement.
Version 1.0.0.3
1) Added ability to select entire line of query by clicking in the area before the line text begins.
2) Added menu item to execute query from right-click menu in query window.
3) Enhanced clarity on all drop-down menu and tree view images.
4) Creating a new data-source will validate by attempting to open a connection instead of a test query.
5) Changed specific color-coded text keywords for EXPLAIN results.
6) Added menu item to search query results from right-click menu.
7) Added user option to clear history each time an item is selected from history list.
8) Changed "Edit query information" on right-click history menu to "Edit...".
9) Changed column order on history datagrid so that comments appear after error column.
10) Added ability to edit item in query history from right-click menu in history datagrid.
11) Removed ability to rearrange the column order on the history datagrid to avoid mismatches when saving.
12) Synchronized history tree view and history datagrid when updating comments, deleting query, renaming query.
13) Added ability to drag/drop all column names for table by selecting and dragging the "Columns" node to the query window.
14) Added Indent and Unindent text functionality via the toolbar.
15) Modified object drag/drop onto query window so text is unselected each time another object is dragged.
16) Next/Previous/Clear bookmark buttons are disabled unless bookmarks exist.
17) User is now prompted for approval before removing all bookmarks.
18) Set syntax outline option to true as the default instead of false.
19) Added ability to delete item from query history from right-click menu in history datagrid.
20) Enhanced query edit window to include all properties about query.
21) Added delete all history button to option menu, which allows user to purge entire history at once.
22) Added option to turn-off automatic save of query text into history window on window closing.
23) Added ability to specify sort-order of My Databases/Custom list.
24) All docked window settings are now stored upon application exit.
25) All toolbar visible settings are now stored upon application exit.
26) Corrected issue on results tab where show table and explain results did not scroll automatically to bottom when scrolling until end.
27) New query windows will be opened with the name Query# (instead of New Query), with # being a sequential number starting with 1.
28) Added ability to open query into existing or new window from right-click menu in history datagrid.
29) Added user option that prompt's user to save any unsaved text in query windows upon window and/or application exit.
Version 1.0.0.2
1) Added ability to stack column titles in query results, using "//" to indicate line breaks.
2) Query window will not load until after the welcome window appears.
3) Changed executable name from CDW.Admin.Presentation.exe to Nexus.exe.
4) Fixed issue with right-click on drop-down menu from the close 'X' on history window, which caused program to fail when selecting items.
5) Query results window (separate window, not tabbed) will return to normal or maximized state when next query runs, instead of staying minimized (when user had minimized window).
6) Fixed issue with comments at end of SQL statement causing error when executing query.
7) Fixed issue that occurred when two or more queries were executed, without a line break or space between the statements.
8) Fixed issue that occurred when extra semi-colons appeared between queries.
9) Fixed issue with comments at beginning of set/change database query.
10) Fixed issue with splash/startup screen that caused password prompt to be hidden behind splash screen.
11) Fixed issue with FORMAT statement where d3, mmmm, m4, eeee, and e4 results were being truncated.
12) Added Features and Functionality document.
Version 1.0.0.1
1) Initial release.
