CData Software - Knowledge Base
Recent Articles
-
Create Exact Online-Connected Business Apps in AppSheet
Connect to Exact Online Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Exact Online.
-
Connect to Cosmos DB Data in DBeaver
Use the CData ODBC Driver to connect to Azure Cosmos DB in DBeaver.
-
Create Salesforce Marketing-Connected Nintex Workflows
Use CData Connect AI to connect to Salesforce Marketing Data from Nintex Workflow Cloud and build custom workflows using live Salesforce Marketing Cloud.
-
How to create an RPA flow for Sendwithus Data in UiPath Studio
Use the Sendwithus ODBC Driver to create workflows that access real-time Sendwithus without any coding.
-
Build AlloyDB-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for AlloyDB to explore live AlloyDB Data in Cursor to assist with building AlloyDB-powered applications.
-
How to Connect to Live Acumatica 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 Acumatica ERP for you.
-
How to Connect to OData Services in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to OData. Leverage the pyodbc module for ODBC in Python.
-
Use JayDeBeApi to access Quaderno Data in Python
Use standard Python scripting and the development environment of your choice to access live Quaderno.
-
Operational Reporting on ZohoPeople Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ZohoPeople.
-
How to publish and share Contentful Data dashboards with Tableau Server
The CData ODBC driver for Contentful enables you integrate Contentful into Tableau dashboards.
-
Automated Continuous Pipeline CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to Azure SQL Database.
-
Connect to Zoho Projects Data in DBArtisan
Use wizards in DBArtisan to configure Zoho Projects as a data source.
-
Import Vault CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Veeva Vault & Vault CRM. In this article, you will use the OData format to import Veeva Vault & Vault CRM into Microsoft Power Query.
-
Visualize Live Cassandra Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Cassandra.
-
Viewing PhantomBuster Data in RAD Studio Data Explorer
How to view PhantomBuster in RAD Studio Data Explorer using the CData ODBC Driver for PhantomBuster.
-
Connect to Authorize.Net Data in DBeaver
Use the CData ODBC Driver to connect to Authorize.Net in DBeaver.
-
Figshare Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Figshare facts in real time.
-
Access Live SAP Business Warehouse Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Business Warehouse in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous Keap Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Keap replication to OneLake in Microsoft Fabric.
-
A PostgreSQL Interface for Aha! Data using the CData ODBC Driver
Use the SQL Gateway and Aha! ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Access eBay Data Using Entity Framework
This article shows how to access eBay using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to PagerDuty Data in Aqua Data Studio
Access PagerDuty from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous AgileCRM Replication to Databricks
Use CData Sync for automated, continuous, customizable AgileCRM replication to Databricks.
-
Connect to Delighted Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Delighted.
-
Integrate Spark Data in the Pentaho Report Designer
Publish reports based on Apache Spark SQL in the Pentaho BI tool.
-
Access Live Printful Data in AWS Lambda
Connect to live Printful in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Aweber Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Aweber replication to delimited files (CSV/TSV).
-
Perform Batch Operations with ActiveCampaign Data in Apache NiFi
Connect to ActiveCampaign and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Access Live Coda Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Coda into the statistical analysis tools available in SAS JMP. This article shows how to use Coda in the Graph Builder and Query Builder.
-
Add Lakebase Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Lakebase with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Brex Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Brex.
-
Getting Started with the CData Tableau Connector for Aircall
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to QuickBooks Time Data in RapidMiner
Integrate QuickBooks Time with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate Tavily Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tavily from PowerShell? This article demonstrates how to utilize the Tavily Cmdlets for tasks like connecting to Tavily, automating operations, downloading data, and more.
-
Use Azure AI Foundry to Talk to Your SAP HANA 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 SAP HANA for you.
-
Use JayDeBeApi to access Zoom Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoom.
-
Edit and Search External Marketo Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Marketo to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Marketo Data objects that you can access from apps and the dashboard.
-
Connect to and Visualize Live MarkLogic Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MarkLogic.
-
Create Reports with LionDesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LionDesk.
-
Build Visualizations of Twitter Ads Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Twitter Ads in Birst.
-
Extend Google Sheets with Reckon Accounts Hosted Data
Make calls to Reckon Accounts Hosted from Google Apps Script via the API Server.
-
Connect to PabblySubscriptions Data in CloverDX (formerly CloverETL)
Transfer PabblySubscriptions using the visual workflow in the CloverDX data integration tool.
-
Query SendGrid Data as a MySQL Database in Node.js
Execute MySQL queries against SendGrid from Node.js.
-
ETL Oracle HCM Cloud in Oracle Data Integrator
This article shows how to transfer Oracle HCM Cloud into a data warehouse using Oracle Data Integrator.
-
How to Build an ETL App for Amplitude Data in Python with CData
Create ETL applications and real-time data pipelines for Amplitude in Python with petl.
-
Integrating Gumloop with Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Amazon S3 within automated workflows.
-
How to Query Live XML Data in Claude Desktop
Connect to and query live XML Data in Claude Desktop using CData MCP Server.
-
Automate Paymo Data Replication to Couchbase
Use CData Sync to Customize and automate Paymo replication to Couchbase.
-
Configure the CData JDBC Driver for Azure Analysis Services in a Connection Pool in Tomcat
Connect to Azure Analysis Services from a connection pool in Tomcat.
-
Work with PayPal Data in FoxPro
Load PayPal into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Gong using the Model Context Protocol.
-
Create Google Ad Manager-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Ad Manager Data from Klipfolio and build custom visualizations using live Google Ad Manager.
-
Create Apps from EnterpriseDB Data in Qlik Sense Cloud
Use CData Connect AI to connect to EnterpriseDB Data and build apps from live EnterpriseDB in Qlik Sense Cloud.
-
Getting Started with the CData Connect AI Python SDK for QuickBooks Online
Install the CData Connect AI Python SDK to read and write live QuickBooks Online with standard DB-API 2.0 Python code.
-
Integrate LibreChat with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Cvent from within the chat interface.
-
Integrating LlamaIndex with MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on MailChimp in real time.
-
Access Live SAP Business One Data in Coginiti Pro
Connect to and query live SAP Business One from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate with Insightly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Insightly to a JSON file on disk.
-
DataBind Discord Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Discord to a chart.
-
Manage Twitter Ads Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Twitter Ads.
-
Analyze Grafana Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Grafana with the CData JDBC Driver for Grafana.
-
How to publish and share Google Directory Data dashboards with Tableau Server
The CData ODBC driver for Google Directory enables you integrate Google Directory into Tableau dashboards.
-
Getting Started with the CData Tableau Connector for NetSuite
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for NetSuite.
-
Integrating Cursor CLI with JobNimbus 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, Visualize, and Share live ActiveCampaign Data in Redash
Use CData Connect AI to connect to live ActiveCampaign in Redash for querying, visualizing, and sharing.
-
How to Query Live Pinecone Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Pinecone data in natural language using Python.
-
Edit and Search External Google Directory Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Directory to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Directory Data objects that you can access from apps and the dashboard.
-
Process & Analyze Spark Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Spark Data.
-
DataBind Google Ad Manager Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Google Ad Manager with the DevExpress Windows Forms and Web controls to provide Google Ad Manager to a chart.
-
Build ServiceNow Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ServiceNow and build visualizations in Tableau Cloud.
-
Integrate with Active Directory Data in JReport Designer
Create charts and reports based on Active Directory in JReport Designer.
-
Design BIRT Reports on Customer.io Data
Provide current Customer.io to your embedded analytics.
-
Connect to Rebilly 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 Rebilly and work with Rebilly in your FileMaker application.
-
Analyze Qualaroo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Qualaroo with the CData JDBC Driver for Qualaroo.
-
Use the CData Software JDBC Driver for MarkLogic in MicroStrategy Web
Connect to MarkLogic in MicroStrategy Web using the CData Software JDBC Driver for MarkLogic.
-
Operational Reporting on Kintone Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Kintone.
-
Visualize Live SAS Data Sets Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAS Data Sets.
-
How to Connect DBeaver to Marketo via a JDBC Driver
Manage Marketo with visual tools in DBeaver like the query browser.
-
Operational Reporting on Superchat Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Superchat.
-
Excel Spreadsheet Automation on Salesforce Pardot Data with the QUERY Formula
Pull data from Salesforce Pardot, automate spreadsheets, and more with the QUERY formula.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MYOB AccountRight
Provide connectivity to MYOB AccountRight through an SAP BusinessObjects universe.
-
Integrate with Power BI XMLA Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Power BI XMLA to a JSON file on disk.
-
Use Dash to Build to Web Apps on Dynamics CRM Data
Create Python applications that use pandas and Dash to build Dynamics CRM-connected web apps.
-
How to Work with LightSpeedRetail Data in ETL Validator JDBC
Connect to LightSpeedRetail from ETL Validator jobs using the CData Software JDBC Driver.
-
Perform Batch Operations with MongoDB Data in Apache NiFi
Connect to MongoDB and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build MVC Applications with Connectivity to JotForm Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access JotForm from an ASP.NET MVC application.
-
Create SSAS Tabular Models from Factorial Data
How to build a SQL Server Analysis Service Tabular Model from Factorial using CData drivers.
-
Analyze VWO Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze VWO with the CData JDBC Driver for VWO.
-
Using the CData Software ODBC Driver for Raisers Edge NXT in PyCharm
Connect to Raisers Edge NXT as an ODBC data source in PyCharm using the CData Software ODBC Driver for Raisers Edge NXT.
-
Getting Started with the CData Tableau Connector for Google Drive
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Google Drive.
-
Use ChatGPT to Talk to Your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Redis for you.
-
Model, Search, and Visualize Live Databricks Data in ThoughtSpot
Use CData Connect AI to connect to live Databricks for modeling, searching, and visualizing.
-
Automated Continuous Presto Replication to Databricks
Use CData Sync for automated, continuous, customizable Presto replication to Databricks.
-
Automated Continuous SparkPost Replication to SQL Server
Use CData Sync for automated, continuous, customizable SparkPost replication to SQL Server.
-
Integrating Cursor CLI with Kafka 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.
-
Visualize Live Active Directory Data in the Power BI Service
Use CData Connect AI to connect to live Active Directory and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Figshare Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Figshare replication to PostgreSQL.
-
Integrate SAS xpt Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SAS XPORT from Informatica Cloud.
-
Create Power BI Reports on Real-Time Klipfolio Data
Use the CData ODBC Driver for Klipfolio to visualize Klipfolio in Power BI Desktop.
-
Bridge HDFS Connectivity with Apache NiFi
Access and process Apache HDFS in Apache NiFi using the CData JDBC Driver.