CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Greenhouse Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Greenhouse replication to Google Cloud SQL.
-
Tally Reporting in OBIEE with the Tally JDBC Driver
Deploy the Tally JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to publish and share Adobe Target Data dashboards with Tableau Server
The CData ODBC driver for Adobe Target enables you integrate Adobe Target into Tableau dashboards.
-
Deploy the ADO.NET Provider for Google Translate on an SSRS Report Server
Connect to Google Translate from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to create Amazon Marketplace federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Amazon Marketplace in MySQL .
-
Automated Continuous SAP Replication to MongoDB
Use CData Sync for automated, continuous, customizable SAP replication to MongoDB.
-
How to Connect the Power BI Service to Elasticsearch: Complete Guide
Connect to the CData Software Power BI Connector for Elasticsearch from PowerBI.com to provide real-time Elasticsearch across the organization.
-
Design BIRT Reports on Cohere Data
Provide current Cohere to your embedded analytics.
-
Access Xero Data from MySQL in PHP
Connect to Xero through the standard MySQL libraries in PHP.
-
Build a Simple VCL Application for Jumpseller Data
How to build a simple VCL Application to view Jumpseller in RAD Studio using the CData ODBC Driver for Jumpseller.
-
Access Live SAP Concur Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP Concur from your Excel spreadsheets.
-
Create Dynamic ChartMogul Grids Using the Infragistics XamDataGrid
Learn how you can connect ChartMogul to Infragistics XamDataGrid to build dynamic grids.
-
How to Connect the Power BI Service to Cosmos DB: Complete Guide
Connect to the CData Software Power BI Connector for Cosmos DB from PowerBI.com to provide real-time Azure Cosmos DB across the organization.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Foursquare
Provide connectivity to Foursquare through an SAP BusinessObjects universe.
-
Easily Integrate ScrapingBee Data in Lazarus Pascal IDE
Learn how to easily integrate live ScrapingBee in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build SAP SuccessFactors Visualizations in Tableau Cloud
Use CData Connect AI to connect to live SAP SuccessFactors and build visualizations in Tableau Cloud.
-
Query ZarMoney Data in ColdFusion
Write standard ColdFusion data access code to connect to ZarMoney.
-
Use the CData ODBC Driver for Zoho Inventory in Microsoft Power Query
You can use the CData Zoho Inventory ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zoho Inventory into Microsoft Power Query.
-
Import Real-Time SpaceX Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use SpaceX in ColdFusion.
-
Create Datasets from ClickTime in Domo Workbench and Build Visualizations of ClickTime Data in Domo
Use the CData Software ODBC Driver for ClickTime to create datasets from ClickTime in Domo Workbench and then build visualizations in the Domo service.
-
Connect to ZohoExpense Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to ZohoExpense and work with ZohoExpense in your FileMaker applications.
-
Build Apps with Live ChargeOver Data Using the Low-Code Development Platform of Mendix
Connect ChargeOver with Mendix to build apps using the CData API Driver for JDBC.
-
Visualize Live Xero Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Xero Accounting using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Extract, Transform, and Load Adobe Experience Manager Data in Informatica PowerCenter
Create a simple Workflow for Adobe Experience Manager in Informatica PowerCenter.
-
A PostgreSQL Interface for Epicor Kinetic Data (MySQL Remoting via JDBC)
Use the Remoting features of the Epicor Kinetic JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software JDBC Driver for Postmark in MicroStrategy Web
Connect to Postmark in MicroStrategy Web using the CData Software JDBC Driver for Postmark.
-
Use the CData Software JDBC Driver for Adobe Commerce in MicroStrategy Web
Connect to Adobe Commerce in MicroStrategy Web using the CData Software JDBC Driver for Adobe Commerce.
-
Automated Continuous CData Connect AI Replication to MySQL
Use CData Sync for automated, continuous, customizable CData Connect AI replication to MySQL.
-
Integrating Cursor CLI with Salesforce Marketing 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 Codex CLI with Square 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.
-
Automate FHIR Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live FHIR and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Getting Started with the CData SSIS Components for Shortcut
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Shortcut.
-
Integrate Stripe Data in the Pentaho Report Designer
Publish reports based on Stripe in the Pentaho BI tool.
-
Deploy the ADO.NET Provider for FHIR on an SSRS Report Server
Connect to FHIR from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
How to Connect to Microsoft Teams Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft Teams. Leverage the pyodbc module for ODBC in Python.
-
Operational Reporting on Slack Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Slack.
-
Automate Raisers Edge NXT Data Replication to Azure Synapse
Use CData Sync to customize and automate Raisers Edge NXT replication to Azure Synapse.
-
Build Klaviyo-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Klaviyo and build Klaviyo-connected web apps with Axios.
-
Use Claude to Talk to Your Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Oracle HCM Cloud for you.
-
Query SQL Analysis Services Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SQL Analysis Services and perform CRUD operations on SQL Analysis Services from Node.js.
-
How to Connect to Google Ad Manager Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Google Ad Manager. Leverage the pyodbc module for ODBC in Python.
-
Getting Started with the CData ODBC Driver for Drift
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Drift.
-
Connect to PingOne Data in Ruby
Connect to PingOne in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Visualizations of SFTP Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SFTP in Birst.
-
Connect to Microsoft Planner Data from AWS Glue
Use CData Connect AI to gain access to live Microsoft Planner from your AWS Glue jobs.
-
How to publish and share Tavily Data dashboards with Tableau Server
The CData ODBC driver for Tavily enables you integrate Tavily into Tableau dashboards.
-
Use Claude to Talk to Your Azure Synapse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Azure Synapse for you.
-
How to Visualize Act CRM Data in Python with pandas
Use pandas and other modules to analyze and visualize live Act CRM in Python.
-
Connect Excel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Microsoft Excel using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Create Apps from Basecamp Data in Qlik Sense Cloud
Use CData Connect AI to connect to Basecamp Data and build apps from live Basecamp in Qlik Sense Cloud.
-
Create Reports from API Data in Looker Studio
Use CData Connect AI to gain access to live API and create custom reports in Looker Studio.
-
Connect to AdRoll Data in CloverDX (formerly CloverETL)
Transfer AdRoll using the visual workflow in the CloverDX data integration tool.
-
Visualize Live Oracle Service Cloud Data in the Power BI Service
Use CData Connect AI to connect to live Oracle Service Cloud and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Dotmailer Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Dotmailer replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData Tableau Connector for AdRoll
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Integrating GitHub Copilot CLI with SAP SuccessFactors 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 FormSite Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your FormSite using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Power BI XMLA Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Power BI XMLA in the Denodo Virtual DataPort Administrator.
-
Build Automated AlloyDB-Connected Workflows in Zapier
Use CData Connect AI to connect to live Google AlloyDB and build automated workflows in Zapier.
-
Create Reports with Invoiced Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Invoiced.
-
Stream WooCommerce Data into Apache Kafka Topics
Access and stream WooCommerce in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to connect SharePoint with Square Data through external lists
Provide Square to SharePoint users as an external list.
-
Object-Relational Mapping (ORM) with SAP HANA XS Advanced 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 SAP HANA XS Advanced into a Java-based ORM framework, Hibernate.
-
Create SSAS Tabular Models from Bitbucket Data
How to build a SQL Server Analysis Service Tabular Model from Bitbucket using CData drivers.
-
Integrating Kiro CLI with Phoenix 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.
-
Integrate LibreChat with Live Presto Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Presto from within the chat interface.
-
Access Live Jira Data in Coginiti Pro
Connect to and query live Atlassian Jira from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build Salesforce-Connected Apps in Choreo
Use CData Connect AI to connect to Salesforce Data from Choreo and build custom apps using live Salesforce & Force.com.
-
Build MVC Applications with Connectivity to Databricks Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Databricks from an ASP.NET MVC application.
-
Use Dash to Build to Web Apps on Oracle Eloqua Data
Create Python applications that use pandas and Dash to build Oracle Eloqua-connected web apps.
-
Automated Continuous Exact Online Replication to MongoDB
Use CData Sync for automated, continuous, customizable Exact Online replication to MongoDB.
-
Working with Authorize.Net Data in LINQPad
Execute LINQ queries to Authorize.Net in LINQPad.
-
Automated Continuous Zoho Projects Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoho Projects replication to IBM DB2.
-
Build Automated Avro-Connected Workflows in Zapier
Use CData Connect AI to connect to live Apache Avro and build automated workflows in Zapier.
-
Visualize Live MongoDB Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live MongoDB into custom reports in Power BI.
-
How to connect SharePoint with BigQuery Data through external lists
Provide Google BigQuery to SharePoint users as an external list.
-
Using the CData Software ODBC Driver for PabblySubscriptions in PyCharm
Connect to PabblySubscriptions as an ODBC data source in PyCharm using the CData Software ODBC Driver for PabblySubscriptions.
-
How to Connect DBeaver to Close via a JDBC Driver
Manage Close with visual tools in DBeaver like the query browser.
-
Provide OData Services of Simplesat Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Simplesat by developing a WCF Service Application.
-
Integrate with live BigQuery Data in Jitterbit
Use CData Connect AI to connect to and integrate live Google BigQuery in Jitterbit.
-
Access Live Jira Assets Data in AWS Lambda
Connect to live Jira Assets in AWS Lambda using the CData JDBC Driver.
-
Back Up Pinterest to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Pinterest. In this article, we will employ an SSIS workflow to populate a database with Pinterest data.
-
Integrate Live SendGrid Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live SendGrid to Blue Prism using the CData ODBC Driver for SendGrid to create automated workflows for repetitive business tasks.
-
Build IBM Cloud Object Storage-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for IBM Cloud Object Storage Data and create custom apps in Mendix.
-
Create Datasets from SAP Fieldglass in Domo Workbench and Build Visualizations of SAP Fieldglass Data in Domo
Use the CData Software ODBC Driver for SAP Fieldglass to create datasets from SAP Fieldglass in Domo Workbench and then build visualizations in the Domo service.
-
How to update Reckon Accounts Hosted from Excel
This article explains how to transfer data from Excel to Reckon Accounts Hosted using the Excel Add-In for Reckon Accounts Hosted.
-
Build LaunchDarkly-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live LaunchDarkly.
-
Use Microsoft Copilot Studio to talk to your Exact Online 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 Exact Online for you.
-
Migrating data from Teradata to Google BigQuery using CData SSIS Components.
Easily push Teradata to Google BigQuery using the CData SSIS Tasks for Teradata and Google BigQuery.
-
Bridge OpenWeatherMap Connectivity with Apache NiFi
Access and process OpenWeatherMap in Apache NiFi using the CData JDBC Driver.
-
Integrating Codex CLI with Pingdom 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.
-
Analyze Microsoft OneDrive Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Microsoft OneDrive and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create SSAS Tabular Models from TaxJar Data
How to build a SQL Server Analysis Service Tabular Model from TaxJar using CData drivers.
-
Import and Visualize Microsoft Entra ID Data in Power View
Create data visualizations based on Microsoft Entra ID in Excel.
-
Use the CData ODBC Driver for eBay Analytics in Microsoft Power Query
You can use the CData eBay Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import eBay Analytics into Microsoft Power Query.
-
Automated Continuous Calendly Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Calendly replication to Amazon S3.
-
Rapidly Develop Sage 200-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 Sage 200.
-
Access Hubstaff Data from MySQL in Amazon QuickSight
Connect to Hubstaff and build visualizations of Hubstaff using a MySQL Connection in Amazon QuickSight.
-
Establish a Live Connection with Hubstaff Data using Tableau Bridge
The CData ODBC Driver for Hubstaff enables you to integrate live Hubstaff into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Microsoft Planner Data from a Connection Pool in Jetty
The Microsoft Planner JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Planner from Web apps in Jetty.