CData Software - Knowledge Base
Recent Articles
-
Create Informatica Mappings From/To a JDBC Data Source for JotForm
Create JotForm data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Process & Analyze Scrapfly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Scrapfly Data.
-
Prepare, Blend, and Analyze YouTube Analytics Data in Alteryx Designer (ODBC)
Build workflows to access live YouTube Analytics for self-service data analytics.
-
Natively Connect to Cloudant Data in PHP
The CData ODBC driver for Cloudant enables you to create PHP applications with connectivity to IBM Cloudant. Leverage the native support for ODBC in PHP.
-
Integrating Redis Data in Talend Cloud Data Management Platform
Connect Redis Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Redis.
-
Use JayDeBeApi to access Airtable Data in Python
Use standard Python scripting and the development environment of your choice to access live Airtable.
-
Connect to Oracle Eloqua Reporting Data in RazorSQL
Connect to Oracle Eloqua Reporting from wizards and query Oracle Eloqua Reporting from the GUI in the RazorSQL database management tool.
-
Connect to YouTube Analytics Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for YouTube Analytics to connect to YouTube Analytics and execute queries in PowerBuilder.
-
How to create an RPA flow for Tavily Data in UiPath Studio
Use the Tavily ODBC Driver to create workflows that access real-time Tavily without any coding.
-
Operational Reporting on Hive Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Apache Hive.
-
Create Datasets from Klipfolio in Domo Workbench and Build Visualizations of Klipfolio Data in Domo
Use the CData Software ODBC Driver for Klipfolio to create datasets from Klipfolio in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Power BI Connector for Drip
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Visualize ChartMogul Data in TIBCO Spotfire through ADO.NET
Integrate ChartMogul into dashboards in TIBCO Spotfire.
-
Connect to FHIR Data from a Connection Pool in JBoss
Integrate FHIR into Java servlets: Use the Management Console in JBoss to install the FHIR JDBC Driver.
-
Choosing the Best Method to Connect Productboard to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Productboard from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Dynamics 365 Data in HULFT Integrate
Connect to Dynamics 365 as a JDBC data source in HULFT Integrate
-
DataBind Controls to Amazon S3 Data in C++Builder
DataBind to Amazon S3 in C++Builder with standard components and controls.
-
Automate SpaceX Data Replication to Azure Data Lake
Use CData Sync to customize and automate SpaceX replication to Azure Data Lake.
-
Use Azure AI Foundry to Talk to Your Impala 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 Apache Impala for you.
-
Build Google Campaign Manager 360-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Google Campaign Manager 360 to explore live Google Campaign Manager 360 Data in Cursor to assist with building Google Campaign Manager 360-powered applications.
-
Creating Paylocity-Connected Applications in Unqork
You can use CData Connect AI to feed Paylocity to Unqork and build custom business apps.
-
How to Connect to SAP Ariba Procurement Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SAP Ariba Procurement. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous Active Directory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Active Directory replication to delimited files (CSV/TSV).
-
Automated Continuous Kafka Replication to SingleStore
Use CData Sync for automated, continuous, customizable Kafka replication to SingleStore.
-
Analyze Instagram Data in Looker
Use CData Connect AI to connect to Instagram Data from Looker and build custom apps using live Instagram.
-
MYOB AccountRight Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on MYOB AccountRight facts in real time.
-
Analyze Salesforce Marketing Data in Cognos Analytics
Use CData Connect AI to connect to Salesforce Marketing Data from Cognos Analytics and analyze live Salesforce Marketing Cloud.
-
Integrating LinkedIn Ads Data in Talend Cloud Data Management Platform
Connect LinkedIn Ads Data with Talend Cloud Data Management Platform using the CData JDBC Driver for LinkedIn Ads.
-
Consume Bullhorn CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Bullhorn CRM feeds that reflect any changes in SAP Lumira.
-
Connect Trello Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Trello using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import and Visualize Harvest Data in Power View
Create data visualizations based on Harvest in Excel.
-
Build Zoho CRM-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zoho CRM to explore live Zoho CRM Data in GitHub Copilot to assist with building Zoho CRM-powered applications.
-
Publish Zoho Projects-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoho Projects.
-
Build Charts with Dotmailer Data in Clear Analytics
Create dynamic charts and perform analytics based on Dotmailer in Clear Analytics.
-
Publish Vercel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Vercel.
-
Connect to ConvertAPI Data in Aqua Data Studio
Access ConvertAPI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Publish eBay Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live eBay Analytics.
-
Getting Started with the CData Power BI Connector for Google Translate
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
DataBind Controls to Front Data in C++Builder
DataBind to Front in C++Builder with standard components and controls.
-
Use Dash to Build to Web Apps on Apollo Data
Create Python applications that use pandas and Dash to build Apollo-connected web apps.
-
Moving Data from GetResponse to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live GetResponse data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Extract, Transform, and Load Calendly Data in Informatica PowerCenter
Create a simple Workflow for Calendly in Informatica PowerCenter.
-
How to Visualize Neo4J 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 Neo4J in Python.
-
How to Query Live Microsoft Teams Data in Claude Desktop
Connect to and query live Microsoft Teams Data in Claude Desktop using CData MCP Server.
-
Automated Continuous Google Contacts Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Contacts replication to PostgreSQL.
-
Integrating Claude Code CLI with Shopify 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.
-
Access Live ActiveCampaign Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate ActiveCampaign into the statistical analysis tools available in SAS JMP. This article shows how to use ActiveCampaign in the Graph Builder and Query Builder.
-
How to Work with Apollo Data in ETL Validator JDBC
Connect to Apollo from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Chargebee Replication to SQLite
Use CData Sync for automated, continuous, customizable Chargebee replication to SQLite.
-
Integrate Microsoft Teams Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft Teams and integrate live Microsoft Teams into your Power Automate tasks.
-
Analyze Amazon S3 Data in Looker
Use CData Connect AI to connect to Amazon S3 Data from Looker and build custom apps using live Amazon S3.
-
Use the CData Software JDBC Driver for Klaviyo in MicroStrategy
Connect to Klaviyo in MicroStrategy Developer using the CData Software JDBC Driver for Klaviyo.
-
Automated Continuous ShipStation Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable ShipStation replication to PostgreSQL.
-
Automate Smartsheet Data Replication to Couchbase
Use CData Sync to Customize and automate Smartsheet replication to Couchbase.
-
Connect to Browserless Data in NetBeans
Connect to Browserless in NetBeans with the data source configuration wizard.
-
Getting Started with the CData JDBC Driver for LionDesk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LionDesk.
-
Analyze MailChimp Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MailChimp and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Prepare, Blend, and Analyze Egnyte Data in Alteryx Designer (ODBC)
Build workflows to access live Egnyte for self-service data analytics.
-
Deploy the ADO.NET Provider for FormSite on an SSRS Report Server
Connect to FormSite 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.
-
Connect to Amazon DynamoDB Data in HULFT Integrate
Connect to Amazon DynamoDB as a JDBC data source in HULFT Integrate
-
Create SSAS Tabular Models from Sybase Data
How to build a SQL Server Analysis Service Tabular Model from Sybase using CData drivers.
-
Connect to Exa Data in RazorSQL
Connect to Exa from wizards and query Exa from the GUI in the RazorSQL database management tool.
-
Use Microsoft Copilot Studio to talk to your Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Microsoft Ads for you.
-
Use Dash to Build to Web Apps on SAP Ariba Source Data
Create Python applications that use pandas and Dash to build SAP Ariba Source-connected web apps.
-
Publish Shopify-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Shopify.
-
How to Connect to & Open Beeminder Data in Microsoft Excel
This article uses the CData ODBC driver for Beeminder to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Automated Zoho Creator-Connected Workflows in Zapier
Use CData Connect AI to connect to live Zoho Creator and build automated workflows in Zapier.
-
Query Zoho Recruit Data in ColdFusion
Write standard ColdFusion data access code to connect to Zoho Recruit.
-
Access Live Beeminder Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Beeminder into the statistical analysis tools available in SAS JMP. This article shows how to use Beeminder in the Graph Builder and Query Builder.
-
Connect to ZohoDesk Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ZohoDesk to connect to ZohoDesk and execute queries in PowerBuilder.
-
Integrating Sybase IQ Data in Talend Cloud Data Management Platform
Connect Sybase IQ Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sybase IQ.
-
Query xBase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume xBase entities in PHP by modeling them as objects.
-
Getting Started with the CData Tableau Connector for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sybase IQ.
-
Integrate CockroachDB Data in Pentaho Data Integration
Build ETL pipelines based on CockroachDB in the Pentaho Data Integration tool.
-
Connect to NASA Data in Ruby
Connect to NASA in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Google Campaign Manager 360 within intelligent workflows.
-
Access Live CouchDB Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache CouchDB from your Excel spreadsheets.
-
Connect to Invoiced Data in DBeaver
Use the CData ODBC Driver to connect to Invoiced in DBeaver.
-
Greenplum Reporting in OBIEE with the Greenplum JDBC Driver
Deploy the Greenplum JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating OpenCode Terminal with Hugging Face 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 Build an ETL App for ShipStation Data in Python with CData Connect AI
Build ETL pipelines that read and write live ShipStation in Python with petl and the CData Connect AI Python SDK.
-
How to Query Live Shopify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Shopify data in natural language using Python.
-
How to connect to Zuora Data from IntelliJ
Integrate connectivity to Zuora with wizards in IntelliJ.
-
Visualize Exa Data in Tableau
The CData ODBC driver for Exa enables you integrate Exa into Tableau dashboards.
-
Publish Crystal Reports on Wave Financial Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Wave Financial.
-
Build Apps with Live FormSite Data Using the Low-Code Development Platform of Mendix
Connect FormSite with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Google Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Google Analytics replication to PostgreSQL.
-
Getting Started with the CData Tableau Connector for Greenplum
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Greenplum.
-
Access Live SAP Ariba Source Data in TIBCO Data Virtualization
Use the SAP Ariba Source Tibco DV Adapter to create a SAP Ariba Source data source in TIBCO Data Virtualization Studio and gain access to live SAP Ariba Source from your TDV Server.
-
Integrating Cursor CLI with Everhour 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.
-
Build Data Flows from Slack to SQL Server using SSIS
Easily back up Slack to SQL Server using the SSIS components for Slack.
-
Integrating Antigravity CLI with LinkedIn Ads via CData CLI
Connect LinkedIn Ads to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build MVC Applications with Connectivity to Shortcut Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Shortcut from an ASP.NET MVC application.
-
Create Informatica Mappings From/To an ODBC Data Source for FHIR
Create an ODBC connection to FHIR in Informatica and browse and transfer FHIR.
-
Getting Started with the CData Python Connector for Wistia
Learn to install and license the CData Python Connector
-
Build Agents in Relevance AI with Access to Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Google Analytics within intelligent agent workflows.
-
Connect to Stripe Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Stripe in the Denodo Virtual DataPort Administrator.
-
Query GraphQL Data in ColdFusion
Write standard ColdFusion data access code to connect to GraphQL.
-
Automated Continuous Dynamics 365 Business Central Replication to SingleStore
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to SingleStore.
-
Access Live Highrise 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 Highrise CRM through MCP integration.