Cloud Component

Open Connector for Salesforce

Simplify integration and extraction of data with Salesforce

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

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

All preconfigured templates, provided by Stambia, can also be adapted to the customer’s needs in order to provide the best solution.


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, Teradata, Netezza, Microsoft SQL Server, Amazon Redshift,...

It can also be used to include Salesforce into the real-time business process of the organisation, using other application connectors of Stambia, in order to connect to other ERP such as SAP.


Native reverse engineering

Stambia allows to reverse any type of information, either native or specific, from Salesforce applications.

Descriptions of specific fields or Salesforce tables, as well as Salesforce internal identifiers and dates, are retrieved which provide an exhaustive view of all data and metadata.

This information is then used in Stambia data flows in order to optimize loads or detect changes in Salesforce


Intelligent integration and extraction methods

Extractions and integrations can be done either in realtime or batch mode, using the bulk interface of Salesforce. The Salesforce connectivity provides the possibility to use native identifiers as well as creation or update dates, in order to automatically detect the differences, and then update, insert, merge the data or decide to do nothing, depending on the contents of the incoming records.

With simple mappings defining the business rules, Stambia generates and executes complex processes to achieve an automatic incremental integration of the organisation’s data.

Stambia can use natively:

  • The Salesforce date/time fields
  • The Internal identifiers
  • The External identifiers

This information is used to detect the modifications and then compare the data to the existing data in a third party application or in a database.


Replication and synchronisation component

The replication component of Stambia allows to quicly replicate data from Salesforce to a third party database, and then also to replicate data from this database to the Salesforce application.

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 Salesforce and the underlying databases. This brings the best level of performance.

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.