CData Software - Knowledge Base
Recent Articles
-
Analyze MYOB AccountRight Data in Cognos Analytics
Use CData Connect AI to connect to MYOB AccountRight Data from Cognos Analytics and analyze live MYOB AccountRight data.
-
Connecting Moonlit Workflow with ADP Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your ADP data in real time.
-
Import Real-Time QuickBooks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use QuickBooks data in ColdFusion.
-
Integrate Goose with Live FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live FreshBooks data from within the local AI agent.
-
Replicate Multiple Cvent Accounts
Replicate multiple Cvent accounts to one or many databases.
-
Connect to Notion Data in DBArtisan
Use wizards in DBArtisan to configure Notion data as a data source.
-
Build Semantic Layer Views for Cosmos DB Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Cosmos DB data.
-
Manage Basecamp Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Basecamp.
-
Object-Relational Mapping (ORM) with ChartMogul Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ChartMogul data into a Java-based ORM framework, Hibernate.
-
How to load Klipfolio data into Elasticsearch via Logstash
Introducing a simple method to load Klipfolio data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Authorize.Net Data from a Connection Pool in Jetty
The Authorize.Net JDBC Driver supports connection pooling: This article shows how to connect faster to Authorize.Net data from Web apps in Jetty.
-
Create Reports with PingOne Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PingOne data.
-
DataBind Controls to Phoenix Data in C++Builder
DataBind to Phoenix data in C++Builder with standard components and controls.
-
How to integrate Reckon Accounts Hosted with Apache Airflow
Access and process Reckon Accounts Hosted data in Apache Airflow using the CData JDBC Driver.
-
Build Automated Workflows with Live ZohoMarketingHub Data in Workato
Use CData Connect AI to connect to live ZohoMarketingHub data and build automated workflows in Workato.
-
Build Charts with Avalara AvaTax Data in Clear Analytics
Create dynamic charts and perform analytics based on Avalara AvaTax data in Clear Analytics.
-
Import Real-Time ZendeskSell Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use ZendeskSell data in ColdFusion.
-
Connect to Zendesk Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zendesk data using standard SQL.
-
Integrating Gumloop with Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Microsoft Exchange data within automated workflows.
-
Getting Started with the CData Connect AI Python SDK for Azure Table
Install the CData Connect AI Python SDK to read and write live Azure Table data with standard DB-API 2.0 Python code.
-
Visualize Oracle SCM Data in TIBCO Spotfire through ADO.NET
Integrate Oracle SCM data into dashboards in TIBCO Spotfire.
-
Query, Visualize, and Share live Gmail Data in Redash
Use CData Connect AI to connect to live Gmail data in Redash for querying, visualizing, and sharing.
-
DataBind Dropbox Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Dropbox with the DevExpress Windows Forms and Web controls to provide Dropbox data to a chart.
-
Connect to Aha! Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Aha! to connect to Aha! data and execute queries in PowerBuilder.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Ad Manager
Create Google Ad Manager data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Query Live ADP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ADP data data in natural language using Python.
-
Build MVC Applications with Connectivity to Close Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Close from an ASP.NET MVC application.
-
Access Live Sage 200 Data in Excel 365 Online (Excel for the web)
Connect to Sage 200 data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Create Datasets from HDFS in Domo Workbench and Build Visualizations of HDFS Data in Domo
Use the CData Software ODBC Driver for HDFS to create datasets from HDFS data in Domo Workbench and then build visualizations in the Domo service.
-
DataBind Controls to Rebilly Data in C++Builder
DataBind to Rebilly data in C++Builder with standard components and controls.
-
DataBind Controls to Phoenix Data in Delphi
DataBind to Phoenix data in Delphi with standard data access components and controls.
-
Integrate with Mouseflow Data in JReport Designer
Create charts and reports based on Mouseflow data in JReport Designer.
-
Build MVC Applications with Connectivity to SAP Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP from an ASP.NET MVC application.
-
Choosing the Best Method to Connect Avro to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Avro data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Back Up Power BI XMLA data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Power BI XMLA. In this article, we will employ an SSIS workflow to populate a database with Power BI XMLA data data.
-
Use Agno to Talk to Your AlloyDB 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 AlloyDB data for you.
-
Connect to Testmonitor Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Testmonitor data in Airbyte.
-
Query SQL Server Data as a MySQL Database in Node.js
Execute MySQL queries against SQL Server data from Node.js.
-
How to integrate Metabase with DB2 Data
Use CData Connect AI to connect to live DB2 data and create an interactive dashboard in Metabase from DB2 data.
-
How to publish and share SAP Ariba Procurement Data dashboards with Tableau Server
The CData ODBC driver for SAP Ariba Procurement enables you integrate SAP Ariba Procurement data into Tableau dashboards.
-
Integrating Cursor with Confluence 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 and process Square data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Square data.
-
Feed Google Directory Data into FineReport
How to set Google Directory data as a JDBC data source in FineReport.
-
Connect to ShipEngine Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ShipEngine as an External Source in Dremio.
-
Connect to SAP Ariba Procurement Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP Ariba Procurement data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for PayPal
Provide connectivity to PayPal data through an SAP BusinessObjects universe.
-
Connect to Vault CRM Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Vault CRM and the Script function in FileMaker Pro to connect to Vault CRM and work with Vault CRM data in your FileMaker application.
-
Integrating Bannerbear Data in Talend Cloud Data Management Platform
Connect Bannerbear Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build MySQL-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live MySQL data.
-
Connect to Adobe Target Data in DBeaver
Use the CData ODBC Driver to connect to Adobe Target data in DBeaver.
-
Connect to Exact Online Data in Aqua Data Studio
Access Exact Online data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build MVC Applications with Connectivity to iContact Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access iContact from an ASP.NET MVC application.
-
Replicate JobNimbus Data in Heroku for Use in Salesforce Connect
Replicate JobNimbus data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connecting Mastra with Redis Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Redis data, no replication required.
-
How to Work with Highrise Data in AWS Glue Jobs Using JDBC
Connect to Highrise from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Informatica Mappings From/To a JDBC Data Source for Instantly
Create Instantly data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ActiveCampaign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ActiveCampaign data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous Microsoft OneLake Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft OneLake replication to Apache Kafka.
-
Create MariaDB Dataflows on PowerBI.com
Connect to the CData Power BI Connector for MariaDB from PowerBI.com to create Power BI Dataflows with real-time data.
-
DataBind Ontraport Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Ontraport data to a chart.
-
ETL ZendeskSell in Oracle Data Integrator
This article shows how to transfer ZendeskSell data into a data warehouse using Oracle Data Integrator.
-
How to Connect to Live Zuora Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Zuora data for you.
-
Moving Data from MongoDB to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live MongoDB data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Power BI Reports on Real-Time ZendeskSell Data
Use the CData ODBC Driver for ZendeskSell to visualize ZendeskSell data in Power BI Desktop.
-
Automate Redshift Data Replication to SAP HANA
Use CData Sync to customize and automate Redshift data replication to SAP HANA.
-
Connect to MailChimp Data in Aqua Data Studio
Access MailChimp data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to PhantomBuster Data in RazorSQL
Connect to PhantomBuster from wizards and query PhantomBuster data from the GUI in the RazorSQL database management tool.
-
How to integrate Bugsnag with Apache Airflow
Access and process Bugsnag data in Apache Airflow using the CData JDBC Driver.
-
Access Elasticsearch Data from MySQL in PHP
Connect to Elasticsearch through the standard MySQL libraries in PHP.
-
Integrate with live Asana Data in Jitterbit
Use CData Connect AI to connect to and integrate live Asana data in Jitterbit.
-
Replicate Templated Data in Heroku for Use in Salesforce Connect
Replicate Templated data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Semantic Layer Views for Google Calendar Data in APOS Live Data Gateway
Use the CData Connector for Google Calendar in APOS Live Data Gateway to build Semantic Layer Views for Google Calendar data.
-
Build Charts with MailChimp Data in Clear Analytics
Create dynamic charts and perform analytics based on MailChimp data in Clear Analytics.
-
Automated Continuous Contentful Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Contentful replication to Amazon Redshift.
-
Connect to RSS Feeds from HeidiSQL
Use CData Connect AI to connect to and query live RSS feeds from HeidiSQL.
-
Build a Simple VCL Application for Workday Data
How to build a simple VCL Application to view Workday data in RAD Studio using the CData ODBC Driver for Workday.
-
Visualize HDFS Data in Tableau
The CData ODBC driver for HDFS enables you integrate HDFS data into Tableau dashboards.
-
How to Connect the Power BI Service to Google Ads: Complete Guide
Connect to the CData Software Power BI Connector for Google Ads from PowerBI.com to provide real-time Google Ads data across the organization.
-
Testmonitor Reporting in OBIEE with the Testmonitor JDBC Driver
Deploy the Testmonitor JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to create an RPA flow for Avro Data in UiPath Studio
Use the Avro ODBC Driver to create workflows that access real-time Avro data without any coding.
-
DataBind Controls to Google Spanner Data in Delphi
DataBind to Google Spanner data in Delphi with standard data access components and controls.
-
Create Informatica Mappings From/To an ODBC Data Source for PabblySubscriptions
Create an ODBC connection to PabblySubscriptions in Informatica and browse and transfer PabblySubscriptions data.
-
Connect to Zendesk Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zendesk data in Google Apps Script.
-
How to Work with Sage 200 Data in ETL Validator JDBC
Connect to Sage 200 from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrating LlamaIndex with SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SendPulse data in real time.
-
Connect to QuickBooks Time Data in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks Time in FileMaker Pro to connect to QuickBooks Time and work with QuickBooks Time data in your FileMaker applications.
-
Integrate Cline with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Freshservice data from within your IDE.
-
Access Live Salesforce CRM Analytics Data in TIBCO Data Virtualization
Use the Salesforce CRM Analytics Tibco DV Adapter to create a Salesforce CRM Analytics data data source in TIBCO Data Virtualization Studio and gain access to live Salesforce CRM Analytics data from your TDV Server.
-
Publish ZarMoney-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZarMoney data.
-
Automate ZendeskSell Data Replication to SAP HANA
Use CData Sync to customize and automate ZendeskSell data replication to SAP HANA.
-
Connect to Google Calendar Data in RazorSQL
Connect to Google Calendar from wizards and query Google Calendar data from the GUI in the RazorSQL database management tool.
-
Connect to Twilio Data in Jaspersoft Studio
Execute SQL to remote Twilio data in Jaspersoft Studio.
-
Integrate with live Guru Data in Jitterbit
Use CData Connect AI to connect to and integrate live Guru data in Jitterbit.
-
Extract, Transform, and Load Twitter Ads Data in Informatica PowerCenter
Create a simple Workflow for Twitter Ads data in Informatica PowerCenter.
-
Build Data Flows from Presto to SQL Server using SSIS
Easily back up Presto data to SQL Server using the SSIS components for Presto.
-
Moving Data from Auth0 to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Auth0 data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to Connect to Live ZohoExpense Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ZohoExpense data securely in real time.
-
Connecting Pipedream with SurveyMonkey 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 SurveyMonkey data in real time.
-
Build Dashboards with Twilio Data in Dundas BI
Create dynamic dashboards and perform analytics based on Twilio data in Dundas BI.
-
How to Connect to Wrike Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Wrike data. Leverage the pyodbc module for ODBC in Python.