CData Software - Knowledge Base
Recent Articles
-
Integrating OpenCode with Gmail 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 a Data Access Object for JobNimbus Data using JDBI
A brief overview of creating a SQL Object API for JobNimbus data in JDBI.
-
Access Landbot Data from MySQL in PHP
Connect to Landbot through the standard MySQL libraries in PHP.
-
Integrate Google's Vertex AI Agent with Live SQL Analysis Services 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 SQL Analysis Services data within intelligent workflows.
-
Analyze BambooHR Data in Cognos Analytics
Use CData Connect AI to connect to BambooHR Data from Cognos Analytics and analyze live BambooHR data.
-
Visualize Live FHIR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FHIR data.
-
Query, Visualize, and Share live DocuSign Data in Redash
Use CData Connect AI to connect to live DocuSign data in Redash for querying, visualizing, and sharing.
-
Process & Analyze QuickBooks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live QuickBooks Data.
-
Integrating LlamaIndex with Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Blackbaud FE NXT data in real time.
-
How to Connect to Slack Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Slack data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Mailjet Data into Power Automate Desktop using CData Connect
CData Connect for Mailjet Data enables you to integrate Mailjet data into workflows built using Microsoft Power Automate Desktop.
-
Working with Google Search Results in LINQPad
Execute LINQ queries to Google Search results in LINQPad.
-
Access Toggl Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Toggl data from HeidiSQL.
-
Integrate Dify with Live Outreach.io 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 Outreach.io data.
-
Create Informatica Mappings From/To a JDBC Data Source for Hubstaff
Create Hubstaff data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Dify with Live Timely 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 Timely data.
-
Build a PostgreSQL Interface for BigCommerce Data using the CData JDBC Driver
Use the Remoting features of the BigCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Prepare, Blend, and Analyze RSS Feeds in Alteryx Designer (ODBC)
Build workflows to access live RSS feeds for self-service data analytics.
-
Connect to Postmark in SpagoBI
Create reports featuring live Postmark data in SpagoBI Studio. Host Postmark reports on SpagoBI Server.
-
How to Build an ETL App for Act CRM Data in Python with CData Connect AI
Build ETL pipelines that read and write live Act CRM data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Microsoft Ads Data in ACL Analytics
Connect to Microsoft Ads data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft Ads data.
-
Analyze Salesforce Pardot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Pardot from Power Pivot. You will use the Table Import Wizard to load Salesforce Pardot data. You can visually build the import query or use any SQL supported by the driver.
-
Establish a Live Connection with Bullhorn CRM Data using Tableau Bridge
The CData ODBC Driver for Bullhorn CRM enables you to integrate live Bullhorn CRM data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to GetResponse Data in DBVisualizer
Integrate GetResponse data with visual data analysis tools and data connection wizards in DBVisualizer
-
Bridge PhantomBuster Connectivity with Apache NiFi
Access and process PhantomBuster data in Apache NiFi using the CData JDBC Driver.
-
How to Seamlessly Import Clio Data into IBM SPSS Modeler
Integrate Clio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Trello Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Trello data and build visualizations in Tableau.
-
Create Informatica Mappings From/To a JDBC Data Source for Impala
Create Impala data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Asana Data in JRuby
Create a simple JRuby app with access to live Asana data.
-
Getting Started with the CData ADO.NET Provider for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Clari Data in CloverDX (formerly CloverETL)
Transfer Clari data using the visual workflow in the CloverDX data integration tool.
-
Integrate Live Typeform Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Typeform from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Typeform data.
-
Build AI/ML Models with Live MarkLogic Data using Dataiku
Connect MarkLogic Data with Dataiku using the CData JDBC Driver for MarkLogic.
-
How to Connect to Live Zoho CRM Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Zoho CRM data securely in real time.
-
Automated Continuous Greenplum Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Greenplum data replication to OneLake in Microsoft Fabric.
-
How to Create Power BI Visual Reports with Real-Time ClickUp Data
Use CData Power BI Connectors to visualize ClickUp data in Power BI.
-
Integrating Cursor with Mailgun 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 Pinterest Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Pinterest data from HeidiSQL.
-
Automate SAP Ariba Source Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP Ariba Source data from PowerShell? This article demonstrates how to utilize the SAP Ariba Source Cmdlets for tasks like connecting to SAP Ariba Source data, automating operations, downloading data, and more.
-
Getting Started with the CData JDBC Driver for Postmark
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Postmark.
-
Work with Teradata Data in FoxPro
Load Teradata data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Instagram Data Replication to SAP HANA
Use CData Sync to customize and automate Instagram data replication to SAP HANA.
-
Publish Reports with eBay Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date eBay data.
-
Automated Continuous Samanage Replication to Snowflake
Use CData Sync for automated, continuous, customizable Samanage replication to Snowflake.
-
Use CData Connect AI to Access Shortcut Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Shortcut data in the Power Pivot business intelligence tool.
-
Use the CData Software ODBC Driver for Shopify in MicroStrategy Web
Connect to Shopify data in MicroStrategy Web using the CData Software ODBC Driver for Shopify.
-
Establish a Live Connection with MYOB AccountRight Data using Tableau Bridge
The CData ODBC Driver for MYOB AccountRight enables you to integrate live MYOB AccountRight data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Access Live JotForm Data in Power Automate Desktop via ODBC
The CData ODBC Driver for JotForm enables you to integrate JotForm data into workflows built using Microsoft Power Automate Desktop.
-
Integrate Zoom Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Zoom data from Informatica Cloud.
-
How to Access Live Browserless Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Browserless enables you to integrate Browserless data into workflows built using Microsoft Power Automate Desktop.
-
Manage Active Directory Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Active Directory.
-
Integrate Real-Time Access to Jira in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Jira data in real time.
-
Automated Continuous Reckon Accounts Hosted Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to Google Cloud SQL.
-
Automated Continuous Zoho Creator Replication to Oracle
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Oracle.
-
How to work with Missive Data in Apache Spark using SQL
Access and process Missive Data in Apache Spark using the CData Software JDBC Driver.
-
How to Connect TaxJar Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live TaxJar data in real time using natural language.
-
Creating Amazon S3-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon S3 data to Unqork and build custom business apps.
-
Work with Humanity Data in FoxPro
Load Humanity data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automated ServiceNow Data Replication to Teradata
Use CData Sync to Customize and automate ServiceNow data replication to Teradata.
-
Automate Zoho CRM Data Replication to SAP HANA
Use CData Sync to customize and automate Zoho CRM data replication to SAP HANA.
-
Create SAP HANA XS Advanced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP HANA XS Advanced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating LangChain with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on BigCommerce data within automated workflows.
-
Connect to Microsoft OneDrive Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft OneDrive data as a data source.
-
Load Instantly Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Instantly data to a database.
-
Getting Started with the CData ODBC Driver for Impala
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Impala.
-
Automated Continuous Deel Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Deel replication to delimited files (CSV/TSV).
-
Connect to Discourse Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Discourse data in the Denodo Virtual DataPort Administrator.
-
Analyze Stripe Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Stripe from Power Pivot. You will use the Table Import Wizard to load Stripe data. You can visually build the import query or use any SQL supported by the driver.
-
Query Dotmailer Data in DataGrip
Create a Data Source for Dotmailer in DataGrip and use SQL to query live Dotmailer data.
-
Integrate with NetSuite SuiteAnalytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live NetSuite SuiteAnalytics data in SnapLogic.
-
Create Apps from YouTube Analytics Data in Qlik Sense Cloud
Use CData Connect AI to connect to YouTube Analytics Data and build apps from live YouTube Analytics data in Qlik Sense Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Redis
Provide connectivity to Redis data through an SAP BusinessObjects universe.
-
How to Query Okta Data in MySQL Workbench
Execute MySQL queries against live Okta data from MySQL Workbench.
-
Viewing Clio Data in RAD Studio Data Explorer
How to view Clio data in RAD Studio Data Explorer using the CData ODBC Driver for Clio.
-
Use Azure AI Foundry to Talk to Your Basecamp 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 Basecamp data for you.
-
Excel Spreadsheet Automation on Quaderno Data with the QUERY Formula
Pull data from Quaderno, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for Clio in SAS for Real-Time Reporting and Analytics
Connect to real-time Clio data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Clio.
-
Use the CData Software ODBC Driver for Discord in MicroStrategy Desktop
Connect to Discord data in MicroStrategy Desktop using the CData Software ODBC Driver for Discord.
-
Connect to ServiceDesk Plus Data in JRuby
Create a simple JRuby app with access to live ServiceDesk Plus data.
-
How to work with Google Translate Data in Apache Spark using SQL
Access and process Google Translate Data in Apache Spark using the CData Software JDBC Driver.
-
Prepare, Blend, and Analyze Paylocity Data in Alteryx Designer (Connect AI)
Build workflows to access live Paylocity data for self-service data analytics.
-
Integrating Antigravity CLI with Authorize.Net data via CData CLI
Connect Authorize.Net data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Connect to Live Power BI XMLA 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 Power BI XMLA data without replication.
-
Integrating ChartMogul Data in Talend Cloud Data Management Platform
Connect ChartMogul Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Automated Continuous Sentry Replication to MongoDB
Use CData Sync for automated, continuous, customizable Sentry replication to MongoDB.
-
Automated Continuous Freshsales Replication to Oracle
Use CData Sync for automated, continuous, customizable Freshsales replication to Oracle.
-
Integrate SendPulse Data in Pentaho Data Integration
Build ETL pipelines based on SendPulse data in the Pentaho Data Integration tool.
-
Build Data Flows from SAS xpt to SQL Server using SSIS
Easily back up SAS xpt data to SQL Server using the SSIS components for SAS xpt.
-
Connect to Live Google Contacts Data in MicroStrategy through CData Connect AI
Create a live connection to Google Contacts Data in CData Connect AI and connect to your Google Contacts data from MicroStrategy.
-
How to Connect to & Open Zoho Books Data in Microsoft Excel
This article uses the CData ODBC driver for Zoho Books to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Microsoft Planner Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Microsoft Planner and the Script function in FileMaker Pro to connect to Microsoft Planner and work with Microsoft Planner data in your FileMaker application.
-
Connect to Oracle Financials Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle Financials Cloud data from your AWS Glue jobs.
-
Use the CData Software JDBC Driver for Basecamp in MicroStrategy Web
Connect to Basecamp data in MicroStrategy Web using the CData Software JDBC Driver for Basecamp.
-
Access Live Google Campaign Manager 360 Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Google Campaign Manager 360 data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
A PostgreSQL Interface for Productboard Data (MySQL Remoting via JDBC)
Use the Remoting features of the Productboard JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Sentry Data Replication to Couchbase
Use CData Sync to Customize and automate Sentry data replication to Couchbase.
-
Query VWO Data through ODBC in Node.js
Use node-odbc to execute SQL queries against VWO data from Node.js.
-
Build Apps with Live ActiveCampaign Data Using the Low-Code Development Platform of Mendix
Connect ActiveCampaign data with Mendix to build apps using the CData JDBC Driver for ActiveCampaign.
-
Integrating Cursor with Procore 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.
-
Feed Freshteam Data into FineReport
How to set Freshteam data as a JDBC data source in FineReport.