CData Software - Knowledge Base
Recent Articles
-
Access Live MYOB AccountRight Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MYOB AccountRight data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build MVC Applications with Connectivity to Elasticsearch Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Elasticsearch from an ASP.NET MVC application.
-
How to Work with Google Ads Data in ETL Validator JDBC
Connect to Google Ads from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Spotify Replication to MongoDB
Use CData Sync for automated, continuous, customizable Spotify replication to MongoDB.
-
Visualize Templated Data in Sisense
Create an ElastiCube in Sisense app with access to Templated data.
-
Access Live Outreach.io Data in TIBCO Data Virtualization
Use the Outreach.io Tibco DV Adapter to create a Outreach.io data data source in TIBCO Data Virtualization Studio and gain access to live Outreach.io data from your TDV Server.
-
Create Apps from Impala Data in Qlik Sense Cloud
Use CData Connect AI to connect to Impala Data and build apps from live Impala data in Qlik Sense Cloud.
-
Automated Continuous OData Replication to SQLite
Use CData Sync for automated, continuous, customizable OData replication to SQLite.
-
Use the CData Software JDBC Driver for Perigon in MicroStrategy Desktop
Connect to Perigon data in MicroStrategy Desktop using the CData Software JDBC Driver for Perigon.
-
Explore Geographical Relationships in YouTube Analytics Data with Power Map
Create data visualizations with YouTube Analytics data in Power Map.
-
How to publish and share Oracle Eloqua Reporting Data dashboards with Tableau Server
The CData ODBC driver for Oracle Eloqua Reporting enables you integrate Oracle Eloqua Reporting data into Tableau dashboards.
-
A PostgreSQL Interface for Chargebee Data (MySQL Remoting via JDBC)
Use the Remoting features of the Chargebee JDBC Driver to create a PostgreSQL entry-point for data access.
-
A Comparison of JDBC & ODBC Drivers for Amazon Athena
A performance comparison of the CData JDBC Driver and ODBC Driver for Amazon Athena and the Amazon-supported Athena JDBC Driver and ODBC Driver.
-
How to Seamlessly Import Couchbase Data into IBM SPSS Modeler
Integrate Couchbase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Zoho Creator Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Zoho Creator data from within the IDE.
-
Connect to Live SendGrid Data in MicroStrategy through CData Connect AI
Create a live connection to SendGrid Data in CData Connect AI and connect to your SendGrid data from MicroStrategy.
-
Replicate Amazon Marketplace Data to Multiple Databases via the CData Sync CLI
Replicate Amazon Marketplace data to disparate databases with a single configuration.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Couchbase
Provide connectivity to Couchbase data through an SAP BusinessObjects universe.
-
Automate Contentful Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Contentful data from PowerShell? This article demonstrates how to utilize the Contentful Cmdlets for tasks like connecting to Contentful data, automating operations, downloading data, and more.
-
Integrate SharePoint Excel Services Data in the Pentaho Report Designer
Publish reports based on SharePoint Excel Services data in the Pentaho BI tool.
-
Easily Integrate SAP ByDesign Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP ByDesign data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Microsoft Dataverse Data in Google Apps Script via Connect AI
Use CData Connect AI to access Microsoft Dataverse data in Google Apps Script.
-
Build Dashboards with Drip Data in DBxtra
Create dynamic dashboards and perform analytics based on Drip data in DBxtra.
-
Integrate FTP Data in the Pentaho Report Designer
Publish reports based on FTP data in the Pentaho BI tool.
-
Build AI/ML Models with Live Sage Cloud Accounting Data using Dataiku
Connect Sage Cloud Accounting Data with Dataiku using the CData JDBC Driver for Sage Cloud Accounting.
-
Integrate Dify with Live Epicor Kinetic Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live Epicor Kinetic data.
-
Automated Continuous Redis Replication to SingleStore
Use CData Sync for automated, continuous, customizable Redis replication to SingleStore.
-
Connect to Airtable Data from PowerBuilder via JDBC
This article demonstrates how to access Airtable data from PowerBuilder using the Airtable JDBC Driver.
-
Build Semantic Layer Views for Sage 200 Data in APOS Live Data Gateway
Use the CData Connector for Sage 200 in APOS Live Data Gateway to build Semantic Layer Views for Sage 200 data.
-
Connect to Billsby Data in JRuby
Create a simple JRuby app with access to live Billsby data.
-
Connect to Coda Data in DBeaver
Use the CData ODBC Driver to connect to Coda data in DBeaver.
-
Connecting GenSpark with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SAP ByDesign data without any replication or custom integration required.
-
How to Easily Query Paymo Data in OpenOffice Base
Connect to Paymo data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Prepare, Blend, and Analyze Zoho Inventory Data in Alteryx Designer (Connect AI)
Build workflows to access live Zoho Inventory data for self-service data analytics.
-
Migrating data from Gorgias to Databricks using CData SSIS Components.
Easily push Gorgias data to Databricks using the CData SSIS Tasks for Gorgias and Databricks.
-
Connect to Google Ads Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Google Ads data in the Denodo Virtual DataPort Administrator.
-
Create Google Directory-Connected Applications in Appsmith
Connect to Google Directory Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Directory data.
-
A PostgreSQL Interface for Microsoft Entra ID Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Entra ID JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Kiro with LinkedIn Ads 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.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Fieldglass
Create SAP Fieldglass data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query GitLab Data in DataGrip
Create a Data Source for GitLab in DataGrip and use SQL to query live GitLab data.
-
How to Connect to Live Airtable Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Airtable data securely in real time.
-
Getting Started with the CData JDBC Driver for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PabblySubscriptions.
-
Connect to Greenhouse Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Greenhouse and the Script function in FileMaker Pro to connect to Greenhouse and work with Greenhouse data in your FileMaker application.
-
ETL OpenWeatherMap in Oracle Data Integrator
This article shows how to transfer OpenWeatherMap data into a data warehouse using Oracle Data Integrator.
-
Connect to Live Instagram Data in MicroStrategy through CData Connect AI
Create a live connection to Instagram Data in CData Connect AI and connect to your Instagram data from MicroStrategy.
-
Automated Continuous SAP Hybris C4C Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Vertica.
-
Integrate Raisers Edge NXT Data in the Pentaho Report Designer
Publish reports based on Raisers Edge NXT data in the Pentaho BI tool.
-
Integrating Dataiku with Greenplum Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Greenplum data.
-
Getting Started with the CData ADO.NET Provider for Azure Table
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Azure Table.
-
Use the CData ODBC Driver for Dotmailer in Microsoft Power Query
You can use the CData Dotmailer ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Dotmailer data into Microsoft Power Query.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Snapchat Ads
Provide connectivity to Snapchat Ads data through an SAP BusinessObjects universe.
-
Connect to Real-Time eBay Analytics Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for eBay Analytics and Dataflow to import and use eBay Analytics data in Power Apps.
-
Integrate Jumpseller Data in the Pentaho Report Designer
Publish reports based on Jumpseller data in the Pentaho BI tool.
-
Extract, Transform, and Load Sendwithus Data in Informatica PowerCenter
Create a simple Workflow for Sendwithus data in Informatica PowerCenter.
-
Integrating Dataiku with Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Amazon Marketplace data.
-
Getting Started with the CData Python Connector for CouchDB
Learn to install and license the CData Python Connector and configure a connection to live CouchDB data.
-
Import HubDB Data Using Azure Data Factory
Use CData Connect AI to connect to HubDB Data from Azure Data Factory and import live HubDB data.
-
Automated Continuous MariaDB Replication to Oracle
Use CData Sync for automated, continuous, customizable MariaDB replication to Oracle.
-
Build Pipelines with Live Coda Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Coda from Google Cloud Data Fusion, enabling the integration of live Coda data into the building and management of effective data pipelines.
-
Use Agno to Talk to Your Yelp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Yelp data for you.
-
Integrate Live Airtable Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Airtable data and integrate live Airtable data into apps built in Microsoft Power Apps.
-
Getting Started with the CData ODBC Driver for Recurly
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Recurly.
-
Use the CData Software ODBC Driver for HubSpot in MicroStrategy
Connect to HubSpot data in MicroStrategy Developer using the CData Software ODBC Driver for HubSpot.
-
Connect to Customer.io Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Customer.io and work with Customer.io data in your FileMaker applications.
-
Automate SAP HANA XS Advanced Data Replication to Azure Data Lake
Use CData Sync to customize and automate SAP HANA XS Advanced data replication to Azure Data Lake.
-
Create Codat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Codat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Airtable Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Airtable data.
-
Integrate Trae with Live Act-On Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Act-On data from within the AI-powered IDE.
-
Provide OData Services of Zoho Projects Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Zoho Projects data by developing a WCF Service Application.
-
How to connect SharePoint with Facebook Data through external lists
Provide Facebook data to SharePoint users as an external list.
-
Automated Continuous Pinterest Replication to SQLite
Use CData Sync for automated, continuous, customizable Pinterest replication to SQLite.
-
Getting Started with the CData SSIS Components for Google Directory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Directory.
-
Connect to Wave Financial from a Connection Pool in WebLogic
Use the CData JDBC Driver for Wave Financial to connect to Wave Financial data from Web applications running on WebLogic.
-
How to Connect the Power BI Service to Autopilot: Complete Guide
Connect to the CData Software Power BI Connector for Autopilot from PowerBI.com to provide real-time Autopilot data across the organization.
-
Connect to SurveyMonkey Data from a Connection Pool in JBoss
Integrate SurveyMonkey data into Java servlets: Use the Management Console in JBoss to install the SurveyMonkey JDBC Driver.
-
Connect to NetSuite Data from a Connection Pool in Jetty
The NetSuite JDBC Driver supports connection pooling: This article shows how to connect faster to NetSuite data from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Azure Table in MicroStrategy
Connect to Azure Table data in MicroStrategy Developer using the CData Software ODBC Driver for Azure Table.
-
Build MVC Applications with Connectivity to Workday Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Workday from an ASP.NET MVC application.
-
Connect Adobe Target to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Adobe Target data using the CData Python MCP Server.
-
Build AI/ML Models with Live Microsoft OneDrive Data using Dataiku
Connect Microsoft OneDrive Data with Dataiku using the CData JDBC Driver for Microsoft OneDrive.
-
LINQ to MongoDB Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the MongoDB Data Provider.
-
Import Real-Time Blackbaud FE NXT Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Blackbaud FE NXT data in ColdFusion.
-
Natively Connect to Aweber Data in PHP
The CData ODBC driver for Aweber enables you to create PHP applications with connectivity to Aweber data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Gorgias Replication to Oracle
Use CData Sync for automated, continuous, customizable Gorgias replication to Oracle.
-
Create Tavily-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Tavily Data from Klipfolio and build custom visualizations using live Tavily data.
-
How to Connect to Live Supabase Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Supabase data for you.
-
Import Xero Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Xero Data and provide access to live Xero data for custom reports in the Power BI Service.
-
Build Data Flows from SQL Server to Excel Online through SSIS
Easily push SQL Server data to Excel Online using the CData SSIS Tasks for Excel Online.
-
Automated Continuous ShipEngine Replication to Oracle
Use CData Sync for automated, continuous, customizable ShipEngine replication to Oracle.
-
Integrate Google's Vertex AI Agent with Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SparkPost data within intelligent workflows.
-
Connect to SAP SuccessFactors LMS Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SAP SuccessFactors LMS to connect to SAP SuccessFactors LMS data and execute queries in PowerBuilder.
-
DataBind Charts to ClickTime Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ClickTime data 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.
-
Use Dash to Build to Web Apps on SAP SuccessFactors Data
Create Python applications that use pandas and Dash to build SAP SuccessFactors-connected web apps.
-
Connect to ScrapingBee from Asprova with CData Software ODBC Driver for ScrapingBee
This article shows how to connect faster to ScrapingBee data from Asprova.
-
Migrating data from SAP Netweaver Gateway to Google BigQuery using CData SSIS Components.
Easily push SAP Netweaver Gateway data to Google BigQuery using the CData SSIS Tasks for SAP Netweaver Gateway and Google BigQuery.
-
Import Real-Time Google Forms Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Forms data in ColdFusion.
-
LINQ to WooCommerce Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the WooCommerce Data Provider.
-
How to Connect to Live IBM Informix 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 IBM Informix data through natural language.
-
Access Live Bullhorn CRM Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Bullhorn CRM data through MCP integration.