CData Software - Knowledge Base
Recent Articles
-
Build Semantic Layer Views for DB2 Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for IBM DB2.
-
Integrate CSV Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live CSV/TSV Files from Informatica Cloud.
-
Automate Mailjet Data Replication to Azure Data Lake
Use CData Sync to customize and automate Mailjet replication to Azure Data Lake.
-
Automated Continuous SuiteCRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable SuiteCRM replication to PostgreSQL.
-
Analyze MariaDB Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of MariaDB and visualize live MariaDB in Infragistics Reveal.
-
Choosing the Best Method to Connect ZohoSubscriptions to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ZohoSubscriptions from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Copper Data Replication to Teradata
Use CData Sync to Customize and automate Copper replication to Teradata.
-
Query SQL Analysis Services Data as a SQL Server Database in Node.js
Execute SQL Server queries against SQL Analysis Services from Node.js.
-
Automate Oracle HCM Cloud Data Replication to Couchbase
Use CData Sync to Customize and automate Oracle HCM Cloud replication to Couchbase.
-
Visualize Raisers Edge NXT Data in TIBCO Spotfire through OData
Integrate Raisers Edge NXT into dashboards in TIBCO Spotfire.
-
Load Cohere Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Cohere to a database.
-
ETL MariaDB in Oracle Data Integrator
This article shows how to transfer MariaDB into a data warehouse using Oracle Data Integrator.
-
How to Connect DBeaver to PolarTeamPro via a JDBC Driver
Manage PolarTeamPro with visual tools in DBeaver like the query browser.
-
Build Semantic Layer Views for Sage 300 Data in APOS Live Data Gateway
Use the CData Connector for Sage 300 in APOS Live Data Gateway to build Semantic Layer Views for Sage 300.
-
Automated Continuous Recurly Replication to Vertica
Use CData Sync for automated, continuous, customizable Recurly replication to Vertica.
-
How to Connect to Live Pipedrive Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Pipedrive for you.
-
How to Import Data from YouTube Analytics into Google Sheets
Import YouTube Analytics into a Google spreadsheet that is automatically refreshed.
-
Automated Continuous Supabase Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Supabase replication to AlloyDB.
-
How to connect PolyBase to Oracle HCM Cloud
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Oracle HCM Cloud.
-
How to create Factorial federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Factorial in MySQL .
-
Query Tickspot Data in DataGrip
Create a Data Source for Tickspot in DataGrip and use SQL to query live Tickspot.
-
Build EnterpriseDB-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for EnterpriseDB Data and create custom apps in Mendix.
-
Automated Continuous Retently Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Retently replication to PostgreSQL.
-
How to Easily Query Mode Data in OpenOffice Base
Connect to Mode data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
How to connect to Azure Data Lake Storage Data with Squirrel SQL client
Connect to Azure Data Lake Storage and execute queries in the Squirrel SQL Client.
-
Use Dash to Build to Web Apps on Azure Data Lake Storage Data
Create Python applications that use pandas and Dash to build Azure Data Lake Storage-connected web apps.
-
Using the CData Software ODBC Driver for Cvent in PyCharm
Connect to Cvent as an ODBC data source in PyCharm using the CData Software ODBC Driver for Cvent.
-
Build a PostgreSQL Interface for Pinterest Data using the CData JDBC Driver
Use the Remoting features of the Pinterest JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Billsby Data in HULFT Integrate
Connect to Billsby as a JDBC data source in HULFT Integrate
-
Extend Google Sheets with Microsoft Planner Data
Make calls to Microsoft Planner from Google Apps Script via the API Server.
-
Work with Delighted Data in FoxPro
Load Delighted into a FoxPro database. This article includes full code and a walk-through of the process.
-
Publish Reports with Typeform Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Typeform.
-
Connect to Google Cloud Storage from Asprova with CData Software ODBC Driver for Google Cloud Storage
This article shows how to connect faster to Google Cloud Storage data from Asprova.
-
Integrate with Oracle Eloqua Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Oracle Eloqua in SnapLogic.
-
Connect to MongoDB Data from PowerBuilder via ADO.NET
This article demonstrates how to access MongoDB from Appeon PowerBuilder using the CData ADO.NET Provider for MongoDB.
-
Integrate Live SAP Business Warehouse Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SAP Business Warehouse to Blue Prism using the CData ODBC Driver for SAP Business Warehouse to create automated workflows for repetitive business tasks.
-
How to Access Azure Synapse Data Using Entity Framework
This article shows how to access Azure Synapse using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build Zoho Books-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Zoho Books to explore live Zoho Books Data in Cursor to assist with building Zoho Books-powered applications.
-
Visualize Live Parquet Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Apache Parquet.
-
Extend Google Sheets with SAP Hybris C4C Data
Make calls to SAP Hybris C4C from Google Apps Script via the API Server.
-
Access Live Anaplan Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Anaplan data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrating Adobe Commerce Data in Talend Cloud Data Management Platform
Connect Adobe Commerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Adobe Commerce.
-
How to Use a Microsoft Access Database to Update TaxJar Data in Real Time
Update TaxJar data by creating a linked table in Microsoft Access with the CData TaxJar ODBC Driver.
-
Automated iContact Data Replication to Teradata
Use CData Sync to Customize and automate iContact replication to Teradata.
-
Connect to Clockify from a Connection Pool in WebLogic
Use the CData JDBC Driver for Clockify to connect to Clockify from Web applications running on WebLogic.
-
Import and Visualize CapsuleCRM Data in Power View
Create data visualizations based on CapsuleCRM in Excel.
-
Automated Reckon Accounts Hosted Data Replication to Teradata
Use CData Sync to Customize and automate Reckon Accounts Hosted replication to Teradata.
-
Automated Continuous Apify Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Apify replication to delimited files (CSV/TSV).
-
How to Import Data from Dropbox into Google Sheets
Import Dropbox into a Google spreadsheet that is automatically refreshed.
-
Building Dynamic Web Pages with Amazon S3 Data Using AngularJS
Create single-page applications with live connectivity to Amazon S3 using the CData API Server.
-
Connect to Quickbase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Quickbase and the Script function in FileMaker Pro to connect to Quickbase and work with Quickbase in your FileMaker application.
-
Integrate Cline with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Business One from within your IDE.
-
Automate HBase Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Apache HBase and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to Live Dropbox Data in MicroStrategy through CData Connect AI
Create a live connection to Dropbox Data in CData Connect AI and connect to your Dropbox from MicroStrategy.
-
Import Real-Time Zendesk Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zendesk in ColdFusion.
-
Enable the Sybase IQ JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Sybase IQ.
-
Connect to WooCommerce Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live WooCommerce.
-
How to Connect the Power BI Service to ConstantContact: Complete Guide
Connect to the CData Software Power BI Connector for ConstantContact from PowerBI.com to provide real-time ConstantContact across the organization.
-
Connect to Real-Time EmailOctopus Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use EmailOctopus in Power Apps.
-
Analyze ADP Data in Cognos Analytics
Use CData Connect AI to connect to ADP Data from Cognos Analytics and analyze live ADP.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAS xpt
Provide connectivity to SAS XPORT through an SAP BusinessObjects universe.
-
Build Visualizations of Clio Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Clio in Birst.
-
Automated Continuous Rebilly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Rebilly replication to Amazon S3.
-
Workday Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Workday through CData Connect AI using different applications and tools.
-
Access Live PayPal Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live PayPal from your Google Sheets.
-
Use Microsoft Copilot Studio to talk to your Oracle Sales 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 Oracle Sales for you.
-
Build Pipelines with Live OneNote Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to OneNote from Google Cloud Data Fusion, enabling the integration of live Microsoft OneNote into the building and management of effective data pipelines.
-
Integrate Goose with Live Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Google Contacts from within the local AI agent.
-
Analyze Webex Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Webex from Power Pivot. You will use the Table Import Wizard to load Webex. You can visually build the import query or use any SQL supported by the driver.
-
Connect to SAP Hybris C4C Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Hybris C4C in FileMaker Pro to connect to SAP Hybris C4C and work with SAP Hybris C4C in your FileMaker applications.
-
Connect to Adobe Target Data in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Target in FileMaker Pro to connect to Adobe Target and work with Adobe Target in your FileMaker applications.
-
Access Live Egnyte Data in AWS Lambda
Connect to live Egnyte in AWS Lambda using the CData JDBC Driver.
-
Connect to Google Campaign Manager 360 Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build SAP SuccessFactors LMS-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP SuccessFactors LMS Data and create custom apps in Mendix.
-
Integrating Kiro CLI with PostgreSQL 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.
-
Process & Analyze Google Directory Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Directory Data.
-
Connect to Oracle Eloqua Data in Aqua Data Studio
Access Oracle Eloqua from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Import Real-Time Instantly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Instantly in ColdFusion.
-
Integrating Gumloop with JSON Services via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on JSON within automated workflows.
-
Rapidly Develop OData-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 OData.
-
Create SAP Concur Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP Concur from PowerBI.com to create Power BI Dataflows with real-time data.
-
Add Databricks Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Databricks with the Informatica Enterprise Data Catalog to classify and organize data.
-
Configure the CData JDBC Driver for LeadDesk in a Connection Pool in Tomcat
Connect to LeadDesk from a connection pool in Tomcat.
-
Connect to Twilio Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Twilio from Filemaker Pro on Mac.
-
Automated Continuous REST Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable REST replication to Google Cloud SQL.
-
How to Access Pingdom Data Using Entity Framework
This article shows how to access Pingdom using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Flowlu Data from MySQL in PHP
Connect to Flowlu through the standard MySQL libraries in PHP.
-
Query Active Directory Data as a SQL Server Database in Node.js
Execute SQL Server queries against Active Directory from Node.js.
-
Perform Batch Operations with Couchbase Data in Apache NiFi
Connect to Couchbase and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Claude Code CLI with ZohoExpense 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.
-
Replicate Quickbase Data to Multiple Databases via the CData Sync CLI
Replicate Quickbase to disparate databases with a single configuration.
-
Automated Continuous Harvest Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Harvest replication to IBM DB2.
-
How to connect SharePoint with Airtable Data through external lists
Provide Airtable to SharePoint users as an external list.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ServiceNow
Provide connectivity to ServiceNow through an SAP BusinessObjects universe.
-
Connect to HubSpot Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Create Informatica Mappings From/To an ODBC Data Source for Google Ad Manager
Create an ODBC connection to Google Ad Manager in Informatica and browse and transfer Google Ad Manager.
-
Build Automated Vertica-Connected Workflows in Zapier
Use CData Connect AI to connect to live Vertica and build automated workflows in Zapier.
-
Build AI/ML Models with Live Basecamp Data using Dataiku
Connect Basecamp Data with Dataiku using the CData JDBC Driver for Basecamp.
-
Connect and Visualize Live MailChimp Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live MailChimp into the Databricks platform and create visualization dashboards with real-time MailChimp.
-
Automate Tasks in Power Automate Using the CData API Server
Automate HBase actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.