CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Aweber in Microsoft Power Query
You can use the CData Aweber ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Aweber into Microsoft Power Query.
-
Analyze Adobe Analytics Data in Looker
Use CData Connect AI to connect to Adobe Analytics Data from Looker and build custom apps using live Adobe Analytics.
-
How to Work with LinkedIn Data in AWS Glue Jobs Using JDBC
Connect to LinkedIn from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Cursor with Live SingleStore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SingleStore from within the editor.
-
Using the CData Software ODBC Driver for Oracle Eloqua in PyCharm
Connect to Oracle Eloqua as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Eloqua.
-
Import and Visualize Jira Data in Power View
Create data visualizations based on Atlassian Jira in Excel.
-
Migrating data from Exact Online to Databricks using CData SSIS Components.
Easily push Exact Online to Databricks using the CData SSIS Tasks for Exact Online and Databricks.
-
Integrate Goose with Live JSON Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live JSON from within the local AI agent.
-
Import Real-Time SparkPost Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SparkPost in ColdFusion.
-
Integrating Dataiku with Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho Projects.
-
Use the CData Software JDBC Driver for Zendesk in MicroStrategy Web
Connect to Zendesk in MicroStrategy Web using the CData Software JDBC Driver for Zendesk.
-
Establish a Live Connection with Sage Intacct Data using Tableau Bridge
The CData ODBC Driver for Sage Intacct enables you to integrate live Sage Intacct into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Grafana from Asprova with CData Software ODBC Driver for Grafana
This article shows how to connect faster to Grafana data from Asprova.
-
Query Power BI XMLA Data in DataGrip
Create a Data Source for Power BI XMLA in DataGrip and use SQL to query live Power BI XMLA.
-
Connect SFTP to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SFTP using the CData Python MCP Server.
-
Build a Simple VCL Application for Procore Data
How to build a simple VCL Application to view Procore in RAD Studio using the CData ODBC Driver for Procore.
-
How to Access Live Reckon Accounts Hosted Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Reckon Accounts Hosted enables you to integrate Reckon Accounts Hosted into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with Greenhouse 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.
-
Getting Started with the CData ODBC Driver for Rebilly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Rebilly.
-
Build Apps with Live Workday Data Using the Low-Code Development Platform of Mendix
Connect Workday with Mendix to build apps using the CData JDBC Driver for Workday.
-
Build Data Flows from Brex to SQL Server using SSIS
Easily back up Brex to SQL Server using the SSIS components for Brex.
-
Prepare, Blend, and Analyze Twilio Data in Alteryx Designer (ODBC)
Build workflows to access live Twilio for self-service data analytics.
-
Getting Started with the CData JDBC Driver for Trello
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Trello.
-
Access Live Dynamics 365 Business Central Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Dynamics 365 Business Central from your Excel spreadsheets.
-
Automated Continuous WordPress Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable WordPress replication to Azure SQL Database.
-
Use the CData Software JDBC Driver for Codat in MicroStrategy Desktop
Connect to Codat in MicroStrategy Desktop using the CData Software JDBC Driver for Codat.
-
Automated Continuous Grafana Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Grafana replication to Google BigQuery.
-
Create Apps from Authorize.Net Data in Qlik Sense Cloud
Use CData Connect AI to connect to Authorize.Net Data and build apps from live Authorize.Net in Qlik Sense Cloud.
-
Integrating Boomi Agentstudio with Microsoft Planner Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Microsoft Planner, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous Sage 300 Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage 300 replication to Snowflake.
-
Provide OData Services of Samanage Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Samanage by developing a WCF Service Application.
-
Connect to Aircall Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Aircall.
-
Build Dashboards with Databricks Data in DBxtra
Create dynamic dashboards and perform analytics based on Databricks in DBxtra.
-
Build Dashboards with Sybase Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sybase in Dundas BI.
-
Use the CData Software ODBC Driver for Impala in MicroStrategy Web
Connect to Apache Impala in MicroStrategy Web using the CData Software ODBC Driver for Impala.
-
Build Visualizations of Everhour Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Everhour in Birst.
-
Connecting Pipedream with Bullhorn CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Bullhorn CRM data in real time.
-
Build a Simple VCL Application for Email Data
How to build a simple VCL Application to view Email in RAD Studio using the CData ODBC Driver for Email.
-
Process & Analyze HubDB Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HubDB Data.
-
Automated Continuous MySQL Replication to Databricks
Use CData Sync for automated, continuous, customizable MySQL replication to Databricks.
-
Deploy the ADO.NET Provider for MarkLogic on an SSRS Report Server
Connect to MarkLogic 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.
-
Integrate Cline with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon Marketplace from within your IDE.
-
Integrating Claude Code with Greenplum Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Pivotal GreenPlum within assisted coding and automated development workflows.
-
Visualize ADP Data in TIBCO Spotfire through ADO.NET
Integrate ADP into dashboards in TIBCO Spotfire.
-
Connect to Real-Time Insightly Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Insightly in Power Apps.
-
Access Live GetResponse Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate GetResponse into the statistical analysis tools available in SAS JMP. This article shows how to use GetResponse in the Graph Builder and Query Builder.
-
Enable the SAP ByDesign JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Business ByDesign.
-
API Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to API through CData Connect AI using different applications and tools.
-
Rapidly Develop Facebook-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Facebook.
-
Use Agno to Talk to Your Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Amazon Redshift for you.
-
Connect to Greenhouse Data from PowerBuilder via ADO.NET
This article demonstrates how to access Greenhouse from Appeon PowerBuilder using the CData ADO.NET Provider for Greenhouse.
-
DataBind Controls to Factorial Data in Delphi
DataBind to Factorial in Delphi with standard data access components and controls.
-
Connect to Twitter Ads Data from PowerBuilder via ADO.NET
This article demonstrates how to access Twitter Ads from Appeon PowerBuilder using the CData ADO.NET Provider for Twitter Ads.
-
Automated Continuous Greenplum Replication to SQLite
Use CData Sync for automated, continuous, customizable Greenplum replication to SQLite.
-
Access Notion Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Notion from your Oracle system.
-
Import and Visualize RSS Feeds in Power View
Create data visualizations based on RSS Feeds in Excel.
-
Build Dashboards with SAP Business One Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP Business One in Dundas BI.
-
Replicate Campaigner Data in Heroku for Use in Salesforce Connect
Replicate Campaigner to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use the CData Software ODBC Driver for Spark in MicroStrategy Desktop
Connect to Apache Spark SQL in MicroStrategy Desktop using the CData Software ODBC Driver for Spark.
-
Create Informatica Mappings From/To a JDBC Data Source for JDBC-ODBC Bridge
Create JDBC-ODBC Bridge data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Live Certinia Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Certinia from your Excel spreadsheets.
-
Create a Data Access Object for SendGrid Data using JDBI
A brief overview of creating a SQL Object API for SendGrid in JDBI.
-
How to use SQLAlchemy ORM to access GetResponse Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of GetResponse.
-
Visualize Live Supabase Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Supabase.
-
Visualize Live Aweber Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Aweber.
-
Feed Excel Online Data into FineReport
How to set Microsoft Excel Online as a JDBC data source in FineReport.
-
DataBind Charts to Instantly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Instantly 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.
-
DataBind Controls to SendInBlue Data in Delphi
DataBind to SendInBlue in Delphi with standard data access components and controls.
-
Replicate Insightly Data from PowerShell
Write a quick PowerShell script to query Insightly. Use connectivity to the live data to replicate Insightly to SQL Server.
-
Access Live Facebook Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Facebook Ads into the statistical analysis tools available in SAS JMP. This article shows how to use Facebook Ads in the Graph Builder and Query Builder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Sybase to Power BI dashboards. Simply drag and drop Sybase into data visuals on the Power BI canvas.
-
Moving Data from Sugar CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Sugar CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Build an ETL App for Azure Data Lake Storage Data in Python with CData Connect AI
Build ETL pipelines that read and write live Azure Data Lake Storage in Python with petl and the CData Connect AI Python SDK.
-
Build MVC Applications with Connectivity to XML Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access XML from an ASP.NET MVC application.
-
Connect to Nonstandard OData Services
Extend the included schemas to connect to nonstandard OData services.
-
Use the CData Software JDBC Driver for Neo4J in MicroStrategy Web
Connect to Neo4J in MicroStrategy Web using the CData Software JDBC Driver for Neo4J.
-
Automated Continuous Grafana Replication to SingleStore
Use CData Sync for automated, continuous, customizable Grafana replication to SingleStore.
-
Extract, Transform, and Load Coinbase Data in Informatica PowerCenter
Create a simple Workflow for Coinbase in Informatica PowerCenter.
-
Visualize Facebook Ads Data in TIBCO Spotfire through OData
Integrate Facebook Ads into dashboards in TIBCO Spotfire.
-
How to connect and process Neo4J from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Neo4J.
-
Working with Bannerbear Data in LINQPad
Execute LINQ queries to Bannerbear in LINQPad.
-
Migrating data from Adobe Commerce to Snowflake using CData SSIS Components.
Easily push Adobe Commerce to Snowflake using the CData SSIS Tasks for Adobe Commerce and Snowflake.
-
Integrating Kiro CLI with Adobe Commerce 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 publish and share Tally Data dashboards with Tableau Server
The CData ODBC driver for Tally enables you integrate Tally ERP into Tableau dashboards.
-
Replicate Multiple Cloudant Accounts
Replicate multiple Cloudant accounts to one or many databases.
-
Automate Access Data Replication to Couchbase
Use CData Sync to Customize and automate Microsoft Access replication to Couchbase.
-
Load Billsby Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Billsby to a database.
-
Connect to Suadeo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Suadeo to connect to Suadeo and execute queries in PowerBuilder.
-
Use the CData Software JDBC Driver for Pingdom in MicroStrategy
Connect to Pingdom in MicroStrategy Developer using the CData Software JDBC Driver for Pingdom.
-
Connect to SAP Business Warehouse Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Business Warehouse and the Script function in FileMaker Pro to connect to SAP Business Warehouse and work with SAP Business Warehouse in your FileMaker application.
-
Connect to Microsoft OneDrive Data from a Connection Pool in Jetty
The Microsoft OneDrive JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft OneDrive from Web apps in Jetty.
-
Build xBase-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for xBase to explore live xBase Data in Claude Code to assist with building xBase-powered applications.
-
Use the CData Software ODBC Driver for Slack in SAS for Real-Time Reporting and Analytics
Connect to real-time Slack in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Slack.
-
Add Bitbucket Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bitbucket with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access Copper Data Using Entity Framework
This article shows how to access Copper using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Salesforce Data 360 Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Data 360 with the CData JDBC Driver for Salesforce Data 360.
-
Design BIRT Reports on Microsoft Entra ID Data
Provide current Microsoft Entra ID to your embedded analytics.
-
Connecting Pipedream with Zoho CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Zoho CRM data in real time.
-
Load Azure Analysis Services Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Azure Analysis Services to a database.
-
Trigger Azure Synapse IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Azure Synapse with standard wizards in Logic Apps.