CData Software - Knowledge Base
Recent Articles
-
Access Facebook Data from MySQL in PHP
Connect to Facebook through the standard MySQL libraries in PHP.
-
How to Connect to Live Adobe Analytics Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Adobe Analytics for you.
-
DataBind Controls to Avaza Data in C++Builder
DataBind to Avaza in C++Builder with standard components and controls.
-
Connect to Real-Time Google Forms Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Google Forms in Power Apps.
-
Build Dashboards with GraphQL Data in Dundas BI
Create dynamic dashboards and perform analytics based on GraphQL in Dundas BI.
-
Connect to Real-Time Outlook Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Outlook in Power Apps.
-
Connect and Visualize Live Trello Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Trello into the Databricks platform and create visualization dashboards with real-time Trello.
-
Replicate MailChimp Data from PowerShell
Write a quick PowerShell script to query MailChimp. Use connectivity to the live data to replicate MailChimp to SQL Server.
-
Automate Oracle Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Oracle Database and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Basecamp Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Basecamp replication to Google BigQuery.
-
Connect to SAP BusinessObjects BI from Asprova with CData Software ODBC Driver for SAP BusinessObjects BI
This article shows how to connect faster to SAP BusinessObjects BI data from Asprova.
-
Create Deel Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Deel data access from reports, embedded analytics, and more.
-
Integrate LibreChat with Live Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Freshservice from within the chat interface.
-
Connect to Pinecone Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Amazon S3 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon S3 replication to Azure SQL Database.
-
Integrating OpenCode Terminal with PostgreSQL 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.
-
Connect to and Query Oracle Eloqua Data in QlikView over ODBC
Create data visualizations with Oracle Eloqua in QlikView.
-
How to Visualize BigQuery 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 Google BigQuery in Python.
-
Access Live Browserless Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Browserless into the statistical analysis tools available in SAS JMP. This article shows how to use Browserless in the Graph Builder and Query Builder.
-
How to Import Data from Suadeo into Google Sheets
Import Suadeo into a Google spreadsheet that is automatically refreshed.
-
View Reports on Real-Time Planio Data in Power BI Report Server
Use the CData ODBC Driver for Planio to visualize Planio in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Live Airtable Data in MicroStrategy through CData Connect AI
Create a live connection to Airtable Data in CData Connect AI and connect to your Airtable from MicroStrategy.
-
Replicate SAS xpt Data to Multiple Databases via the CData Sync CLI
Replicate SAS XPORT to disparate databases with a single configuration.
-
Connect to Oracle Sales Data in RapidMiner
Integrate Oracle Sales with standard components and data source configuration wizards in RapidMiner Studio.
-
Automate VWO Data Replication to Couchbase
Use CData Sync to Customize and automate VWO replication to Couchbase.
-
Build Automated Dynamics CRM-Connected Workflows in Zapier
Use CData Connect AI to connect to live Microsoft Dynamics CRM and build automated workflows in Zapier.
-
Automated Continuous SAP Ariba Source Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to Databricks.
-
How to use SQLAlchemy ORM to access MailerSend Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of MailerSend.
-
Establish a Live Connection with Greenplum Data using Tableau Bridge
The CData ODBC Driver for Greenplum enables you to integrate live Pivotal GreenPlum into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous Exact Online Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Exact Online replication to PostgreSQL.
-
Integrating Kafka Data in Talend Cloud Data Management Platform
Connect Kafka Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Kafka.
-
How to Connect to eBay Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to eBay. Leverage the pyodbc module for ODBC in Python.
-
How to Connect DBeaver to Autopilot via a JDBC Driver
Manage Autopilot with visual tools in DBeaver like the query browser.
-
Connect to Delighted in SpagoBI
Create reports featuring live Delighted in SpagoBI Studio. Host Delighted reports on SpagoBI Server.
-
Migrating data from ZohoMarketingHub to Snowflake using CData SSIS Components.
Easily push ZohoMarketingHub to Snowflake using the CData SSIS Tasks for ZohoMarketingHub and Snowflake.
-
Automate Cloudflare Data Replication to Azure Data Lake
Use CData Sync to customize and automate Cloudflare replication to Azure Data Lake.
-
How to Work with Drift Data in AWS Glue Jobs Using JDBC
Connect to Drift from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Replicate ClickTime Data from PowerShell
Write a quick PowerShell script to query ClickTime. Use connectivity to the live data to replicate ClickTime to SQL Server.
-
Create Power BI Reports on Real-Time GitLab Data
Use the CData ODBC Driver for GitLab to visualize GitLab in Power BI Desktop.
-
Connect to Quaderno Data from PowerBuilder via JDBC
This article demonstrates how to access Quaderno from PowerBuilder using the Quaderno JDBC Driver.
-
Integrating OpenCode Terminal with Databricks 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 Seamlessly Import DocuSign Data into IBM SPSS Modeler
Integrate DocuSign data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Excel Spreadsheet Automation on Paymo Data with the QUERY Formula
Pull data from Paymo, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData Python Connector for Sage 300
Learn to install and license the CData Python Connector
-
Automate SharePoint Excel Services Data Replication to SAP HANA
Use CData Sync to customize and automate SharePoint Excel Services replication to SAP HANA.
-
How to Connect to Live BigCommerce 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 BigCommerce for you.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for LinkedIn Ads
Provide connectivity to LinkedIn Ads through an SAP BusinessObjects universe.
-
Connect to SAS Data Sets Data from PowerBuilder via JDBC
This article demonstrates how to access SAS Data Sets from PowerBuilder using the SAS Data Sets JDBC Driver.
-
Access Live ServiceDesk Plus Data in AWS Lambda
Connect to live ServiceDesk Plus in AWS Lambda using the CData JDBC Driver.
-
Use ChatGPT to Talk to Your Smartsheet 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 Smartsheet for you.
-
Integrating Kiro CLI with PagerDuty 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.
-
Query, Visualize, and Share live Cloudant Data in Redash
Use CData Connect AI to connect to live IBM Cloudant in Redash for querying, visualizing, and sharing.
-
Automated Continuous CampaignMonitor Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to delimited files (CSV/TSV).
-
Integrate PostgreSQL Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to PostgreSQL and integrate live PostgreSQL into your Power Automate tasks.
-
Integrate SAP BusinessObjects BI with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP BusinessObjects BI with External Services.
-
How to connect to Zendesk Data with Squirrel SQL client
Connect to Zendesk and execute queries in the Squirrel SQL Client.
-
Consume Greenplum OData Feeds in PowerBuilder
This article demonstrates how to consume Pivotal GreenPlum as OData feeds from PowerBuilder using the API Server.
-
Automate Facebook Data Replication to Azure Data Lake
Use CData Sync to customize and automate Facebook replication to Azure Data Lake.
-
Integrating Freshsales Data in Talend Cloud Data Management Platform
Connect Freshsales Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access Pipeliner CRM Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Pipeliner CRM.
-
Prepare, Blend, and Analyze Redshift Data in Alteryx Designer (ODBC)
Build workflows to access live Amazon Redshift for self-service data analytics.
-
How to load AlloyDB data into Elasticsearch via Logstash
Introducing a simple method to load AlloyDB data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Configure the CData JDBC Driver for Retently in a Connection Pool in Tomcat
Connect to Retently from a connection pool in Tomcat.
-
Establish a Live Connection with Hacker News Data using Tableau Bridge
The CData ODBC Driver for Hacker News enables you to integrate live Hacker News into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Kintone Data in NetBeans
Connect to Kintone in NetBeans with the data source configuration wizard.
-
Explore Geographical Relationships in Reckon Data with Power Map
Create data visualizations with Reckon in Power Map.
-
Deploy the ADO.NET Provider for Helpscout on an SSRS Report Server
Connect to Helpscout 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.
-
Build Marketo-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Marketo to explore live Marketo Data in Cursor to assist with building Marketo-powered applications.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for HubDB
Provide connectivity to HubDB through an SAP BusinessObjects universe.
-
How to Import Data from SAP ByDesign into Google Sheets
Import SAP Business ByDesign into a Google spreadsheet that is automatically refreshed.
-
Connect to Power BI XMLA Data from HeidiSQL
Use CData Connect AI to connect to and query live Power BI XMLA from HeidiSQL.
-
Replicate Sage 300 Data to Multiple Databases
Replicate Sage 300 to disparate databases with a point-and-click configuration.
-
Build Data Flows from GetResponse to SQL Server using SSIS
Easily back up GetResponse to SQL Server using the SSIS components for GetResponse.
-
Automate Microsoft Ads Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Ads replication to SAP HANA.
-
Analyze WordPress Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of WordPress and visualize WordPress in SAP Analytics Cloud.
-
Choosing the Best Method to Connect Salesloft to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Salesloft from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to MarkLogic Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for MarkLogic in the Denodo Virtual DataPort Administrator.
-
Connect to and Visualize Live Superchat Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Superchat.
-
How to Connect the Power BI Service to JSON: Complete Guide
Connect to the CData Software Power BI Connector for JSON from PowerBI.com to provide real-time JSON across the organization.
-
How to create Wave Financial federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Wave Financial in MySQL .
-
Build AI Agents with AlloyDB 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 Google AlloyDB through CData Connect AI.
-
View Reports on Real-Time Vimeo Data in Power BI Report Server
Use the CData ODBC Driver for Vimeo to visualize Vimeo in Power BI Desktop and then publish them to Power BI Report Server.
-
Connecting Moonlit Workflow with Greenhouse Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Greenhouse in real time.
-
Replicate Multiple Mode Accounts
Replicate multiple Mode accounts to one or many databases.
-
How to Visualize Amazon Athena Data in Python with pandas
Use pandas and other modules to analyze and visualize live Amazon Athena in Python.
-
DataBind Charts to Rebilly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Rebilly 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 the CData Software ODBC Driver for Avalara AvaTax in MicroStrategy Web
Connect to Avalara AvaTax in MicroStrategy Web using the CData Software ODBC Driver for Avalara AvaTax.
-
Using the CData Software ODBC Driver for Twitter Ads in PyCharm
Connect to Twitter Ads as an ODBC data source in PyCharm using the CData Software ODBC Driver for Twitter Ads.
-
Connect to PayPal Data in NetBeans
Connect to PayPal in NetBeans with the data source configuration wizard.
-
How to Import Data from Facebook into Google Sheets
Import Facebook into a Google spreadsheet that is automatically refreshed.
-
How to Connect to Live PayPal Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your PayPal for you.
-
How to Access Impala Data Using Entity Framework
This article shows how to access Apache Impala using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use Microsoft Copilot Studio to talk to your Redis Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Redis for you.
-
Automated Continuous SAP Ariba Procurement Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Ariba Procurement replication to Databricks.
-
Use Dash to Build to Web Apps on Delighted Data
Create Python applications that use pandas and Dash to build Delighted-connected web apps.
-
Query MYOB AccountRight Data in ColdFusion
Write standard ColdFusion data access code to connect to MYOB AccountRight.
-
Use the CData Software ODBC Driver for Google Ads in MicroStrategy Web
Connect to Google Ads in MicroStrategy Web using the CData Software ODBC Driver for Google Ads.
-
Getting Started with the CData ADO.NET Provider for Amazon S3
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Amazon S3.
-
Automate Microsoft Teams Data Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Teams replication to Azure Synapse.
-
Add Salesforce Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce with the Informatica Enterprise Data Catalog to classify and organize data.