Azure Data Factory, a service built for all data integration needs and skill levels which helps you integrate your data silos. Easily construct ETL and ELT processes code-free within the intuitive visual environment, or write your own code. Visually integrate data sources using more than 80 natively built and maintenance-free connectors at no added cost. Focus on your data—the server-less integration service does the rest.
SSIS
Microsoft SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions. Use Integration Services to solve complex business problems by copying or downloading files, loading data warehouses, cleansing and mining data, and managing SQL Server objects and data. Integration Services includes a rich set of built-in tasks and transformations, graphical tools for building packages, and the Integration Services Catalog database, where you store, run, and manage packages.
Theobald Software
SAP integration made easy. The interfaces of Theobald Software pave the way for you. Data integration into the cloud, BI & Analytics, databases and process integration.
Xtract IS – Integrate your SAP system (ERP, S/4HANA, BW) with SQL Server Integration Services. With a few clicks of the mouse, you can extract mass data with high performance and stability.
Xtract IS for Azure – Leverage the proven SAP extraction capabilities of the On-Premises version of Xtract IS and simply move it to the Azure cloud.
add.BI ETL / ELT Framework
Over the years we have and are still developing our own ETL/ELT framework with the purpose to increase our speed and quality of implementations and not forgetting on reusability and standardization which provides us ability to switch developer between projects without an issue. add.BI ETL/ELT Framework provides you either on-prem (SQL Server) or cloud (Azure Data Factory, Azure Data Warehouse):
- Metadata driven development
- Easier & Faster
- Standardized (naming conventions, best practices)
- It takes away routine tasks and error handling
- Easier maintenance & change management
- Code reusability
- Error Logging, Alerting
Analytics Center of Excellence (Data Governance)
The main purpose of a CoE is to establish, identify, develop, and harness cross-functional processes, knowledge, and expertise that have tangible benefits for the business. They serve as channels through which project managers, practice managers, business customers, and line managers can fulfil projects, teams, and business initiatives. Most important, COEs continually generate and refresh knowledge, competencies, practices, and skills with the goal of informing and guiding others working in the same business domain. Typical services that should be looked at are:
- Data governance and data stewardship
- Information delivery
- Data acquisition
- Support (1st line, 2nd line & 3rd line)
- Training
- Analytics Program management
- Vendor management
Data Stewardship (Datally)
Datally is a versatile business application. It’s a product built by ADD software development team. Its design is based on the rich experience of application architects and business analysts.
Main goal for Datally is to provide simple and intuitive data management user interface for typical business user and for typical business implementations:
- data enrichment and embellishment for Data Warehouse / Business Intelligence solutions
- supporting business specific tasks for bridging application and technology gaps
- replacing spreadsheet files with data sharing using single point of data entry and supervising
- running and monitoring data processing jobs
- self and assisted application building from own business data ranging from simple lists up to complete business processes