CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Google Search Replication to SQLite
Use CData Sync for automated, continuous, customizable Google Search replication to SQLite.
-
Configure the CData JDBC Driver for Phoenix in a Connection Pool in Tomcat
Connect to Apache Phoenix from a connection pool in Tomcat.
-
Create Informatica Mappings From/To an ODBC Data Source for Microsoft OneDrive
Create an ODBC connection to Microsoft OneDrive in Informatica and browse and transfer Microsoft OneDrive.
-
Natively Connect to Sybase Data in PHP
The CData ODBC driver for Sybase enables you to create PHP applications with connectivity to Sybase. Leverage the native support for ODBC in PHP.
-
Creating FTP-Connected Applications in Unqork
You can use CData Connect AI to feed FTP Servers to Unqork and build custom business apps.
-
Integrate Humanity Data in Pentaho Data Integration
Build ETL pipelines based on Humanity in the Pentaho Data Integration tool.
-
DataBind Controls to PayPal Data in Delphi
DataBind to PayPal in Delphi with standard data access components and controls.
-
How to connect SharePoint with Oracle Financials Cloud Data through external lists
Provide Oracle Financials Cloud to SharePoint users as an external list.
-
How to Build an ETL App for Google Forms Data in Python with CData
Create ETL applications and real-time data pipelines for Google Forms in Python with petl.
-
Build Apps with Live Paddle Data Using the Low-Code Development Platform of Mendix
Connect Paddle with Mendix to build apps using the CData API Driver for JDBC.
-
Import Real-Time Jumpseller Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Jumpseller in ColdFusion.
-
Integrate Live SAP Ariba Procurement Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Viewing ServiceDesk Plus Data in RAD Studio Data Explorer
How to view ServiceDesk Plus in RAD Studio Data Explorer using the CData ODBC Driver for ServiceDesk Plus.
-
Connect SpaceX to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SpaceX with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Salesforce CRM Analytics Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce CRM Analytics and the Script function in FileMaker Pro to connect to Salesforce CRM Analytics and work with Salesforce CRM Analytics in your FileMaker application.
-
Connecting Mastra with Shopify Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Shopify, no replication required.
-
Visualize ZohoSubscriptions Data in Tableau
The CData ODBC driver for ZohoSubscriptions enables you integrate ZohoSubscriptions into Tableau dashboards.
-
Create Dynamic Airtable Grids Using the Infragistics XamDataGrid
Learn how you can connect Airtable to Infragistics XamDataGrid to build dynamic grids.
-
How to Query HubSpot Data in MySQL Workbench
Execute MySQL queries against live HubSpot from MySQL Workbench.
-
Connect to ServiceNow Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ServiceNow in Airbyte.
-
Query Live Smartsheet Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Smartsheet directly from the development environment.
-
Getting Started with the CData ADO.NET Provider for Vercel
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Snapchat Ads Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Snapchat Ads to connect to Snapchat Ads and execute queries in PowerBuilder.
-
Connect to SparkPost Data in RazorSQL
Connect to SparkPost from wizards and query SparkPost from the GUI in the RazorSQL database management tool.
-
Object-Relational Mapping (ORM) with Amazon S3 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 Amazon S3 into a Java-based ORM framework, Hibernate.
-
Back Up MariaDB to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for MariaDB. In this article, we will employ an SSIS workflow to populate a database with MariaDB data.
-
Automate Kintone Data Replication to Couchbase
Use CData Sync to Customize and automate Kintone replication to Couchbase.
-
Build Instantly-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Instantly Data in Claude Code to assist with building Instantly-powered applications.
-
Extend Google Sheets with Nuclia Data
Make calls to Nuclia from Google Apps Script via the API Server.
-
Edit and Search External MYOB AccountRight Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of MYOB AccountRight to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create MYOB AccountRight Data objects that you can access from apps and the dashboard.
-
Automated Continuous OData Replication to Databricks
Use CData Sync for automated, continuous, customizable OData replication to Databricks.
-
Connecting Agentforce with DB2 Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your IBM DB2 for you.
-
Create Apps from FTP Data in Qlik Sense Cloud
Use CData Connect AI to connect to FTP Data and build apps from live FTP Servers in Qlik Sense Cloud.
-
Use the CData SSIS Components to Insert New or Update Existing SendGrid Records from SQL Server
Easily push SQL Server data to SendGrid using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SendGrid or update existing records with data from a SQL Server database.
-
Build Semantic Layer Views for Deel Data in APOS Live Data Gateway
Use the CData Connector for Deel in APOS Live Data Gateway to build Semantic Layer Views for Deel.
-
Replicate Factorial Data from PowerShell
Write a quick PowerShell script to query Factorial. Use connectivity to the live data to replicate Factorial to SQL Server.
-
Import Apollo Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Apollo. In this article, you will use the OData format to import Apollo into Microsoft Power Query.
-
Build Automated Workflows with Live OneNote Data in Workato
Use CData Connect AI to connect to live Microsoft OneNote and build automated workflows in Workato.
-
Query Figshare Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Figshare from Node.js.
-
Access Live OData Services in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate OData into the statistical analysis tools available in SAS JMP. This article shows how to use OData in the Graph Builder and Query Builder.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed CapsuleCRM to Power BI dashboards. Simply drag and drop CapsuleCRM into data visuals on the Power BI canvas.
-
Publish Crystal Reports on Zoho Recruit Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Zoho Recruit.
-
Choosing the Best Method to Connect MailChimp to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MailChimp from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Dynamics NAV Data from a Connection Pool in JBoss
Integrate Microsoft Dynamics NAV into Java servlets: Use the Management Console in JBoss to install the Dynamics NAV JDBC Driver.
-
Add Pinecone Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Pinecone with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Placid in SAS for Real-Time Reporting and Analytics
Connect to real-time Placid in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Placid.
-
Automated Continuous Eventbrite Replication to SQL Server
Use CData Sync for automated, continuous, customizable Eventbrite replication to SQL Server.
-
Integrate Live Adobe Target Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Adobe Target to Blue Prism using the CData ODBC Driver for Adobe Target to create automated workflows for repetitive business tasks.
-
DataBind Everhour Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Everhour to a chart.
-
Use the CData Software ODBC Driver for Webflow in MicroStrategy Desktop
Connect to Webflow in MicroStrategy Desktop using the CData Software ODBC Driver for Webflow.
-
Build a Simple VCL Application for ADP Data
How to build a simple VCL Application to view ADP in RAD Studio using the CData ODBC Driver for ADP.
-
How to Visualize Printify Data in Python with pandas
Use pandas and other modules to analyze and visualize live Printify in Python.
-
Analyze Okta Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Okta and visualize live Okta in Infragistics Reveal.
-
Build Visualizations of SparkPost Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SparkPost in Birst.
-
Build Agents in Relevance AI with Access to Live LinkedIn Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on LinkedIn Ads within intelligent agent workflows.
-
Replicate Zoom Data in Heroku for Use in Salesforce Connect
Replicate Zoom to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Manus AI to Talk to Your BambooHR 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 BambooHR.
-
How to Design SendGrid Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SendGrid from mobile and tablet Power Apps.
-
Integrate with Aha! Data in JReport Designer
Create charts and reports based on Aha! in JReport Designer.
-
How to connect Amazon QuickSight to Gmail Data
Create a connection to Gmail in CData Connect AI and insert Gmail into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Multiple Microsoft Ads Accounts
Replicate multiple Microsoft Ads accounts to one or many databases.
-
Deploy the ADO.NET Provider for Zoho Books on an SSRS Report Server
Connect to Zoho Books from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Easily Integrate Todoist Data in Lazarus Pascal IDE
Learn how to easily integrate live Todoist in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for MySQL Data using JDBI
A brief overview of creating a SQL Object API for MySQL in JDBI.
-
Use the CData Software ODBC Driver for SAP Netweaver Gateway in MicroStrategy Desktop
Connect to SAP Netweaver Gateway in MicroStrategy Desktop using the CData Software ODBC Driver for SAP Netweaver Gateway.
-
How to Query Adobe Analytics Data in MySQL Workbench
Execute MySQL queries against live Adobe Analytics from MySQL Workbench.
-
Migrating data from CircleCI to Snowflake using CData SSIS Components.
Easily push CircleCI to Snowflake using the CData SSIS Tasks for CircleCI and Snowflake.
-
Integrate Oracle Financials Cloud Data in the Pentaho Report Designer
Publish reports based on Oracle Financials Cloud in the Pentaho BI tool.
-
Integrating LangChain with FreshBooks Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on FreshBooks within automated workflows.
-
Build Automated BigCommerce-Connected Workflows in Zapier
Use CData Connect AI to connect to live BigCommerce and build automated workflows in Zapier.
-
Use the CData Software ODBC Driver for Rebilly in MicroStrategy Web
Connect to Rebilly in MicroStrategy Web using the CData Software ODBC Driver for Rebilly.
-
Connect to Landbot Data from a Connection Pool in Jetty
The Landbot JDBC Driver supports connection pooling: This article shows how to connect faster to Landbot from Web apps in Jetty.
-
Manage EmailOctopus Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for EmailOctopus.
-
Connect Smartsheet to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Smartsheet with IBM WebSphere for seamless data integration and connectivity.
-
Model, Search, and Visualize Live Oracle Eloqua Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Eloqua for modeling, searching, and visualizing.
-
Consume Microsoft Dataverse OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Microsoft Dataverse feeds that reflect any changes in SAP Lumira.
-
Connect to Freshservice Data in Google Apps Script via Connect AI
Use CData Connect AI to access Freshservice in Google Apps Script.
-
Access ZendeskSell Data from MySQL in PHP
Connect to ZendeskSell through the standard MySQL libraries in PHP.
-
Query, Visualize, and Share live Oracle SCM Data in Redash
Use CData Connect AI to connect to live Oracle SCM in Redash for querying, visualizing, and sharing.
-
DataBind Charts to Google Analytics Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Analytics 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.
-
Create Informatica Mappings From/To a JDBC Data Source for Guru
Create Guru data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate Sybase IQ Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Sybase IQ from Informatica Cloud.
-
Edit and Search LeadDesk External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of LeadDesk to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create LeadDesk objects that you can access from apps and the dashboard.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ShipEngine
Provide connectivity to ShipEngine through an SAP BusinessObjects universe.
-
Bidirectional Access to Exact Online Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Exact Online in Filemaker Pro for Mac or Windows.
-
DataBind Microsoft Exchange Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Exchange with the DevExpress Windows Forms and Web controls to provide Microsoft Exchange to a chart.
-
Process & Analyze Bitly Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Bitly Data.
-
Integrating Shippo Data in Talend Cloud Data Management Platform
Connect Shippo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Biml to Build SSIS Tasks to Replicate Foursquare Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Foursquare to SQL Server.
-
Model Stripe Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Stripe, enabling the direct import of real-time Stripe.
-
Replicate LDAP Objects to Multiple Databases via the CData Sync CLI
Replicate LDAP to disparate databases with a single configuration.
-
How to work with Oracle Service Cloud Data in Apache Spark using SQL
Access and process Oracle Service Cloud Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Moosend Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Moosend data source in TIBCO Data Virtualization Studio and gain access to live Moosend from your TDV Server.
-
Connect to Blackbaud FE NXT Data from PowerBuilder via JDBC
This article demonstrates how to access Blackbaud FE NXT from PowerBuilder using the Blackbaud FE NXT JDBC Driver.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Bright Data to Power BI dashboards. Simply drag and drop Bright Data into data visuals on the Power BI canvas.
-
Integrate Drift Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Drift from Informatica Cloud.
-
Automated Continuous ZohoInvoice Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to Apache Cassandra.
-
Automated Continuous Zoho CRM Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Zoho CRM replication to Azure SQL Database.
-
Work with Live Oracle Data in Power Query
Use CData Connect AI to connect to Oracle Database and work with live Oracle Database in Microsoft Power Query.
-
How to Connect to Live DocuSign Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your DocuSign through natural language.