CData Software - Knowledge Base
Recent Articles
-
How to connect and process ClickTime from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ClickTime.
-
Use the CData ODBC Driver for MYOB AccountRight in Microsoft Power Query
You can use the CData MYOB AccountRight ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MYOB AccountRight into Microsoft Power Query.
-
Integrate IBM Informix with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate IBM Informix with External Services.
-
Integrate AlloyDB Data in Pentaho Data Integration
Build ETL pipelines based on Google AlloyDB in the Pentaho Data Integration tool.
-
Factorial Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Factorial facts in real time.
-
Replicate Box Data to Multiple Databases via the CData Sync CLI
Replicate Box to disparate databases with a single configuration.
-
Getting Started with the CData ODBC Driver for SAP ByDesign
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP ByDesign.
-
Automated Continuous LinkedIn Ads Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to Apache Kafka.
-
How to Seamlessly Import Helpscout Data into IBM SPSS Modeler
Integrate Helpscout data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Codex CLI with Planio 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.
-
Create Mailgun Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Mailgun from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Reckon Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Reckon in the Denodo Virtual DataPort Administrator.
-
Work with Google Forms Data in FoxPro
Load Google Forms into a FoxPro database. This article includes full code and a walk-through of the process.
-
Replicate Wistia Data to Multiple Databases
Replicate Wistia to disparate databases with a point-and-click configuration.
-
Connect to RSS Feeds in Ruby
Connect to RSS Feeds in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
View Reports on Real-Time Amplitude Data in Power BI Report Server
Use the CData ODBC Driver for Amplitude to visualize Amplitude in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating LangChain with eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on eBay within automated workflows.
-
How to import ConvertAPI Data into Apache Solr
Use the CData Software JDBC Driver for ConvertAPI in Data Import Handler and create an automated import of ConvertAPI to Apache Solr Enterprise Search platform.
-
How to use SQLAlchemy ORM to access Splunk Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Splunk.
-
How to Connect to Live SurveyMonkey Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live SurveyMonkey without replication.
-
Build Jira Assets-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Jira Assets to explore live Jira Assets Data in Cursor to assist with building Jira Assets-powered applications.
-
Analyze Elasticsearch Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Elasticsearch and visualize Elasticsearch in SAP Analytics Cloud.
-
Build Automated Instagram-Connected Workflows in Zapier
Use CData Connect AI to connect to live Instagram and build automated workflows in Zapier.
-
Connect to Typeform Data in DBArtisan
Use wizards in DBArtisan to configure Typeform as a data source.
-
Integrate FreeAgent Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live FreeAgent from Informatica Cloud.
-
Design BIRT Reports on Harvest Data
Provide current Harvest to your embedded analytics.
-
How to Connect to Paddle Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Paddle. Leverage the pyodbc module for ODBC in Python.
-
Work with PingOne Data in FoxPro
Load PingOne into a FoxPro database. This article includes full code and a walk-through of the process.
-
Getting Started with the CData Connect AI Python SDK for Google Cloud Storage
Install the CData Connect AI Python SDK to read and write live Google Cloud Storage with standard DB-API 2.0 Python code.
-
Connect to Email Data in ACL Analytics
Connect to Email via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Email.
-
Access Adobe Target Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Adobe Target from HeidiSQL.
-
How to Create Power BI Visual Reports with Real-Time Odoo Data
Use CData Power BI Connectors to visualize Odoo ERP in Power BI.
-
Build SQL Server-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SQL Server to explore live SQL Server Data in Claude Code to assist with building SQL Server-powered applications.
-
Integrate Live Oracle Service Cloud Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Oracle Service Cloud from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Oracle Service Cloud.
-
Use the CData Software ODBC Driver for CircleCI in MicroStrategy Web
Connect to CircleCI in MicroStrategy Web using the CData Software ODBC Driver for CircleCI.
-
Automated Continuous Twilio Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Twilio replication to Google Cloud SQL.
-
How to connect to Float Data from IntelliJ
Integrate connectivity to Float with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Oracle Service Cloud in MicroStrategy
Connect to Oracle Service Cloud in MicroStrategy Developer using the CData Software ODBC Driver for Oracle Service Cloud.
-
Build Gmail-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Gmail and build web apps with connectivity to live Gmail.
-
Explore Geographical Relationships in MailChimp Data with Power Map
Create data visualizations with MailChimp in Power Map.
-
Build LinkedIn-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live LinkedIn.
-
Connect to JotForm Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for JotForm to connect to JotForm and execute queries in PowerBuilder.
-
Integrate Goose with Live Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Klaviyo from within the local AI agent.
-
Build Visualizations of Amazon Athena Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Amazon Athena in Birst.
-
Visualize Live SpaceX Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SpaceX using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect Amazon QuickSight to Microsoft Dataverse Data
Create a connection to Microsoft Dataverse (CDS) in CData Connect AI and insert Microsoft Dataverse (CDS) into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to Airtable Data in Claris FileMaker Pro
Use the CData ODBC Driver for Airtable in FileMaker Pro to connect to Airtable and work with Airtable in your FileMaker applications.
-
Object-Relational Mapping (ORM) with Printful Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Printful into a Java-based ORM framework, Hibernate.
-
Build Trello-Connected Apps in Choreo
Use CData Connect AI to connect to Trello Data from Choreo and build custom apps using live Trello.
-
Automate Slack Data Replication to Couchbase
Use CData Sync to Customize and automate Slack replication to Couchbase.
-
How to Design SAS Data Sets Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SAS Data Sets from mobile and tablet Power Apps.
-
Connect to Snapchat Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Snapchat Ads in FileMaker Pro to connect to Snapchat Ads and work with Snapchat Ads in your FileMaker applications.
-
Natively Connect to Freshteam Data in PHP
The CData ODBC driver for Freshteam enables you to create PHP applications with connectivity to Freshteam. Leverage the native support for ODBC in PHP.
-
Enable the Okta JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Okta.
-
Use the CData Software JDBC Driver for Apollo in MicroStrategy
Connect to Apollo in MicroStrategy Developer using the CData Software JDBC Driver for Apollo.
-
Manage SharePoint Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SharePoint.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho Inventory
Provide connectivity to Zoho Inventory through an SAP BusinessObjects universe.
-
Automated Continuous Drip Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Drip replication to OneLake in Microsoft Fabric.
-
Build PolarTeamPro-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PolarTeamPro.
-
Visualize Twitter Ads Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Twitter Ads.
-
Build Visualizations of MessageBird Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of MessageBird in Birst.
-
Getting Started with the CData SSIS Components for Cohere
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Cohere.
-
Integrating Claude Code CLI with SFTP 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.
-
Operational Reporting on Instantly Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Instantly.
-
Automated Continuous Salesforce Marketing Replication to Databricks
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Databricks.
-
Connect to Avalara AvaTax Data from a Connection Pool in JBoss
Integrate Avalara AvaTax into Java servlets: Use the Management Console in JBoss to install the Avalara AvaTax JDBC Driver.
-
Import Real-Time Google Directory Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Google Directory in ColdFusion.
-
Automated Continuous NetSuite SuiteAnalytics Replication to IBM DB2
Use CData Sync for automated, continuous, customizable NetSuite SuiteAnalytics replication to IBM DB2.
-
Connect to QuickBooks Data from PowerBuilder
This article demonstrates how to access QuickBooks data from PowerBuilder using the CData ADO.NET Provider for QuickBooks.
-
Build SAS xpt-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAS xpt to explore live SAS xpt Data in GitHub Copilot to assist with building SAS xpt-powered applications.
-
How to Connect to Live Google Sheets Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Google Sheets for you.
-
Build Apps with Live Google Spanner in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Spanner into the Adalo platform and build custom mobile and web applications with real-time Google Spanner.
-
Use Biml to Build SSIS Tasks to Replicate Yelp Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Yelp to SQL Server.
-
Use Dash to Build to Web Apps on Shopify Data
Create Python applications that use pandas and Dash to build Shopify-connected web apps.
-
Automated Continuous SAP Fieldglass Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Vertica.
-
Import Paylocity Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Paylocity Data and provide access to live Paylocity for custom reports in the Power BI Service.
-
Create Informatica Mappings From/To an ODBC Data Source for BigCommerce
Create an ODBC connection to BigCommerce in Informatica and browse and transfer BigCommerce.
-
Create Power BI Reports on Real-Time CampaignMonitor Data
Use the CData ODBC Driver for CampaignMonitor to visualize CampaignMonitor in Power BI Desktop.
-
Automated Continuous ZohoInvoice Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable ZohoInvoice replication to delimited files (CSV/TSV).
-
Access Live Square Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Square from your Excel spreadsheets.
-
How to Query Live CSV Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live CSV/TSV Files data in natural language using Python.
-
Publish Crystal Reports on Gmail Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Gmail.
-
Process & Analyze Microsoft Exchange Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Microsoft Exchange Data.
-
Connect to Tally from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Tally ERP, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Build Visualizations of Harvest Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Harvest in Birst.
-
Integrate ChargeOver Data in Pentaho Data Integration
Build ETL pipelines based on ChargeOver in the Pentaho Data Integration tool.
-
Model, Search, and Visualize Live Confluence Data in ThoughtSpot
Use CData Connect AI to connect to live Atlassian Confluence for modeling, searching, and visualizing.
-
Connect to xBase Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time xBase using standard SQL.
-
Integrate Invoiced Data in the Pentaho Report Designer
Publish reports based on Invoiced in the Pentaho BI tool.
-
Access Amplitude Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Amplitude.
-
Build Visualizations of Datadog Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Datadog in Birst.
-
Build Power BI XMLA Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Power BI XMLA and build visualizations in Tableau.
-
Integrate Avalara AvaTax with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Avalara AvaTax with External Services.
-
Create Pipedrive-Connected Business Apps in AppSheet
Connect to Pipedrive Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Pipedrive.
-
How to Access Live Presto Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Presto enables you to integrate Presto into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous Oracle Replication to Databricks
Use CData Sync for automated, continuous, customizable Oracle replication to Databricks.
-
LINQ to Mailgun Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Mailgun Data Provider.
-
Build a Simple VCL Application for Optimizely Data
How to build a simple VCL Application to view Optimizely in RAD Studio using the CData ODBC Driver for Optimizely.
-
How to Query AdRoll Data in MySQL Workbench
Execute MySQL queries against live AdRoll from MySQL Workbench.
-
Connect to Zoho Creator Data in Google Apps Script via Connect AI
Use CData Connect AI to access Zoho Creator in Google Apps Script.