CData Software - Knowledge Base
Recent Articles
-
Build Pipelines with Live Salesforce Marketing Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Salesforce Marketing from Google Cloud Data Fusion, enabling the integration of live Salesforce Marketing Cloud into the building and management of effective data pipelines.
-
Access Live Xero Data in AWS Lambda
Connect to live Xero Accounting in AWS Lambda using the CData JDBC Driver.
-
Use Dash to Build Web Apps on IBM Informix Data via CData Connect AI
Build interactive Dash web apps on live IBM Informix using pandas and the CData Connect AI Python SDK.
-
Automated Continuous SendGrid Replication to SQLite
Use CData Sync for automated, continuous, customizable SendGrid replication to SQLite.
-
Integrating LangChain with Google Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Google Directory within automated workflows.
-
Use Microsoft Copilot Studio to talk to your Zoho Creator 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 Zoho Creator for you.
-
How to connect Amazon QuickSight to Bullhorn CRM Data
Create a connection to Bullhorn CRM in CData Connect AI and insert Bullhorn CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Build Apps with Live DocuSign in Adalo using CData Connect AI
Use CData Connect AI to integrate live DocuSign into the Adalo platform and build custom mobile and web applications with real-time DocuSign.
-
Visualize Jodoo Data in Tableau
The CData ODBC driver for Jodoo enables you integrate Jodoo into Tableau dashboards.
-
Automate Zoho Projects Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Projects replication to Couchbase.
-
Connect to Supabase Data in DBeaver
Use the CData ODBC Driver to connect to Supabase in DBeaver.
-
Replicate CockroachDB Data in Heroku for Use in Salesforce Connect
Replicate CockroachDB to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Open WebUI with Live MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live MailChimp from within the chat interface.
-
Build Voice Agents in ElevenLabs with access to Live BigQuery Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google BigQuery.
-
Automated Continuous Calendly Replication to Vertica
Use CData Sync for automated, continuous, customizable Calendly replication to Vertica.
-
Visualize Live VWO Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live VWO using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Twitter Ads Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Amazon S3.
-
Connect to FreeAgent Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FreeAgent as an External Source in Dremio.
-
Connect to Wistia from Asprova with CData Software ODBC Driver for Wistia
This article shows how to connect faster to Wistia data from Asprova.
-
Connect Outlook Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Outlook using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Creating Smartsheet-Connected Applications in Unqork
You can use CData Connect AI to feed Smartsheet to Unqork and build custom business apps.
-
Use the CData Software JDBC Driver for Zoho Inventory in MicroStrategy Desktop
Connect to Zoho Inventory in MicroStrategy Desktop using the CData Software JDBC Driver for Zoho Inventory.
-
How to Create Power BI Visual Reports with Real-Time Vercel Data
Use CData Power BI Connectors to visualize Vercel in Power BI.
-
How to Connect to Avalara AvaTax Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Avalara AvaTax. Leverage the pyodbc module for ODBC in Python.
-
Connect to SQL Analysis Services Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SQL Analysis Services.
-
Access xBase 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 xBase.
-
Publish Crystal Reports on Quaderno Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Quaderno.
-
Contentful Reporting in OBIEE with the Contentful JDBC Driver
Deploy the Contentful JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize Live ZohoDesk Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZohoDesk.
-
How to connect and process Google Translate from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Translate.
-
Create SSAS Tabular Models from Freshdesk Data
How to build a SQL Server Analysis Service Tabular Model from Freshdesk using CData drivers.
-
Write a Simple Go Application to work with NASA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NASA.
-
Create Data Visualizations in Cognos BI with ZohoPeople Data
Access ZohoPeople as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate SharePoint Excel Services Data to Multiple Databases
Replicate SharePoint Excel Services to disparate databases with a point-and-click configuration.
-
Use Biml to Build SSIS Tasks to Replicate Jodoo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Jodoo to SQL Server.
-
DataBind Charts to Oracle Eloqua Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Eloqua from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Getting Started with the CData JDBC Driver for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for QuickBooks Online.
-
Build Visualizations of SAP BusinessObjects BI Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP BusinessObjects BI in Birst.
-
Build Data Flows from ZohoMarketingHub to SQL Server using SSIS
Easily back up ZohoMarketingHub to SQL Server using the SSIS components for ZohoMarketingHub.
-
Natively Connect to Attio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Attio. Leverage the native support for ODBC in PHP.
-
Integrate Goose with Live Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Certinia from within the local AI agent.
-
Migrating data from ServiceNow to Google BigQuery using CData SSIS Components.
Easily push ServiceNow to Google BigQuery using the CData SSIS Tasks for ServiceNow and Google BigQuery.
-
Analyze JobNimbus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze JobNimbus with the CData JDBC Driver for JobNimbus.
-
A PostgreSQL Interface for Zendesk Data (MySQL Remoting via JDBC)
Use the Remoting features of the Zendesk JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Couchbase Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Couchbase from Filemaker Pro on Mac.
-
How to connect Amazon QuickSight to SurveyMonkey Data
Create a connection to SurveyMonkey in CData Connect AI and insert SurveyMonkey into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Tasks
Create Google Tasks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Create Power BI Visual Reports with Real-Time Yelp Data
Use CData Power BI Connectors to visualize Yelp in Power BI.
-
DataBind Charts to HCL Domino Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HCL Domino from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Integrate Humanity with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Humanity with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Humanity.
-
How to publish and share Foursquare Data dashboards with Tableau Server
The CData ODBC driver for Foursquare enables you integrate Foursquare into Tableau dashboards.
-
Object-Relational Mapping (ORM) with Office 365 Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Office 365 into a Java-based ORM framework, Hibernate.
-
Rapidly Develop Salesforce Pardot-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Salesforce Pardot.
-
Build Semantic Layer Views for SingleStore Data in APOS Live Data Gateway
Use the CData Connector for SingleStore in APOS Live Data Gateway to build Semantic Layer Views for SingleStore.
-
Extract, Transform, and Load Nethunt Data in Informatica PowerCenter
Create a simple Workflow for Nethunt in Informatica PowerCenter.
-
Create Datasets from Adobe Target in Domo Workbench and Build Visualizations of Adobe Target Data in Domo
Use the CData Software ODBC Driver for Adobe Target to create datasets from Adobe Target in Domo Workbench and then build visualizations in the Domo service.
-
Build AI Agents with SAP Concur Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live SAP Concur through CData Connect AI.
-
Build Google Translate-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Google Translate.
-
Integrating LangGraph with DB2 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on IBM DB2 within automated workflows.
-
How to Connect to Live MySQL 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 MySQL for you.
-
Build Microsoft Entra ID-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Microsoft Entra ID and build Microsoft Entra ID-connected web apps with Axios.
-
DataBind Controls to CouchDB Data in C++Builder
DataBind to Apache CouchDB in C++Builder with standard components and controls.
-
Object-Relational Mapping (ORM) with Anaplan Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Anaplan into a Java-based ORM framework, Hibernate.
-
Access XML Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access XML Files from your Oracle system.
-
Automated Continuous AlloyDB Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable AlloyDB replication to PostgreSQL.
-
Connect to Marketo Data from a Connection Pool in JBoss
Integrate Marketo into Java servlets: Use the Management Console in JBoss to install the Marketo JDBC Driver.
-
Create Acumatica-Connected Nintex Workflows
Use CData Connect AI to connect to Acumatica Data from Nintex Workflow Cloud and build custom workflows using live Acumatica ERP.
-
Build Pipelines with Live MYOB AccountRight Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to MYOB AccountRight from Google Cloud Data Fusion, enabling the integration of live MYOB AccountRight into the building and management of effective data pipelines.
-
Object-Relational Mapping (ORM) with MariaDB Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MariaDB into a Java-based ORM framework, Hibernate.
-
Create Reports with Email Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Email.
-
Excel Spreadsheet Automation on SparkPost Data with the QUERY Formula
Pull data from SparkPost, automate spreadsheets, and more with the QUERY formula.
-
Access Live PayPal Data in AWS Lambda
Connect to live PayPal in AWS Lambda using the CData JDBC Driver.
-
Connect to Nethunt Data in Aqua Data Studio
Access Nethunt from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Query Pushbullet Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Pushbullet from Node.js.
-
Analyze Power BI XMLA Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Power BI XMLA and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to API Data in Google Apps Script via Connect AI
Use CData Connect AI to access API in Google Apps Script.
-
Integrating LangGraph with Zoho Creator Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Zoho Creator within automated workflows.
-
Connect to Zoho CRM Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Zoho CRM.
-
DataBind Controls to Snapchat Ads Data in C++Builder
DataBind to Snapchat Ads in C++Builder with standard components and controls.
-
Build Voice Agents in ElevenLabs with access to Live Google Cloud Storage Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Google Cloud Storage.
-
Write a Simple Go Application to work with Datadog Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Datadog.
-
How to create an RPA flow for Auth0 Data in UiPath Studio
Use the Auth0 ODBC Driver to create workflows that access real-time Auth0 without any coding.
-
Visualize MailerLite Data in Sisense
Create an ElastiCube in Sisense app with access to MailerLite.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Oracle SCM within intelligent workflows.
-
Integrate Open WebUI with Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Acumatica ERP from within the chat interface.
-
DataBind Controls to Trello Data in C++Builder
DataBind to Trello in C++Builder with standard components and controls.
-
Write a Simple Go Application to work with Discourse Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Discourse.
-
Load Oracle HCM Cloud Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Oracle HCM Cloud to a database.
-
Google Contacts Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Google Contacts through CData Connect AI using different applications and tools.
-
Process & Analyze Oracle Service Cloud Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Oracle Service Cloud Data.
-
Connect to Salesforce Data 360 Data in Ruby
Connect to Salesforce Data 360 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create ShipEngine Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ShipEngine from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build Automated Facebook Ads-Connected Workflows in Zapier
Use CData Connect AI to connect to live Facebook Ads and build automated workflows in Zapier.
-
Create SAP HANA-Connected Nintex Workflows
Use CData Connect AI to connect to SAP HANA Data from Nintex Workflow Cloud and build custom workflows using live SAP HANA.
-
Access Live GraphQL Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live GraphQL from your Google Sheets.
-
Use ChatGPT to Talk to Your Bullhorn CRM 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 Bullhorn CRM for you.
-
Integrate Slack Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Slack from Informatica Cloud.
-
Connect to MongoDB Data in Jaspersoft Studio
Execute SQL to remote MongoDB in Jaspersoft Studio.
-
Connect to Monday.com from Asprova with CData Software ODBC Driver for Monday.com
This article shows how to connect faster to Monday.com data from Asprova.
-
Integrating Kiro CLI with JSON Services 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.