Data integration for Amazon S3, Redshift and RDS

Open Connector for Amazon

Simplify data integration with your cloud components

The Open Connector for Amazon is the best way to simplify interaction (extraction or integration of data) with the Amazon cloud technologies, including Amazon S3 , Amazon Redshift or Amazon RDS .

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

It is possible to address any type of project including Business Intelligence in the Cloud

All preconfigured templates can also be adapted to the customer’s needs in order to provide the best solution and fit with all your needs.


Connectivity to S3

S3 is the protocol defined by Amazon to push information, such as flat files, into the Amazon cloud environment.

Stambia enables pushing files or extacting data from traditional relational databases to Amazon S3. This data can then be managed by other cloud applications or by other Stambia integration processes.


Integration to Redshift and RDS databases

Stambia enables the loading of Redshift or RDS tables from any other source whether from the local systems or from the cloud information systems. The Amazon RDS databases can be Oracle, My SQL, Postgre SQL or other compliant databases.

Stambia supports massive data loading with a high level of performance, using the native functionalities of Redshift (Or RDS) and Amazon S3 to load the data.

Stambia gives the possibility to choose different strategies for the integration part : simple append, incremental integration, slowly changing dimensions. The management of rejects and business rules is integrated and optimized for Redshift or RDS.

Stambia will generate the appropriate SQL orders needed to improve the performance on such databases.


Replication and synchronization components

The replication component of Stambia allows to quickly replicate an entire database towards Redshift or RDS databases. It is particularly useful when initializing a new Amazon database, in order to initiate and migrate the database from an existing third party database.

Companies wanting to be quickly operational on Amazon without having to reconstruct all the databases from scratch can greatly simplify and accelerate the process of migrating the Business Intelligence databases.

This component is optimized for Redshift and can bring the best level of performance.


Autonomous execution in the cloud

Some companies need to manage autonomous executions in the cloud. Traditional data integration solutions have difficulties to bring this opportunity to their customers, because of the proprietary engine that would have to be deployed in the cloud.

The ELT architecture of Stambia allows to install a runtime in the Cloud with no high costs or technical difficulties for the customers.

This runtime will be totally autonomous and compliant with the cloud architecture.