CData Software - Knowledge Base
Recent Articles
-
Moving Data from Neo4J to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Neo4J data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to connect to Amazon S3 Data in DBVisualizer
Integrate Amazon S3 data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate with live Cloudant Data in Jitterbit
Use CData Connect AI to connect to and integrate live Cloudant data in Jitterbit.
-
Query Live ClickUp Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ClickUp data directly from the development environment.
-
Add Paddle Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Paddle with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Figshare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Figshare data from Informatica Cloud.
-
Connect to SAP BusinessObjects BI Data in CloverDX (formerly CloverETL)
Transfer SAP BusinessObjects BI data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous SQL Server Replication to Databricks
Use CData Sync for automated, continuous, customizable SQL Server replication to Databricks.
-
Connect to Gorgias Data from PowerBuilder via JDBC
This article demonstrates how to access Gorgias data from PowerBuilder using the Gorgias JDBC Driver.
-
Integrate OpenCode with Live SparkPost Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live SparkPost data from within your AI coding agent.
-
Connect to Azure Analysis Services Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Analysis Services data in Google Apps Script.
-
Integrating Yelp Data in Talend Cloud Data Management Platform
Connect Yelp Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Publish Microsoft Exchange-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Exchange data.
-
Use the CData Software ODBC Driver for Yelp in MicroStrategy
Connect to Yelp data in MicroStrategy Developer using the CData Software ODBC Driver for Yelp.
-
Automated Continuous Guru Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Guru replication to Apache Kafka.
-
Build an OLAP Cube in SSAS from Samanage Data
Establish a connection to Samanage data data from SQL Server Analysis Services, and use the Samanage Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect to ZohoMarketingHub Data from Spring Boot
Connect to ZohoMarketingHub in a Spring Boot Application using the CData API Driver for JDBC
-
Automated Continuous Jira Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Jira replication to Amazon Redshift.
-
Build Apps with Live Aircall Data Using the Low-Code Development Platform of Mendix
Connect Aircall data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous QuickBooks Online Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Google BigQuery.
-
View Reports on Real-Time Campaigner Data in Power BI Report Server
Use the CData ODBC Driver for Campaigner to visualize Campaigner data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to connect to Salesforce CRM Analytics Data with Squirrel SQL client
Connect to Salesforce CRM Analytics data and execute queries in the Squirrel SQL Client.
-
Build Apps with Live Microsoft Dataverse data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Microsoft Dataverse data into the Adalo platform and build custom mobile and web applications with real-time Microsoft Dataverse data.
-
Use Dash to Build Web Apps on CockroachDB Data via CData Connect AI
Build interactive Dash web apps on live CockroachDB data using pandas and the CData Connect AI Python SDK.
-
Integrate Live SparkPost Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SparkPost data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Accelo Data in JRuby
Create a simple JRuby app with access to live Accelo data.
-
How to connect to TaxJar Data from Spring Boot
Connect to TaxJar in a Spring Boot Application using the CData JDBC Driver for TaxJar
-
Getting Started with the CData Tableau Connector for FreshBooks
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Replicate ZohoSubscriptions Data to Multiple Databases via the CData Sync CLI
Replicate ZohoSubscriptions data to disparate databases with a single configuration.
-
Replicate Google Campaign Manager 360 Data from PowerShell
Write a quick PowerShell script to query Google Campaign Manager 360 data. Use connectivity to the live data to replicate Google Campaign Manager 360 data to SQL Server.
-
Build AI/ML Models with Live Active Directory Data using Dataiku
Connect Active Directory Data with Dataiku using the CData JDBC Driver for Active Directory.
-
Create SSAS Tabular Models from Sentry Data
How to build a SQL Server Analysis Service Tabular Model from Sentry data using CData drivers.
-
ETL Intercom in Oracle Data Integrator
This article shows how to transfer Intercom data into a data warehouse using Oracle Data Integrator.
-
Seamlessly Bring SAP ByDesign Data into Retool Using CData Connect AI
Integrate SAP ByDesign data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Explore Geographical Relationships in Amazon DynamoDB Data with Power Map
Create data visualizations with Amazon DynamoDB data in Power Map.
-
Connect to Instantly Data in Ruby
Connect to Instantly data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Using the CData Software ODBC Driver for Oracle HCM Cloud in PyCharm
Connect to Oracle HCM Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle HCM Cloud.
-
Create SendGrid-Connected Dashboards in Grafana
Connect to SendGrid Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to SendGrid data.
-
Analyze Aweber Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Aweber data in Microsoft R Open.
-
Automate Freshteam Data Replication to SAP HANA
Use CData Sync to customize and automate Freshteam data replication to SAP HANA.
-
Connect to Telegram Data in DBArtisan
Use wizards in DBArtisan to configure Telegram data as a data source.
-
Access Live Perigon Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Perigon data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connecting Agentforce with Printify Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Printify data for you.
-
Connect to MYOB AccountRight Data in Jaspersoft Studio
Execute SQL to remote MYOB AccountRight data in Jaspersoft Studio.
-
How to connect PolyBase to Zuora
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zuora data.
-
Query Zuora Data as a MySQL Database in Node.js
Execute MySQL queries against Zuora data from Node.js.
-
Connect to Real-Time Microsoft Planner Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Microsoft Planner and Dataflow to import and use Microsoft Planner data in Power Apps.
-
Build AI Agents with Optimizely 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 Optimizely data through CData Connect AI.
-
How to connect to Webflow Data in DBVisualizer
Integrate Webflow data with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software ODBC Driver for PolarTeamPro in MicroStrategy Web
Connect to PolarTeamPro data in MicroStrategy Web using the CData Software ODBC Driver for PolarTeamPro.
-
Work with PDFMonkey Data in FoxPro
Load PDFMonkey data into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Work with Mode Data in AWS Glue Jobs Using JDBC
Connect to Mode from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Configure the CData JDBC Driver for Drip in a Connection Pool in Tomcat
Connect to Drip data from a connection pool in Tomcat.
-
Use Dash to Build Web Apps on HCL Domino Data via CData Connect AI
Build interactive Dash web apps on live HCL Domino data using pandas and the CData Connect AI Python SDK.
-
Integrate Theia IDE with Live RSS 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 RSS feeds from within the development environment.
-
Build SAP Ariba Source-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP Ariba Source data.
-
How to create Visio diagrams from FTP Data
Automatically update FTP data with the changes you make to Visio master shapes.
-
Query QuickBooks Time Data in ColdFusion
Write standard ColdFusion data access code to connect to QuickBooks Time data.
-
Publish Reports with Printful Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Printful data.
-
Access Live Tanda Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Tanda data into the statistical analysis tools available in SAS JMP. This article shows how to use Tanda data in the Graph Builder and Query Builder.
-
Access Zoho Books Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Zoho Books data from HeidiSQL.
-
Bind Live Google Ads Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Google Ads data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Replicate PabblySubscriptions Data in Heroku for Use in Salesforce Connect
Replicate PabblySubscriptions data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build Shopify-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Shopify data.
-
Migrating data from Sage Cloud Accounting to Snowflake using CData SSIS Components.
Easily push Sage Cloud Accounting data to Snowflake using the CData SSIS Tasks for Sage Cloud Accounting and Snowflake.
-
How to create Visio diagrams from Marketo Data
Automatically update Marketo data with the changes you make to Visio master shapes.
-
Integrating Claude Code with FreshBooks Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on FreshBooks data within assisted coding and automated development workflows.
-
Publish Reckon Accounts Hosted-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Reckon Accounts Hosted data.
-
Replicate Multiple Bright Data Accounts via the CData Sync CLI
Replicate multiple Bright Data accounts to one or many databases.
-
Natively Connect to Omnisend Data in PHP
The CData ODBC driver for Omnisend enables you to create PHP applications with connectivity to Omnisend data. Leverage the native support for ODBC in PHP.
-
Integrating Codex with Guru 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.
-
Getting Started with the CData SSIS Components for AdRoll
Complete guide to installing, licensing, and connecting with the CData SSIS Components for AdRoll.
-
Import Amazon DynamoDB Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Amazon DynamoDB Data and provide access to live Amazon DynamoDB data for custom reports in the Power BI Service.
-
Visualize Live Zoho CRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Zoho CRM data into custom reports in Power BI.
-
Integrate Live Timely Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Timely data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Deel 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 Deel and work with Deel data in your FileMaker application.
-
Integrating OpenCode with Deel 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 Microsoft Dataverse Data in DBArtisan
Use wizards in DBArtisan to configure Microsoft Dataverse data as a data source.
-
Getting Started with the CData Python Connector for Gong
Learn to install and license the CData Python Connector and configure a connection to live Gong data.
-
Integrating Dataiku with SAP Ariba Source Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP Ariba Source data.
-
Create Dashboards and Visualize Live Google Cloud Storage Data in Geckoboard
Use CData Connect AI to connect to live Google Cloud Storage data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Rapidly Develop MySQL-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by MySQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Greenhouse
Provide connectivity to Greenhouse data through an SAP BusinessObjects universe.
-
Replicate Campaigner Data to Multiple Databases via the CData Sync CLI
Replicate Campaigner data to disparate databases with a single configuration.
-
Build Semantic Layer Views for Oracle Service Cloud Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Oracle Service Cloud data.
-
Connect to eBay from a Connection Pool in WebLogic
Use the CData JDBC Driver for eBay to connect to eBay data from Web applications running on WebLogic.
-
Use the CData Software ODBC Driver for Samanage in SAS for Real-Time Reporting and Analytics
Connect to real-time Samanage data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Samanage.
-
Klaviyo Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Klaviyo facts in real time.
-
Integrating Claude Code CLI with Printify 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.
-
Automated Continuous Workable Replication to Vertica
Use CData Sync for automated, continuous, customizable Workable replication to Vertica.
-
Build Tavily-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Tavily data.
-
Visualize PDFMonkey Data in Tableau
The CData ODBC driver for PDFMonkey enables you integrate PDFMonkey data into Tableau dashboards.
-
Create Slack-Connected Applications in Appsmith
Connect to Slack Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Slack data.
-
Integrate Devin with Live Paylocity 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 Paylocity data.
-
Integrate Trae with Live Salesforce Pardot Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Salesforce Pardot data from within the AI-powered IDE.
-
Analyze CloudConvert Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze CloudConvert data in Microsoft R Open.
-
Integrate Paylocity Data in the Pentaho Report Designer
Publish reports based on Paylocity data in the Pentaho BI tool.
-
Automate Front Data Replication to Couchbase
Use CData Sync to Customize and automate Front data replication to Couchbase.
-
Edit and Search External Microsoft Exchange Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Microsoft Exchange data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Microsoft Exchange Data objects that you can access from apps and the dashboard.
-
Automated Samanage Data Replication to Teradata
Use CData Sync to Customize and automate Samanage data replication to Teradata.