Stambia for Relational Databases

Stambia provides specific components for all types of relational databases. Using these components, you can access the databases to read and write and perform simple to complex transformations.

Stambia helps you build integration pipelines that produces native SQL scripts specific for the technologies, in a Universal Mapper.

Connect to any databases with ETL / ELT Stambia

Relational Database Components: Use Cases & Requirements

Use an ELT solution to maximize performance

ETL, back in the days was required due to the inability of the database engine to perform complex transformations. Relational databases over the years have improved in many ways.

From providing more optimized features, to handling big volumes of data, to performing complex operation on these datasets.

Hence, the database engine is more capable than ever. Working with these advanced analytical RDBMS, requires invoking native loaders, import and export, copy commands etc.

With an improved and robust database engine, currently the adoption of ELT practices has improved performance and provided greater flexibility in setting up integration pipelines.
Robust native parallel processing, newer datatypes for e.g. JSON, SPATIAL, CSV etc. And many more features can be leveraged in building the integration designs.

ELT solution to maximize performance
 

Universal and Unique approach to specific technologies

Universal and Unique approach to specific technologies

Every organization's Information system is using at least one relational database management system (RDBMS) to support their business data.

These databases could be supporting an application or could be used as a warehouse for analytics and reporting purposes. In some project, RDBMS have been used to support a unique architecture such as Data Hub.

With Information Systems using standard relational databases such as Oracle, IBM DB2, Microsoft SQL Server, MySQL, PostgreSQL etc., it is very important to cater to these database technologies in the specific way they work.

Therefore, a generic solution cannot support the complex needs. The Integration solution must provide specific components to bring the best performance.

On the other hand, provide a Universal approach of managing heterogenous technologies to keep your designs simple.

Some examples of Cloud projects made with the Stambia solution

 

Hybrid solution for as-a-service databases

With the advent and adoption of cloud, a lot of the relational databases are available in the marketplace.

These databases provide the same functionality with a pay-per use model.

Migrating data to these cloud databases, integrating the daily data from various source systems to on cloud database, working on a Hybrid model with databases that are on-prem or on cloud etc. becomes a norm.

In such projects it is essential to have a single solution, that is Hybrid and can cater to the various needs that are on-premise or on cloud.
On the other hand, provides a consistent way to manage your designs in a Hybrid environment, hence providing agility in your projects..

Hybrid solution for as-a-service databases in cloud

Features of Stambia Component for Relational Databases

Stambia Component for Relational Databases provides the ability to work with one or more RDBMS technologies and to access, extract, load and transform data in and out of it these databases.

These components automate a lot of manual design as the entire integration solution for database technologies is templatized.

Stambia uses JDBC as the standard way to connect to databases.
JDBC allows native access to all the databases without the need to install any connector or any database client API.

Stambia mapping with JDBC

An ELT approach to employ optimized database utilities

Stambia implements the ELT principles, in order to provide the best level of performance on databases.
The E-LT Stambia Approach consists in doing the transformations on the underlying systems without adding a proprietary engine.

The transformations are made by the databases or other technologies (OLAP, Operating Systems, etc.) according to their transformation capabilities.

Stambia will use all the native components of the underlying technologies (such as the database loaders, native CDC etc.) to maximize the performance.

ELT principles with Stambia
 
 

Dedicated Component for each technology with a Universal way of designing

Stambia provides dedicated components for each type of relational databases to cater to various forms of distinction that exists in these technologies.

These relational databases conceptually behave the same way but are distinct from each other syntactically, which means a generic solution would not be enough to fulfill the requirements.

The specific components generate native code for e.g. when using Oracle Database as a Target, you may use SQL Loader or DBLink etc.

And when having MS SQL Server as a Target you may prefer Bulk Load or BCP etc.

And with the Universal Mapper, users across different teams and projects, design in a consistent way.

Stambia specific components generate native code for databases
 

Deploy your designs on any environment

Deploy your designs on any environment

With the same Components, and using the same solution, thanks to the Universal Mapper, the integration designs can be configured to connect to a relational database on cloud (DB-as-a-service).

With Stambia's Replicator templates, the data can be easily migrated to cloud. And the same mappings can be quickly configured to point to the cloud instance with a quick Metadata update.

The data integration processes then can be deployed on Stambia Runtime which is a hybrid component and can be installed anywhere.

This increase productivity and agility in your projects.
As well, optimize the overall cost to move your data to cloud due to the notion of templates and with an ELT approach you manage & optimize the transformations and computations on cloud..

Technical specifications and prerequisites

SpecificationsDescription

Protocol

JDBC, HTTP

Structured and semi-structured

XML, JSON, Avro

Standard Features From Stambia Runtime S17.5.6

Stambia Runtime Version

Stambia DI Runtime S17.4.7 or higher
Non-exhautive lis of supported technologies

RDBMS:
• Actian Ingres
• IBM DB2 UDB V8.x, V9.x, V10.x
• IBM DB2/400, DB2/MVS
• Informix
• Oracle, Oracle Hexadata, 8i, 9i, 10g, 11g, 12c
• Oracle RDB
• Microsoft SQL Server 2019 & previous
• MySQL 8.0 & previous
• Postgre SQL 12.3 & previous
• SAP Sybase ASE
Other databases:
• DBase
• H2
• Hyperfile
• Hypersonic SQL
• Lotus Notes
• Microsoft Access
• Microsoft Excel
• Paradox
MPP databases:
• EMC Greenplum
• IBM Netezza (Pure Data)
• Oracle Hexadata
• Teradata Vantage 17 & previous
Vectorial or In-Memory databases:
• Actian Vectorwise
• Vertica
• Monet DB
• SAP Sybase IQ
• SAP S3 HANA
Cloud databases:
• Amazon Redshift
• Amazon RDS (Oracle, MySQL...)
• Google Spreadsheet
• Google Cloud SQL
• Azure SQL
• Snowflake
Hadoop:
• Hive
• HBASE
• Impala
No SQL:
• MongoDB
• Cassandra
• Elastic Search

Want to know more ?

Consult our resources

Anonymisation
Ask advices to our experts in Data integration.
Contact us
Anonymisation
Replay Webinar : How to accelerate data integration to Google BigQuery!
Watch Replay
Anonymisation
Your customized demonstration
Get your demo
Anonymisation
Discover our training and certifications
To know more about it

Subscribe to Stambia newsletter

Sign up for our email newsletters and stay connected to the best ideas in data integration

Send me the Stambia newsletter. I expressly agree to receive the newsletter and know that I can easily unsubscribe at any time.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.