CData Software - Knowledge Base
Recent Articles
-
Import Oracle Eloqua Reporting Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle Eloqua Reporting. In this article, you will use the OData format to import Oracle Eloqua Reporting into Microsoft Power Query.
-
Use the CData Software ODBC Driver for Vimeo in MicroStrategy Web
Connect to Vimeo in MicroStrategy Web using the CData Software ODBC Driver for Vimeo.
-
How to Connect to Live PayPal 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 PayPal for you.
-
Connect xBase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your xBase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Live MySQL Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MySQL in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate LinkedIn Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to LinkedIn and integrate live LinkedIn into your Power Automate tasks.
-
Access Live Avro Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Apache Avro in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Data Visualizations Based On Apollo Data in Mode
Use CData Connect AI to connect to Apollo Data from Mode and build visualizations using live
-
Integrating GitHub Copilot CLI with Clari 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.
-
Connect to Drip Data in Jaspersoft Studio
Execute SQL to remote Drip in Jaspersoft Studio.
-
Create Power BI Reports on Real-Time Avalara AvaTax Data
Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax in Power BI Desktop.
-
Use the CData Software JDBC Driver for Workable in MicroStrategy
Connect to Workable in MicroStrategy Developer using the CData Software JDBC Driver for Workable.
-
How to Connect the Power BI Service to CapsuleCRM: Complete Guide
Connect to the CData Software Power BI Connector for CapsuleCRM from PowerBI.com to provide real-time CapsuleCRM across the organization.
-
Use the CData Software ODBC Driver for SAS Data Sets in MicroStrategy
Connect to SAS Data Sets in MicroStrategy Developer using the CData Software ODBC Driver for SAS Data Sets.
-
Integrate GraphQL Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GraphQL from Informatica Cloud.
-
Connect to SharePoint Excel Services Data in RapidMiner
Integrate SharePoint Excel Services with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to SAP SuccessFactors LMS Data in ACL Analytics
Connect to SAP SuccessFactors LMS via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP SuccessFactors LMS.
-
Provide OData Services of Guru Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Guru by developing a WCF Service Application.
-
Integrate Google Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Ads and integrate live Google Ads into your Power Automate tasks.
-
Stream PhantomBuster Data into Apache Kafka Topics
Access and stream PhantomBuster in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP Hybris C4C within intelligent workflows.
-
Connect to Microsoft OneDrive Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft OneDrive from PowerBuilder using the Microsoft OneDrive JDBC Driver.
-
Getting Started with the CData Excel Add-In for HBase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HBase.
-
A PostgreSQL Interface for Google Ads Data using the CData ODBC Driver
Use the SQL Gateway and Google Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Controls to Neo4J Data in Delphi
DataBind to Neo4J in Delphi with standard data access components and controls.
-
How to Work with Pipeline CRM Data in AWS Glue Jobs Using JDBC
Connect to Pipeline CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Access Gumroad Data from MySQL in PHP
Connect to Gumroad through the standard MySQL libraries in PHP.
-
How to connect to LinkedIn Data from Spring Boot
Connect to LinkedIn in a Spring Boot Application using the CData JDBC Driver for LinkedIn
-
Provide OData Services of SAP Ariba Source Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Ariba Source by developing a WCF Service Application.
-
Integrating Claude Code with Instagram Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Instagram within assisted coding and automated development workflows.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Box
Provide connectivity to Box through an SAP BusinessObjects universe.
-
Import Real-Time Missive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Missive in ColdFusion.
-
Automated Continuous SendGrid Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SendGrid replication to Apache Kafka.
-
Create Informatica Mappings From/To a JDBC Data Source for OnePageCrm
Create OnePageCrm data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Mode Data in JRuby
Create a simple JRuby app with access to live Mode.
-
Connect to Salesforce Marketing Data in Aqua Data Studio
Access Salesforce Marketing Cloud from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build a PostgreSQL Interface for Authorize.Net Data using the CData JDBC Driver
Use the Remoting features of the Authorize.Net JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use ChatGPT to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Apache Hive for you.
-
Connect to Real-Time SendPulse Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use SendPulse in Power Apps.
-
Query LightSpeedRetail Data in DataGrip
Create a Data Source for LightSpeedRetail in DataGrip and use SQL to query live LightSpeedRetail.
-
Getting Started with the CData Python Connector for ZendeskSell
Learn to install and license the CData Python Connector
-
Work with Live Amazon DynamoDB Data in Power Query
Use CData Connect AI to connect to Amazon DynamoDB and work with live Amazon DynamoDB in Microsoft Power Query.
-
How to Query Live GitHub Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live GitHub data in natural language using Python.
-
Build xBase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for xBase to explore live xBase Data in Cursor to assist with building xBase-powered applications.
-
Build Data Flows from Microsoft Ads to SQL Server using SSIS
Easily back up Microsoft Ads to SQL Server using the SSIS components for Microsoft Ads.
-
Create Datasets from PingOne in Domo Workbench and Build Visualizations of PingOne Data in Domo
Use the CData Software ODBC Driver for PingOne to create datasets from PingOne in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Webex Data from a Connection Pool in Jetty
The Webex JDBC Driver supports connection pooling: This article shows how to connect faster to Webex from Web apps in Jetty.
-
Automated Continuous Raisers Edge NXT Replication to MongoDB
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to MongoDB.
-
Automated Continuous ZohoInvoice Replication to SingleStore
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to SingleStore.
-
Integrating Codex CLI with EmailOctopus 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.
-
Visualize Live SAS xpt Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live SAS XPORT.
-
How to connect to Oracle SCM Data in DBVisualizer
Integrate Oracle SCM with visual data analysis tools and data connection wizards in DBVisualizer
-
How to create Cloudant federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM Cloudant in MySQL .
-
Integrate with Live Google Campaign Manager 360 Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Google Campaign Manager 360 from the MuleSoft Anypoint Platform to integrate live Google Campaign Manager 360 into custom reports and dashboards.
-
Replicate GraphQL Data to Multiple Databases
Replicate GraphQL to disparate databases with a point-and-click configuration.
-
Stream BigCommerce Data into Apache Kafka Topics
Access and stream BigCommerce in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze SingleStore Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SingleStore and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Dynamic Beeminder Grids Using the Infragistics XamDataGrid
Learn how you can connect Beeminder to Infragistics XamDataGrid to build dynamic grids.
-
Vertica Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Vertica through CData Connect AI using different applications and tools.
-
How to Build an ETL App for Hive Data in Python with CData
Create ETL applications and real-time data pipelines for Apache Hive in Python with petl.
-
Automated Continuous Reckon Accounts Hosted Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Reckon Accounts Hosted replication to AlloyDB.
-
Use JayDeBeApi to access Microsoft Entra ID Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Entra ID.
-
Integrate Smartsheet Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Smartsheet from Informatica Cloud.
-
DataBind Charts to BambooHR Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to BambooHR 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.
-
Integrate Live CockroachDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to CockroachDB and integrate live CockroachDB into apps built in Microsoft Power Apps.
-
Analyze Vault CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Vault CRM from Power Pivot. You will use the Table Import Wizard to load Veeva Vault & Vault CRM. You can visually build the import query or use any SQL supported by the driver.
-
Build Dashboards with VWO Data in Dundas BI
Create dynamic dashboards and perform analytics based on VWO in Dundas BI.
-
Visualize Live Productboard Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Productboard.
-
Getting Started with the CData Tableau Connector for Cloudant
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Cloudant.
-
Getting Started with the CData Python Connector for Oracle Service Cloud
Learn to install and license the CData Python Connector
-
How to use SQLAlchemy ORM to access SAP SuccessFactors Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP SuccessFactors.
-
Integrating Cursor CLI with Excel Online 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.
-
Automated Continuous Klipfolio Replication to MongoDB
Use CData Sync for automated, continuous, customizable Klipfolio replication to MongoDB.
-
Integrate FreshBooks Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FreshBooks from Informatica Cloud.
-
Integrating LangGraph with Avalara AvaTax Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Avalara AvaTax within automated workflows.
-
Access Live Databricks Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Databricks through MCP integration.
-
Integrate Front Data in the Pentaho Report Designer
Publish reports based on Front in the Pentaho BI tool.
-
Access Webflow Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Webflow from your Oracle system.
-
Getting Started with the CData Connect AI Python SDK for WooCommerce
Install the CData Connect AI Python SDK to read and write live WooCommerce with standard DB-API 2.0 Python code.
-
Connect Cvent to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Cvent using the CData Python MCP Server.
-
How to use SQLAlchemy ORM to access Clio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clio.
-
Integrate Copper Data in Pentaho Data Integration
Build ETL pipelines based on Copper in the Pentaho Data Integration tool.
-
Connect to Google Ad Manager in SpagoBI
Create reports featuring live Google Ad Manager in SpagoBI Studio. Host Google Ad Manager reports on SpagoBI Server.
-
Automated Continuous Sybase IQ Replication to SingleStore
Use CData Sync for automated, continuous, customizable Sybase IQ replication to SingleStore.
-
Integrate Live SharePoint Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to create an RPA flow for Microsoft Ads Data in UiPath Studio
Use the Microsoft Ads ODBC Driver to create workflows that access real-time Microsoft Ads without any coding.
-
Use Dash to Build Web Apps on Sugar CRM Data via CData Connect AI
Build interactive Dash web apps on live Sugar CRM using pandas and the CData Connect AI Python SDK.
-
How to connect to Microsoft Ads Data with Squirrel SQL client
Connect to Microsoft Ads and execute queries in the Squirrel SQL Client.
-
Analyze Redshift Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Redshift from Power Pivot. You will use the Table Import Wizard to load Amazon Redshift. You can visually build the import query or use any SQL supported by the driver.
-
Explore Geographical Relationships in PDFMonkey Data with Power Map
Create data visualizations with PDFMonkey in Power Map.
-
Build Semantic Layer Views for Wrike Data in APOS Live Data Gateway
Use the CData Connector for Wrike in APOS Live Data Gateway to build Semantic Layer Views for Wrike.
-
How to Connect to & Open CapsuleCRM Data in Microsoft Excel
This article uses the CData ODBC driver for CapsuleCRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Import Real-Time Google Campaign Manager 360 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Campaign Manager 360 in ColdFusion.
-
Connect and Query Live Impala Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Apache Impala into Databricks
-
Build Data Flows from Scrapfly to SQL Server using SSIS
Easily back up Scrapfly to SQL Server using the SSIS components for Scrapfly.
-
Back Up Sage Intacct to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Sage Intacct. In this article, we will employ an SSIS workflow to populate a database with Sage Intacct data.
-
How to Connect DBeaver to Moosend via a JDBC Driver
Manage Moosend with visual tools in DBeaver like the query browser.
-
Build Pipelines with Live Microsoft Ads Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Ads from Google Cloud Data Fusion, enabling the integration of live Microsoft Ads into the building and management of effective data pipelines.
-
Visualize Aweber Data in Tableau
The CData ODBC driver for Aweber enables you integrate Aweber into Tableau dashboards.
-
Create CouchDB-Connected Applications in Appsmith
Connect to CouchDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Apache CouchDB.