CData Software - Knowledge Base
Recent Articles
-
Work with LDAP Objects in FoxPro
Load LDAP into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to work with Recurly Data in Apache Spark using SQL
Access and process Recurly Data in Apache Spark using the CData Software JDBC Driver.
-
Create Informatica Mappings From/To an ODBC Data Source for Dynamics 365
Create an ODBC connection to Dynamics 365 in Informatica and browse and transfer Microsoft Dynamics 365.
-
Publish Reports with Vault CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Veeva Vault & Vault CRM.
-
Automated Continuous Jodoo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Jodoo replication to Apache Kafka.
-
Integrate Real-Time Access to Microsoft Planner in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Planner in real time.
-
Integrate Open WebUI with Live Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Vertica from within the chat interface.
-
Connect to Oracle HCM Cloud Data in ACL Analytics
Connect to Oracle HCM Cloud via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle HCM Cloud.
-
Model, Search, and Visualize Live Stripe Data in ThoughtSpot
Use CData Connect AI to connect to live Stripe for modeling, searching, and visualizing.
-
Migrating data from Jumpseller to Google BigQuery using CData SSIS Components.
Easily push Jumpseller to Google BigQuery using the CData SSIS Tasks for Jumpseller and Google BigQuery.
-
How to Design Google Directory Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Google Directory from mobile and tablet Power Apps.
-
How to connect to ChargeOver Data from IntelliJ
Integrate connectivity to ChargeOver with wizards in IntelliJ.
-
DataBind Charts to Wistia Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Wistia 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.
-
Automated Continuous Oracle Eloqua Reporting Replication to Snowflake
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Snowflake.
-
Access Vercel Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Vercel from your Oracle system.
-
Integrate with Amazon Marketplace Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Amazon Marketplace in SnapLogic.
-
Automated Continuous Oracle Sales Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle Sales replication to delimited files (CSV/TSV).
-
Integrating LangChain with Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Salesforce Marketing Cloud within automated workflows.
-
Connect to Pipeliner CRM from a Connection Pool in WebLogic
Use the CData JDBC Driver for Pipeliner CRM to connect to Pipeliner CRM from Web applications running on WebLogic.
-
Getting Started with the CData Tableau Connector for Workday
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Workday.
-
Integrating Codex CLI with Optimizely 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.
-
Publish Reports with SendPulse Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SendPulse.
-
Viewing Excel Data in RAD Studio Data Explorer
How to view Microsoft Excel in RAD Studio Data Explorer using the CData ODBC Driver for Excel.
-
Integrating Dataiku with SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAS Data Sets.
-
ETL DocuSign in Oracle Data Integrator
This article shows how to transfer DocuSign into a data warehouse using Oracle Data Integrator.
-
Access Adobe Experience Manager 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 Adobe Experience Manager.
-
Connect to Phoenix Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache Phoenix from Filemaker Pro on Mac.
-
Create Reports from HubSpot Data in Looker Studio
Use CData Connect AI to gain access to live HubSpot and create custom reports in Looker Studio.
-
Access Google Spanner 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 Google Spanner.
-
Create SAP Business One-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to SAP Business One Data from Klipfolio and build custom visualizations using live SAP Business One.
-
Access Live Drift Data in AWS Lambda
Connect to live Drift in AWS Lambda using the CData JDBC Driver.
-
Prepare, Blend, and Analyze Email Data in Alteryx Designer (Connect AI)
Build workflows to access live Email for self-service data analytics.
-
Connect to Zoom Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoom in the Denodo Virtual DataPort Administrator.
-
Connect Gorgias to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Gorgias using the CData Python MCP Server.
-
Load Spotify Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Spotify to a database.
-
Integrating OpenCode Terminal with Quickbase 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.
-
Configure the CData JDBC Driver for ServiceDesk Plus in a Connection Pool in Tomcat
Connect to ServiceDesk Plus from a connection pool in Tomcat.
-
Connect to ZeroBounce in SpagoBI
Create reports featuring live ZeroBounce in SpagoBI Studio. Host ZeroBounce reports on SpagoBI Server.
-
How to Easily Query EnterpriseDB Data in OpenOffice Base
Connect to EnterpriseDB data in OpenOffice Base using the CData ODBC Driver for EnterpriseDB and generate reports with live data insights.
-
How to connect to Paymo Data from Spring Boot
Connect to Paymo in a Spring Boot Application using the CData API Driver for JDBC
-
Build Sage 200-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Sage 200 to explore live Sage 200 Data in Claude Code to assist with building Sage 200-powered applications.
-
Load Google Directory Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Directory to a database.
-
Build Oracle Sales Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Sales and build visualizations in Tableau Cloud.
-
How to Visualize AlloyDB Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Google AlloyDB in Python.
-
DataBind Charts to HubDB Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HubDB 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.
-
How to Connect to Live Facebook Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Facebook securely in real time.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for WooCommerce
Provide connectivity to WooCommerce through an SAP BusinessObjects universe.
-
Access Exa Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Exa from HeidiSQL.
-
Integrate Gumroad with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Gumroad with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Gumroad.
-
Connect to and Query Jira Assets Data in QlikView over ODBC
Create data visualizations with Jira Assets in QlikView.
-
Replicate Shippo Data from PowerShell
Write a quick PowerShell script to query Shippo. Use connectivity to the live data to replicate Shippo to SQL Server.
-
Automated Continuous Oracle Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Oracle replication to Google BigQuery.
-
Access Live Elorus Data in AWS Lambda
Connect to live Elorus in AWS Lambda using the CData JDBC Driver.
-
Connect to Quickbase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Quickbase to connect to Quickbase from Web applications running on WebLogic.
-
How to work with Tickspot Data in Apache Spark using SQL
Access and process Tickspot Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating LangChain with MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on MailChimp within automated workflows.
-
Build a Simple VCL Application for Azure Data Lake Storage Data
How to build a simple VCL Application to view Azure Data Lake Storage in RAD Studio using the CData ODBC Driver for Azure Data Lake Storage.
-
View Reports on Real-Time Quaderno Data in Power BI Report Server
Use the CData ODBC Driver for Quaderno to visualize Quaderno in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Calendly Data from a Connection Pool in Jetty
The Calendly JDBC Driver supports connection pooling: This article shows how to connect faster to Calendly from Web apps in Jetty.
-
Back Up Yelp to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Yelp data.
-
Access Live Oracle SCM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Oracle SCM into the statistical analysis tools available in SAS JMP. This article shows how to use Oracle SCM in the Graph Builder and Query Builder.
-
Integrate Live SendGrid Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to SendGrid and integrate live SendGrid into apps built in Microsoft Power Apps.
-
How to Connect to & Open Clari Data in Microsoft Excel
This article uses the CData ODBC driver for Clari to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Cloudant Data to Multiple Databases
Replicate IBM Cloudant to disparate databases with a point-and-click configuration.
-
Connect to Pinterest Data in Claris FileMaker Pro
Use the CData ODBC Driver for Pinterest in FileMaker Pro to connect to Pinterest and work with Pinterest in your FileMaker applications.
-
Access Live Azure Table Data in AWS Lambda
Connect to live Azure Table Storage in AWS Lambda using the CData JDBC Driver.
-
Extend Google Sheets with SAP Netweaver Gateway Data
Make calls to SAP Netweaver Gateway from Google Apps Script via the API Server.
-
Access Live OneNote Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Microsoft OneNote from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Create SSAS Tabular Models from Perigon Data
How to build a SQL Server Analysis Service Tabular Model from Perigon using CData drivers.
-
Connect to Dynamics 365 Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics 365 and the Script function in FileMaker Pro to connect to Dynamics 365 and work with Microsoft Dynamics 365 in your FileMaker application.
-
Integrate Live Sage Intacct Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Sage Intacct from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Sage Intacct.
-
Connect to Microsoft Exchange Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Exchange as a data source.
-
How to Create Power BI Visual Reports with Real-Time Stack Exchange Data
Use CData Power BI Connectors to visualize Stack Exchange in Power BI.
-
Automated Continuous Sage Cloud Accounting Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Amazon S3.
-
Connect to VWO Data in Jaspersoft Studio
Execute SQL to remote VWO in Jaspersoft Studio.
-
Automate Google Sheets Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Google Sheets from PowerShell? This article demonstrates how to utilize the Google Sheets Cmdlets for tasks like connecting to Google Sheets, automating operations, downloading data, and more.
-
Getting Started with the CData Excel Add-In for FHIR
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for FHIR.
-
Connect to Dynamics CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Dynamics CRM from PowerBuilder using the Dynamics CRM JDBC Driver.
-
DataBind Controls to PolarTeamPro Data in Delphi
DataBind to PolarTeamPro in Delphi with standard data access components and controls.
-
Import Real-Time CloudConvert Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use CloudConvert in ColdFusion.
-
Integrate Live BigCommerce Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to BigCommerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live BigCommerce.
-
How to Easily Query Acumatica Data in OpenOffice Base
Connect to Acumatica data in OpenOffice Base using the CData ODBC Driver for Acumatica and generate reports with live data insights.
-
Connect to Kintone Data from Crystal Reports
Use CData Connect AI to connect to and report on live Kintone from Crystal Reports.
-
How to Query Live SAP HANA Data in Perplexity MacOS Desktop
Connect to and query live SAP HANA Data in Perplexity Desktop using CData MCP Server.
-
Connect to Superchat Data in Aqua Data Studio
Access Superchat from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create an RPA flow for HBase Data in UiPath Studio
Use the HBase ODBC Driver to create workflows that access real-time Apache HBase without any coding.
-
Automated Continuous Bannerbear Replication to Databricks
Use CData Sync for automated, continuous, customizable Bannerbear replication to Databricks.
-
Build a PostgreSQL Interface for WooCommerce Data using the CData JDBC Driver
Use the Remoting features of the WooCommerce JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro CLI with Typeform 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 Zuora Data in Redash
Use CData Connect AI to connect to live Zuora in Redash for querying, visualizing, and sharing.
-
Connect to Klaviyo Data in RapidMiner
Integrate Klaviyo with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SurveyMonkey Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to OneLake in Microsoft Fabric.
-
Use Microsoft Copilot Studio to talk to your Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for FHIR
Provide connectivity to FHIR through an SAP BusinessObjects universe.
-
Visualize SQL Analysis Services Data in TIBCO Spotfire through ADO.NET
Integrate SQL Analysis Services into dashboards in TIBCO Spotfire.
-
Integrating LangChain with Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft Dynamics CRM within automated workflows.
-
How to Query Live SAP Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live SAP ERP/NetWeaver data in natural language using Python.
-
Getting Started with the CData SSIS Components for Bannerbear
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Bannerbear.
-
How to Work with SurveyMonkey Data in ETL Validator JDBC
Connect to SurveyMonkey from ETL Validator jobs using the CData Software JDBC Driver.
-
Visualize Salesforce Pardot Data in TIBCO Spotfire through OData
Integrate Salesforce Pardot into dashboards in TIBCO Spotfire.