Teradata

Connector for Teradata

Open Connector for Teradata

Optimize your Teradata data flows

The Open Connector for Teradata is the best way to simplify interaction (extraction or integration of data) with the Teradata MPP system, providing a high level of productivity with an amazing simplicity.

With the same agility as the other Stambia connectors, the Teradata Open Connector is directly usable and offers a high level of performance due to the ELT approach of the transformation and the use of native tools and specifities of Teradata.

The Model Driven Approach of Stambia (templates) is used to adapt the connector to all types of projects.

 

Native reverse engineering

Stambia allows to reverse any type of information, either standard information such as schemas, tables and columns, but also specific information such as primary indexes and other metadata specificities.

Moreover, the Stambia Model Driven Approach gives the opportunity to adapt (add) specific metadata which can then be used to optimize or process specific operations.

 

Intelligent integration and extraction methods

Stambia uses specific methods adapted to Teradata in order to integrate or extract the data.

Load or export can be done using tools such as Teradata Parallel Transporter, Fastload, Multiload, Fastexport and other utilities provided by Teradata.

The incremental mode of integrating the data proposes different methods such as "insert and update", renaming table methods, "delete and insert" methods or "merge" operations.

Primary indexes and statistics are detected and used to improve the performance.

"Query band" can be used to track the SQL orders generated by Stambia and provide a way to optimize and master the processes.

Teradata-Screenshot3  

 

Replication and synchronisation component

The replication component of Stambia allows to quicly replicate data from any third party database towards Teradata. This is particularly useful when initializing a new Teradata database, in order to initiate and migrate the database from an existing third party database.

This can be done with simple parameters and without any complex designs.

The Stambia universal mappings can also be used to complete and adapt the replication process in case there is a need to implement business specificities.

This component is optimized for Teradata and the underlying third party databases. This will bring the best level of performance.

 

Used for both Business Intelligence and real-time projects

The connector is a part of a complete data integration solution which can be used to load large amounts of data for datawarehousing projects, using other Stambia connectors to many databases such as Oracle, Netezza, Microsoft SQL Server, Amazon Redshift, MySQL...

It can also be used to include realtime data into Teradata, using other application connectors of Stambia, in order to connect to other ERP such as SAP or Salesforce.