Added Azure SQL Data Warehouse to Teradata in the database mover. The Super Join Builder now supports joins from Azure SQL Data Warehouse to Teradata. Metrics for Azure SQL Data Warehouse have been added to the Super Join Builder. No. PI tables are now displayed in the WHERE tab of the Super Join Builder.
Fixed a parsing issue when running multi- statement SQL requests on Hadoop. Fixed an issue creating cubes in the Super Join Builder when the Teradata Calendar table had been added.
Fixed an issue in the Super Join Builder where columns in the WHERE clause tab were not being added to data movement. Version 1. 1. 1. 1. Added data movement from Redshift to DB2 in the single- table data mover.
Added several analytic functions to the in- memory Garden of Analysis such as List. Agg. 3. Removed the Indexes on Redshift node and split it into two separate nodes for Distribution Key and Sort Keys.
Added Constraints, References and Referenced By nodes to the Redshift system tree. Primary Key will now be highlighted with an different icon in the Redshift system tree.
The distribution key column will now be colored blue in the Redshift tree. Column compression will now be shown as a column attribute in the Redshift system tree.
Added table- level refresh to Redshift system tree. Fixed data source re- connection issue when Redshift ODBC driver connection state is “Starting.
Fixed issue moving Date columns from Redshift to Teradata. Fixed issues where comments were not being sent to the driver.
This can be turned on or off in Tools > Options. View alias issue in the Super Join Builder which was causing WHERE clause items to not populate has been fixed. Changed text “serial number” to “activation key” globally. Added program bit- type to information copied to clipboard in Help > About. Version 1. 1. 1. 0. Added Hadoop to Teradata, SQL Server, Oracle and DB2 in the single- table data mover. Added Hadoop to Teradata in the database mover.
Added first- phase custom SQL in Super Join Builder. Updated Hadoop indexes and partition display in system tree. Updated Teradata Aster partition and constraints display in system tree. Direct Data Export is tied to each query window now. Added DB2 metrics to the Super Join Builder. Fixed timestamp fractional display issue for timestamps with over 7 fractional seconds.
Fixed issue saving to Tableau format when using Direct Data Export. Fixed issue when video help XML file is empty. Removed hard- coded USEREGIONALSETTINGS=Y in Teradata connection string to help with localization. Modified test connection for Hadoop to make connections more stable. Fixed Query. Grid foreign server alias mismatch error in the Super Join Builder. Fixed licensing issues on some wire- protocol drivers. Added additional logging on scheduled batch processes.
Removed external table node in Teradata Aster system tree. Fixed Recent File List error when saving to a text file. Brown Bunny John Frusciante Download Chrome. Quick Select from Hadoop will no longer show partition columns. Fixed comma- separated values file compression issue. Updated Hadoop Super Join Builder demo for Hadoop. Hadoop query syntax errors in the Super Join Builder are fixed.
Query. Grid query syntax errors in the Super Join Builder are fixed. Modified My Schemas on Teradata Aster to allow filtering of schemas in system tree. Fixed numeric formatting issue in Hound Dog Compression. Fixed localization issue with pulling Teradata version number in Hound Dog Compression.
Fixed Teradata Aster reconnection issues when loading objects in the Super Join Builder. Fixed formatting issue in Hound Dog Compress for float data types. Fixed regression issues with TD1. Removed partition check for systems earlier than Teradata 1. Hound Dog Compression.
Fixed DDL NULL column issue in SAP Hana when converting tables from other systems. Excluding non- index partition columns from Hound Dog Compression. The array data type will show in the Teradata system tree. Fixed “object not set to a reference of an object” error in the Super Join Builder when using Query. Grid. Version 1. 1. Added Greenplum to Teradata data movement options.
Added Greenplum to SQL Server data movement options. Added Greenplum to Oracle data movement options. C Programming Language Ebook Download.
Added Greenplum to Azure SQL Data Warehouse data movement options. Added DB2 to Teradata data movement options. Added DB2 to SQL Server data movement options.
Added DB2 to Oracle data movement options. Added DB2 to Azure SQL Data Warehouse data movement options. Added DB2 to SAP Hana data movement options. Added DB2 to DB2 data movement options. Added Teradata to DB2 data movement options. Added Teradata to SAP Hana data movement options.
Added Teradata to Hadoop data movement options using Sqoop. Added SQL Server to DB2 data movement options. Added Oracle to DB2 data movement options. Added Oracle to SAP Hana data movement options. Added Oracle to Hadoop data movement options using Sqoop.
Added SQL Server to SAP data movement options. Added SQL Server to Hadoop data movement options using Sqoop. Added Azure SQL Data Warehouse to DB2 data movement options.
Added Azure SQL Data Warehouse to Azure SQL Data Warehouse movement options. Added Azure SQL Data Warehouse to SAP Hana data movement options. Added SAP Hana to Oracle data movement options. Added SAP Hana to SQL Server data movement options. Added SAP Hana to Azure SQL Data Warehouse data movement options. Added SAP Hana to DB2 data movement options.
Added SAP Hana to SAP Hana data movement options. Added Hadoop to Oracle data movement options.
Added Hadoop to SQL Server data movement options. Added Hadoop to DB2 data movement options. Added Excel import to Oracle.
Added Excel import to Teradata. Added Excel import to SQL Server. Added Excel import to Azure SQL Data Warehouse. Added Excel import to DB2. Added Excel import to SAP Hana. Added table data type conversions for all new data movement options.
Scheduler has been redesigned. New way to schedule queries via the scheduler. Super Join Builder queries and data movement can now be scheduled. Comparisons between systems can now be scheduled.
Data movement between systems can now be scheduled. Teradata Compression can now be scheduled. Updated the DB2 system tree.
Updated the Greenplum system tree. Added support for SAP Hana in the system tree. Added support for Postgres in the system tree. Nexus will now handle objects in Hadoop tree based on if they are a table or view. Added several new objects to the Oracle system tree.
Fixed issue on SQL Server with My Databases filter menu on system tree. Fixed Vertica issue displaying multiple items in system tree. Fixed query issues with DB2 9. Made changes to how Excel data types are displayed in the system tree. Fixed several issues displaying system information in Netezza system tree. Super Join Builder joins can be saved. Added support for Query.
Grid to Super Join Builder. Added Hadoop support in the Super Join Builder. Updates to Redshift in Super Join Builder. Added Greenplum support in the Super Join Builder.
Fixed cube tables error in the Super Join Builder. Added Greenplum to database compare module. Added Redshift to database compare module. Added new AWS product keys for government region. Turned off all internet calls for AWS government region. Updated Amazon Product Codes for New AWS government region. Nexus can now export data results to Tableau (.
Logon Mechanism crash fix when creating a data source. OS Polling Integration to facilitate data movement. Added lexer for SAP Hana and Postgres. Optimized the code to set the correct lexer for all systems. Fixed conversion bug between Teradata and SQL Server.
Fixed bug joining tables in the Garden of Analysis. Updated copyright to 2.
Added Greenplum demo database. Fixed issues with Hadoop data type conversions to other systems. Moved the data movement log to its own tab in the ODBC Stream Loader. Fixed several Redshift issues in the Super Join Builder. Updated Greenplum keywords in the parser. Added Execute as Batch option to Oracle queries.