AZURE SQL SERVER INTEGRATION SERVICE INTERFACE
Xtract IS for Azure – Plug’n’Play for SAP and Azure SQL Server Integration Services
„Xtract IS is a really intelligent interface thanks to the available delta logic – and it also comes at a very fair price.“
Christof Meier, Project Manager in charge at JUST AG
The main features of Xtract IS for Azure
Seamless integration between SAP and Microsoft Azure-SSIS Integration Runtime.
Deploy, schedule and run your SSIS packages, containing Xtract IS for Azure components, on Microsoft’s Azure-SSIS IR (as a part of Microsoft Azure Data Factory v2). Leverage the proven SAP extraction capabilities of the on premises version of Xtract IS and simply shift it to the Azure Cloud.
The concept is a no-brainer: Develop on Prem, run in the Cloud.
And the best part: With Xtract IS for Azure you can either develop new SSIS packages from scratch or use your existing SSIS packages developed with Xtract IS Ultimate/Enterprise.
Xtract IS for Azure Table Join
The Table Join Component allows to mix/merge several tables. It is possible to join tables for document headers and items into one single resultset.
The Join-process takes place entirely within the SAP system, which does not require to download each single table anymore.
- Table-comprehensive selection criteria
- Creating a view in SAP manually not necessary anymore
- Supports aggregations and criteria within the aggregation
- Granularity of data will be scaled down
- Optimization of extraction performance
Xtract IS for Azure Query
SAP queries are so popular as data suppliers because tables can be joined on the SAP end without any developer authorization. With Xtract IS Query, you can make your SAP queries directly available in the Integration Services. With a graphical user interface and full metadata support, the result is available for further processing within seconds.
Xtract IS for Azure BW Cube
Xtract IS BW Cube is a data source for SQL Server Integration Services (2005 – 2014) with which datasets can be extracted from SAP BW InfoCubes and BW queries. The dimensions, key figures and attributes to be transferred can simply be dragged and dropped into the query output. This turns complex, cubic data structures into relational data that are easy to handle.
Xtract IS for Azure Hierarchy
Unfortunately, Open Hub Services do not support extraction from BW hierarchies. Due to this, the Xtract IS Hierarchy component was developed. It makes it possible to extract all hierarchy types from the BW. The image below shows the component at the design time. If necessary, hierarchy texts can also be read in.
Xtract IS for Azure DeltaQ
The Xtract IS DeltaQ component forms the top class of the BI components for SAP access by SSIS. With its help, the Extractor API in SAP R/3 can be addressed and in such, the functionality with which BW systems also secure their data supply from the production system can be used.
cMORE/Connect for SAP from pmOne AG is the perfect tool if you are looking for a faster way to build an enterprise-class data warehouse with your SAP data. Integrate your SAP and other data with much less development effort and SAP Certified connectivity.
- Automates building ETL processes for bringing virtually any (standard or custom) SAP data into Microsoft SQL Server and Microsoft APS
- Prebuilt Business Content (flexible analytical databases with a variety of metrics) for jump-starting a data warehouse
- Makes managing ETL processes for multiple (Dev, Test, Production) environments or instances of SAP ECC and SAP BI (SAP BW) much easier
Seamless integration of SAP and Microsoft at PUMA
Bridge for the gap between Kanban and SAP-System
Interoperability between SharePoint and SAP
Your advantages with Xtract IS for Azure
- Based on SAP certified technology*
Minimal to zero modification in your SAP system
Very fast installation and configuration
Fast, simple, user-friendly; programming knowledge not necessary
Cross-module and module independent
show more advantages
100 % type safety with full meta data support
Business logic is available
Robust, standardized process for incremental loads (Delta Logic)
Seamless integration for both read and write
Cost savings through optimal integration, no friction losses
*Our SAP certified product ERPConnect provides the kernel for all our products and is responsible for the connection to each SAP system.
Xtract IS for Azure is based on our SAP certified product ERPConnect.
Xtract IS integrates itself in the Business Intelligence Studio of the SQL Servers 2008 – 2016. On the SAP side, SAP release 4.0B or BW 3.0 is the minimum requirement.
Xtract IS is licensed per server. An unlimited number of SAP systems and developers is covered. There are two different license packages, depending on which components you want to use.
Every license comes with six months of maintenance. Apart from technical support via phone or email, this also includes updates for all versions that are released within this period. After the six-month maintenance period is over, an additional year of maintenance can be purchased for 20% of the license fee. There is no right for updates after expiration of maintenance.
Yes. We provide the consulting you want and need. From a single-day workshop up to a complete interface solution. Please contact us at email@example.com.