Data Sources

  • Build-in Connectivity: MS SQL Server, Oracle, SAP ERP, S4/HANA with Theobald Software (ODP, DeltaQ/Tables), SAP Business One with AnalyticsCreator own connectivity, SAP ODP objects, Excel, Access, CSV/Text, OLEDB (e.g. Terradata, Netezza, DB2..), ODBC (MySQL, …) , OData , Azure Blob Storage (CSV, Parquet, Avro), REST, MS Sharepoint, Google Ads, Amazon, Salesforce CRM, Hubspot CRM, MS Dynamics 365 Business Central, MS Dynamics Navision
  • 3rd party Connectivity: Access to more than 250+ data source with C-Data connector [www.cdata.com/drivers]. This allows for connection to AnalyticsCreator directly by an ODBC, or OLE DB driver, or by connecting an ingest layer with externally filled tables.
  • Define Your Own Connectivity: (Any data source, Hadoop, Google BigQuery/Analytics, Amazon, Shop solutions, Facebook, LinkedIn, X (formerly Twitter)) In all cases of access to source data an AnalyticsCreator-metadata-connector is created. The AnalyticsCreator -metadata-connector is a description of data-sources you use for more easy handling in AnalyticsCreator. AnalyticsCreator is able to automatically create a metadata connector by extracting the data definition from your source data. it contains information about key fields, referential integrity, name of fields and description.