CData Software - Knowledge Base
Recent Articles
-
Integrate Devin with Live MarkLogic Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live MarkLogic data.
-
Automated Continuous HDFS Replication to MySQL
Use CData Sync for automated, continuous, customizable HDFS replication to MySQL.
-
Connect to Oracle Eloqua Data in ACL Analytics
Connect to Oracle Eloqua data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Oracle Eloqua data.
-
Integrate Helpscout with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Helpscout with External Services.
-
Build Agents in Relevance AI with Access to Live SAP HANA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP HANA data within intelligent agent workflows.
-
Natively Connect to Azure Synapse Data in PHP
The CData ODBC driver for Azure Synapse enables you to create PHP applications with connectivity to Azure Synapse data. Leverage the native support for ODBC in PHP.
-
Access SAP Business One Data from MySQL in Amazon QuickSight
Connect to SAP Business One and build visualizations of SAP Business One data using a MySQL Connection in Amazon QuickSight.
-
DataBind Gumroad Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Gumroad data to a chart.
-
Integrating Gumloop with Jumpseller Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Jumpseller data within automated workflows.
-
Connect to QuickBooks in SpagoBI
Create reports featuring live QuickBooks data in SpagoBI Studio. Host QuickBooks reports on SpagoBI Server.
-
Build AI Agents with IBM Cloud Object Storage 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 IBM Cloud Object Storage data through CData Connect AI.
-
Use the CData Software ODBC Driver for Google Ad Manager in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Ad Manager data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Ad Manager.
-
Publish Reports with Xero Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Xero data.
-
Analyze Pipedrive Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Pipedrive data and visualize live Pipedrive data in Infragistics Reveal.
-
Create Power BI Reports on Real-Time Hacker News Data
Use the CData ODBC Driver for Hacker News to visualize Hacker News data in Power BI Desktop.
-
Provide OData Services of Google Analytics Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Analytics data by developing a WCF Service Application.
-
Create Reports from Zoho Books Data in Looker Studio
Use CData Connect AI to gain access to live Zoho Books data and create custom reports in Looker Studio.
-
Create Reports from RSS Feeds in Looker Studio
Use CData Connect AI to gain access to live RSS feeds and create custom reports in Looker Studio.
-
Import Vertica Data Using Azure Data Factory
Use CData Connect AI to connect to Vertica Data from Azure Data Factory and import live Vertica data.
-
Connect to Oracle Eloqua Reporting from a Connection Pool in WebLogic
Use the CData JDBC Driver for Oracle Eloqua Reporting to connect to Oracle Eloqua Reporting data from Web applications running on WebLogic.
-
Integrate Microsoft Ads Data into Power Automate Desktop using CData Connect
CData Connect for Microsoft Ads Data enables you to integrate Microsoft Ads data into workflows built using Microsoft Power Automate Desktop.
-
Build Neo4J-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Neo4J data without replication.
-
Link Supabase with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Supabase data in Filemaker Pro for Mac or Windows.
-
Connect to Exact Online Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Exact Online data.
-
Connect to CouchDB Data in JRuby
Create a simple JRuby app with access to live CouchDB data.
-
How to connect to Anaplan Data from IntelliJ
Integrate connectivity to Anaplan data with wizards in IntelliJ.
-
Automate Attio Data Replication to SAP HANA
Use CData Sync to customize and automate Attio data replication to SAP HANA.
-
How to Work with Oracle Eloqua Data in AWS Glue Jobs Using JDBC
Connect to Oracle Eloqua from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create FHIR-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to FHIR Data from Klipfolio and build custom visualizations using live FHIR data.
-
Publish Reports with SingleStore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SingleStore data.
-
Build an OLAP Cube in SSAS from Avaza Data
Establish a connection to Avaza data data from SQL Server Analysis Services, and use the Avaza Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Dynamics 365 Business Central Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to AlloyDB.
-
Query HDFS Data as a MySQL Database in Node.js
Execute MySQL queries against HDFS data from Node.js.
-
How to Connect the Power BI Service to Salesforce Pardot: Complete Guide
Connect to the CData Software Power BI Connector for Salesforce Pardot from PowerBI.com to provide real-time Salesforce Pardot data across the organization.
-
Automated Continuous Guru Replication to Oracle
Use CData Sync for automated, continuous, customizable Guru replication to Oracle.
-
Connect to SAP Business Warehouse Data in Google Apps Script via Connect AI
Use CData Connect AI to access SAP Business Warehouse data in Google Apps Script.
-
Build a PostgreSQL Interface for Hugging Face Data using the CData JDBC Driver
Use the Remoting features of the Hugging Face JDBC Driver to create a PostgreSQL entry-point for data access.
-
A PostgreSQL Interface for SAP Fieldglass Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Fieldglass JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Adobe Target from Asprova with CData Software ODBC Driver for Adobe Target
This article shows how to connect faster to Adobe Target data from Asprova.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ChartMogul
Provide connectivity to ChartMogul data through an SAP BusinessObjects universe.
-
Build a Singer.io Tap for PagerDuty With the CData Python Connector
Learn how to easily build a Singer.io Tap for live PagerDuty data using the CData Python Connector.
-
Connect to Authorize.Net Data from Crystal Reports
Use CData Connect AI to connect to and report on live Authorize.Net data from Crystal Reports.
-
Integrating Kiro with DocuSign 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 Monday.com Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Monday.com data in Airbyte.
-
How to connect PolyBase to SFTP
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SFTP data.
-
Integrating Gumloop with PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on PingOne data within automated workflows.
-
Create Apps from Vault CRM Data in Qlik Sense Cloud
Use CData Connect AI to connect to Vault CRM Data and build apps from live Vault CRM data in Qlik Sense Cloud.
-
Automated Continuous Exa Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Exa replication to Azure SQL Database.
-
How to connect to Asana Data from IntelliJ
Integrate connectivity to Asana data with wizards in IntelliJ.
-
Access Live Wrike Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Wrike data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Instagram Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Instagram data in SnapLogic.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Pingdom
Provide connectivity to Pingdom data through an SAP BusinessObjects universe.
-
How to connect to Azure Data Catalog Data with Squirrel SQL client
Connect to Azure Data Catalog data and execute queries in the Squirrel SQL Client.
-
How to work with Dynamics 365 Business Central Data in Apache Spark using SQL
Access and process Dynamics 365 Business Central Data in Apache Spark using the CData Software JDBC Driver.
-
Connect to SAP HANA Data from AWS Glue
Use CData Connect AI to gain access to live SAP HANA data from your AWS Glue jobs.
-
Integrating LangChain with Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Cloudflare data within automated workflows.
-
Build Semantic Layer Views for SendGrid Data in APOS Live Data Gateway
Use the CData Connector for SendGrid in APOS Live Data Gateway to build Semantic Layer Views for SendGrid data.
-
Connect to HubSpot Data in Google Apps Script via Connect AI
Use CData Connect AI to access HubSpot data in Google Apps Script.
-
Build LinkedIn Visualizations in Tableau Desktop
Use CData Connect AI to connect to live LinkedIn data and build visualizations in Tableau.
-
Bridge Codat Connectivity with Apache NiFi
Access and process Codat data in Apache NiFi using the CData JDBC Driver.
-
Connect to Parallel Data in DBArtisan
Use wizards in DBArtisan to configure Parallel data as a data source.
-
Integrating GitHub Copilot with Salesloft 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.
-
Automate Azure Data Lake Storage Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Azure Data Lake Storage data from PowerShell? This article demonstrates how to utilize the Azure Data Lake Storage Cmdlets for tasks like connecting to Azure Data Lake Storage data, automating operations, downloading data, and more.
-
Connect to Klaviyo Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Klaviyo and the SQL Gateway to access Klaviyo data from Google Apps Script.
-
Publish Hacker News-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Hacker News data.
-
Automate ElevenLabs Data Replication to Azure Data Lake
Use CData Sync to customize and automate ElevenLabs data replication to Azure Data Lake.
-
Integrate Microsoft Entra ID Data in Pentaho Data Integration
Build ETL pipelines based on Microsoft Entra ID data in the Pentaho Data Integration tool.
-
Use Microsoft Copilot Studio to talk to your HubDB 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 HubDB data for you.
-
Access Live Google Calendar Data in AWS Lambda
Connect to live Google Calendar data in AWS Lambda using the CData JDBC Driver.
-
Connecting Mastra with Google Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Google Directory data, no replication required.
-
Replicate Multiple JobNimbus Accounts via the CData Sync CLI
Replicate multiple JobNimbus accounts to one or many databases.
-
Use the CData ODBC Driver for Contentful in Microsoft Power Query
You can use the CData Contentful ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Contentful data into Microsoft Power Query.
-
Automated Continuous Hubstaff Replication to Oracle
Use CData Sync for automated, continuous, customizable Hubstaff replication to Oracle.
-
Work with Yelp Data in FoxPro
Load Yelp data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Microsoft Planner Data in DBVisualizer
Integrate Microsoft Planner data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating GitHub Copilot with Outlook 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 BigQuery Data from a Connection Pool in Jetty
The BigQuery JDBC Driver supports connection pooling: This article shows how to connect faster to BigQuery data from Web apps in Jetty.
-
Build a Simple VCL Application for Mailjet Data
How to build a simple VCL Application to view Mailjet data in RAD Studio using the CData ODBC Driver for Mailjet.
-
Natively Connect to Google Drive Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Drive data. Leverage the native support for ODBC in PHP.
-
Visualize MessageBird Data in Tableau
The CData ODBC driver for MessageBird enables you integrate MessageBird data into Tableau dashboards.
-
Build Amazon DynamoDB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Amazon DynamoDB data and build visualizations in Tableau Cloud.
-
Integrate with SAP Ariba Source Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Ariba Source data in SnapLogic.
-
Integrate Theia IDE with Live Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live Teradata data from within the development environment.
-
Consume Oracle Service Cloud OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Service Cloud data as OData feeds from PowerBuilder using the API Server.
-
Connect to BigCommerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to BigCommerce.
-
How to Visualize Google Spanner Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Spanner data in Python.
-
Connect to Dynamics 365 Business Central Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics 365 Business Central and the Script function in FileMaker Pro to connect to Dynamics 365 Business Central and work with Dynamics 365 Business Central data in your FileMaker application.
-
Automate HDFS Data Replication to SAP HANA
Use CData Sync to customize and automate HDFS data replication to SAP HANA.
-
Back Up HubSpot data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for HubSpot. In this article, we will employ an SSIS workflow to populate a database with HubSpot data data.
-
Connect to Webflow Data in HULFT Integrate
Connect to Webflow as a JDBC data source in HULFT Integrate
-
Query, Visualize, and Share live Act-On Data in Redash
Use CData Connect AI to connect to live Act-On data in Redash for querying, visualizing, and sharing.
-
How to connect PolyBase to Google Sheets
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Sheets data.
-
Connect to Bitly in SpagoBI
Create reports featuring live Bitly data in SpagoBI Studio. Host Bitly reports on SpagoBI Server.
-
Access Salesforce Pardot Data from MySQL in PHP
Connect to Salesforce Pardot through the standard MySQL libraries in PHP.
-
Automated Continuous Workable Replication to SQLite
Use CData Sync for automated, continuous, customizable Workable replication to SQLite.
-
Getting Started with the CData Python Connector for SAP Ariba Procurement
Learn to install and license the CData Python Connector and configure a connection to live SAP Ariba Procurement data.
-
QuickBooks Remote Connector Certificate Revoked
Update QuickBooks Remote Connector to maintain remote access to QuickBooks Desktop
-
Integrate with live SQL Server Data in Jitterbit
Use CData Connect AI to connect to and integrate live SQL Server data in Jitterbit.
-
Use the CData Software JDBC Driver for Autopilot in MicroStrategy
Connect to Autopilot data in MicroStrategy Developer using the CData Software JDBC Driver for Autopilot.
-
Use the CData ODBC Driver for Strava from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Strava to connect to Strava data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Strava data in Excel.