CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Egnyte Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Egnyte replication to OneLake in Microsoft Fabric.
-
Import Sage Cloud Accounting Data Using Azure Data Factory
Use CData Connect AI to connect to Sage Cloud Accounting Data from Azure Data Factory and import live Sage Business Cloud Accounting.
-
Use the CData Software ODBC Driver for Telegram in MicroStrategy
Connect to Telegram in MicroStrategy Developer using the CData Software ODBC Driver for Telegram.
-
Replicate Shortcut Data from PowerShell
Write a quick PowerShell script to query Shortcut. Use connectivity to the live data to replicate Shortcut to SQL Server.
-
Stream Autopilot Data into Apache Kafka Topics
Access and stream Autopilot in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Connect to & Open Tavily Data in Microsoft Excel
This article uses the CData ODBC driver for Tavily to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Drift Replication to Snowflake
Use CData Sync for automated, continuous, customizable Drift replication to Snowflake.
-
Build Agents in Relevance AI with Access to Live Cosmos DB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Cosmos DB within intelligent agent workflows.
-
Integrate Cline with Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live MariaDB from within your IDE.
-
Build Charts with Tanda Data in Clear Analytics
Create dynamic charts and perform analytics based on Tanda in Clear Analytics.
-
Publish AdRoll-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live AdRoll.
-
Integrating Antigravity CLI with Pipedrive via CData CLI
Connect Pipedrive to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Create SendGrid-Connected Applications in Appsmith
Connect to SendGrid Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SendGrid.
-
ETL Helpscout in Oracle Data Integrator
This article shows how to transfer Helpscout into a data warehouse using Oracle Data Integrator.
-
Automated REST Data Replication to Teradata
Use CData Sync to Customize and automate REST replication to Teradata.
-
How to work with Google Ads Data in Apache Spark using SQL
Access and process Google Ads Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to Google Sheets Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Google Sheets in Airbyte.
-
Connect to Simplesat Data in CloverDX (formerly CloverETL)
Transfer Simplesat using the visual workflow in the CloverDX data integration tool.
-
Replicate Multiple Elorus Accounts
Replicate multiple Elorus accounts to one or many databases.
-
How to Create Power BI Visual Reports with Real-Time Amazon DynamoDB Data
Use CData Power BI Connectors to visualize Amazon DynamoDB in Power BI.
-
Integrating Antigravity CLI with Onfleet via CData CLI
Connect Onfleet to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate with Demio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Demio to a JSON file on disk.
-
Prepare, Blend, and Analyze Coinbase Data in Alteryx Designer (ODBC)
Build workflows to access live Coinbase for self-service data analytics.
-
Connect Mailjet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mailjet using the CData Python MCP Server.
-
View Reports on Real-Time Brex Data in Power BI Report Server
Use the CData ODBC Driver for Brex to visualize Brex in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Greenplum with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Greenplum with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Pivotal GreenPlum.
-
Deploy the ADO.NET Provider for EnterpriseDB on an SSRS Report Server
Connect to EnterpriseDB from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build Zoho Projects-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho Projects and build web apps with connectivity to live Zoho Projects.
-
Query Freshdesk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Freshdesk from Node.js.
-
How to Connect to Live AlloyDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Google AlloyDB securely in real time.
-
Natively Connect to Bugsnag Data in PHP
The CData ODBC driver for Bugsnag enables you to create PHP applications with connectivity to Bugsnag. Leverage the native support for ODBC in PHP.
-
Visualize Aircall Data in TIBCO Spotfire through ADO.NET
Integrate Aircall into dashboards in TIBCO Spotfire.
-
Replicate Power BI XMLA Data to Multiple Databases via the CData Sync CLI
Replicate Power BI XMLA to disparate databases with a single configuration.
-
Visualize Live Parallel Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Parallel using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use the CData Software ODBC Driver for Perigon in MicroStrategy Web
Connect to Perigon in MicroStrategy Web using the CData Software ODBC Driver for Perigon.
-
Build a PostgreSQL Interface for ZohoInvoice Data using the CData JDBC Driver
Use the Remoting features of the ZohoInvoice JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for CapsuleCRM
Provide connectivity to CapsuleCRM through an SAP BusinessObjects universe.
-
Publish Basecamp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Basecamp.
-
Edit and Search Neo4J External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Neo4J to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Neo4J objects that you can access from apps and the dashboard.
-
Replicate JSON Services in Heroku for Use in Salesforce Connect
Replicate JSON to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
DataBind Charts to Superchat Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Superchat from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
How to Connect SAP Ariba Source Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP Ariba Source data in real time using natural language.
-
Create Jira Assets-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Jira Assets Data from Klipfolio and build custom visualizations using live Jira Assets.
-
Access Live Smartsheet Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Smartsheet from your Excel spreadsheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Trello
Provide connectivity to Trello through an SAP BusinessObjects universe.
-
Automated Continuous Confluence Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Confluence replication to PostgreSQL.
-
How to connect and process Perplexity from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Perplexity.
-
Connect to Okta Data in DBArtisan
Use wizards in DBArtisan to configure Okta as a data source.
-
Visualize Live Mode Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Mode.
-
How to import Monday.com Data into Apache Solr
Use the CData Software JDBC Driver for Monday.com in Data Import Handler and create an automated import of Monday.com to Apache Solr Enterprise Search platform.
-
Connect to and Query Rebilly Data in QlikView over ODBC
Create data visualizations with Rebilly in QlikView.
-
Use the CData Software ODBC Driver for Harvest in MicroStrategy Desktop
Connect to Harvest in MicroStrategy Desktop using the CData Software ODBC Driver for Harvest.
-
Use Microsoft Copilot Studio to talk to your Salesforce Pardot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Salesforce Pardot for you.
-
Migrating data from Paylocity to Databricks using CData SSIS Components.
Easily push Paylocity to Databricks using the CData SSIS Tasks for Paylocity and Databricks.
-
Analyze Rebilly Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Rebilly from Power Pivot. You will use the Table Import Wizard to load Rebilly. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Tableau Connector for SAS xpt
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAS xpt.
-
Create Google Calendar-Connected Applications in Appsmith
Connect to Google Calendar Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Calendar.
-
Extract, Transform, and Load Splunk Data in Informatica PowerCenter
Create a simple Workflow for Splunk in Informatica PowerCenter.
-
Integrate Invoiced Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Invoiced from Informatica Cloud.
-
How to Connect DBeaver to Workable via a JDBC Driver
Manage Workable with visual tools in DBeaver like the query browser.
-
DataBind Contentful Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Contentful to a chart.
-
Access Perigon Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Perigon from your Oracle system.
-
Operational Reporting on iContact Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote iContact.
-
How to publish and share Google Translate Data dashboards with Tableau Server
The CData ODBC driver for Google Translate enables you integrate Google Translate into Tableau dashboards.
-
ETL Yelp in Oracle Data Integrator
This article shows how to transfer Yelp into a data warehouse using Oracle Data Integrator.
-
Use the CData Software ODBC Driver for Azure Synapse in MicroStrategy Desktop
Connect to Azure Synapse in MicroStrategy Desktop using the CData Software ODBC Driver for Azure Synapse.
-
Add Paylocity Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paylocity with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData Power BI Connector for Asana
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Asana.
-
Use the CData Software ODBC Driver for Wave Financial in SAS for Real-Time Reporting and Analytics
Connect to real-time Wave Financial in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Wave Financial.
-
Query SharePoint Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SharePoint entities in PHP by modeling them as objects.
-
Access Live Gumroad Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Gumroad in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build a Simple VCL Application for SharePoint Data
How to build a simple VCL Application to view Microsoft SharePoint in RAD Studio using the CData ODBC Driver for SharePoint.
-
Connecting Agentforce with DocuSign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your DocuSign for you.
-
Integrating Antigravity CLI with ZarMoney via CData CLI
Connect ZarMoney to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Avro with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Avro with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Avro.
-
Automated Continuous Google Forms Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Forms replication to Azure SQL Database.
-
Feed Datadog Data into FineReport
How to set Datadog as a JDBC data source in FineReport.
-
Integrate LeadDesk Data in the Pentaho Report Designer
Publish reports based on LeadDesk in the Pentaho BI tool.
-
Connect to MYOB AccountRight Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MYOB AccountRight Data and connect to MYOB AccountRight in Akorbi Digital RunMyProcess.
-
Use the CData Software ODBC Driver for Yelp in SAS for Real-Time Reporting and Analytics
Connect to real-time Yelp in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Yelp.
-
Use the CData ODBC Driver for FTP in Microsoft Power Query
You can use the CData FTP ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FTP Servers into Microsoft Power Query.
-
Connect to OpenWeatherMap Data from PowerBuilder via ADO.NET
This article demonstrates how to access OpenWeatherMap from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build a Singer.io Tap for ScrapingBee With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ScrapingBee data using
-
Automate Dynamics CRM Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dynamics CRM and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to and Query CockroachDB Data in QlikView over ODBC
Create data visualizations with CockroachDB in QlikView.
-
Automated Continuous Oracle HCM Cloud Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Databricks.
-
Analyze Coda Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Coda from Power Pivot. You will use the Table Import Wizard to load Coda. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Oracle Sales Data in NetBeans
Connect to Oracle Sales in NetBeans with the data source configuration wizard.
-
Connect to Browserless Data in Jaspersoft Studio
Execute SQL to remote Browserless in Jaspersoft Studio.
-
Build Apps with Live Google Campaign Manager 360 in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Campaign Manager 360 into the Adalo platform and build custom mobile and web applications with real-time Google Campaign Manager 360.
-
Visualize Sage 200 Data in Sisense
Create an ElastiCube in Sisense app with access to Sage 200.
-
Use the CData Software ODBC Driver for Dotmailer in MicroStrategy Web
Connect to Dotmailer in MicroStrategy Web using the CData Software ODBC Driver for Dotmailer.
-
Consume HubSpot OData Feeds in PowerBuilder
This article demonstrates how to consume HubSpot as OData feeds from PowerBuilder using the API Server.
-
Access Live WooCommerce Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live WooCommerce through MCP integration.
-
Connect to PagerDuty Data in Ruby
Connect to PagerDuty in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous NetSuite Replication to IBM DB2
Use CData Sync for automated, continuous, customizable NetSuite replication to IBM DB2.
-
Integrating OpenCode Terminal with PingOne Data via CData CLI
CData CLI gives AI coding agents direct, command-line-native access to CData Drivers across hundreds of data sources, allowing agents to manage licenses, configure connections, run SQL queries, and explore schema metadata, all without leaving the terminal.
-
How to Connect to & Open Presto Data in Microsoft Excel
This article uses the CData ODBC driver for Presto to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Excel Online Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Excel Online replication to Azure SQL Database.
-
Visualize Live NetSuite SuiteAnalytics Data in the Power BI Service
Use CData Connect AI to connect to live NetSuite SuiteAnalytics and create custom reports in the Power BI Service through the On-Premises Gateway.