CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData ADO.NET Provider for Oracle Sales
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Oracle Sales.
-
Build Amazon S3 Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Amazon S3 and build visualizations in Tableau Cloud.
-
Replicate Multiple eBay Accounts
Replicate multiple eBay accounts to one or many databases.
-
Replicate Multiple HDFS Accounts
Replicate multiple HDFS accounts to one or many databases.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Twilio to Power BI dashboards. Simply drag and drop Twilio into data visuals on the Power BI canvas.
-
How to Easily Query Workable Data in OpenOffice Base
Connect to Workable data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Build MVC Applications with Connectivity to Microsoft OneDrive Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft OneDrive from an ASP.NET MVC application.
-
ETL Shopify in Oracle Data Integrator
This article shows how to transfer Shopify into a data warehouse using Oracle Data Integrator.
-
Connect to Live Email Data in MicroStrategy through CData Connect AI
Create a live connection to Email Data in CData Connect AI and connect to your Email from MicroStrategy.
-
How to connect to ZohoSubscriptions Data from Spring Boot
Connect to ZohoSubscriptions in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Dynamics CRM Replication to Vertica
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Vertica.
-
Import Real-Time MongoDB Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use MongoDB in ColdFusion.
-
DataBind Controls to Google Sheets Data in C++Builder
DataBind to Google Sheets in C++Builder with standard components and controls.
-
Build Couchbase-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Couchbase to explore live Couchbase Data in Gemini Code Assist to assist with building Couchbase-powered applications.
-
Automate JSON Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live JSON and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connecting Agentforce with Google Cloud Storage 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 Google Cloud Storage for you.
-
Connect Box to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Box with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Azure Analysis Services in MicroStrategy Desktop
Connect to Azure Analysis Services in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Analysis Services.
-
Connect to Greenhouse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate with live NetSuite Data in Jitterbit
Use CData Connect AI to connect to and integrate live NetSuite CRM & ERP in Jitterbit.
-
Automated Continuous Coinbase Replication to MongoDB
Use CData Sync for automated, continuous, customizable Coinbase replication to MongoDB.
-
Integrating Xero Data in Talend Cloud Data Management Platform
Connect Xero Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Xero.
-
Integrating Kiro CLI with Vault CRM 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.
-
Operational Reporting on Dynamics 365 Business Central Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Dynamics 365 Business Central.
-
Build HBase-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for HBase to explore live HBase Data in Claude Code to assist with building HBase-powered applications.
-
Import Google Sheets Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Sheets Data and provide access to live Google Sheets for custom reports in the Power BI Service.
-
Create SSAS Tabular Models from Azure Table Data
How to build a SQL Server Analysis Service Tabular Model from Azure Table Storage using CData drivers.
-
How to connect to Reply.io Data from Spring Boot
Connect to Reply.io in a Spring Boot Application using the CData API Driver for JDBC
-
Integrating Antigravity CLI with Jodoo via CData CLI
Connect Jodoo to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate SAP Netweaver Gateway Data in Pentaho Data Integration
Build ETL pipelines based on SAP Netweaver Gateway in the Pentaho Data Integration tool.
-
Connect to LinkedIn Ads Data as an External Source in Dremio
Use the CData JDBC Driver to connect to LinkedIn Ads as an External Source in Dremio.
-
Visualize Live ActiveCampaign Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live ActiveCampaign using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access Live Factorial Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Factorial enables you to integrate Factorial into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Highrise Replication to MySQL
Use CData Sync for automated, continuous, customizable Highrise replication to MySQL.
-
Query CampaignMonitor Data as a MySQL Database in Node.js
Execute MySQL queries against CampaignMonitor from Node.js.
-
Use the CData SSIS Components to Insert New or Update Existing SFTP Records from SQL Server
Easily push SQL Server data to SFTP using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into SFTP or update existing records with data from a SQL Server database.
-
How to Build an ETL App for Dynamics CRM Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dynamics CRM in Python with petl.
-
Build Microsoft Entra ID-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Microsoft Entra ID Data and create custom apps in Bubble.
-
How to Connect to Live FHIR 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 FHIR for you.
-
Moving Data from SAP Hybris C4C to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Hybris C4C data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect Miro to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Miro with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SurveyMonkey Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for SurveyMonkey and the Script function in FileMaker Pro to connect to SurveyMonkey and work with SurveyMonkey in your FileMaker application.
-
Prepare, Blend, and Analyze Quickbase Data in Alteryx Designer (ODBC)
Build workflows to access live Quickbase for self-service data analytics.
-
Build AI/ML Models with Live FreeAgent Data using Dataiku
Connect FreeAgent Data with Dataiku using the CData API Driver for JDBC.
-
Import Real-Time SuiteCRM Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use SuiteCRM in ColdFusion.
-
Automated Continuous Instagram Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Instagram replication to IBM DB2.
-
Create Dynamic Adobe Target Grids Using the Infragistics XamDataGrid
Learn how you can connect Adobe Target to Infragistics XamDataGrid to build dynamic grids.
-
Query Microsoft OneDrive Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft OneDrive and perform CRUD operations on Microsoft OneDrive from Node.js.
-
Access Live Clio Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Clio into the statistical analysis tools available in SAS JMP. This article shows how to use Clio in the Graph Builder and Query Builder.
-
Access Keap Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Keap from HeidiSQL.
-
Integrate Tickspot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Tickspot with External Services.
-
How to Connect to & Open Microsoft Dataverse Data in Microsoft Excel
This article uses the CData ODBC driver for Microsoft Dataverse to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to xBase in SpagoBI
Create reports featuring live xBase in SpagoBI Studio. Host xBase reports on SpagoBI Server.
-
Integrating GitHub Copilot CLI with SFTP 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.
-
Create Informatica Mappings From/To an ODBC Data Source for Access
Create an ODBC connection to Access in Informatica and browse and transfer Microsoft Access.
-
Visualize ZeroBounce Data in TIBCO Spotfire through ADO.NET
Integrate ZeroBounce into dashboards in TIBCO Spotfire.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live SAP SuccessFactors using the Model Context Protocol.
-
Integrate Goose with Live Blackbaud FE NXT Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Blackbaud FE NXT from within the local AI agent.
-
Marketo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Marketo facts in real time.
-
Process & Analyze Postmark Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Postmark Data.
-
Build Dashboards with RabbitMQ Data in Dundas BI
Create dynamic dashboards and perform analytics based on RabbitMQ in Dundas BI.
-
Connect to XML Data in DBArtisan
Use wizards in DBArtisan to configure XML Files as a data source.
-
Connect to Oracle Financials Cloud Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Financials Cloud in Google Apps Script.
-
How to create an RPA flow for Sentry Data in UiPath Studio
Use the Sentry ODBC Driver to create workflows that access real-time Sentry without any coding.
-
Automated Continuous Bugsnag Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bugsnag replication to OneLake in Microsoft Fabric.
-
Access Live Coda Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Coda in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Edit and Search External SQL Server Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft SQL Server to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SQL Server Data objects that you can access from apps and the dashboard.
-
DataBind GetResponse Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide GetResponse to a chart.
-
Connect Coinbase to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Coinbase with IBM WebSphere for seamless data integration and connectivity.
-
Connect Stripe to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Stripe with IBM WebSphere for seamless data integration and connectivity.
-
Integrate LibreChat with Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live SAP Business ByDesign from within the chat interface.
-
Access Zoho Recruit Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Recruit from HeidiSQL.
-
Integrate Theia IDE with Live Reckon Accounts Hosted Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Query Live Google Ads Data in Perplexity MacOS Desktop
Connect to and query live Google Ads Data in Perplexity Desktop using CData MCP Server.
-
Automated Continuous Pipeline CRM Replication to MySQL
Use CData Sync for automated, continuous, customizable Pipeline CRM replication to MySQL.
-
How to import Google Campaign Manager 360 Data into Apache Solr
Use the CData Software JDBC Driver for Google Campaign Manager 360 in Data Import Handler and create an automated import of Google Campaign Manager 360 to Apache Solr Enterprise Search platform.
-
Automated Continuous Zoho Creator Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Zoho Creator replication to Amazon S3.
-
Connect to AdRoll from a Connection Pool in WebLogic
Use the CData JDBC Driver for AdRoll to connect to AdRoll from Web applications running on WebLogic.
-
How to Connect to Live Trello Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Trello securely in real time.
-
Natively Connect to Zoho Projects Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Zoho Projects. Leverage the native support for ODBC in PHP.
-
Edit and Search Amazon Marketplace External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Amazon Marketplace to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Amazon Marketplace objects that you can access from apps and the dashboard.
-
Connect to Real-Time ElevenLabs Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ElevenLabs in Power Apps.
-
Import IBM Informix Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to IBM Informix Data and provide access to live IBM Informix for custom reports in the Power BI Service.
-
Back Up Google Sheets to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Sheets. In this article, we will employ an SSIS workflow to populate a database with Google Sheets data.
-
iContact Reporting in OBIEE with the iContact JDBC Driver
Deploy the iContact JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Apps with Live Amazon Marketplace Data Using the Low-Code Development Platform of Mendix
Connect Amazon Marketplace with Mendix to build apps using the CData JDBC Driver for Amazon Marketplace.
-
Connect Suadeo to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Suadeo using the CData Python MCP Server.
-
How to Easily Query SpaceX Data in OpenOffice Base
Connect to SpaceX data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Integrate Cursor with Live Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Analytics from within the editor.
-
Connect to Azure Table Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Table Storage in Airbyte.
-
How to Connect to Anaplan Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Anaplan. Leverage the pyodbc module for ODBC in Python.
-
Integrate Confluence with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Confluence with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Atlassian Confluence.
-
Migrating data from Bitly to Google BigQuery using CData SSIS Components.
Easily push Bitly to Google BigQuery using the CData SSIS Tasks for Bitly and Google BigQuery.
-
Migrating data from Parallel to Snowflake using CData SSIS Components.
Easily push Parallel to Snowflake using the CData SSIS Tasks for Parallel and Snowflake.
-
Integrate Paddle with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Paddle with External Services.
-
How to load Opsgenie data into Elasticsearch via Logstash
Introducing a simple method to load Opsgenie data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous ZohoSubscriptions Replication to SQLite
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to SQLite.
-
Visualize Hubstaff Data in Sisense
Create an ElastiCube in Sisense app with access to Hubstaff.
-
Write a Simple Go Application to work with SageHR Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SageHR.
-
How to Create Power BI Visual Reports with Real-Time Instantly Data
Use CData Power BI Connectors to visualize Instantly in Power BI.