CData Software - Knowledge Base
Recent Articles
-
Connect and Visualize Live Oracle Financials Cloud Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Financials Cloud data into the Databricks platform and create visualization dashboards with real-time Oracle Financials Cloud data.
-
How to Connect to Live QuickBooks Data 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 QuickBooks data for you.
-
How to Create Power BI Visual Reports with Real-Time Pinecone Data
Use CData Power BI Connectors to visualize Pinecone data in Power BI.
-
Connect to Odoo from Asprova with CData Software ODBC Driver for Odoo
This article shows how to connect faster to Odoo data from Asprova.
-
How to connect to OneNote Data with Squirrel SQL client
Connect to OneNote data and execute queries in the Squirrel SQL Client.
-
Prepare, Blend, and Analyze Salesforce Data in Alteryx Designer (Connect AI)
Build workflows to access live Salesforce data for self-service data analytics.
-
Build Agents in Relevance AI with Access to Live ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ZohoDesk data within intelligent agent workflows.
-
Integrating Opsgenie Data in Talend Cloud Data Management Platform
Connect Opsgenie Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics 365
Create Dynamics 365 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Informatica Mappings From/To an ODBC Data Source for Instantly
Create an ODBC connection to Instantly in Informatica and browse and transfer Instantly data.
-
Onfleet Reporting in OBIEE with the Onfleet JDBC Driver
Deploy the Onfleet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Extract, Transform, and Load Access Data in Informatica PowerCenter
Create a simple Workflow for Access data in Informatica PowerCenter.
-
DataBind Charts to Mailgun Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Mailgun data 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.
-
Build Dashboards with TaxJar Data in DBxtra
Create dynamic dashboards and perform analytics based on TaxJar data in DBxtra.
-
Integrating ClickUp Data in Talend Cloud Data Management Platform
Connect ClickUp Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate SAP SuccessFactors with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP SuccessFactors with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP SuccessFactors data.
-
Use the CData Software ODBC Driver for Bitly in MicroStrategy Desktop
Connect to Bitly data in MicroStrategy Desktop using the CData Software ODBC Driver for Bitly.
-
Access Dynamics CRM Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Dynamics CRM data.
-
Manage PDFMonkey Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PDFMonkey.
-
Publish Crystal Reports on SharePoint Excel Services Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SharePoint Excel Services data.
-
Connect to XML from Asprova with CData Software ODBC Driver for XML
This article shows how to connect faster to XML data from Asprova.
-
Replicate Zoho Creator Data to Multiple Databases
Replicate Zoho Creator data to disparate databases with a point-and-click configuration.
-
Access Datadog Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Datadog data from HeidiSQL.
-
Build Google Sheets-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Google Sheets data.
-
Connect to Onfleet Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Onfleet and work with Onfleet data in your FileMaker applications.
-
Extract, Transform, and Load Cvent Data in Informatica PowerCenter
Create a simple Workflow for Cvent data in Informatica PowerCenter.
-
Connect to ZohoSubscriptions in SpagoBI
Create reports featuring live ZohoSubscriptions data in SpagoBI Studio. Host ZohoSubscriptions reports on SpagoBI Server.
-
Access ZeroBounce Data from MySQL in Amazon QuickSight
Connect to ZeroBounce and build visualizations of ZeroBounce data using a MySQL Connection in Amazon QuickSight.
-
Connect Wave Financial to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Wave Financial data using the CData Python MCP Server.
-
Query Live Toggl Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Toggl data directly from the development environment.
-
View Reports on Real-Time Supabase Data in Power BI Report Server
Use the CData ODBC Driver for Supabase to visualize Supabase data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automate PhantomBuster Data Replication to Couchbase
Use CData Sync to Customize and automate PhantomBuster data replication to Couchbase.
-
Visualize Live Scrapfly Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Scrapfly data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Seamlessly Import PolarTeamPro Data into IBM SPSS Modeler
Integrate PolarTeamPro data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Load Authorize.Net Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Authorize.Net data to a database.
-
Load Highrise Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Highrise data to a database.
-
Access Live Outreach.io Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Outreach.io data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate CapsuleCRM Data in the Pentaho Report Designer
Publish reports based on CapsuleCRM data in the Pentaho BI tool.
-
Connect to Zuora Data in RapidMiner
Integrate Zuora data with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for ZendeskSell
Create an ODBC connection to ZendeskSell in Informatica and browse and transfer ZendeskSell data.
-
Integrating OpenCode with Microsoft Planner 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.
-
Link Placid with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Placid data in Filemaker Pro for Mac or Windows.
-
Analyze PolarTeamPro Data in Cognos Analytics
Use CData Connect AI to connect to PolarTeamPro Data from Cognos Analytics and analyze live PolarTeamPro data.
-
Integrate SAP ByDesign Data into Power Automate Desktop using CData Connect
CData Connect for SAP ByDesign Data enables you to integrate SAP ByDesign data into workflows built using Microsoft Power Automate Desktop.
-
How to Use a Microsoft Access Database to Update FTP Data in Real Time
Update FTP data by creating a linked table in Microsoft Access with the CData FTP ODBC Driver.
-
Use Claude to Talk to Your Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Sage 200 data for you.
-
Integrate Oracle HCM Cloud with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Oracle HCM Cloud with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Oracle HCM Cloud data.
-
Connect to Airtable Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Airtable to connect to Airtable data and execute queries in PowerBuilder.
-
Automate Sage 200 Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sage 200 data replication to Azure Data Lake.
-
Access Live Sage Intacct Data in TIBCO Data Virtualization
Use the Sage Intacct Tibco DV Adapter to create a Sage Intacct data data source in TIBCO Data Virtualization Studio and gain access to live Sage Intacct data from your TDV Server.
-
Integrating Codex with NASA 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.
-
Create Elasticsearch Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Elasticsearch data access from reports, embedded analytics, and more.
-
Connecting Moonlit Workflow with ShipEngine 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 ShipEngine data in real time.
-
Getting Started with the CData Python Connector for Hive
Learn to install and license the CData Python Connector and configure a connection to live Hive data.
-
Natively Connect to Webex Data in PHP
The CData ODBC driver for Webex enables you to create PHP applications with connectivity to Webex data. Leverage the native support for ODBC in PHP.
-
How to Seamlessly Import Billsby Data into IBM SPSS Modeler
Integrate Billsby data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Connect to & Open Chargebee Data in Microsoft Excel
This article uses the CData ODBC driver for Chargebee to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to OneNote Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for OneNote to connect to OneNote data and execute queries in PowerBuilder.
-
How to Access Freshdesk Data Using Entity Framework
This article shows how to access Freshdesk data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to connect to ZohoMarketingHub Data from IntelliJ
Integrate connectivity to ZohoMarketingHub data with wizards in IntelliJ.
-
Query MailerLite Data in ColdFusion
Write standard ColdFusion data access code to connect to MailerLite data.
-
Rapidly Develop SAP Business Warehouse-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 SAP Business Warehouse.
-
Automated Continuous MailerSend Replication to Vertica
Use CData Sync for automated, continuous, customizable MailerSend replication to Vertica.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for JobNimbus
Provide connectivity to JobNimbus data through an SAP BusinessObjects universe.
-
Query Timely Data in ColdFusion
Write standard ColdFusion data access code to connect to Timely data.
-
How to Connect to Live Adobe Target 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 Adobe Target data for you.
-
Validate Salesforce Data 360 Data with QuerySurge
Access and validate Salesforce Data 360 data in QuerySurge using the CData JDBC Driver.
-
Bind Live Certinia Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Certinia data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Connect to Live Act-On Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Act-On data without replication.
-
Back Up Cassandra data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Cassandra. In this article, we will employ an SSIS workflow to populate a database with Cassandra data data.
-
Query PolarTeamPro Data as a SQL Server Database in Node.js
Execute SQL Server queries against PolarTeamPro data from Node.js.
-
Connect to SAP SuccessFactors LMS Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP SuccessFactors LMS in FileMaker Pro to connect to SAP SuccessFactors LMS and work with SAP SuccessFactors LMS data in your FileMaker applications.
-
Automated Continuous Reply.io Replication to SQLite
Use CData Sync for automated, continuous, customizable Reply.io replication to SQLite.
-
Connect to Dynamics 365 Business Central from Asprova with CData Software ODBC Driver for Dynamics 365 Business Central
This article shows how to connect faster to Dynamics 365 Business Central data from Asprova.
-
Moving Data from Ontraport to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Ontraport data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Analyze Supabase Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Supabase data with the CData JDBC Driver for Supabase.
-
Getting Started with the CData Connect AI Python SDK for Timely
Install the CData Connect AI Python SDK to read live Timely data with standard DB-API 2.0 Python code.
-
Back Up Webflow data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Webflow data data.
-
Connect to Jira Assets Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Jira Assets to connect to Jira Assets data and execute queries in PowerBuilder.
-
Getting Started with the CData Python Connector for ChargeOver
Learn to install and license the CData Python Connector and configure a connection to live ChargeOver data.
-
Connect to ClickTime Data in DBeaver
Use the CData ODBC Driver to connect to ClickTime data in DBeaver.
-
How to Visualize ChartMogul Data in Python with pandas
Use pandas and other modules to analyze and visualize live ChartMogul data in Python.
-
DataBind Controls to Cosmos DB Data in Delphi
DataBind to Cosmos DB data in Delphi with standard data access components and controls.
-
Create Zoom Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Zoom from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect Recurly to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Recurly data using the CData Python MCP Server.
-
Connect and Visualize Live Redshift Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Redshift data into the Databricks platform and create visualization dashboards with real-time Redshift data.
-
LINQ to Google Drive Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Google Drive Data Provider.
-
Integrating GitHub Copilot with Ontraport 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.
-
Automated Continuous Google Ads Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Ads replication to PostgreSQL.
-
Connect to Real-Time ZarMoney Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZarMoney data in Power Apps.
-
Getting Started with the CData Tableau Connector for Optimizely
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to Google Sheets Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Sheets data.
-
Integrating GitHub Copilot with Teamwork 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.
-
Configure the CData JDBC Driver for Pingdom in a Connection Pool in Tomcat
Connect to Pingdom data from a connection pool in Tomcat.
-
Integrate Google's Vertex AI Agent with Live BambooHR 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 BambooHR data within intelligent workflows.
-
Integrate Google's Antigravity Agent with Live BenchmarkEmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live BenchmarkEmail data using the Model Context Protocol.
-
Work with Live Google Calendar Data in Power Query
Use CData Connect AI to connect to Google Calendar data and work with live Google Calendar data in Microsoft Power Query.
-
Replicate Shippo Data to Multiple Databases via the CData Sync CLI
Replicate Shippo data to disparate databases with a single configuration.
-
Using the CData Software ODBC Driver for ChartMogul in PyCharm
Connect to ChartMogul as an ODBC data source in PyCharm using the CData Software ODBC Driver for ChartMogul.
-
Automated Continuous Basecamp Replication to SingleStore
Use CData Sync for automated, continuous, customizable Basecamp replication to SingleStore.