CData Software - Knowledge Base
Recent Articles
-
Analyze Office 365 Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Microsoft Office 365 and visualize Microsoft Office 365 in SAP Analytics Cloud.
-
Create a Data Access Object for BambooHR Data using JDBI
A brief overview of creating a SQL Object API for BambooHR in JDBI.
-
Using the CData Software ODBC Driver for Billsby in PyCharm
Connect to Billsby as an ODBC data source in PyCharm using the CData Software ODBC Driver for Billsby.
-
MongoDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MongoDB through CData Connect AI using different applications and tools.
-
Bidirectional Access to Blackbaud FE NXT Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Blackbaud FE NXT in Filemaker Pro for Mac or Windows.
-
Using the CData Software ODBC Driver for IBM Cloud Object Storage in PyCharm
Connect to IBM Cloud Object Storage as an ODBC data source in PyCharm using the CData Software ODBC Driver for IBM Cloud Object Storage.
-
Import and Visualize ConvertAPI Data in Power View
Create data visualizations based on ConvertAPI in Excel.
-
How to Access Live Mailgun Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mailgun enables you to integrate Mailgun into workflows built using Microsoft Power Automate Desktop.
-
Create Datasets from XML in Domo Workbench and Build Visualizations of XML Data in Domo
Use the CData Software ODBC Driver for XML to create datasets from XML Files in Domo Workbench and then build visualizations in the Domo service.
-
Integrating OpenCode Terminal with Klaviyo 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 Zoom Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Zoom replication to OneLake in Microsoft Fabric.
-
Automated Continuous Aha! Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Aha! replication to Amazon S3.
-
Visualize Live Wave Financial Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Wave Financial.
-
Create Data Visualizations in Cognos BI with Omnisend Data
Access Omnisend as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Webflow Data in Ruby
Connect to Webflow in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Power BI Reports on Real-Time XML Data
Use the CData ODBC Driver for XML to visualize XML Files in Power BI Desktop.
-
Connect Impala Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apache Impala using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for SAP HANA
Provide connectivity to SAP HANA through an SAP BusinessObjects universe.
-
Access Live Amazon Athena Data in AWS Lambda
Connect to live Amazon Athena in AWS Lambda using the CData JDBC Driver.
-
Connect to Shopify Data in RapidMiner
Integrate Shopify with standard components and data source configuration wizards in RapidMiner Studio.
-
Create SSAS Tabular Models from Helpscout Data
How to build a SQL Server Analysis Service Tabular Model from Helpscout using CData drivers.
-
Connect Jumpseller to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Jumpseller using the CData Python MCP Server.
-
Connect to Retently Data in Aqua Data Studio
Access Retently from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Scrapfly Data from PowerBuilder via JDBC
This article demonstrates how to access Scrapfly from PowerBuilder using the Scrapfly JDBC Driver.
-
Connect to Lakebase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Lakebase and the Script function in FileMaker Pro to connect to Lakebase and work with Lakebase in your FileMaker application.
-
Create Informatica Mappings From/To an ODBC Data Source for Contentful
Create an ODBC connection to Contentful in Informatica and browse and transfer Contentful.
-
Extend Google Sheets with Kafka Data
Make calls to Kafka from Google Apps Script via the API Server.
-
Connect to Certinia Data in Aqua Data Studio
Access Certinia from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Azure Analysis Services Data in TIBCO Spotfire through ADO.NET
Integrate Azure Analysis Services into dashboards in TIBCO Spotfire.
-
Automated Continuous Splunk Replication to SQLite
Use CData Sync for automated, continuous, customizable Splunk replication to SQLite.
-
Feed Teradata Data into FineReport
How to set Teradata as a JDBC data source in FineReport.
-
Access Live Oracle Financials Cloud Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Financials Cloud from your Google Sheets.
-
Use JayDeBeApi to access CockroachDB Data in Python
Use standard Python scripting and the development environment of your choice to access live CockroachDB.
-
Create Informatica Mappings From/To an ODBC Data Source for Reply.io
Create an ODBC connection to Reply.io in Informatica and browse and transfer Reply.io.
-
Getting Started with the CData ADO.NET Provider for Google Search
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Search.
-
How to Query Bullhorn CRM Data in MySQL Workbench
Execute MySQL queries against live Bullhorn CRM from MySQL Workbench.
-
Build Charts with SAP ByDesign Data in Clear Analytics
Create dynamic charts and perform analytics based on SAP Business ByDesign in Clear Analytics.
-
Getting Started with the CData Python Connector for Nuclia
Learn to install and license the CData Python Connector
-
How to connect and process Sendwithus from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Sendwithus.
-
Connect to Harvest Data in Ruby
Connect to Harvest in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect to Trello Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Trello and the SQL Gateway to access Trello from Google Apps Script.
-
Automated Continuous AdRoll Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable AdRoll replication to Apache Kafka.
-
Integrating Claude Code with Google Contacts Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Google Contacts within assisted coding and automated development workflows.
-
Connect to Aweber Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Aweber as an External Source in Dremio.
-
Build AI/ML Models with Live Clockify Data using Dataiku
Connect Clockify Data with Dataiku using the CData API Driver for JDBC.
-
Build SAP BusinessObjects BI-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SAP BusinessObjects BI and build SAP BusinessObjects BI-connected web apps with Axios.
-
Natively Connect to Mailgun Data in PHP
The CData ODBC driver for Mailgun enables you to create PHP applications with connectivity to Mailgun. Leverage the native support for ODBC in PHP.
-
How to Connect DBeaver to Cosmos DB via a JDBC Driver
Manage Azure Cosmos DB with visual tools in DBeaver like the query browser.
-
Use Dash to Build Web Apps on EnterpriseDB Data via CData Connect AI
Build interactive Dash web apps on live EnterpriseDB using pandas and the CData Connect AI Python SDK.
-
Connect Active Directory to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Active Directory using the CData Python MCP Server.
-
Connect Apollo Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Apollo using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrating Kiro CLI with Dynamics 365 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.
-
Visualize Cassandra Data in Tableau
The CData ODBC driver for Cassandra enables you integrate Apache Cassandra into Tableau dashboards.
-
Build Charts with xBase Data in Clear Analytics
Create dynamic charts and perform analytics based on xBase in Clear Analytics.
-
How to Query Live Xero Data in Claude Desktop
Connect to and query live Xero Data in Claude Desktop using CData MCP Server.
-
Access Live DB2 Data in Excel 365 Online (Excel for the web)
Connect to IBM DB2 from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Data Flows from Unbounce to SQL Server using SSIS
Easily back up Unbounce to SQL Server using the SSIS components for Unbounce.
-
Build Pipelines with Live Cassandra Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Cassandra from Google Cloud Data Fusion, enabling the integration of live Apache Cassandra into the building and management of effective data pipelines.
-
Connect to Outlook Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Outlook and work with Outlook in your FileMaker applications.
-
Visualize Webflow Data in Tableau
The CData ODBC driver for Webflow enables you integrate Webflow into Tableau dashboards.
-
Integrate Impala Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Apache Impala and integrate live Apache Impala into your Power Automate tasks.
-
Integrate CouchDB Data into Power Automate Desktop using CData Connect
CData Connect for CouchDB Data enables you to integrate Apache CouchDB into workflows built using Microsoft Power Automate Desktop.
-
Access Live BigCommerce Data in AWS Lambda (with IntelliJ IDEA)
Connect to live BigCommerce in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Configure the CData JDBC Driver for xBase in a Connection Pool in Tomcat
Connect to xBase from a connection pool in Tomcat.
-
DataBind Charts to Epicor Kinetic Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Epicor Kinetic 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.
-
Integrate Telegram Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Telegram from Informatica Cloud.
-
How to Connect DBeaver to HBase via a JDBC Driver
Manage Apache HBase with visual tools in DBeaver like the query browser.
-
Work with Act CRM Data in FoxPro
Load Act CRM into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to Act-On Data in DBeaver
Use the CData ODBC Driver to connect to Act-On in DBeaver.
-
Connect to Real-Time Outreach.io Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Outreach.io and Dataflow to import and use Outreach.io in Power Apps.
-
Replicate ActiveCampaign Data to Multiple Databases via the CData Sync CLI
Replicate ActiveCampaign to disparate databases with a single configuration.
-
Create Data Visualizations in Cognos BI with Azure DevOps Data
Access Azure DevOps as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Kiro 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.
-
Moving Data from Pipedrive to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pipedrive data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Missive-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Missive.
-
How to create Acumatica federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Acumatica ERP in MySQL .
-
Easily Integrate Workable Data in Lazarus Pascal IDE
Learn how to easily integrate live Workable in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automated Continuous MongoDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable MongoDB replication to SQL Server.
-
Natively Connect to Templated Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Templated. Leverage the native support for ODBC in PHP.
-
Build Dashboards with Hacker News Data in DBxtra
Create dynamic dashboards and perform analytics based on Hacker News in DBxtra.
-
Integrate Live Act-On Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Access ScrapingBee Data Using Entity Framework
This article shows how to access ScrapingBee using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Freshservice Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Freshservice replication to delimited files (CSV/TSV).
-
Build a PostgreSQL Interface for Spark Data using the CData JDBC Driver
Use the Remoting features of the Spark JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Snapchat Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Snapchat Ads to connect to Snapchat Ads from Web applications running on WebLogic.
-
Visualize Live Demio Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Demio.
-
Access Live Vertica Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Vertica from your Google Sheets.
-
How to connect to Workday Data from Spring Boot
Connect to Workday in a Spring Boot Application using the CData JDBC Driver for Workday
-
Publish Reports with Sybase IQ Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sybase IQ.
-
How to connect Amazon QuickSight to Trello Data
Create a connection to Trello in CData Connect AI and insert Trello into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Cursor CLI with Tanda 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.
-
Manage Hive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Hive.
-
Add Klaviyo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Klaviyo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for AfterShip
Provide connectivity to AfterShip through an SAP BusinessObjects universe.
-
Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy Web
Connect to Microsoft Dynamics NAV in MicroStrategy Web using the CData Software JDBC Driver for Dynamics NAV.
-
How to Connect to Sybase IQ Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Sybase IQ. Leverage the pyodbc module for ODBC in Python.
-
How to Visualize Hive 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 Apache Hive in Python.
-
How to connect to Recurly Data with Squirrel SQL client
Connect to Recurly and execute queries in the Squirrel SQL Client.
-
Access Live REST Data in AWS Lambda (with IntelliJ IDEA)
Connect to live REST in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Create Reports with Autopilot Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Autopilot.