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

Next