CData Software - Knowledge Base
Recent Articles
-
Connect to OpenWeatherMap Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for OpenWeatherMap and the SQL Gateway to access OpenWeatherMap data from Google Apps Script.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bugsnag
Provide connectivity to Bugsnag data through an SAP BusinessObjects universe.
-
Build Apps with Live Perplexity data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Perplexity data into the Adalo platform and build custom mobile and web applications with real-time Perplexity data.
-
Query Twitter Ads Data as a MySQL Database in Node.js
Execute MySQL queries against Twitter Ads data from Node.js.
-
Host the API Server on Amazon EC2
Host the Windows and Java editions of an API Server on Amazon EC2.
-
Integrating LangChain with Zuora Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Zuora data within automated workflows.
-
Access Live Instantly Data in AWS Lambda
Connect to live Instantly data in AWS Lambda using the CData JDBC Driver.
-
Connect to Paddle Data in CloverDX (formerly CloverETL)
Transfer Paddle data using the visual workflow in the CloverDX data integration tool.
-
Connect to Clockify from Asprova with CData Software ODBC Driver for Clockify
This article shows how to connect faster to Clockify data from Asprova.
-
Import Real-Time Float Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Float data in ColdFusion.
-
Automated Samanage Data Replication to Teradata
Use CData Sync to Customize and automate Samanage data replication to Teradata.
-
Integrate Dify with Live Salesforce CRM Analytics Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Salesforce CRM Analytics data.
-
Connect to Customer.io 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 Customer.io and work with Customer.io data in your FileMaker application.
-
Build Charts with ChartMogul Data in Clear Analytics
Create dynamic charts and perform analytics based on ChartMogul data in Clear Analytics.
-
Validate Google Ad Manager Data with QuerySurge
Access and validate Google Ad Manager data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for Pinterest
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Pinterest.
-
Connect to HubDB Data in Aqua Data Studio
Access HubDB data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Jira-Connected Business Apps in AppSheet
Connect to Jira Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Jira data.
-
Publish Reports with WordPress Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date WordPress data.
-
Access Live Procore Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Procore data from your Excel spreadsheets.
-
Automate Mailjet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Mailjet data from PowerShell? This article demonstrates how to utilize the Mailjet Cmdlets for tasks like connecting to Mailjet data, automating operations, downloading data, and more.
-
Integrate Open WebUI with Live FTP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live FTP data from within the chat interface.
-
Use the CData Software JDBC Driver for Dynamics 365 Business Central in MicroStrategy Web
Connect to Dynamics 365 Business Central data in MicroStrategy Web using the CData Software JDBC Driver for Dynamics 365 Business Central.
-
BigCommerce Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BigCommerce facts in real time.
-
Migrating data from Highrise to Databricks using CData SSIS Components.
Easily push Highrise data to Databricks using the CData SSIS Tasks for Highrise and Databricks.
-
Create Dynamic Salesloft Grids Using the Infragistics XamDataGrid
Learn how you can connect Salesloft to Infragistics XamDataGrid to build dynamic grids.
-
Create Dynamic LightSpeedRetail Grids Using the Infragistics XamDataGrid
Learn how you can connect LightSpeedRetail to Infragistics XamDataGrid to build dynamic grids.
-
DataBind Controls to Hubstaff Data in C++Builder
DataBind to Hubstaff data in C++Builder with standard components and controls.
-
Connect and Visualize Live Certinia Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Certinia data into the Databricks platform and create visualization dashboards with real-time Certinia data.
-
Automated Continuous BambooHR Replication to Snowflake
Use CData Sync for automated, continuous, customizable BambooHR replication to Snowflake.
-
Connect to ZarMoney Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZarMoney and work with ZarMoney data in your FileMaker applications.
-
Query Google Sheets Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Sheets data from Node.js.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Printful
Provide connectivity to Printful data through an SAP BusinessObjects universe.
-
Getting Started with the CData Connect AI Python SDK for Kafka
Install the CData Connect AI Python SDK to read and write live Kafka data with standard DB-API 2.0 Python code.
-
Prepare, Blend, and Analyze Pingdom Data in Alteryx Designer (ODBC)
Build workflows to access live Pingdom data for self-service data analytics.
-
Write a Simple Go Application to work with LeadDesk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to LeadDesk data.
-
Connect to and Query PabblySubscriptions Data in QlikView over ODBC
Create data visualizations with PabblySubscriptions data in QlikView.
-
Connect to Rebilly Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Rebilly and the SQL Gateway to access Rebilly data from Google Apps Script.
-
Moving Data from Samanage to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Samanage data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Design BIRT Reports on Act CRM Data
Provide current Act CRM data to your embedded analytics.
-
Access Amazon DynamoDB Data from MySQL in Amazon QuickSight
Connect to Amazon DynamoDB and build visualizations of Amazon DynamoDB data using a MySQL Connection in Amazon QuickSight.
-
How to connect to Oracle Eloqua Reporting Data with Squirrel SQL client
Connect to Oracle Eloqua Reporting data and execute queries in the Squirrel SQL Client.
-
Import and Visualize TaxJar Data in Power View
Create data visualizations based on TaxJar data in Excel.
-
How to work with Timely Data in Apache Spark using SQL
Access and process Timely Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Telegram Data in Dundas BI
Create dynamic dashboards and perform analytics based on Telegram data in Dundas BI.
-
Automated Continuous SendGrid Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SendGrid data replication to OneLake in Microsoft Fabric.
-
Work with CapsuleCRM Data in FoxPro
Load CapsuleCRM data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Enable the Google Contacts JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Google Contacts data.
-
DataBind Controls to Rootly Data in Delphi
DataBind to Rootly data in Delphi with standard data access components and controls.
-
Integrate Qualaroo Data in Pentaho Data Integration
Build ETL pipelines based on Qualaroo data in the Pentaho Data Integration tool.
-
Access Office 365 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Office 365 data from your Oracle system.
-
Creating OData-Connected Applications in Unqork
You can use CData Connect AI to feed OData services to Unqork and build custom business apps.
-
Migrating data from Omnisend to Google BigQuery using CData SSIS Components.
Easily push Omnisend data to Google BigQuery using the CData SSIS Tasks for Omnisend and Google BigQuery.
-
Access Live MailChimp Data in TIBCO Data Virtualization
Use the MailChimp Tibco DV Adapter to create a MailChimp data data source in TIBCO Data Virtualization Studio and gain access to live MailChimp data from your TDV Server.
-
Access FTP 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 FTP data.
-
Build Charts with Webex Data in Clear Analytics
Create dynamic charts and perform analytics based on Webex data in Clear Analytics.
-
Add LinkedIn Ads Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LinkedIn Ads with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData SSIS Components to Insert New or Update Existing Facebook Ads Records from SQL Server
Easily push SQL Server data to Facebook Ads using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Facebook Ads or update existing records with data from a SQL Server database.
-
Moving Data from Quickbase to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Quickbase data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Biml to Build SSIS Tasks to Replicate SAP Ariba Source Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Ariba Source data to SQL Server.
-
Validate ScrapingBee Data with QuerySurge
Access and validate ScrapingBee data in QuerySurge using the CData JDBC Driver.
-
Bridge Adobe Target Connectivity with Apache NiFi
Access and process Adobe Target data in Apache NiFi using the CData JDBC Driver.
-
Easily Integrate Printful Data in Lazarus Pascal IDE
Learn how to easily integrate live Printful data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrating LangChain with IBM Cloud Object Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on IBM Cloud Object Storage data within automated workflows.
-
Connect to Egnyte from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Egnyte data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
DataBind Controls to HelloSign Data in C++Builder
DataBind to HelloSign data in C++Builder with standard components and controls.
-
How to create an RPA flow for Eventbrite Data in UiPath Studio
Use the Eventbrite ODBC Driver to create workflows that access real-time Eventbrite data without any coding.
-
Integrating Kiro with Highrise 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.
-
Query Airtable Data as a SQL Server Database in Node.js
Execute SQL Server queries against Airtable data from Node.js.
-
Connect to Landbot Data in DBArtisan
Use wizards in DBArtisan to configure Landbot data as a data source.
-
Bridge Elasticsearch Connectivity with Apache NiFi
Access and process Elasticsearch data in Apache NiFi using the CData JDBC Driver.
-
Create GitHub Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GitHub from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create Data Visualizations in Cognos BI with Oracle Financials Cloud Data
Access Oracle Financials Cloud data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Google Spanner Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Spanner data.
-
Explore Geographical Relationships in Missive Data with Power Map
Create data visualizations with Missive data in Power Map.
-
How to Connect to Live Neo4J Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Neo4J data securely in real time.
-
How to connect to Authorize.Net Data with Squirrel SQL client
Connect to Authorize.Net data and execute queries in the Squirrel SQL Client.
-
Use Manus AI to Talk to Your Egnyte Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Egnyte data.
-
Create Informatica Mappings From/To an ODBC Data Source for SparkPost
Create an ODBC connection to SparkPost in Informatica and browse and transfer SparkPost data.
-
Automated Continuous Freshdesk Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Freshdesk replication to AlloyDB.
-
Build Apps with Live Salesforce CRM Analytics data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesforce CRM Analytics data into the Adalo platform and build custom mobile and web applications with real-time Salesforce CRM Analytics data.
-
Create Dynamic Sage Intacct Grids Using the Infragistics XamDataGrid
Learn how you can connect Sage Intacct to Infragistics XamDataGrid to build dynamic grids.
-
Use the CData Software ODBC Driver for Outlook in SAS for Real-Time Reporting and Analytics
Connect to real-time Outlook data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Outlook.
-
How to create Greenplum federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Greenplum data in MySQL .
-
Build Bitbucket-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Bitbucket data and build Bitbucket-connected web apps with Axios.
-
Integrating Claude Code with Facebook Ads Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Facebook Ads data within assisted coding and automated development workflows.
-
How to Connect to Live BenchmarkEmail Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your BenchmarkEmail data for you.
-
Connect to Azure Analysis Services Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure Analysis Services Data and connect to Azure Analysis Services data in Akorbi Digital RunMyProcess.
-
Integrate Goose with Live Azure Table Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Azure Table data from within the local AI agent.
-
Connect to Google Directory from Asprova with CData Software ODBC Driver for Google Directory
This article shows how to connect faster to Google Directory data from Asprova.
-
Integrating Claude Code CLI with GitHub 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.
-
Getting Started with the CData ADO.NET Provider for WordPress
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for WordPress.
-
How to Connect to Live Testmonitor Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Testmonitor data securely in real time.
-
Use Dash to Build to Web Apps on Moosend Data
Create Python applications that use pandas and Dash to build Moosend-connected web apps.
-
Integrating OpenCode with MarkLogic 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.
-
Use the CData SSIS Components to Insert New or Update Existing Impala Records from SQL Server
Easily push SQL Server data to Impala using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Impala or update existing records with data from a SQL Server database.
-
Connect to Live Zoho Creator Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zoho Creator in CData Connect AI and connect to your Zoho Creator data from PostgreSQL.
-
Connect to Impala Data in DBArtisan
Use wizards in DBArtisan to configure Impala data as a data source.
-
Build Agents in Relevance AI with Access to Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Greenhouse data within intelligent agent workflows.
-
Integrating LlamaIndex with SuiteCRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SuiteCRM data in real time.