CData Software - Knowledge Base
Recent Articles
-
Integrate eBay Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live eBay from Informatica Cloud.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Vimeo
Provide connectivity to Vimeo through an SAP BusinessObjects universe.
-
Integrate Tavily Data in Pentaho Data Integration
Build ETL pipelines based on Tavily in the Pentaho Data Integration tool.
-
Establish a Live Connection with Microsoft Dataverse Data using Tableau Bridge
The CData ODBC Driver for Microsoft Dataverse enables you to integrate live Microsoft Dataverse (CDS) into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Instagram Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Instagram replication to Google BigQuery.
-
DataBind Controls to Unbounce Data in C++Builder
DataBind to Unbounce in C++Builder with standard components and controls.
-
Connect to SAP BusinessObjects BI Data from PowerBuilder via ADO.NET
This article demonstrates how to access SAP BusinessObjects BI from Appeon PowerBuilder using the CData ADO.NET Provider for SAP BusinessObjects BI.
-
Import ActiveCampaign Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to ActiveCampaign Data and provide access to live ActiveCampaign for custom reports in the Power BI Service.
-
How to Connect to Google Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Ads. Leverage the pyodbc module for ODBC in Python.
-
How to Access Live Blackbaud FE NXT Data in Visual Studio Code via Cline
Run CData MCP Server for Blackbaud FE NXT on Windows Subsytem for Linux (WSL) and connect to live Blackbaud FE NXT from the Cline extension in Visual Studio Code.
-
Visualize Live Freshteam Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Freshteam.
-
Write a Simple Go Application to work with Calendly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Calendly.
-
Connect to SuiteCRM Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for SuiteCRM in the Denodo Virtual DataPort Administrator.
-
View Reports on Real-Time Elasticsearch Data in Power BI Report Server
Use the CData ODBC Driver for Elasticsearch to visualize Elasticsearch in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect PolyBase to FreshBooks
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FreshBooks.
-
Integrating Dataiku with CockroachDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live CockroachDB.
-
Excel Spreadsheet Automation on Parquet Data with the QUERY Formula
Pull data from Parquet, automate spreadsheets, and more with the QUERY formula.
-
Build a Singer.io Tap for Apify With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Apify data using
-
Connect and Visualize Live Oracle Sales Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Oracle Sales into the Databricks platform and create visualization dashboards with real-time Oracle Sales.
-
How to Visualize Sybase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Sybase in Python.
-
A PostgreSQL Interface for Pingdom Data using the CData ODBC Driver
Use the SQL Gateway and Pingdom ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Paylocity from a Connection Pool in WebLogic
Use the CData JDBC Driver for Paylocity to connect to Paylocity from Web applications running on WebLogic.
-
Seamlessly Bring Certinia Data into Retool Using CData Connect AI
Integrate Certinia data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Visualize GitLab Data in Tableau
The CData ODBC driver for GitLab enables you integrate GitLab into Tableau dashboards.
-
Automated Continuous Jumpseller Replication to MongoDB
Use CData Sync for automated, continuous, customizable Jumpseller replication to MongoDB.
-
Visualize CampaignMonitor Data in Sisense
Create an ElastiCube in Sisense app with access to CampaignMonitor.
-
Create Dynamic PhantomBuster Grids Using the Infragistics XamDataGrid
Learn how you can connect PhantomBuster to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect Oracle Service Cloud Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Oracle Service Cloud data in real time using natural language.
-
Use Grok to Talk to Your Sage Cloud Accounting Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Sage Business Cloud Accounting for you.
-
How to Connect to Live Oracle Service Cloud Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Oracle Service Cloud without replication.
-
Replicate Clockify Data to Multiple Databases
Replicate Clockify to disparate databases with a point-and-click configuration.
-
How to Connect to & Open CircleCI Data in Microsoft Excel
This article uses the CData ODBC driver for CircleCI to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Amazon Marketplace Replication to Vertica
Use CData Sync for automated, continuous, customizable Amazon Marketplace replication to Vertica.
-
How to Work with Bannerbear Data in ETL Validator JDBC
Connect to Bannerbear from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Reports with Placid Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Placid.
-
Automated Continuous Oracle HCM Cloud Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to delimited files (CSV/TSV).
-
Migrating data from Highrise to Snowflake using CData SSIS Components.
Easily push Highrise CRM to Snowflake using the CData SSIS Tasks for Highrise and Snowflake.
-
Build Semantic Layer Views for Salesforce Marketing Data in APOS Live Data Gateway
Use the CData Connector for Salesforce Marketing in APOS Live Data Gateway to build Semantic Layer Views for Salesforce Marketing Cloud.
-
How to connect PolyBase to Guru
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Guru.
-
Object-Relational Mapping (ORM) with Trello 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 Trello into a Java-based ORM framework, Hibernate.
-
Integrate with live Marketo Data in Jitterbit
Use CData Connect AI to connect to and integrate live Marketo in Jitterbit.
-
DataBind Microsoft Ads Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Microsoft Ads with the DevExpress Windows Forms and Web controls to provide Microsoft Ads to a chart.
-
How to Visualize Xero Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Xero Accounting in Python.
-
How to update Highrise from Excel
This article explains how to transfer data from Excel to Highrise using the Excel Add-In for Highrise.
-
Replicate MailerLite Data in Heroku for Use in Salesforce Connect
Replicate MailerLite to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrate Microsoft Entra ID Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Microsoft Entra ID from Informatica Cloud.
-
Getting Started with the CData ADO.NET Provider for SharePoint
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SharePoint.
-
Build an OLAP Cube in SSAS from CircleCI Data
Establish a connection to CircleCI data from SQL Server Analysis Services, and use the CircleCI Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build Dashboards with Oracle Service Cloud Data in Dundas BI
Create dynamic dashboards and perform analytics based on Oracle Service Cloud in Dundas BI.
-
Connect AI Guide: SSO (Single Sign-On) and User Credentials
A basic guide to Connect AI features: Single Sign-On (SSO) and User Credentials
-
How to Access Live Smartsheet Data in Visual Studio Code via Cline
Run CData MCP Server for Smartsheet on Windows Subsytem for Linux (WSL) and connect to live Smartsheet from the Cline extension in Visual Studio Code.
-
Integrate Live SAP Netweaver Gateway Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate Box Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Box from Informatica Cloud.
-
Establish a Live Connection with SAS Data Sets Data using Tableau Bridge
The CData ODBC Driver for SAS Data Sets enables you to integrate live SAS Data Sets into Tableau Cloud dashboards using the Tableau Bridge.
-
Getting Started with the CData Tableau Connector for Sugar CRM
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Sugar CRM.
-
How to Connect the Power BI Service to ADP: Complete Guide
Connect to the CData Software Power BI Connector for ADP from PowerBI.com to provide real-time ADP across the organization.
-
Create SAP SuccessFactors-Connected Dashboards in Grafana
Connect to SAP SuccessFactors Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SAP SuccessFactors.
-
How to Design Microsoft Dataverse Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Microsoft Dataverse from mobile and tablet Power Apps.
-
How to Visualize YouTube Analytics Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live YouTube Analytics in Python.
-
Use the CData Software JDBC Driver for Shopify in MicroStrategy
Connect to Shopify in MicroStrategy Developer using the CData Software JDBC Driver for Shopify.
-
Connect to and Visualize Live SparkPost Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SparkPost.
-
How to Connect to Live Paylocity 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 Paylocity for you.
-
Connect to Smartsheet Data from HeidiSQL
Use CData Connect AI to connect to and query live Smartsheet from HeidiSQL.
-
Connect to Pinterest Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pinterest using standard SQL.
-
Deploy the ADO.NET Provider for PayPal on an SSRS Report Server
Connect to PayPal 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.
-
Seamlessly Bring DB2 Data into Retool Using CData Connect AI
Integrate DB2 data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Viewing SAP Hybris C4C Data in RAD Studio Data Explorer
How to view SAP Hybris C4C in RAD Studio Data Explorer using the CData ODBC Driver for SAP Hybris C4C.
-
Replicate Oracle Sales Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Sales to disparate databases with a single configuration.
-
How to integrate Factorial with Apache Airflow
Access and process Factorial in Apache Airflow using the CData JDBC Driver.
-
Automate SendInBlue Data Replication to Couchbase
Use CData Sync to Customize and automate SendInBlue replication to Couchbase.
-
Integrate Cursor with Live SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP Ariba Source from within the editor.
-
Publish Crystal Reports on Databricks Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Databricks.
-
Integrating Claude Code CLI with Adobe Target 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.
-
How to Query Cloudant Data in MySQL Workbench
Execute MySQL queries against live IBM Cloudant from MySQL Workbench.
-
DataBind Controls to RSS Feeds in Delphi
DataBind to RSS Feeds in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for SQL Server in MicroStrategy Web
Connect to Microsoft SQL Server in MicroStrategy Web using the CData Software ODBC Driver for SQL Server.
-
Connect to Factorial Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Factorial and work with Factorial in your FileMaker applications.
-
Create Reports with SAP ByDesign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business ByDesign.
-
Build BenchmarkEmail-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to BenchmarkEmail and build web apps with connectivity to live BenchmarkEmail.
-
Integrating Parquet Data in Talend Cloud Data Management Platform
Connect Parquet Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Parquet.
-
How to import PhantomBuster Data into Apache Solr
Use the CData Software JDBC Driver for PhantomBuster in Data Import Handler and create an automated import of PhantomBuster to Apache Solr Enterprise Search platform.
-
How to connect PolyBase to Keap
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Keap.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Pipedrive actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Integrating Antigravity CLI with Facebook via CData CLI
Connect Facebook to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData SSIS Components for PagerDuty
Complete guide to installing, licensing, and connecting with the CData SSIS Components for PagerDuty.
-
Bind Live Epicor Kinetic Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Epicor Kinetic data
-
Establish a Live Connection with CloudConvert Data using Tableau Bridge
The CData ODBC Driver for CloudConvert enables you to integrate live CloudConvert into Tableau Cloud dashboards using the Tableau Bridge.
-
Automate ShipStation Data Replication to Azure Synapse
Use CData Sync to customize and automate ShipStation replication to Azure Synapse.
-
Access Calendly Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Calendly.
-
How to Connect to Live Exact Online 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 Exact Online for you.
-
How to create SageHR federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SageHR in MySQL .
-
Samanage Reporting in OBIEE with the Samanage JDBC Driver
Deploy the Samanage JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Exact Online Data in Heroku for Use in Salesforce Connect
Replicate Exact Online to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to connect to Aweber Data with Squirrel SQL client
Connect to Aweber and execute queries in the Squirrel SQL Client.
-
Access Grafana Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Grafana.
-
Getting Started with the CData Tableau Connector for LDAP
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LDAP.
-
Connect to Pingdom Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Pingdom and work with Pingdom in your FileMaker application.
-
Connect MessageBird to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect MessageBird with IBM WebSphere for seamless data integration and connectivity.
-
Import Zoho CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Zoho CRM. In this article, you will use the OData format to import Zoho CRM into Microsoft Power Query.
-
Build Visualizations of Lakebase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Lakebase in Birst.