CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for Perplexity
Create Perplexity data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Informatica Mappings From/To a JDBC Data Source for QuickBooks Time
Create QuickBooks Time data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
DataBind Charts to PagerDuty Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to PagerDuty 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.
-
Analyze SAP Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for SAP from Power Pivot. You will use the Table Import Wizard to load SAP data. You can visually build the import query or use any SQL supported by the driver.
-
Build Dropbox-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Dropbox Data and create custom apps in Mendix.
-
Use the CData ODBC Driver for HCL Domino from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HCL Domino data in Excel.
-
Connecting Pipedream with QuickBooks Time 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 QuickBooks Time data in real time.
-
Add PayPal Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PayPal with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OpenWeatherMap data.
-
Integrate Optimizely with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Optimizely with External Services.
-
Build Dashboards with Google Drive Data in DBxtra
Create dynamic dashboards and perform analytics based on Google Drive data in DBxtra.
-
Connect to ElevenLabs Data in DBeaver
Use the CData ODBC Driver to connect to ElevenLabs data in DBeaver.
-
Connect to Clio from a Connection Pool in WebLogic
Use the CData JDBC Driver for Clio to connect to Clio data from Web applications running on WebLogic.
-
Build Apps with Live Microsoft Planner Data Using the Low-Code Development Platform of Mendix
Connect Microsoft Planner data with Mendix to build apps using the CData JDBC Driver for Microsoft Planner.
-
Automate Qualaroo Data Replication to Azure Synapse
Use CData Sync to customize and automate Qualaroo data replication to Azure Synapse.
-
Build Pipelines with Live GraphQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from Google Cloud Data Fusion, enabling the integration of live GraphQL data into the building and management of effective data pipelines.
-
How to Connect to Google Forms Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Forms data. Leverage the pyodbc module for ODBC in Python.
-
How to Connect to Live Toggl Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Toggl data for you.
-
How to Connect to Live Oracle Financials Cloud Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle Financials Cloud data for you.
-
Import Real-Time Calendly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Calendly data in ColdFusion.
-
Create Reports with ChartMogul Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChartMogul data.
-
Create Datasets from AgileCRM in Domo Workbench and Build Visualizations of AgileCRM Data in Domo
Use the CData Software ODBC Driver for AgileCRM to create datasets from AgileCRM data in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Intercom Data from IntelliJ
Integrate connectivity to Intercom data with wizards in IntelliJ.
-
Automated Continuous MailChimp Replication to Databricks
Use CData Sync for automated, continuous, customizable MailChimp replication to Databricks.
-
How to connect to Customer.io Data in DBVisualizer
Integrate Customer.io data with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Shippo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Shippo data.
-
Automate Epicor Kinetic Data Replication to SAP HANA
Use CData Sync to customize and automate Epicor Kinetic data replication to SAP HANA.
-
ETL Paddle in Oracle Data Integrator
This article shows how to transfer Paddle data into a data warehouse using Oracle Data Integrator.
-
Connect to ZohoExpense 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 ZohoExpense data.
-
Connect to Typeform 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 Typeform data.
-
How to Work with SAP Hybris C4C Data in AWS Glue Jobs Using JDBC
Connect to SAP Hybris C4C from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Live WooCommerce Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live WooCommerce data.
-
Integrating Kiro with Zoho Recruit 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.
-
Integrating Cursor with Teradata 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.
-
Integrate Klaviyo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Klaviyo data from Informatica Cloud.
-
Integrate Hubstaff Data in Pentaho Data Integration
Build ETL pipelines based on Hubstaff data in the Pentaho Data Integration tool.
-
Connect to Excel Online Data from Crystal Reports
Use CData Connect AI to connect to and report on live Excel Online data from Crystal Reports.
-
Connect to BambooHR Data in NetBeans
Connect to BambooHR data in NetBeans with the data source configuration wizard.
-
Create Reports from Neo4J Data in Looker Studio
Use CData Connect AI to gain access to live Neo4J data and create custom reports in Looker Studio.
-
Access Live Amazon Marketplace 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 Amazon Marketplace data through MCP integration.
-
View Reports on Real-Time Sendwithus Data in Power BI Report Server
Use the CData ODBC Driver for Sendwithus to visualize Sendwithus data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Use a Microsoft Access Database to Update Workday Data in Real Time
Update Workday data by creating a linked table in Microsoft Access with the CData Workday ODBC Driver.
-
Use the CData Software ODBC Driver for Azure DevOps in MicroStrategy Desktop
Connect to Azure DevOps data in MicroStrategy Desktop using the CData Software ODBC Driver for Azure DevOps.
-
Integrating Claude Code CLI with LinkedIn 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 Create Power BI Visual Reports with Real-Time Deel Data
Use CData Power BI Connectors to visualize Deel data in Power BI.
-
Build Lakebase-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Lakebase data.
-
Integrating Codex with Redshift 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.
-
DataBind Charts to Aha! Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Aha! 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.
-
How to Query Parallel Data in MySQL Workbench
Execute MySQL queries against live Parallel data from MySQL Workbench.
-
Query Office 365 Data as a SQL Server Database in Node.js
Execute SQL Server queries against Office 365 data from Node.js.
-
Provide OData Services of EmailOctopus Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for EmailOctopus data by developing a WCF Service Application.
-
How to Connect to Live BigCommerce 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 BigCommerce data for you.
-
Integrating Antigravity CLI with Google Analytics data via CData CLI
Connect Google Analytics data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Search External Salesforce Data 360 Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Salesforce Data 360 data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Salesforce Data 360 Data objects that you can access from apps and the dashboard.
-
Build Voice Agents in ElevenLabs with access to Live Aweber Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Aweber data.
-
Analyze Power BI XMLA Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Power BI XMLA data with the CData JDBC Driver for Power BI XMLA.
-
Access Live Salesforce Marketing 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 Salesforce Marketing data through MCP integration.
-
Integrating Claude Code with Mailjet Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Mailjet data within assisted coding and automated development workflows.
-
How to Visualize ConstantContact 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 ConstantContact data in Python.
-
Analyze Phoenix Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Phoenix from Power Pivot. You will use the Table Import Wizard to load Phoenix data. You can visually build the import query or use any SQL supported by the driver.
-
Use Biml to Build SSIS Tasks to Replicate Pipeliner CRM Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Pipeliner CRM data to SQL Server.
-
Build Automated LinkedIn Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live LinkedIn Ads data and build automated workflows in Zapier.
-
A PostgreSQL Interface for Oracle Eloqua Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Eloqua ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous ClickUp Replication to Amazon S3
Use CData Sync for automated, continuous, customizable ClickUp replication to Amazon S3.
-
Automated Continuous Mode Replication to Snowflake
Use CData Sync for automated, continuous, customizable Mode replication to Snowflake.
-
DataBind Controls to Typeform Data in C++Builder
DataBind to Typeform data in C++Builder with standard components and controls.
-
Use Claude to Talk to Your ServiceNow 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 ServiceNow data for you.
-
Automated Continuous Vercel Replication to MySQL
Use CData Sync for automated, continuous, customizable Vercel replication to MySQL.
-
Build a Simple VCL Application for Elorus Data
How to build a simple VCL Application to view Elorus data in RAD Studio using the CData ODBC Driver for Elorus.
-
Publish Reports with Hive Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Hive data.
-
Use the CData SSIS Components to Insert New or Update Existing Google Campaign Manager 360 Records from SQL Server
Easily push SQL Server data to Google Campaign Manager 360 using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Google Campaign Manager 360 or update existing records with data from a SQL Server database.
-
Create SSAS Tabular Models from Onfleet Data
How to build a SQL Server Analysis Service Tabular Model from Onfleet data using CData drivers.
-
Natively Connect to Airtable Data in PHP
The CData ODBC driver for Airtable enables you to create PHP applications with connectivity to Airtable data. Leverage the native support for ODBC in PHP.
-
Creating Apollo-Connected Applications in Unqork
You can use CData Connect AI to feed Apollo data to Unqork and build custom business apps.
-
Build AI/ML Models with Live Zoom Data using Dataiku
Connect Zoom Data with Dataiku using the CData API Driver for JDBC.
-
Connect to PolarTeamPro Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with PolarTeamPro Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Create Power BI Visual Reports with Real-Time Simplesat Data
Use CData Power BI Connectors to visualize Simplesat data in Power BI.
-
How to Work with Oracle Eloqua Reporting Data in AWS Glue Jobs Using JDBC
Connect to Oracle Eloqua Reporting from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData Software JDBC Driver for Workable in MicroStrategy Web
Connect to Workable data in MicroStrategy Web using the CData Software JDBC Driver for Workable.
-
How to work with ConstantContact Data in Apache Spark using SQL
Access and process ConstantContact Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live ZohoInvoice Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ZohoInvoice data from your Google Sheets.
-
Connect to Hive Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Hive data using standard SQL.
-
Create a Data Access Object for SharePoint Data using JDBI
A brief overview of creating a SQL Object API for SharePoint data in JDBI.
-
How to Access Live Rebilly Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Rebilly enables you to integrate Rebilly data into workflows built using Microsoft Power Automate Desktop.
-
Access Live Blackbaud FE NXT Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Blackbaud FE NXT data from your Excel spreadsheets.
-
Rapidly Develop Basecamp-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 Basecamp.
-
Access Live YouTube Analytics 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 YouTube Analytics data through MCP integration.
-
How to work with Attio Data in Apache Spark using SQL
Access and process Attio Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate Goose with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Zendesk data from within the local AI agent.
-
Replicate Trello Data in Heroku for Use in Salesforce Connect
Replicate Trello data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Work with Microsoft Dataverse Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Dataverse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connecting Mastra with HubDB 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 HubDB data, no replication required.
-
Connect to Google Spanner Data from a Connection Pool in JBoss
Integrate Google Spanner data into Java servlets: Use the Management Console in JBoss to install the Google Spanner JDBC Driver.
-
Automated Continuous Egnyte Replication to Databricks
Use CData Sync for automated, continuous, customizable Egnyte replication to Databricks.
-
Use JayDeBeApi to access Procore Data in Python
Use standard Python scripting and the development environment of your choice to access live Procore data.
-
Analyze SAP Netweaver Gateway Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze SAP Netweaver Gateway data in Microsoft R Open.
-
Query Salesforce Data as a SQL Server Database in Node.js
Execute SQL Server queries against Salesforce data from Node.js.
-
Integrate PingOne Data in the Pentaho Report Designer
Publish reports based on PingOne data in the Pentaho BI tool.
-
Connect to Zoho Books Data in DBArtisan
Use wizards in DBArtisan to configure Zoho Books data as a data source.
-
Analyze Live Dynamics NAV Data in SAS Viya
Use CData Connect AI to connect to Dynamics NAV data from SAS Viya and deploy self-service analytics using live Dynamics NAV data.