CData Software - Knowledge Base
Recent Articles
-
View Reports on Real-Time Google Ads Data in Power BI Report Server
Use the CData ODBC Driver for Google Ads to visualize Google Ads data in Power BI Desktop and then publish them to Power BI Report Server.
-
ETL IBM Cloud Object Storage in Oracle Data Integrator
This article shows how to transfer IBM Cloud Object Storage data into a data warehouse using Oracle Data Integrator.
-
Connect to Vercel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Vercel data.
-
Consume Salesforce OData Feeds in PowerBuilder
This article demonstrates how to consume Salesforce data as OData feeds from PowerBuilder using the API Server.
-
Use CData Connect AI to Access SAP ByDesign Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP ByDesign data in the Power Pivot business intelligence tool.
-
Interact with Live Instagram Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Instagram data.
-
Use Grok to Talk to Your Salesforce Marketing 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 Salesforce Marketing data for you.
-
Feed Dynamics 365 Business Central Data into FineReport
How to set Dynamics 365 Business Central data as a JDBC data source in FineReport.
-
How to Query LinkedIn Data in MySQL Workbench
Execute MySQL queries against live LinkedIn data from MySQL Workbench.
-
Use the CData Software ODBC Driver for Pipeliner CRM in MicroStrategy Web
Connect to Pipeliner CRM data in MicroStrategy Web using the CData Software ODBC Driver for Pipeliner CRM.
-
Connect Mouseflow to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Mouseflow data using the CData Python MCP Server.
-
Build a PostgreSQL Interface for Timely Data using the CData JDBC Driver
Use the Remoting features of the Timely JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from Zoom Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoom Data and build apps from live Zoom data in Qlik Sense Cloud.
-
Access Vault CRM Data from MySQL in PHP
Connect to Vault CRM through the standard MySQL libraries in PHP.
-
Connect to XML Data in Claris FileMaker Pro
Use the CData ODBC Driver for XML in FileMaker Pro to connect to XML and work with XML data in your FileMaker applications.
-
Consume Kafka OData Feeds in PowerBuilder
This article demonstrates how to consume Kafka data as OData feeds from PowerBuilder using the API Server.
-
Integrating Cursor with ConvertAPI 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.
-
Build Dashboards with ZohoInvoice Data in Dundas BI
Create dynamic dashboards and perform analytics based on ZohoInvoice data in Dundas BI.
-
Connect to and Query Quaderno Data in QlikView over ODBC
Create data visualizations with Quaderno data in QlikView.
-
Query Phoenix Data as a MySQL Database in Node.js
Execute MySQL queries against Phoenix data from Node.js.
-
Connect to Perplexity Data from PowerBuilder via ADO.NET
This article demonstrates how to access Perplexity data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Link Mixpanel with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mixpanel data in Filemaker Pro for Mac or Windows.
-
Access Live Authorize.Net Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Authorize.Net data into the statistical analysis tools available in SAS JMP. This article shows how to use Authorize.Net data in the Graph Builder and Query Builder.
-
Connect to Chargebee Data in RazorSQL
Connect to Chargebee from wizards and query Chargebee data from the GUI in the RazorSQL database management tool.
-
Connect to ConvertKit Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ConvertKit data using standard SQL.
-
Integrating Productboard Data in Talend Cloud Data Management Platform
Connect Productboard Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Use Dash to Build to Web Apps on RabbitMQ Data
Create Python applications that use pandas and Dash to build RabbitMQ-connected web apps.
-
Automated Continuous Klipfolio Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Klipfolio replication to Amazon Redshift.
-
Build Data Flows from SQL Server to BigQuery through SSIS
Easily push SQL Server data to BigQuery using the CData SSIS Tasks for BigQuery.
-
Connect to Elorus from a Connection Pool in WebLogic
Use the CData JDBC Driver for Elorus to connect to Elorus data from Web applications running on WebLogic.
-
Analyze SAP SuccessFactors LMS Data in Cognos Analytics
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Cognos Analytics and analyze live SAP SuccessFactors LMS data.
-
Access Superchat Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Superchat data from your Oracle system.
-
A PostgreSQL Interface for Smartsheet Data using the CData ODBC Driver
Use the SQL Gateway and Smartsheet ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Adobe Analytics Data in Claris FileMaker Pro
Use the CData ODBC Driver for Adobe Analytics in FileMaker Pro to connect to Adobe Analytics and work with Adobe Analytics data in your FileMaker applications.
-
Connect to Basecamp Data from PowerBuilder via ADO.NET
This article demonstrates how to access Basecamp data from Appeon PowerBuilder using the CData ADO.NET Provider for Basecamp.
-
How to create Visio diagrams from LinkedIn Data
Automatically update LinkedIn data with the changes you make to Visio master shapes.
-
Build Data Flows from SQL Server to Spark through SSIS
Easily push SQL Server data to Spark using the CData SSIS Tasks for Spark.
-
Automated Apollo Data Replication to Teradata
Use CData Sync to Customize and automate Apollo data replication to Teradata.
-
How to use SQLAlchemy ORM to access Zoho CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho CRM data.
-
Integrate Attio Data in Pentaho Data Integration
Build ETL pipelines based on Attio data in the Pentaho Data Integration tool.
-
Build AI Agents with Sybase Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Sybase data through CData Connect AI.
-
How to Connect to Live SendGrid 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 SendGrid data for you.
-
Automated Continuous Raisers Edge NXT Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Apache Cassandra.
-
How to Visualize SageHR 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 SageHR data in Python.
-
Analyze EnterpriseDB Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of EnterpriseDB data and visualize live EnterpriseDB data in Infragistics Reveal.
-
How to Seamlessly Import Amazon Marketplace Data into IBM SPSS Modeler
Integrate Amazon Marketplace data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Salesforce Pardot Data from PowerBuilder via JDBC
This article demonstrates how to access Salesforce Pardot data from PowerBuilder using the Salesforce Pardot JDBC Driver.
-
Replicate Missive Data from PowerShell
Write a quick PowerShell script to query Missive data. Use connectivity to the live data to replicate Missive data to SQL Server.
-
How to Connect Zuora 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 Zuora data in real time using natural language.
-
Automated Continuous JotForm Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable JotForm replication to Azure SQL Database.
-
DataBind Controls to Teamgate Data in C++Builder
DataBind to Teamgate data in C++Builder with standard components and controls.
-
Access Reply.io Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Reply.io data from HeidiSQL.
-
Access Live Amazon DynamoDB Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Amazon DynamoDB data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
How to Connect to Live Sage 200 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 Sage 200 data through natural language.
-
Automated Continuous Tavily Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Tavily replication to Amazon Redshift.
-
Getting Started with the CData Python Connector for SAP Netweaver Gateway
Learn to install and license the CData Python Connector and configure a connection to live SAP Netweaver Gateway data.
-
Analyze Tickspot Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Tickspot data in Microsoft R Open.
-
Build an OLAP Cube in SSAS from EnterpriseDB Data
Establish a connection to EnterpriseDB data data from SQL Server Analysis Services, and use the EnterpriseDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData ODBC Driver for Azure DevOps in Microsoft Power Query
You can use the CData Azure DevOps ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Azure DevOps data into Microsoft Power Query.
-
A PostgreSQL Interface for Sentry Data (MySQL Remoting via JDBC)
Use the Remoting features of the Sentry JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect the Power BI Service to Quickbase: Complete Guide
Connect to the CData Software Power BI Connector for Quickbase from PowerBI.com to provide real-time Quickbase data across the organization.
-
Use the CData Software ODBC Driver for Adobe Analytics in MicroStrategy Desktop
Connect to Adobe Analytics data in MicroStrategy Desktop using the CData Software ODBC Driver for Adobe Analytics.
-
Connect Postmark to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Postmark with IBM WebSphere for seamless data integration and connectivity.
-
Query BigQuery Data as a SQL Server Database in Node.js
Execute SQL Server queries against BigQuery data from Node.js.
-
Integrate Open WebUI with Live Suadeo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Suadeo data from within the chat interface.
-
Automated Continuous OData Replication to SingleStore
Use CData Sync for automated, continuous, customizable OData replication to SingleStore.
-
Connect to Blackbaud FE NXT Data in Ruby
Connect to Blackbaud FE NXT data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Cohere Data in JRuby
Create a simple JRuby app with access to live Cohere data.
-
Query AdRoll Data in DataGrip
Create a Data Source for AdRoll in DataGrip and use SQL to query live AdRoll data.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data for you.
-
Object-Relational Mapping (ORM) with PolarTeamPro 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 PolarTeamPro data into a Java-based ORM framework, Hibernate.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP SuccessFactors
Create SAP SuccessFactors data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Moving Data from Freshteam to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Freshteam data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Dash to Build Web Apps on ServiceDesk Plus Data via CData Connect AI
Build interactive Dash web apps on live ServiceDesk Plus data using pandas and the CData Connect AI Python SDK.
-
Create Data Visualizations Based On SuiteCRM Data in Mode
Use CData Connect AI to connect to SuiteCRM Data from Mode and build visualizations using live SuiteCRM data.
-
Build a Simple VCL Application for SendPulse Data
How to build a simple VCL Application to view SendPulse data in RAD Studio using the CData ODBC Driver for SendPulse.
-
Connect to TigerGraph Data in Ruby
Connect to TigerGraph data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Informatica Mappings From/To an ODBC Data Source for SAP Ariba Source
Create an ODBC connection to SAP Ariba Source in Informatica and browse and transfer SAP Ariba Source data.
-
Automate Asana Data Replication to SAP HANA
Use CData Sync to customize and automate Asana data replication to SAP HANA.
-
How to connect to Google Ad Manager Data from IntelliJ
Integrate connectivity to Google Ad Manager data with wizards in IntelliJ.
-
Connect to DB2 Data from a Connection Pool in Jetty
The DB2 JDBC Driver supports connection pooling: This article shows how to connect faster to DB2 data from Web apps in Jetty.
-
Automated Continuous SAP Ariba Source Replication to IBM DB2
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to IBM DB2.
-
Automated Continuous Accelo Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Accelo replication to Amazon Redshift.
-
How to connect and process EmailOctopus data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live EmailOctopus data.
-
Use the CData Software ODBC Driver for ZohoPeople in SAS for Real-Time Reporting and Analytics
Connect to real-time ZohoPeople data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ZohoPeople.
-
Create Freshservice-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Freshservice Data from OutSystems and build custom enterprise apps using live Freshservice data.
-
Integrate with live WooCommerce Data in Jitterbit
Use CData Connect AI to connect to and integrate live WooCommerce data in Jitterbit.
-
Create Phoenix-Connected Business Apps in AppSheet
Connect to Phoenix Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Phoenix data.
-
Integrate Dify with Live SAS Data Sets 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 SAS Data Sets data.
-
Create Informatica Mappings From/To an ODBC Data Source for SharePoint Excel Services
Create an ODBC connection to SharePoint Excel Services in Informatica and browse and transfer SharePoint Excel Services data.
-
How to work with Auth0 Data in Apache Spark using SQL
Access and process Auth0 Data in Apache Spark using the CData Software JDBC Driver.
-
Build Data Flows from Tally to SQL Server using SSIS
Easily back up Tally data to SQL Server using the SSIS components for Tally.
-
Connect to Avaza Data in HULFT Integrate
Connect to Avaza as a JDBC data source in HULFT Integrate
-
Build AI Agents with Shortcut Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Shortcut data through CData Connect AI.
-
Connect to MYOB AccountRight Data in Claris FileMaker Pro
Use the CData ODBC Driver for MYOB AccountRight in FileMaker Pro to connect to MYOB AccountRight and work with MYOB AccountRight data in your FileMaker applications.
-
Connect to Bannerbear Data in RazorSQL
Connect to Bannerbear from wizards and query Bannerbear data from the GUI in the RazorSQL database management tool.
-
Automated Continuous Jumpseller Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Jumpseller replication to delimited files (CSV/TSV).
-
Integrate OneNote Data into Power Automate Desktop using CData Connect
CData Connect for OneNote Data enables you to integrate OneNote data into workflows built using Microsoft Power Automate Desktop.
-
Use Dash to Build to Web Apps on Intercom Data
Create Python applications that use pandas and Dash to build Intercom-connected web apps.
-
Connect to Sendwithus Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sendwithus.