CData Software - Knowledge Base
Recent Articles
-
Replicate MYOB AccountRight Data from PowerShell
Write a quick PowerShell script to query MYOB AccountRight. Use connectivity to the live data to replicate MYOB AccountRight to SQL Server.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Bitbucket
Provide connectivity to Bitbucket through an SAP BusinessObjects universe.
-
Access Live SAP Data in TIBCO Data Virtualization
Use the SAP ERP Tibco DV Adapter to create a SAP ERP/NetWeaver data source in TIBCO Data Virtualization Studio and gain access to live SAP ERP/NetWeaver from your TDV Server.
-
How to publish and share Apify Data dashboards with Tableau Server
The CData ODBC driver for Apify enables you integrate Apify into Tableau dashboards.
-
Automate OpenWeatherMap Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live OpenWeatherMap and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to Create Power BI Visual Reports with Real-Time ShipStation Data
Use CData Power BI Connectors to visualize ShipStation in Power BI.
-
Build Dashboards with Microsoft Entra ID Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft Entra ID in DBxtra.
-
Build AI/ML Models with Live Gong Data using Dataiku
Connect Gong Data with Dataiku using the CData API Driver for JDBC.
-
How to connect to SAP Hybris C4C Data from IntelliJ
Integrate connectivity to SAP Hybris C4C with wizards in IntelliJ.
-
Deploy the ADO.NET Provider for AlloyDB on an SSRS Report Server
Connect to Google AlloyDB 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.
-
Add Cassandra Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Cassandra with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Google Sheets Data in CloverDX (formerly CloverETL)
Transfer Google Sheets using the visual workflow in the CloverDX data integration tool.
-
Build Impala-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Apache Impala.
-
Access Drip Data from MySQL in PHP
Connect to Drip through the standard MySQL libraries in PHP.
-
Automated Continuous Amazon Athena Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Amazon Athena replication to Azure SQL Database.
-
Integrate with Amazon S3 Data in JReport Designer
Create charts and reports based on Amazon S3 in JReport Designer.
-
Integrating Outlook Data in Talend Cloud Data Management Platform
Connect Outlook Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Choosing the Best Method to Connect Dotmailer to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Dotmailer from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData Tableau Connector for MailerLite
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate SAP ByDesign Data to Multiple Databases
Replicate SAP Business ByDesign to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for Insightly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Insightly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from Attio to Google BigQuery using CData SSIS Components.
Easily push Attio to Google BigQuery using the CData SSIS Tasks for Attio and Google BigQuery.
-
Connect to Cloudflare Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Cloudflare in the Denodo Virtual DataPort Administrator.
-
How to connect to Microsoft Planner Data with Squirrel SQL client
Connect to Microsoft Planner and execute queries in the Squirrel SQL Client.
-
Dropbox Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Dropbox through CData Connect AI using different applications and tools.
-
Access Helpscout Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Helpscout from HeidiSQL.
-
Manage Act-On Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Act-On.
-
Getting Started with the CData ODBC Driver for Typeform
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Typeform.
-
Access PingOne Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live PingOne from HeidiSQL.
-
Integrate Real-Time Access to Instagram in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Instagram in real time.
-
Connecting GenSpark with CouchDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Apache CouchDB without any replication or custom integration required.
-
Build Apps with Live Telegram Data Using the Low-Code Development Platform of Mendix
Connect Telegram with Mendix to build apps using the CData API Driver for JDBC.
-
Build AI/ML Models with Live Dynamics 365 Data using Dataiku
Connect Dynamics 365 Data with Dataiku using the CData JDBC Driver for Dynamics 365.
-
Use the CData ODBC Driver for Databricks in Microsoft Power Query
You can use the CData Databricks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Databricks into Microsoft Power Query.
-
How to Access Live ZarMoney Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZarMoney enables you to integrate ZarMoney into workflows built using Microsoft Power Automate Desktop.
-
How to connect to RabbitMQ Data from Spring Boot
Connect to RabbitMQ in a Spring Boot Application using the CData API Driver for JDBC
-
How to connect to Pushbullet Data with Squirrel SQL client
Connect to Pushbullet and execute queries in the Squirrel SQL Client.
-
How to connect SharePoint with SurveyMonkey Data through external lists
Provide SurveyMonkey to SharePoint users as an external list.
-
How to Connect Redshift 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 Redshift data in real time using natural language.
-
Use Azure AI Foundry to Talk to Your Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Kintone for you.
-
How to Work with Rebilly Data in ETL Validator JDBC
Connect to Rebilly from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to and Query Missive Data in QlikView over ODBC
Create data visualizations with Missive in QlikView.
-
How to Connect DBeaver to Reckon via a JDBC Driver
Manage Reckon with visual tools in DBeaver like the query browser.
-
Integrate with Live Gong Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Gong from the MuleSoft Anypoint Platform to integrate live Gong into custom reports and dashboards.
-
Work with HDFS Data in FoxPro
Load Apache HDFS into a FoxPro database. This article includes full code and a walk-through of the process.
-
Configure the CData JDBC Driver for Guru in a Connection Pool in Tomcat
Connect to Guru from a connection pool in Tomcat.
-
How to connect to Gmail Data from Spring Boot
Connect to Gmail in a Spring Boot Application using the CData JDBC Driver for Gmail
-
Create Microsoft Teams-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Microsoft Teams Data from Klipfolio and build custom visualizations using live Microsoft Teams.
-
Integrating Antigravity CLI with HubDB via CData CLI
Connect HubDB to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Visualize Live NetSuite Data in the Power BI Service
Use CData Connect AI to connect to live NetSuite CRM & ERP and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from Hacker News to SQL Server using SSIS
Easily back up Hacker News to SQL Server using the SSIS components for Hacker News.
-
Query Webflow Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Webflow entities in PHP by modeling them as objects.
-
Create Data Visualizations in Cognos BI with SAS xpt Data
Access SAS XPORT as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Import ShipEngine Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access ShipEngine. In this article, you will use the OData format to import ShipEngine into Microsoft Power Query.
-
Getting Started with the CData Power BI Connector for REST
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for REST.
-
Build GraphQL-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for GraphQL Data and create custom apps in Bubble.
-
View Reports on Real-Time CSV Data in Power BI Report Server
Use the CData ODBC Driver for CSV to visualize CSV/TSV Files in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Google Contacts 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 Google Contacts for you.
-
Integrating Codex CLI with Microsoft Teams 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.
-
DataBind Controls to Google Ads Data in C++Builder
DataBind to Google Ads in C++Builder with standard components and controls.
-
Create ZohoPeople Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ZohoPeople data access from reports, embedded analytics, and more.
-
Access Live Paddle Data in Coginiti Pro
Connect to and query live Paddle from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to connect to Snowflake Data from Spring Boot
Connect to Snowflake in a Spring Boot Application using the CData JDBC Driver for Snowflake
-
Integrating Cursor CLI with Sendwithus 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.
-
Use Microsoft Copilot Studio to talk to your Stripe 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 Stripe for you.
-
Integrate with Browserless Data in JReport Designer
Create charts and reports based on Browserless in JReport Designer.
-
Query Reckon Accounts Hosted Data in ColdFusion
Write standard ColdFusion data access code to connect to Reckon Accounts Hosted.
-
How to connect and process ShipStation from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ShipStation.
-
Connect and Query Live Kintone Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Kintone into Databricks
-
Build Data Flows from Browserless to SQL Server using SSIS
Easily back up Browserless to SQL Server using the SSIS components for Browserless.
-
Automated Continuous API Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable API replication to PostgreSQL.
-
Connect SAP SuccessFactors to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP SuccessFactors with IBM WebSphere for seamless data integration and connectivity.
-
Migrating data from Humanity to Databricks using CData SSIS Components.
Easily push Humanity to Databricks using the CData SSIS Tasks for Humanity and Databricks.
-
Connect to xBase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for xBase.
-
Use the CData Software JDBC Driver for Guru in MicroStrategy
Connect to Guru in MicroStrategy Developer using the CData Software JDBC Driver for Guru.
-
How to create an RPA flow for Customer.io Data in UiPath Studio
Use the Customer.io ODBC Driver to create workflows that access real-time Customer.io without any coding.
-
Getting Started with the CData Power BI Connector for Odoo
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Odoo.
-
Stream PabblySubscriptions Data into Apache Kafka Topics
Access and stream PabblySubscriptions in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Real-Time Oracle HCM Cloud Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Oracle HCM Cloud and Dataflow to import and use Oracle HCM Cloud in Power Apps.
-
Automate SQL Server Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft SQL Server and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect to ChartMogul Data in DBArtisan
Use wizards in DBArtisan to configure ChartMogul as a data source.
-
Viewing Rebilly Data in RAD Studio Data Explorer
How to view Rebilly in RAD Studio Data Explorer using the CData ODBC Driver for Rebilly.
-
How to use SQLAlchemy ORM to access Onfleet Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Onfleet.
-
A PostgreSQL Interface for JobNimbus Data (MySQL Remoting via JDBC)
Use the Remoting features of the JobNimbus JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Seamlessly Import SendPulse Data into IBM SPSS Modeler
Integrate SendPulse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build Pipelines with Live Facebook Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Facebook from Google Cloud Data Fusion, enabling the integration of live Facebook into the building and management of effective data pipelines.
-
Automated Continuous Zoho Inventory Replication to SingleStore
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to SingleStore.
-
Integrate Live ZohoPeople Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ZohoPeople to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Query Quaderno Data as a MySQL Database in Node.js
Execute MySQL queries against Quaderno from Node.js.
-
Connect to Workable Data from a Connection Pool in JBoss
Integrate Workable into Java servlets: Use the Management Console in JBoss to install the Workable JDBC Driver.
-
Build SAP Ariba Source-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for SAP Ariba Source Data and create custom apps in Mendix.
-
Build Dashboards with eBay Analytics Data in DBxtra
Create dynamic dashboards and perform analytics based on eBay Analytics in DBxtra.
-
Getting Started with the CData Tableau Connector for Paymo
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Use the CData Software ODBC Driver for Intercom in MicroStrategy Web
Connect to Intercom in MicroStrategy Web using the CData Software ODBC Driver for Intercom.
-
Getting Started with the CData JDBC Driver for Zendesk
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Zendesk.
-
Connect Coinbase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Coinbase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous Cvent Replication to Snowflake
Use CData Sync for automated, continuous, customizable Cvent replication to Snowflake.
-
Integrating Boomi Agentstudio with Sugar CRM Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Sugar CRM, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
ETL Short.io in Oracle Data Integrator
This article shows how to transfer Short.io into a data warehouse using Oracle Data Integrator.
-
Connect to LightSpeedRetail Data in RapidMiner
Integrate LightSpeedRetail with standard components and data source configuration wizards in RapidMiner Studio.