CData Software - Knowledge Base
Recent Articles
-
Read and Modify Google Sheets Directly from Microsoft Access
Learn how to connect Microsoft Access with Google Sheets to read, update, and manage spreadsheet data in real time.
-
Integrate with MailChimp Data in JReport Designer
Create charts and reports based on MailChimp data in JReport Designer.
-
Build an OLAP Cube in SSAS from IBM Cloud Object Storage Data
Establish a connection to IBM Cloud Object Storage data data from SQL Server Analysis Services, and use the IBM Cloud Object Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous HelloSign Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable HelloSign replication to Apache Cassandra.
-
Create Dynamic PingOne Grids Using the Infragistics XamDataGrid
Learn how you can connect PingOne to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Google's Vertex AI Agent with Live Outreach.io Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Outreach.io data within intelligent workflows.
-
Connect to Placid Data in Aqua Data Studio
Access Placid data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Query Facebook Data in MySQL Workbench
Execute MySQL queries against live Facebook data from MySQL Workbench.
-
Connect to Real-Time Figshare Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Figshare data in Power Apps.
-
Connect to GetResponse Data from a Connection Pool in Jetty
The GetResponse JDBC Driver supports connection pooling: This article shows how to connect faster to GetResponse data from Web apps in Jetty.
-
Connect to Marketo Data from PowerBuilder via JDBC
This article demonstrates how to access Marketo data from PowerBuilder using the Marketo JDBC Driver.
-
Automate Presto Data Replication to Azure Synapse
Use CData Sync to customize and automate Presto data replication to Azure Synapse.
-
Integrating GitHub Copilot with PayPal 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 Visualize Jira Data in Python with pandas
Use pandas and other modules to analyze and visualize live Jira data in Python.
-
Create Datasets from Workday in Domo Workbench and Build Visualizations of Workday Data in Domo
Use the CData Software ODBC Driver for Workday to create datasets from Workday data in Domo Workbench and then build visualizations in the Domo service.
-
ETL Mode in Oracle Data Integrator
This article shows how to transfer Mode data into a data warehouse using Oracle Data Integrator.
-
Connecting Pipedream with Azure Synapse 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 Azure Synapse data in real time.
-
Integrating Antigravity CLI with Phoenix data via CData CLI
Connect Phoenix data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to and Visualize Live Adobe Commerce Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Adobe Commerce data.
-
Publish Reports with FHIR Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FHIR data.
-
Automated Continuous Datadog Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Datadog replication to Apache Cassandra.
-
Integrate ZohoSubscriptions Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ZohoSubscriptions data and integrate live ZohoSubscriptions data into your Power Automate tasks.
-
Rapidly Develop Smartsheet-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 Smartsheet.
-
How to create an RPA flow for Amplitude Data in UiPath Studio
Use the Amplitude ODBC Driver to create workflows that access real-time Amplitude data without any coding.
-
How to Connect to & Open Humanity Data in Microsoft Excel
This article uses the CData ODBC driver for Humanity to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic ConvertKit Grids Using the Infragistics XamDataGrid
Learn how you can connect ConvertKit to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with Access Data in Dundas BI
Create dynamic dashboards and perform analytics based on Access data in Dundas BI.
-
Access Live Google Calendar Data in Excel 365 Online (Excel for the web)
Connect to Google Calendar data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to SAP ByDesign Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP ByDesign data in Google Apps Script.
-
Access Live Azure Synapse Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Azure Synapse data through MCP integration.
-
Visualize Live SageHR Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SageHR data into custom reports in Power BI.
-
Connect to Parallel Data from a Connection Pool in Jetty
The Parallel JDBC Driver supports connection pooling: This article shows how to connect faster to Parallel data from Web apps in Jetty.
-
Epicor Kinetic Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Epicor Kinetic facts in real time.
-
Connect to Adobe Target Data in HULFT Integrate
Connect to Adobe Target as a JDBC data source in HULFT Integrate
-
How to Build an ETL App for MailerLite Data in Python with CData
Create ETL applications and real-time data pipelines for MailerLite data in Python with petl.
-
Connect to ActiveCampaign Data in ACL Analytics
Connect to ActiveCampaign data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ActiveCampaign data.
-
Publish Crystal Reports on Greenplum Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Greenplum data.
-
How to create Raisers Edge NXT federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Raisers Edge NXT data in MySQL .
-
Connect to MariaDB Data from a Connection Pool in Jetty
The MariaDB JDBC Driver supports connection pooling: This article shows how to connect faster to MariaDB data from Web apps in Jetty.
-
Connect to Pipedrive Data in RazorSQL
Connect to Pipedrive from wizards and query Pipedrive data from the GUI in the RazorSQL database management tool.
-
Getting Started with the CData ODBC Driver for Klipfolio
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Klipfolio.
-
Work with Zoho Projects Data in FoxPro
Load Zoho Projects data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Agents in Relevance AI with Access to Live eBay Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on eBay Analytics data within intelligent agent workflows.
-
A PostgreSQL Interface for Gong Data (MySQL Remoting via JDBC)
Use the Remoting features of the Gong JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Build an ETL App for Dynamics CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Dynamics CRM data in Python with petl and the CData Connect AI Python SDK.
-
DataBind Controls to Bright Data Data in Delphi
DataBind to Bright Data data in Delphi with standard data access components and controls.
-
ConvertAPI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ConvertAPI facts in real time.
-
Integrate Access Data in Pentaho Data Integration
Build ETL pipelines based on Access data in the Pentaho Data Integration tool.
-
Integrate Trae with Live Teradata Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Teradata data from within the AI-powered IDE.
-
Getting Started with the CData Power BI Connector for Google Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Ads.
-
Query GitHub Data in DataGrip
Create a Data Source for GitHub in DataGrip and use SQL to query live GitHub data.
-
Explore Geographical Relationships in Certinia Data with Power Map
Create data visualizations with Certinia data in Power Map.
-
Use Biml to Build SSIS Tasks to Replicate SAP Hybris C4C Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Hybris C4C data to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Exa
Provide connectivity to Exa data through an SAP BusinessObjects universe.
-
Process & Analyze Aircall Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Aircall Data.
-
Create SparkPost-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SparkPost Data from Klipfolio and build custom visualizations using live SparkPost data.
-
Connect and Query Live Google Analytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Analytics data into Databricks and enable direct, live querying and analysis without replication.
-
Use Biml to Build SSIS Tasks to Replicate Greenplum Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Greenplum data to SQL Server.
-
Access Grafana Data from MySQL in PHP
Connect to Grafana through the standard MySQL libraries in PHP.
-
Visualize Gorgias Data in Tableau
The CData ODBC driver for Gorgias enables you integrate Gorgias data into Tableau dashboards.
-
Connect to Cohere Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Cohere and work with Cohere data in your FileMaker application.
-
Connect to GitLab 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 GitLab data.
-
Integrating PingOne Data in Talend Cloud Data Management Platform
Connect PingOne Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PingOne.
-
How to Visualize HubDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live HubDB data in Python.
-
Integrate Real-Time Access to Avro in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Avro data in real time.
-
Automated Continuous Copper Replication to Vertica
Use CData Sync for automated, continuous, customizable Copper replication to Vertica.
-
Integrating LangChain with Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Stripe data within automated workflows.
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy Desktop
Connect to AfterShip data in MicroStrategy Desktop using the CData Software JDBC Driver for AfterShip.
-
Connect to MongoDB Data in DBArtisan
Use wizards in DBArtisan to configure MongoDB data as a data source.
-
How to connect to ShipStation Data in DBVisualizer
Integrate ShipStation data with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Calendly Data in DBVisualizer
Integrate Calendly data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to ZeroBounce Data in DBeaver
Use the CData ODBC Driver to connect to ZeroBounce data in DBeaver.
-
Natively Connect to PostgreSQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PostgreSQL data. Leverage the native support for ODBC in PHP.
-
Create HubSpot-Connected Applications in Appsmith
Connect to HubSpot Data via CData Connect AI in Appsmith and create custom business applications with real-time access to HubSpot data.
-
Connect to SAP BusinessObjects BI Data in JRuby
Create a simple JRuby app with access to live SAP BusinessObjects BI data.
-
Connect to TaxJar Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for TaxJar and the Script function in FileMaker Pro to connect to TaxJar and work with TaxJar data in your FileMaker application.
-
Feed Wave Financial Data into FineReport
How to set Wave Financial data as a JDBC data source in FineReport.
-
Getting Started with the CData SSIS Components for LDAP
Complete guide to installing, licensing, and connecting with the CData SSIS Components for LDAP.
-
Connect to Zoom Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Zoom Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to & Open Jodoo Data in Microsoft Excel
This article uses the CData ODBC driver for Jodoo to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Bridge BambooHR Connectivity with Apache NiFi
Access and process BambooHR data in Apache NiFi using the CData JDBC Driver.
-
Publish Freshsales-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshsales data.
-
Connect to SuiteCRM Data in DBArtisan
Use wizards in DBArtisan to configure SuiteCRM data as a data source.
-
Build MVC Applications with Connectivity to SAP Fieldglass Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP Fieldglass from an ASP.NET MVC application.
-
Integrate Live Confluence Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Confluence data from within the IDE.
-
Viewing Dynamics 365 Data in RAD Studio Data Explorer
How to view Dynamics 365 data in RAD Studio Data Explorer using the CData ODBC Driver for Dynamics 365.
-
Use Azure AI Foundry to Talk to Your DocuSign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your DocuSign data for you.
-
Integrate Epicor Kinetic Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Epicor Kinetic data from Informatica Cloud.
-
Stream Vimeo Data into Apache Kafka Topics
Access and stream Vimeo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect Jumpseller to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Jumpseller with IBM WebSphere for seamless data integration and connectivity.
-
Visualize SingleStore Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load SingleStore data into TIBCO Spotfire.
-
Extract, Transform, and Load Shippo Data in Informatica PowerCenter
Create a simple Workflow for Shippo data in Informatica PowerCenter.
-
Connect to SFTP Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for SFTP and the SQL Gateway to access SFTP data from Google Apps Script.
-
Use the CData ODBC Driver for Teamwork in Microsoft Power Query
You can use the CData Teamwork ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Teamwork data into Microsoft Power Query.
-
Replicate Tickspot Data to Multiple Databases via the CData Sync CLI
Replicate Tickspot data to disparate databases with a single configuration.
-
Integrating LlamaIndex with Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Moosend data in real time.
-
How to Seamlessly Import Eventbrite Data into IBM SPSS Modeler
Integrate Eventbrite data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Coda-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Coda Data and create custom apps in Mendix.
-
Create Informatica Mappings From/To an ODBC Data Source for Zoho Projects
Create an ODBC connection to Zoho Projects in Informatica and browse and transfer Zoho Projects data.
-
Interact with Live Gong Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Gong data.