CData Software - Knowledge Base
Recent Articles
-
Access Live SAP Ariba Procurement Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SAP Ariba Procurement into the statistical analysis tools available in SAS JMP. This article shows how to use SAP Ariba Procurement in the Graph Builder and Query Builder.
-
Integrate with Apify Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Apify to a JSON file on disk.
-
Connect to Redshift Data in RapidMiner
Integrate Amazon Redshift with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Humanity Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Humanity replication to Amazon Redshift.
-
Automated Continuous Google Calendar Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Google Calendar replication to Amazon Redshift.
-
How to connect Amazon QuickSight to Blackbaud FE NXT Data
Create a connection to Blackbaud FE NXT in CData Connect AI and insert Blackbaud FE NXT into Amazon QuickSight SPICE to build interactive dashboards.
-
How to publish and share Webflow Data dashboards with Tableau Server
The CData ODBC driver for Webflow enables you integrate Webflow into Tableau dashboards.
-
Connect to Productboard Data in Jaspersoft Studio
Execute SQL to remote Productboard in Jaspersoft Studio.
-
Prepare, Blend, and Analyze Toggl Data in Alteryx Designer (ODBC)
Build workflows to access live Toggl for self-service data analytics.
-
Load Testmonitor Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Testmonitor to a database.
-
Bridge Qualaroo Connectivity with Apache NiFi
Access and process Qualaroo in Apache NiFi using the CData JDBC Driver.
-
Build Pinterest-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Pinterest.
-
Validate ZohoInvoice Data with QuerySurge
Access and validate ZohoInvoice in QuerySurge using the CData JDBC Driver.
-
Connect to and Visualize Live Snowflake Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Snowflake.
-
Integrating Kiro CLI with Elasticsearch 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.
-
Analyze Marketo Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Marketo and visualize Marketo in SAP Analytics Cloud.
-
Connect to and Visualize Live Wistia Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Wistia.
-
Build Data Flows from SQL Server to MariaDB through SSIS
Easily push SQL Server data to MariaDB using the CData SSIS Tasks for MariaDB.
-
Operational Reporting on Oracle Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Oracle Database.
-
Connect to Google Forms Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Forms.
-
Work with BenchmarkEmail Data in FoxPro
Load BenchmarkEmail into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Azure Synapse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Azure Synapse and build web apps with connectivity to live Azure Synapse.
-
Access Neo4J Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Neo4J from your Oracle system.
-
Write a Simple Go Application to work with HBase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apache HBase.
-
Create Amazon Marketplace-Connected Nintex Workflows
Use CData Connect AI to connect to Amazon Marketplace Data from Nintex Workflow Cloud and build custom workflows using live Amazon Marketplace.
-
Connect to Oracle Eloqua Reporting Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle Eloqua Reporting as an External Source in Dremio.
-
Access Azure Table Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Azure Table Storage from your Oracle system.
-
Create HCL Domino-Connected Nintex Workflows
Use CData Connect AI to connect to HCL Domino Data from Nintex Workflow Cloud and build custom workflows using live HCL Domino.
-
Build LinkedIn-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for LinkedIn Data and create custom apps in Bubble.
-
Connect to Discord Data in Jaspersoft Studio
Execute SQL to remote Discord in Jaspersoft Studio.
-
LINQ to Miro 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 Miro Data Provider.
-
Manage Clari Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Clari.
-
Validate Sage 200 Data with QuerySurge
Access and validate Sage 200 in QuerySurge using the CData JDBC Driver.
-
Create Reports with PolarTeamPro Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PolarTeamPro.
-
Build a Singer.io Tap for Pingdom With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Pingdom data using
-
Access ServiceDesk Plus Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access ServiceDesk Plus from your Oracle system.
-
Build Dashboards with Adobe Commerce Data in Dundas BI
Create dynamic dashboards and perform analytics based on Adobe Commerce in Dundas BI.
-
Monday.com Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Monday.com through CData Connect AI using different applications and tools.
-
How to work with Vimeo Data in Apache Spark using SQL
Access and process Vimeo Data in Apache Spark using the CData Software JDBC Driver.
-
Bidirectional Access to Tavily Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Tavily in Filemaker Pro for Mac or Windows.
-
Integrate Neo4J Data in the Pentaho Report Designer
Publish reports based on Neo4J in the Pentaho BI tool.
-
Getting Started with the CData ODBC Driver for Google Ads
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Ads.
-
Access Avro Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Apache Avro from HeidiSQL.
-
Bind Live Jira Assets Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Jira Assets data
-
Integrating Codex CLI with Atlassian Jira 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.
-
Query iContact Data in ColdFusion
Write standard ColdFusion data access code to connect to iContact.
-
Connect to Gumroad Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Gumroad in the Denodo Virtual DataPort Administrator.
-
Use the CData Software JDBC Driver for Tickspot in MicroStrategy Web
Connect to Tickspot in MicroStrategy Web using the CData Software JDBC Driver for Tickspot.
-
Create Reports from Dynamics 365 Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Dynamics 365 and create custom reports in Looker Studio.
-
Create Data Visualizations Based On Highrise Data in Mode
Use CData Connect AI to connect to Highrise Data from Mode and build visualizations using live
-
Build Paylocity-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Paylocity to explore live Paylocity Data in Gemini Code Assist to assist with building Paylocity-powered applications.
-
Connect to Cvent Data from PowerBuilder via JDBC
This article demonstrates how to access Cvent from PowerBuilder using the Cvent JDBC Driver.
-
Connect to Pinecone Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Pinecone as an External Source in Dremio.
-
Integrate with Live Apollo Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Apollo from the MuleSoft Anypoint Platform to integrate live Apollo into custom reports and dashboards.
-
How to connect to LinkedIn Ads Data in DBVisualizer
Integrate LinkedIn Ads with visual data analysis tools and data connection wizards in DBVisualizer
-
How to Connect to & Open Slack Data in Microsoft Excel
This article uses the CData ODBC driver for Slack to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
How to import Supabase Data into Apache Solr
Use the CData Software JDBC Driver for Supabase in Data Import Handler and create an automated import of Supabase to Apache Solr Enterprise Search platform.
-
Create Xero-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Xero Data from OutSystems and build custom enterprise apps using live Xero Accounting.
-
How to create an RPA flow for Coda Data in UiPath Studio
Use the Coda ODBC Driver to create workflows that access real-time Coda without any coding.
-
Connect to Google Campaign Manager 360 Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Google Campaign Manager 360 Data and connect to Google Campaign Manager 360 in Akorbi Digital RunMyProcess.
-
Use the CData Software JDBC Driver for Kafka in MicroStrategy Desktop
Connect to Apache Kafka in MicroStrategy Desktop using the CData Software JDBC Driver for Kafka.
-
How to Connect to Live Databricks Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Databricks for you.
-
Integrating Gumloop with Procore Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Procore within automated workflows.
-
Moving Data from Smartsheet to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Smartsheet data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect Humanity to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Humanity using the CData Python MCP Server.
-
Stream Retently Data into Apache Kafka Topics
Access and stream Retently in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to Query Live Dynamics NAV Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Microsoft Dynamics NAV data in natural language using Python.
-
Moving Data from Paddle to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Paddle data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
DataBind Pingdom Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Pingdom to a chart.
-
How to Work with Salesforce Data in AWS Glue Jobs Using JDBC
Connect to Salesforce from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate Goose with Live Act-On Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Act-On from within the local AI agent.
-
How to Access Live Sage Intacct Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sage Intacct enables you to integrate Sage Intacct into workflows built using Microsoft Power Automate Desktop.
-
Connect to CapsuleCRM Data from PowerBuilder via JDBC
This article demonstrates how to access CapsuleCRM from PowerBuilder using the CapsuleCRM JDBC Driver.
-
Use Dash to Build to Web Apps on Deel Data
Create Python applications that use pandas and Dash to build Deel-connected web apps.
-
How to Connect to Live QuickBooks Time Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your QuickBooks Time for you.
-
Connect to Google Contacts 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 Google Contacts.
-
Publish Crystal Reports on Salesloft Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Salesloft.
-
Connect to Google Cloud Storage Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Google Cloud Storage and the Script function in FileMaker Pro to connect to Google Cloud Storage and work with Google Cloud Storage in your FileMaker application.
-
Build Bitly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Bitly.
-
Import ServiceNow Data Using Azure Data Factory
Use CData Connect AI to connect to ServiceNow Data from Azure Data Factory and import live ServiceNow.
-
How to Query Live Microsoft Ads Data in Claude Desktop
Connect to and query live Microsoft Ads Data in Claude Desktop using CData MCP Server.
-
Automated Continuous ChargeOver Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable ChargeOver replication to Azure SQL Database.
-
Bind Live Zoho CRM Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Zoho CRM data
-
Consume IBM Informix OData Feeds in PowerBuilder
This article demonstrates how to consume IBM Informix as OData feeds from PowerBuilder using the API Server.
-
Use Agno to Talk to Your HCL Domino 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 HCL Domino for you.
-
Automated Continuous Dotmailer Replication to MongoDB
Use CData Sync for automated, continuous, customizable Dotmailer replication to MongoDB.
-
Migrating data from XML to Google BigQuery using CData SSIS Components.
Easily push XML Files to Google BigQuery using the CData SSIS Tasks for XML and Google BigQuery.
-
Getting Started with the CData Connect AI Python SDK for SAP Hybris C4C
Install the CData Connect AI Python SDK to read and write live SAP Hybris C4C with standard DB-API 2.0 Python code.
-
Build Egnyte-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Egnyte.
-
Migrating data from Elorus to Databricks using CData SSIS Components.
Easily push Elorus to Databricks using the CData SSIS Tasks for Elorus and Databricks.
-
How to import XML Data into Apache Solr
Use the CData Software JDBC Driver for XML in Data Import Handler and create an automated import of XML Files to Apache Solr Enterprise Search platform.
-
Connect to Gmail Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Gmail to connect to Gmail and execute queries in PowerBuilder.
-
Automate OneNote Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft OneNote and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to ZeroBounce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZeroBounce in the Denodo Virtual DataPort Administrator.
-
Migrating data from Pinterest to Snowflake using CData SSIS Components.
Easily push Pinterest to Snowflake using the CData SSIS Tasks for Pinterest and Snowflake.
-
How to create Phoenix federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Apache Phoenix in MySQL .
-
How to Connect to JotForm Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to JotForm. Leverage the pyodbc module for ODBC in Python.
-
Integrating GitHub Copilot CLI with Postmark 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 Bullhorn CRM Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Bullhorn CRM replication to IBM DB2.
-
Use Grok to Talk to Your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your GraphQL for you.