CData Software - Knowledge Base
Recent Articles
-
Using the CData Software ODBC Driver for Invoiced in PyCharm
Connect to Invoiced as an ODBC data source in PyCharm using the CData Software ODBC Driver for Invoiced.
-
Epicor Kinetic Reporting in OBIEE with the Epicor Kinetic JDBC Driver
Deploy the Epicor Kinetic JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to HBase Data from a Connection Pool in Jetty
The HBase JDBC Driver supports connection pooling: This article shows how to connect faster to HBase data from Web apps in Jetty.
-
Automated Continuous Calendly Replication to SQLite
Use CData Sync for automated, continuous, customizable Calendly replication to SQLite.
-
Analyze SuiteCRM Data in Cognos Analytics
Use CData Connect AI to connect to SuiteCRM Data from Cognos Analytics and analyze live SuiteCRM data.
-
Integrate IBM Informix Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to IBM Informix data and integrate live IBM Informix data into your Power Automate tasks.
-
Build Pipelines with Live Google Calendar Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Calendar from Google Cloud Data Fusion, enabling the integration of live Google Calendar data into the building and management of effective data pipelines.
-
Connect and Query Live Facebook Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Facebook data into Databricks and enable direct, live querying and analysis without replication.
-
Replicate Reckon Accounts Hosted Data in Heroku for Use in Salesforce Connect
Replicate Reckon Accounts Hosted data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Figshare Data in Cognos Analytics
Use CData Connect AI to connect to Figshare Data from Cognos Analytics and analyze live Figshare data.
-
Analyze GitLab Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze GitLab data in Microsoft R Open.
-
Connecting Moonlit Workflow with Google Ads 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 Google Ads data in real time.
-
Connect to Templated from Asprova with CData Software ODBC Driver for Templated
This article shows how to connect faster to Templated data from Asprova.
-
Connect to Bullhorn CRM Data in Jaspersoft Studio
Execute SQL to remote Bullhorn CRM data in Jaspersoft Studio.
-
Automated Continuous SingleStore Replication to Databricks
Use CData Sync for automated, continuous, customizable SingleStore replication to Databricks.
-
Automated Continuous ZohoSubscriptions Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoSubscriptions replication to delimited files (CSV/TSV).
-
Automated SpaceX Data Replication to Teradata
Use CData Sync to Customize and automate SpaceX data replication to Teradata.
-
Query Mouseflow Data in DataGrip
Create a Data Source for Mouseflow in DataGrip and use SQL to query live Mouseflow data.
-
Easily Integrate Coinbase Data in Lazarus Pascal IDE
Learn how to easily integrate live Coinbase data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Live FHIR Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live FHIR data.
-
Use Dash to Build to Web Apps on Freshsales Data
Create Python applications that use pandas and Dash to build Freshsales-connected web apps.
-
How to connect to ElevenLabs Data from Spring Boot
Connect to ElevenLabs in a Spring Boot Application using the CData API Driver for JDBC
-
Snowflake Reporting in OBIEE with the Snowflake JDBC Driver
Deploy the Snowflake JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build Act CRM-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Act CRM Data and create custom apps in Mendix.
-
Use Dash to Build to Web Apps on Highrise Data
Create Python applications that use pandas and Dash to build Highrise-connected web apps.
-
Connecting Agentforce with QuickBooks Online 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 QuickBooks Online data for you.
-
How to Connect Blackbaud FE NXT 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 Blackbaud FE NXT data in real time using natural language.
-
How to connect Amazon QuickSight to Klaviyo Data
Create a connection to Klaviyo data in CData Connect AI and insert Klaviyo data into Amazon QuickSight SPICE to build interactive dashboards.
-
Rapidly Develop Customer.io-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 Customer.io.
-
Use Microsoft Copilot Studio to talk to your Shortcut 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 Shortcut data for you.
-
Integrate Dify with Live Timely 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 Timely data.
-
Build Suadeo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Suadeo data and build visualizations in Tableau Cloud.
-
Connect to Postmark in SpagoBI
Create reports featuring live Postmark data in SpagoBI Studio. Host Postmark reports on SpagoBI Server.
-
Analyze Salesforce Pardot Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Salesforce Pardot from Power Pivot. You will use the Table Import Wizard to load Salesforce Pardot data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for Workable
Learn to install and license the CData Python Connector and configure a connection to live Workable data.
-
Build Semantic Layer Views for Cloudflare Data in APOS Live Data Gateway
Use the CData Connector for Cloudflare in APOS Live Data Gateway to build Semantic Layer Views for Cloudflare data.
-
How to Seamlessly Import Clio Data into IBM SPSS Modeler
Integrate Clio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Edit and Search External WooCommerce Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of WooCommerce data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create WooCommerce Data objects that you can access from apps and the dashboard.
-
Connect to Asana Data in JRuby
Create a simple JRuby app with access to live Asana data.
-
Getting Started with the CData ADO.NET Provider for Bannerbear
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Import Real-Time Zoho Recruit Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Zoho Recruit data in ColdFusion.
-
Automated Continuous Sage 200 Replication to SQL Server
Use CData Sync for automated, continuous, customizable Sage 200 replication to SQL Server.
-
Integrate FHIR Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to FHIR data and integrate live FHIR data into your Power Automate tasks.
-
Write a Simple Go Application to work with Autopilot Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Autopilot data.
-
Automate Instagram Data Replication to SAP HANA
Use CData Sync to customize and automate Instagram data replication to SAP HANA.
-
Using the CData Software ODBC Driver for Foursquare in PyCharm
Connect to Foursquare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Foursquare.
-
Query DB2 Data as a SQL Server Database in Node.js
Execute SQL Server queries against DB2 data from Node.js.
-
View Reports on Real-Time ConstantContact Data in Power BI Report Server
Use the CData ODBC Driver for ConstantContact to visualize ConstantContact data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use Biml to Build SSIS Tasks to Replicate Qualaroo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Qualaroo data to SQL Server.
-
Analyze Live Vertica Data in SAS Viya
Use CData Connect AI to connect to Vertica data from SAS Viya and deploy self-service analytics using live Vertica data.
-
Connect to GetResponse from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from GetResponse data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use Biml to Build SSIS Tasks to Replicate Monday.com Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Monday.com data to SQL Server.
-
Connect to Salesforce from Asprova with CData Software ODBC Driver for Salesforce
This article shows how to connect faster to Salesforce data from Asprova.
-
Connect to Google Ads Data in NetBeans
Connect to Google Ads data in NetBeans with the data source configuration wizard.
-
Connect to Superchat Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Superchat and work with Superchat data in your FileMaker applications.
-
Create SAP HANA XS Advanced Dataflows on PowerBI.com
Connect to the CData Power BI Connector for SAP HANA XS Advanced from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous MailerLite Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable MailerLite replication to Apache Cassandra.
-
Work with Live Airtable Data in Power Query
Use CData Connect AI to connect to Airtable data and work with live Airtable data in Microsoft Power Query.
-
Access Live Bitbucket Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Bitbucket data from your Excel spreadsheets.
-
Query DB2 Data in DataGrip
Create a Data Source for DB2 in DataGrip and use SQL to query live DB2 data.
-
Connect to Greenplum Data in HULFT Integrate
Connect to Greenplum as a JDBC data source in HULFT Integrate
-
Add Zoho Creator Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Zoho Creator with the Informatica Enterprise Data Catalog to classify and organize data.
-
Intercom Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Intercom facts in real time.
-
Integrate with ShipEngine Data in JReport Designer
Create charts and reports based on ShipEngine data in JReport Designer.
-
Automated Continuous Greenhouse Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Greenhouse replication to Google BigQuery.
-
How to Connect to Live Google Drive 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 Google Drive data for you.
-
Integrate with NetSuite SuiteAnalytics Data in SnapLogic
Use CData Connect AI to connect to and integrate with live NetSuite SuiteAnalytics data in SnapLogic.
-
Build MYOB AccountRight-Connected Apps in Choreo
Use CData Connect AI to connect to MYOB AccountRight Data from Choreo and build custom apps using live MYOB AccountRight data.
-
Load Vercel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Vercel data to a database.
-
Use the CData Software JDBC Driver for Drip in MicroStrategy Web
Connect to Drip data in MicroStrategy Web using the CData Software JDBC Driver for Drip.
-
Integrate Real-Time Access to Sage 300 in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Sage 300 data in real time.
-
How to Connect the Power BI Service to HBase: Complete Guide
Connect to the CData Software Power BI Connector for HBase from PowerBI.com to provide real-time HBase data across the organization.
-
Analyze HBase Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HBase from Power Pivot. You will use the Table Import Wizard to load HBase data. You can visually build the import query or use any SQL supported by the driver.
-
View Reports on Real-Time Snowflake Data in Power BI Report Server
Use the CData ODBC Driver for Snowflake to visualize Snowflake data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Oracle SCM Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle SCM data from your Google Sheets.
-
Build Apps with Live Yelp Data Using the Low-Code Development Platform of Mendix
Connect Yelp data with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize ConvertAPI Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to ConvertAPI data.
-
How to Connect the Power BI Service to Azure DevOps: Complete Guide
Connect to the CData Software Power BI Connector for Azure DevOps from PowerBI.com to provide real-time Azure DevOps data across the organization.
-
Query Act-On Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Act-On data from Node.js.
-
How to Query Dynamics 365 Data in MySQL Workbench
Execute MySQL queries against live Dynamics 365 data from MySQL Workbench.
-
Getting Started with the CData Excel Add-In for Freshsales
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshsales.
-
Build a Singer.io Tap for ZendeskSell With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ZendeskSell data using the CData Python Connector.
-
Analyze SAP Fieldglass Data in Looker
Use CData Connect AI to connect to SAP Fieldglass Data from Looker and build custom apps using live SAP Fieldglass data.
-
Integrate Theia IDE with Live Snapchat Ads 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 Snapchat Ads data from within the development environment.
-
How to Build an ETL App for ServiceNow Data in Python with CData
Create ETL applications and real-time data pipelines for ServiceNow data in Python with petl.
-
Automated Continuous Coinbase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Coinbase replication to Amazon Redshift.
-
Integrating Cursor with YouTube Analytics 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 Connect to & Open ZohoDesk Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoDesk to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Replicate Multiple Cloudflare Accounts
Replicate multiple Cloudflare accounts to one or many databases.
-
Automated Continuous HDFS Replication to AlloyDB
Use CData Sync for automated, continuous, customizable HDFS replication to AlloyDB.
-
How to connect to HubSpot Data from Spring Boot
Connect to HubSpot in a Spring Boot Application using the CData JDBC Driver for HubSpot
-
Visualize Live Outreach.io Data in the Power BI Service
Use CData Connect AI to connect to live Outreach.io data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with live MarkLogic Data in Jitterbit
Use CData Connect AI to connect to and integrate live MarkLogic data in Jitterbit.
-
ETL Authorize.Net in Oracle Data Integrator
This article shows how to transfer Authorize.Net data into a data warehouse using Oracle Data Integrator.
-
Connect to IBM Cloud Object Storage Data in Aqua Data Studio
Access IBM Cloud Object Storage data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to work with Teradata Data in Apache Spark using SQL
Access and process Teradata Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Simplesat Data Replication to Azure Data Lake
Use CData Sync to customize and automate Simplesat data replication to Azure Data Lake.
-
Create Stripe-Connected Nintex Workflows
Use CData Connect AI to connect to Stripe Data from Nintex Workflow Cloud and build custom workflows using live Stripe data.
-
Getting Started with the CData Python Connector for Suadeo
Learn to install and license the CData Python Connector and configure a connection to live Suadeo data.
-
Rapidly Develop PhantomBuster-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 PhantomBuster.