 |
Data Warehousing and ETL for All Your Data Sources
Enterprises store data in a variety of different source systems. Therefore, the data warehouse must be able to integrate with many different systems and files.
Furthermore, all data must be part of the ETL process in order to provide a clear and accurate picture of the state of the business. timeXtender connects to virtually any data source to ensure that the final output in reports and dashboards is valuable and trustworthy.
Extract, transform and load (ETL) data from multiple data sources
|
|
|
Text files
Use timeXtender's adapters - designed specifically for extracting data from your IT systems
For some systems timeXtender comes with specially designed adapters that make the connection to those systems fast and painless.
 |
 |
 |
 |
Data warehousing and ETL for Microsoft Dynamics CRM Online and on-premise
With the Microsoft Dynamics CRM Online adapter timeXtender solves the issue of extracting data from CRM Online. timeXtender seamlessly pulls data from Microsoft CRM Online to an on-premise data warehouse. Using the adapter, timeXtender connects to CRM Online and pulls data from all standard entities such as accounts, contacts, leads, opportunities, etc. as well as from any custom entities and fields.
Naturally, timeXtender also connects to the on-premise version of Microsoft Dynamics CRM.
Data warehousing and ETL for Microsoft Dynamics AX
The tailor-made Dynamics AX adapter simplifies and speeds up the process of unlocking data from the ERP system. And timeXtender gives you a solid data foundation because you can integrate with other data sources as well.
-
Global company accounts selection with an option of overriding at table level
-
Virtual company accounts extraction including table collections and tables
-
Base enums and associated labels extraction
Data warehousing and ETL for Microsoft Dynamics NAV
timeXtender gives you unlimited access to information in Dynamics NAV and enables you to integrate with data from other sources.
-
Global company accounts selection with an option of overriding at table level
-
Single logical data model – including SIFT tables regardless of the number of physical tables
-
Dimension table merge across company accounts
SQL Server based data warehousing for SAP R/3
If your organization uses SAP, you can now easily extract data from your SAP R/3 system into a Microsoft SQL Server based data warehouse solution. As a result, it is no longer a labor intensive project to migrate data from SAP R/3 to SQL Server. The timeXtender SAP adapter ensures that you can extract mass data from SAP r/3 with the highest degree of performance and stability.
The timeXtender SAP adapter offers you a number of different modules for SQL Server based on certified technology from German SAP experts Theobald Software:
-
Table
Extracts data quickly and reliably. Depending on your need, data can also be restricted with any Where statement, and there is support for Dynamic SQL statements, including SSIS variables. -
Query
Makes type-safe SSIS data flows from SAP Queries available in just seconds. -
DeltaQ
Connects to the extractor API of the SAP system and thereby utilizes the functionality that SAP’s Business Information Warehouse (BW) systems use to manage their data supply from the ERP production system. It enables SAP controlled incremental loads. -
BAPI
Makes it possible to call BAPIs and RFC function modules directly from your SSIS data flow. -
BW Cube
Extracts attributes and key measures from BW Cube and BEx Queries. Complex multidimensional data structures are turned into relational data that are easy to handle.
 |
Download Whitepaper "Understanding the Differences Between Using Standard AX OLAP Cubes in Microsoft® Dynamics® AX 2009 and timeXtender as a BI Platform"
Download Whitepaper "Advantages of Implementing a Data Warehouse During an ERP Upgrade"
"It is simply the solution we all dreamed of both in the IT Department and among Management, because it is both fast and user-friendly."
IT System Manager,
Jens Erik Møller,
Fertin Pharma A/S