CData Software - Knowledge Base
Recent Articles
-
Model Email Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Email, enabling the direct import of real-time Email data.
-
Connect to Oracle Data in CloverDX (formerly CloverETL)
Transfer Oracle data using the visual workflow in the CloverDX data integration tool.
-
Use the CData Software ODBC Driver for Anaplan in MicroStrategy
Connect to Anaplan data in MicroStrategy Developer using the CData Software ODBC Driver for Anaplan.
-
Migrating data from Instantly to Snowflake using CData SSIS Components.
Easily push Instantly data to Snowflake using the CData SSIS Tasks for Instantly and Snowflake.
-
Visualize Codat Data in TIBCO Spotfire through ADO.NET
Integrate Codat data into dashboards in TIBCO Spotfire.
-
Create Amazon Athena Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Amazon Athena from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating GitHub Copilot with ZohoInvoice 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.
-
Integrating Antigravity CLI with Phoenix data via CData CLI
Connect Phoenix data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Stream Parallel Data into Apache Kafka Topics
Access and stream Parallel data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Live Cosmos DB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Cosmos DB data and integrate live Cosmos DB data into apps built in Microsoft Power Apps.
-
Getting Started with the CData Connect AI Python SDK for Dynamics 365 Business Central
Install the CData Connect AI Python SDK to read and write live Dynamics 365 Business Central data with standard DB-API 2.0 Python code.
-
Getting Started with the CData Tableau Connector for CouchDB
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for CouchDB.
-
Build Dashboards with Pushbullet Data in Dundas BI
Create dynamic dashboards and perform analytics based on Pushbullet data in Dundas BI.
-
Integrate SAP Netweaver Gateway Data into Power Automate Desktop using CData Connect
CData Connect for SAP Netweaver Gateway Data enables you to integrate SAP Netweaver Gateway data into workflows built using Microsoft Power Automate Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for SAP Ariba Source
Create SAP Ariba Source data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to and Visualize Live IBM Informix Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live IBM Informix data.
-
Build MVC Applications with Connectivity to BigCommerce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BigCommerce from an ASP.NET MVC application.
-
Viewing Microsoft OneDrive Data in RAD Studio Data Explorer
How to view Microsoft OneDrive data in RAD Studio Data Explorer using the CData ODBC Driver for Microsoft OneDrive.
-
Query LinkedIn Ads Data as a MySQL Database in Node.js
Execute MySQL queries against LinkedIn Ads data from Node.js.
-
How to use SQLAlchemy ORM to access Quickbase Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Quickbase data.
-
Automated Continuous Tavily Replication to Vertica
Use CData Sync for automated, continuous, customizable Tavily replication to Vertica.
-
Automated Continuous Optimizely Replication to Databricks
Use CData Sync for automated, continuous, customizable Optimizely replication to Databricks.
-
Establish a Live Connection with Oracle Financials Cloud Data using Tableau Bridge
The CData ODBC Driver for Oracle Financials Cloud enables you to integrate live Oracle Financials Cloud data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Build an ETL App for MailerLite Data in Python with CData
Create ETL applications and real-time data pipelines for MailerLite data in Python with petl.
-
How to load Monday.com data into Elasticsearch via Logstash
Introducing a simple method to load Monday.com data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Dashboards and Visualize Live MailChimp Data in Geckoboard
Use CData Connect AI to connect to live MailChimp data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Connect to Pipedrive Data in RazorSQL
Connect to Pipedrive from wizards and query Pipedrive data from the GUI in the RazorSQL database management tool.
-
Connect to Samanage Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Samanage as an External Source in Dremio.
-
How to import PDFMonkey Data into Apache Solr
Use the CData Software JDBC Driver for PDFMonkey in Data Import Handler and create an automated import of PDFMonkey data to Apache Solr Enterprise Search platform.
-
How to Connect to & Open Factorial Data in Microsoft Excel
This article uses the CData ODBC driver for Factorial to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Integrating Kiro with HBase 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 publish and share SAP Ariba Source Data dashboards with Tableau Server
The CData ODBC driver for SAP Ariba Source enables you integrate SAP Ariba Source data into Tableau dashboards.
-
DataBind Charts to Google Translate Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Translate data 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 with SAP Fieldglass Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP Fieldglass data in SnapLogic.
-
Load Guru Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Guru data to a database.
-
Explore Geographical Relationships in ZohoSubscriptions Data with Power Map
Create data visualizations with ZohoSubscriptions data in Power Map.
-
Integrating OpenCode with Microsoft OneDrive 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.
-
Working with HCL Domino Data in LINQPad
Execute LINQ queries to HCL Domino data in LINQPad.
-
Connect to Outlook Data from a Connection Pool in JBoss
Integrate Outlook data into Java servlets: Use the Management Console in JBoss to install the Outlook JDBC Driver.
-
Visualize Live Asana Data in the Power BI Service
Use CData Connect AI to connect to live Asana data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Supabase to Google BigQuery using CData SSIS Components.
Easily push Supabase data to Google BigQuery using the CData SSIS Tasks for Supabase and Google BigQuery.
-
Work with Zoho Books Data in FoxPro
Load Zoho Books data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Oracle-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Oracle data and build Oracle-connected web apps with Axios.
-
Integrating Antigravity CLI with Salesforce Data 360 data via CData CLI
Connect Salesforce Data 360 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to and Query Tavily Data in QlikView over ODBC
Create data visualizations with Tavily data in QlikView.
-
Connecting Mastra with ShipEngine Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time ShipEngine data, no replication required.
-
How to connect PolyBase to Redis
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Redis data.
-
Integrate Live Zoho Inventory Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoho Inventory data to Blue Prism using the CData ODBC Driver for Zoho Inventory to create automated workflows for repetitive business tasks.
-
Build Shippo-Connected Apps in Choreo
Use CData Connect AI to connect to Shippo Data from Choreo and build custom apps using live Shippo data.
-
Connect to Neo4J Data from Crystal Reports
Use CData Connect AI to connect to and report on live Neo4J data from Crystal Reports.
-
Stream FreeAgent Data into Apache Kafka Topics
Access and stream FreeAgent data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating PingOne Data in Talend Cloud Data Management Platform
Connect PingOne Data with Talend Cloud Data Management Platform using the CData JDBC Driver for PingOne.
-
Analyze Workday Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Workday data and visualize Workday data in SAP Analytics Cloud.
-
Connect to Tanda Data in Ruby
Connect to Tanda data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Google Contacts Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Google Contacts replication to IBM DB2.
-
Connect to JobNimbus Data in HULFT Integrate
Connect to JobNimbus as a JDBC data source in HULFT Integrate
-
Use the CData Software JDBC Driver for AfterShip in MicroStrategy Desktop
Connect to AfterShip data in MicroStrategy Desktop using the CData Software JDBC Driver for AfterShip.
-
How to Query Amazon DynamoDB Data in MySQL Workbench
Execute MySQL queries against live Amazon DynamoDB data from MySQL Workbench.
-
Integrate Certinia Data in Pentaho Data Integration
Build ETL pipelines based on Certinia data in the Pentaho Data Integration tool.
-
Provide OData Services of MessageBird Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MessageBird data by developing a WCF Service Application.
-
Natively Connect to PostgreSQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to PostgreSQL data. Leverage the native support for ODBC in PHP.
-
Analyze SAP SuccessFactors LMS Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of SAP SuccessFactors LMS data and visualize SAP SuccessFactors LMS data in SAP Analytics Cloud.
-
Build Dashboards with Xero Data in DBxtra
Create dynamic dashboards and perform analytics based on Xero data in DBxtra.
-
Integrating Claude Code CLI with Azure Synapse 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 ADO.NET Provider for SAP Business One
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Business One.
-
Automated Continuous Salesforce Marketing Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Google Cloud SQL.
-
Use Agno to Talk to Your Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Instagram data for you.
-
Extract, Transform, and Load Productboard Data in Informatica PowerCenter
Create a simple Workflow for Productboard data in Informatica PowerCenter.
-
Publish Freshsales-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Freshsales data.
-
Create Power BI Reports on Real-Time Dotmailer Data
Use the CData ODBC Driver for Dotmailer to visualize Dotmailer data in Power BI Desktop.
-
Integrate Live Confluence Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Confluence data from within the IDE.
-
Use ChatGPT to Talk to Your Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Jira data for you.
-
Integrate Landbot with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Landbot with External Services.
-
Query, Visualize, and Share live Freshdesk Data in Redash
Use CData Connect AI to connect to live Freshdesk data in Redash for querying, visualizing, and sharing.
-
Build an OLAP Cube in SSAS from Grafana Data
Establish a connection to Grafana data data from SQL Server Analysis Services, and use the Grafana Data Provider to build OLAP cubes for use in analytics and reporting.
-
Extract, Transform, and Load Shippo Data in Informatica PowerCenter
Create a simple Workflow for Shippo data in Informatica PowerCenter.
-
Prepare, Blend, and Analyze Sybase Data in Alteryx Designer (ODBC)
Build workflows to access live Sybase data for self-service data analytics.
-
Create Dynamic Landbot Grids Using the Infragistics XamDataGrid
Learn how you can connect Landbot to Infragistics XamDataGrid to build dynamic grids.
-
Access SAP Business Warehouse Data from MySQL in PHP
Connect to SAP Business Warehouse through the standard MySQL libraries in PHP.
-
Automated Continuous HubDB Replication to MySQL
Use CData Sync for automated, continuous, customizable HubDB replication to MySQL.
-
Import Real-Time Wrike Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Wrike data in ColdFusion.
-
Migrating data from GetResponse to Databricks using CData SSIS Components.
Easily push GetResponse data to Databricks using the CData SSIS Tasks for GetResponse and Databricks.
-
Integrate Cline with Live Shippo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Shippo data from within your IDE.
-
Create Datasets from Azure Analysis Services in Domo Workbench and Build Visualizations of Azure Analysis Services Data in Domo
Use the CData Software ODBC Driver for Azure Analysis Services to create datasets from Azure Analysis Services data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Accelo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Accelo to connect to Accelo data and execute queries in PowerBuilder.
-
Automated Continuous Mailgun Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Mailgun replication to PostgreSQL.
-
Automate PayPal Data Replication to SAP HANA
Use CData Sync to customize and automate PayPal data replication to SAP HANA.
-
How to Connect DBeaver to Harvest via a JDBC Driver
Manage Harvest data with visual tools in DBeaver like the query browser.
-
How to Build an ETL App for Dynamics NAV Data in Python with CData Connect AI
Build ETL pipelines that read and write live Dynamics NAV data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Klaviyo Data in RazorSQL
Connect to Klaviyo from wizards and query Klaviyo data from the GUI in the RazorSQL database management tool.
-
Access Live Highrise Data in AWS Lambda
Connect to live Highrise data in AWS Lambda using the CData JDBC Driver.
-
Connect to LightSpeedRetail Data in DBArtisan
Use wizards in DBArtisan to configure LightSpeedRetail data as a data source.
-
Getting Started with the CData Python Connector for FreshBooks
Learn to install and license the CData Python Connector and configure a connection to live FreshBooks data.
-
Build Charts with ElevenLabs Data in Clear Analytics
Create dynamic charts and perform analytics based on ElevenLabs data in Clear Analytics.
-
Connect to SageHR Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SageHR data.
-
Use the CData ODBC Driver for Sentry in Microsoft Power Query
You can use the CData Sentry ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sentry data into Microsoft Power Query.
-
Replicate Multiple SendPulse Accounts
Replicate multiple SendPulse accounts to one or many databases.
-
Connecting Agentforce with Elasticsearch 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 Elasticsearch data for you.
-
Connect to Klipfolio Data from a Connection Pool in Jetty
The Klipfolio JDBC Driver supports connection pooling: This article shows how to connect faster to Klipfolio data from Web apps in Jetty.
-
Access Live Power BI XMLA Data in Excel 365 Online (Excel for the web)
Connect to Power BI XMLA data from Excel 365 Online (Excel for the web) with CData Connect AI.