CData Software - Knowledge Base
Recent Articles
-
Connect to XML in the Denodo Platform
Use CData driver technologies to create a virtual data source for XML Files in the Denodo Virtual DataPort Administrator.
-
Automate Oracle Financials Cloud Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Oracle Financials Cloud and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Establish a Live Connection with Teradata using Tableau Bridge
The CData ODBC Driver for Teradata enables you to integrate live Teradata into Tableau Cloud dashboards using the Tableau Bridge.
-
Replicate Multiple ClickUp Accounts via the CData Sync CLI
Replicate multiple ClickUp accounts to one or many databases.
-
Create a Data Access Object for TigerGraph using JDBI
A brief overview of creating a SQL Object API for TigerGraph in JDBI.
-
Build Dashboards with Email in DBxtra
Create dynamic dashboards and perform analytics based on Email in DBxtra.
-
Create Datasets from HubDB in Domo Workbench and Build Visualizations of HubDB in Domo
Use the CData Software ODBC Driver for HubDB to create datasets from HubDB in Domo Workbench and then build visualizations in the Domo service.
-
Create Dynamic PostgreSQL Grids Using the Infragistics XamDataGrid
Learn how you can connect PostgreSQL to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData API Server to Access Oracle SCM in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle SCM in the Power Pivot business intelligence tool.
-
How to Query PingOne in MySQL Workbench
Execute MySQL queries against live PingOne from MySQL Workbench.
-
Import Smartsheet into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Smartsheet. In this article, you will use the OData format to import Smartsheet into Microsoft Power Query.
-
Connect to ServiceNow from a Connection Pool in Jetty
The ServiceNow JDBC Driver supports connection pooling: This article shows how to connect faster to ServiceNow from Web apps in Jetty.
-
Connect to SAP Concur from Crystal Reports
Use CData Connect AI to connect to and report on live SAP Concur from Crystal Reports.
-
How to Connect to & Open QuickBooks Time in Microsoft Excel
This article uses the CData ODBC driver for QuickBooks Time to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create a Data Access Object for Confluence using JDBI
A brief overview of creating a SQL Object API for Atlassian Confluence in JDBI.
-
Migrating data from SuiteCRM to Databricks using CData SSIS Components.
Easily push SuiteCRM to Databricks using the CData SSIS Tasks for SuiteCRM and Databricks.
-
Integrate with Live Sage 200 in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Sage 200 from the MuleSoft Anypoint Platform to integrate live Sage 200 into custom reports and dashboards.
-
Automated Continuous SQL Server Replication to Databricks
Use CData Sync for automated, continuous, customizable SQL Server replication to Databricks.
-
Query JSON Services in DataGrip
Create a Data Source for JSON in DataGrip and use SQL to query live JSON.
-
Visualize Live Excel of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Excel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Pipedrive to Google BigQuery using CData SSIS Components.
Easily push Pipedrive to Google BigQuery using the CData SSIS Tasks for Pipedrive and Google BigQuery.
-
How to Work with Highrise in AWS Glue Jobs Using JDBC
Connect to Highrise from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Dashboards with Avalara AvaTax in DBxtra
Create dynamic dashboards and perform analytics based on Avalara AvaTax in DBxtra.
-
Automate Marketo Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Marketo and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use the CData Software JDBC Driver for Active Directory in MicroStrategy Web
Connect to Active Directory in MicroStrategy Web using the CData Software JDBC Driver for Active Directory.
-
Import BigCommerce into the Power BI Service for Visualizations
Use CData Connect AI to connect to BigCommerce and provide access to live BigCommerce for custom reports in the Power BI Service.
-
Access Live LinkedIn Ads in AWS Lambda (with IntelliJ IDEA)
Connect to live LinkedIn Ads in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData ODBC Driver for IBM Cloud Object Storage in Microsoft Power Query
You can use the CData IBM Cloud Object Storage ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import IBM Cloud Object Storage into Microsoft Power Query.
-
Use ChatGPT to Talk to Your SAP Hybris C4C via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your SAP Hybris C4C for you.
-
Build ADP-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ADP.
-
Visualize Drift in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Drift into TIBCO Spotfire.
-
Build Agents in Relevance AI with Access to Live BigCommerce via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on BigCommerce within intelligent agent workflows.
-
Integrating Dataiku with Azure Table via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Azure Table Storage.
-
How to Connect to Live Zuora from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Zuora for you.
-
Create Confluence-Connected Applications in Appsmith
Connect to Confluence via CData Connect AI in Appsmith and create custom business applications with real-time access to Atlassian Confluence.
-
Query Klaviyo as a MySQL Database in Node.js
Execute MySQL queries against Klaviyo from Node.js.
-
Create Data Visualizations in Cognos BI with Couchbase
Access Couchbase as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Access Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Access replication to PostgreSQL.
-
Analyze SAP ByDesign with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP ByDesign from Power Pivot. You will use the Table Import Wizard to load SAP Business ByDesign. You can visually build the import query or use any SQL supported by the driver.
-
Integrate IBM Cloud Object Storage in the Pentaho Report Designer
Publish reports based on IBM Cloud Object Storage in the Pentaho BI tool.
-
Connect to Google Calendar in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Calendar and connect to Google Calendar in Akorbi Digital RunMyProcess.
-
Analyze Live Avalara AvaTax in SAS Viya
Use CData Connect AI to connect to Avalara AvaTax from SAS Viya and deploy self-service analytics using live Avalara AvaTax.
-
Connect to JotForm in HULFT Integrate
Connect to JotForm as a JDBC data source in HULFT Integrate
-
TigerGraph Reporting in OBIEE with the TigerGraph JDBC Driver
Deploy the TigerGraph JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Migrating data from MYOB AccountRight to Google BigQuery using CData SSIS Components.
Easily push MYOB AccountRight to Google BigQuery using the CData SSIS Tasks for MYOB AccountRight and Google BigQuery.
-
Connect to LinkedIn Ads in HULFT Integrate
Connect to LinkedIn Ads as a JDBC data source in HULFT Integrate
-
Automated Continuous Phoenix Replication to SQLite
Use CData Sync for automated, continuous, customizable Phoenix replication to SQLite.
-
Use the CData Software JDBC Driver for Exact Online in MicroStrategy
Connect to Exact Online in MicroStrategy Developer using the CData Software JDBC Driver for Exact Online.
-
Access Live Aha! in AWS Lambda (with IntelliJ IDEA)
Connect to live Aha! in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Claude to Talk to Your Stripe via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Stripe for you.
-
Access Live Tally in Coginiti Pro
Connect to and query live Tally ERP from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Odoo Replication to SingleStore
Use CData Sync for automated, continuous, customizable Odoo replication to SingleStore.
-
Build Stripe-Powered Applications in Cursor with CData Code Assist MCP
-