In a context where data is at the heart of organizations, data integration has become a key factor in the success of digital transformation. No digital transformation without movement or transformation of data.
Organizations must meet several challenges:
Be able to remove the silos in the information systems
Agile and fast processing of growing data volumes and very different types of information (structured, semi-structured or unstructured data)
Manage massive loads as well as ingest the data in real-time (streaming), for the most relevant decisions
Control the infrastructure costs of the data
In this context, Stambia responds by providing a unified solution for any type of data processing, which can be deployed both in the cloud and on site, and which guarantees control and optimization of the costs of ownership and transformation of the data.
With a unique architecture and a single development platform, Stambia Enterprise can address any type of data integration projects, whether projects addressing very large volumes of data or more real-time oriented projects.
Here is a non-exhaustive list of feasible projects:
Business Intelligence (datawarehouses, datamarts, infocentres) & Analytics
Big Data, Hadoop, Spark et No SQL
Platform migration to the Cloud (Google Cloud Plateform, Amazon, Azure, Snowflake…)
Exchanges of data with third parties (API, Web Services)
Data Hub project, exchange of data between applications (batch or real-time mode, exposure or use of Web Services)
Unlike traditional approaches, which are technical-process oriented, Stambia offers a vision based on the "universal" mapping: any technology must be able to be fed or read in a simple way, regardless of its structure and complexity (table, file, Xml, Web Service, SAP application, ...). It's a business-oriented data vision
The Stambia approach is based on models. The notion of templates or adaptive technologies offers a capacity for abstraction and industrialization of data flows. This approach increases productivity, agility and quality during the completion of the projects.
Stambia's vision is to enable its customers to master the cost of ownership of data integration projects and platforms. This is possible thanks to the Stambia business model and the technological approaches that increase productivity and improve the learning curve.
The architecture of Stambia Enterprise is based on three simple components:
Designers are development and test UI. Designers rely on an Eclipse architecture for easy sharing and flexible management of developments and team projects.
Runtimes are the processes that execute the jobs in production. They are based on a Java architecture facilitating their deployment on site or in the cloud. They are compatible with Docker and Kubernetes architectures.
Stambia Analytics is the web component that enables production (deployment, configuration and planning) and job tracking, as well as the management of different runtimes.
Technical specifications and prerequisites
Simple and agile architecture
1. Designer: data integration development studio
2. Runtime: engine that executes data integration processes
3. Production Analytics: management of production (logs, delivery)
You can extract data from:
Any relational database system such as Oracle, PostgreSQL, MSSQL, ...
Any NoSQL database system such as MongoDB, Elasticsearch, Cassandra, ...
Any High performance database system such as Vertica, Teradata, Netezza, Action Vector, Sybase IQ, ...
Any Cloud system such as Amazon Web Service (AWS), Google Cloud Platform (GCP), Microsoft Azure, ...
Any ERP applications such as SAP, Microsoft Dynamics, ...
Any SAAS applications such as Salesforce, Snowflake, Big Query, ...
Any Big Data system such as Spark, Hadoop, ...
Any Messaging MOM or ESB such as JMS, Apache Active MQ, Kafka, ...
Any file type such as XML, JSON, ...
Any spreadsheet such as Excel, Google Spreadsheet, ...