Foundation: Data Sources
TimeXtender Classic provides robust connectivity for your data warehouse, enabling seamless integration with SQL-based systems through flexible configuration options.
Key features include:
- Provider flexibility: Easily switch between database providers (e.g., Oracle → SQL Server) without breaking transformations.
- Data type overrides: Resolve compatibility issues like MySQL dates pre-1753 by converting DateTime → DateTime2.
- Metadata extraction: Automatic detection of primary/foreign keys from source systems that expose this information.
- Schema organization simplifies navigation by allowing table grouping at the data source level, streamlining object management within Business Units.
- Query tables: Create virtual tables using custom SQL statements for advanced filtering/joins during ingestion.
- Adapters for enterprise systems simplify extraction by normalizing table structures across multi-company implementations.
- Any ODBC: TimeXtender supports any providers installed on the server, facilitating connections like MySQL & Snowflake.
Supported data sources span:
- Relational Databases
- SQL Server
- Oracle
- MySQL
- DB2
- Microsoft Access (via ODBC)
- Cloud Systems
- Azure SQL Database
- Snowflake
- REST APIs
- Flat Files
- CSV
- Excel
- JSON
- XML
- ERP Adapters
- Dynamics AX
- SAP
- Salesforce
- Infor Movex/M3
- Microsoft Dynamics CRM
- Microsoft Dynamics GP
- Microsoft Dynamics Business Central (NAV)
- Sun Systems
- UNIT4 Agresso
- Other data sources
More information about data sources can be found here - Connecting to Data Sources