Stambia Data Integration allows to work with Microsoft Azure SQL Databases, offering the possibility to produce fully customized Integration Processes.
The database structure can be entirely reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.
Specific Azure templates moreover allows to optimize loading steps with the use of Microsoft Azure Storage containers.
- The Microsoft Azure Storage Java libraries must be installed in the Runtime (see this article).
- The Microsoft SQL Server JDBC library (sqljdbcxx.jar) must be installed in the Designer and Runtime.
Stambia DI is a flexible and agile solution. It can be quickly adapted to your needs.
If you have any question, any feature request or any issue, do not hesitate to contact us.
This component may require a dedicated license.
Please contact the Stambia support team if you have any doubt and if you need to use it in a production environment.
You can find below the necessary material to work with Microsoft Azure SQL Databases in Stambia DI
|Generic Templates||Package containing the generic Templates||
Package containing the specific Templates.
As Azure SQL Databases are SQL Server databases behind the scenes, The SQL Server templates contained in this package are required.
Package containing the Azure Templates.
Azure specificities are handled in dedicated templates that can be found in this package.
|Demonstration Project||A project that demonstrates Azure features through examples of Mappings and Processes||download|
To learn how to install and use Microsoft Azure SQL Database in Stambia DI, have a look at the following getting started article.
You can find below an overview of what Stambia DI can do with Microsoft Azure SQL Databases
The database structure can be reversed in a dedicated Metadata
|DDL /DML Operations||
DML/DDL operations can be performed on the database, such as: Insert, Update, Select, Delete, Create or Drop
The databases can be used as a staging area to make data transformation, mutualization, ...
The following modes are supported:
Reject rules can be defined to filter or detect data that does not fulfill the rules during integrations.
Replication of databases is supported.
The replication source can be any rdbms, Flat files or XML files.
|Slowly Changing Dimension Integrations||Integrations can be performed using Slowly Changing Dimension (SCD)|
|Change Data Capture||The Change Data Capture (CDC) allows to follow and store all the changes on the tables|