Jet Analytics Enhanced Data Source Providers to Replace CData Providers
As stated in this announcement, support for CData providers in Jet Analytics has been discontinued. A broad range of new Jet Analytics data source providers has been developed to provide a more flexible and reliable alternative.
The table below lists CData providers (including the latest version available in Jet Analytics) alongside their recommended replacements. While the goal is to eventually replace all CData providers with Jet Analytics enhanced data source providers, development is ongoing. Where a Jet Analytics enhanced provider is not yet available, other alternatives are provided.
For information on how to change a data source provider, see Change data source provider.
| Provider | Latest Version | Alternatives |
|---|---|---|
| Act! CRM | 24.0.8963.0 | Jet Analytics REST |
| Amazon Redshift | 24.0.8963.0 | Odbc Data Provider, OleDb Data Provider |
| API | 24.0.8963.0 | Jet Analytics REST |
| Azure Active Directory | 24.0.8963.0 | OLE DB Provider for Microsoft Directory Services, Jet Analytics REST |
| Azure Analysis Services | 24.0.8963.0 | Microsoft OLE DB Provider for Analysis Services 14.0 |
| Azure Cosmos DB | 24.0.8963.0 | Odbc Data Provider |
| Azure Data Lake Storage | 24.0.8963.0 | Jet Analytics CSV Data Source |
| Azure Synapse | 24.0.8963.0 | Azure Data Factory - SQL Server, Jet Analytics SQL Data Source |
| Basecamp | 24.0.8963.0 | Jet Analytics REST |
| Box | 24.0.8963.0 | Jet Analytics REST |
| CSV | 24.0.9104.0 | Jet Analytics CSV Data Source |
| Databricks | 24.0.8963.0 | Odbc Data Provider |
| eBay Analytics | 24.0.8963.0 | Jet Analytics REST |
| Elasticsearch | 24.0.8963.0 | Jet Analytics REST |
| Exact Online | 24.0.8963.0 | Jet Analytics Exact Online Data Source |
| FTP | 24.0.8963.0 | Jet Analytics CSV Data Source |
| Google Analytics | 23.0.8839.0 | Jet Analytics REST |
| Google BigQuery | 24.0.8963.0 | Odbc Data Provider, OleDb Data Provider |
| GraphQL | 24.0.9008.0 | Jet Analytics REST |
| HubSpot | 24.0.8963.0 | Jet Analytics HubSpot Data Source, Jet Analytics REST |
| Jira | 24.0.8963.0 | Jet Analytics REST |
| JSON | 24.0.8963.0 | Jet Analytics XML and JSON Data Source |
| MariaDB | 24.0.8963.0 | Odbc Data Provider, OleDb Data Provider |
| Microsoft Access | 24.0.8963.0 | Odbc Data Provider |
| Microsoft Active Directory | 24.0.8963.0 | OLE DB Provider for Microsoft Directory Services, Jet Analytics REST |
| Microsoft Dataverse | 24.0.8963.0 | Jet Analytics REST |
| Microsoft Dynamics 365 | 24.0.8963.0 | Jet Analytics Business Central 365 Data Source, Jet Analytics Business Central 365 Option Values, Jet Analytics Dynamics 365 Business Central - Online, Jet Analytics Dynamics 365 Business Central - SQL Server, Jet Analytics Dynamics 365 Finance - SQL Server, Jet Analytics Navision Option Values Data Source, Jet Analytics OneLake Finance & Operations Data Source |
| Microsoft Dynamics 365 Business Central | 24.0.8963.0 | Jet Analytics Business Central 365 Data Source, Jet Analytics Business Central 365 Option Values, Jet Analytics Dynamics 365 Business Central - Online, Jet Analytics Dynamics 365 Business Central - SQL Server, Jet Analytics Dynamics 365 Finance - SQL Server, Jet Analytics Navision Option Values Data Source, Jet Analytics OneLake Finance & Operations Data Source |
| Microsoft Dynamics CRM | 24.0.8963.0 | Jet Analytics Business Central 365 Data Source, Jet Analytics Business Central 365 Option Values, Jet Analytics Dynamics 365 Business Central - Online, Jet Analytics Dynamics 365 Business Central - SQL Server, Jet Analytics Dynamics 365 Finance - SQL Server, Jet Analytics Navision Option Values Data Source, Jet Analytics OneLake Finance & Operations Data Source |
| Microsoft Dynamics NAV | 24.0.8963.0 | Jet Analytics Business Central 365 Data Source, Jet Analytics Business Central 365 Option Values, Jet Analytics Dynamics 365 Business Central - Online, Jet Analytics Dynamics 365 Business Central - SQL Server, Jet Analytics Dynamics 365 Finance - SQL Server, Jet Analytics Navision Option Values Data Source, Jet Analytics OneLake Finance & Operations Data Source |
| Microsoft Excel | 24.0.9033.0 | Microsoft Jet 4.0 OLE DB Provider, Jet Analytics Excel Data Source |
| Microsoft Excel Online | 24.0.8963.0 | Microsoft Jet 4.0 OLE DB Provider, Jet Analytics Excel Data Source |
| Microsoft Office 365 | 24.0.8963.0 | Jet Analytics REST |
| Microsoft Planner | 24.0.8963.0 | Jet Analytics REST |
| Microsoft SharePoint | 24.0.8963.0 | Jet Analytics REST |
| Microsoft SharePoint Excel | 24.0.8963.0 | Jet Analytics REST |
| Microsoft Teams | 24.0.8963.0 | Jet Analytics REST |
| MySQL | 24.0.8963.0 | Azure Data Factory - MySQL, Odbc Data Provider, OleDb Data Provider, Jet Analytics MySQL Data Source |
| NetSuite | 24.0.8963.0 | Jet Analytics REST |
| OData | 24.0.8963.0 | Jet Analytics OData Data Source |
| Oracle | 24.0.8963.0 | Azure Data Factory - Oracle, Microsoft OLE DB Provider for Oracle, OracleClient Data Provider, Jet Analytics Oracle Data Source |
| Parquet | 24.0.8963.0 | Jet Analytics OneLake Delta Parquet Data Source, Jet Analytics Parquet Data Source |
| PostgreSQL | 24.0.8963.0 | Azure Data Factory - PostgreSQL, Odbc Data Provider, OleDb Data Provider |
| REST | 24.0.8963.0 | Jet Analytics REST |
| RSS | 24.0.8963.0 | Jet Analytics REST |
| Salesforce | 24.0.8963.0 | Jet Analytics REST, Jet Analytics Salesforce Data Source |
| SAP Cloud for Customer | 24.0.8963.0 | Azure Data Factory - SAP Table, Jet Analytics SAP Table Data Source |
| SAP HANA | 24.0.8963.0 | Azure Data Factory - SAP Table, Jet Analytics SAP Table Data Source |
| ServiceNow | 24.0.8963.0 | Jet Analytics REST |
| SFTP | 24.0.8963.0 | Jet Analytics CSV Data Source |
| Shopify | 24.0.8963.0 | Jet Analytics REST |
| Smartsheet | 24.0.8963.0 | Jet Analytics REST |
| Snowflake | 24.0.8963.0 | Odbc Data Provider |
| SugarCRM | 24.0.8963.0 | Jet Analytics REST |
| Trello | 24.0.8963.0 | Jet Analytics REST |
| Workday | 24.0.8963.0 | Jet Analytics REST |
| XML | 24.0.8991.0 | Jet Analytics XML and JSON Data Source |
| Zendesk | 24.0.8963.0 | Jet Analytics REST |
| Zuora | 24.0.8963.0 | Jet Analytics REST |