CData Software - Knowledge Base
Recent Articles
-
Create Reports with Recurly Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Recurly.
-
Integrating Dataiku with EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live EnterpriseDB.
-
Build Data Flows from SQL Server to Oracle Service Cloud through SSIS
Easily push SQL Server data to Oracle Service Cloud using the CData SSIS Tasks for Oracle Service Cloud.
-
Reckon Accounts Hosted Reporting in OBIEE with the Reckon Accounts Hosted JDBC Driver
Deploy the Reckon Accounts Hosted JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live Asana Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Asana through natural language.
-
A PostgreSQL Interface for FreeAgent Data using the CData ODBC Driver
Use the SQL Gateway and FreeAgent ODBC Driver to create a PostgreSQL entry-point for data access.
-
Natively Connect to Procore Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Procore. Leverage the native support for ODBC in PHP.
-
Create Dynamic Square Grids Using the Infragistics XamDataGrid
Learn how you can connect Square to Infragistics XamDataGrid to build dynamic grids.
-
Visualize Live Exa Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Exa.
-
Use the CData Software JDBC Driver for Monday.com in MicroStrategy Desktop
Connect to Monday.com in MicroStrategy Desktop using the CData Software JDBC Driver for Monday.com.
-
Integrate Live Google Search Results into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Google Search to Blue Prism using the CData ODBC Driver for Google Search to create automated workflows for repetitive business tasks.
-
Automated Continuous Google Sheets Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Sheets replication to AlloyDB.
-
Getting Started with the CData ADO.NET Provider for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SAP Ariba Source.
-
Visualize Google Drive Data in Sisense
Create an ElastiCube in Sisense app with access to Google Drive.
-
Automated Continuous Aircall Replication to Vertica
Use CData Sync for automated, continuous, customizable Aircall replication to Vertica.
-
Load PayPal Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load PayPal to a database.
-
Integrate Active Directory Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Active Directory and integrate live Active Directory into your Power Automate tasks.
-
How to update Google Calendar from Excel
This article explains how to transfer data from Excel to Google Calendar using the Excel Add-In for Google Calendar.
-
Create ConvertAPI Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ConvertAPI data access from reports, embedded analytics, and more.
-
How to connect to ChargeOver Data from Spring Boot
Connect to ChargeOver in a Spring Boot Application using the CData API Driver for JDBC
-
Rapidly Develop Cosmos DB-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 Cosmos DB.
-
Analyze Redis Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Redis and visualize live Redis in Infragistics Reveal.
-
Integrating Humanity Data in Talend Cloud Data Management Platform
Connect Humanity Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Live Salesforce Pardot Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Salesforce Pardot using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Build an ETL App for MySQL Data in Python with CData Connect AI
Build ETL pipelines that read and write live MySQL in Python with petl and the CData Connect AI Python SDK.
-
Configure the CData JDBC Driver for Confluence in a Connection Pool in Tomcat
Connect to Atlassian Confluence from a connection pool in Tomcat.
-
Explore Geographical Relationships in Sugar CRM Data with Power Map
Create data visualizations with Sugar CRM in Power Map.
-
How to Work with Tavily Data in AWS Glue Jobs Using JDBC
Connect to Tavily from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to OnePageCrm Data from a Connection Pool in JBoss
Integrate OnePageCrm into Java servlets: Use the Management Console in JBoss to install the OnePageCrm JDBC Driver.
-
Create Apps from Zoho Books Data in Qlik Sense Cloud
Use CData Connect AI to connect to Zoho Books Data and build apps from live Zoho Books in Qlik Sense Cloud.
-
Connect to Live Phoenix Data in MicroStrategy through CData Connect AI
Create a live connection to Phoenix Data in CData Connect AI and connect to your Apache Phoenix from MicroStrategy.
-
Connect to and Visualize Live Mailgun Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mailgun.
-
Create Sage Cloud Accounting-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage Cloud Accounting Data from OutSystems and build custom enterprise apps using live Sage Business Cloud Accounting.
-
Access Live xBase Data in AWS Lambda (with IntelliJ IDEA)
Connect to live xBase in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to create Missive federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Missive in MySQL .
-
Connect to Live Amazon DynamoDB Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Amazon DynamoDB in CData Connect AI and connect to your Amazon DynamoDB from PostgreSQL.
-
DataBind Controls to ServiceDesk Plus Data in C++Builder
DataBind to ServiceDesk Plus in C++Builder with standard components and controls.
-
Publish Jira-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Atlassian Jira.
-
Publish Crystal Reports on OneNote Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft OneNote.
-
Connect to Accelo from Asprova with CData Software ODBC Driver for Accelo
This article shows how to connect faster to Accelo data from Asprova.
-
Work with Live SAS xpt Data in Power Query
Use CData Connect AI to connect to SAS XPORT and work with live SAS XPORT in Microsoft Power Query.
-
Use the CData Software JDBC Driver for Microsoft Entra ID in MicroStrategy Desktop
Connect to Microsoft Entra ID in MicroStrategy Desktop using the CData Software JDBC Driver for Microsoft Entra ID.
-
Replicate Multiple xBase Accounts
Replicate multiple xBase accounts to one or many databases.
-
How to Work with GraphQL Data in ETL Validator JDBC
Connect to GraphQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Consume MySQL OData Feeds in SAP Lumira
Use the API Server to create data visualizations on MySQL feeds that reflect any changes in SAP Lumira.
-
How to create an RPA flow for Jira Data in UiPath Studio
Use the Jira ODBC Driver to create workflows that access real-time Atlassian Jira without any coding.
-
Using the CData Software ODBC Driver for Clio in PyCharm
Connect to Clio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Clio.
-
Natively Connect to Confluence Data in PHP
The CData ODBC driver for Confluence enables you to create PHP applications with connectivity to Atlassian Confluence. Leverage the native support for ODBC in PHP.
-
Integrate Missive with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Missive with External Services.
-
Build a Simple VCL Application for Intercom Data
How to build a simple VCL Application to view Intercom in RAD Studio using the CData ODBC Driver for Intercom.
-
Integrating Codex CLI with NetSuite CRM & ERP 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.
-
Feed Sendwithus Data into FineReport
How to set Sendwithus as a JDBC data source in FineReport.
-
Build Apps with Live Google Directory in Adalo using CData Connect AI
Use CData Connect AI to integrate live Google Directory into the Adalo platform and build custom mobile and web applications with real-time Google Directory.
-
Connect to Marketo Data in Jaspersoft Studio
Execute SQL to remote Marketo in Jaspersoft Studio.
-
Consume CSV OData Feeds in PowerBuilder
This article demonstrates how to consume CSV/TSV Files as OData feeds from PowerBuilder using the API Server.
-
How to integrate Metabase with YouTube Analytics Data
Use CData Connect AI to connect to live YouTube Analytics and create an interactive dashboard in Metabase from YouTube Analytics.
-
Connect to Slack Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Slack to connect to Slack and execute queries in PowerBuilder.
-
Build AI/ML Models with Live Mocean Data using Dataiku
Connect Mocean Data with Dataiku using the CData API Driver for JDBC.
-
Integrating GitHub Copilot CLI with SAP Ariba Procurement 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.
-
Build BigCommerce-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to BigCommerce Data from Zoho Analytics and import live BigCommerce.
-
Build Dashboards with Microsoft Ads Data in Dundas BI
Create dynamic dashboards and perform analytics based on Microsoft Ads in Dundas BI.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SQL Server actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Import Real-Time BambooHR Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use BambooHR in ColdFusion.
-
Connecting Mastra with Snapchat Ads 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 Snapchat Ads, no replication required.
-
Replicate Multiple eBay Analytics Accounts via the CData Sync CLI
Replicate multiple eBay Analytics accounts to one or many databases.
-
Easily Integrate Printify Data in Lazarus Pascal IDE
Learn how to easily integrate live Printify in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Amplitude from Asprova with CData Software ODBC Driver for Amplitude
This article shows how to connect faster to Amplitude data from Asprova.
-
Access Live Salesforce Pardot Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce Pardot in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Extract, Transform, and Load MariaDB Data in Informatica PowerCenter
Create a simple Workflow for MariaDB in Informatica PowerCenter.
-
Access Live Salesforce Pardot Data in TIBCO Data Virtualization
Use the Salesforce Pardot Tibco DV Adapter to create a Salesforce Pardot data source in TIBCO Data Virtualization Studio and gain access to live Salesforce Pardot from your TDV Server.
-
Connect to Presto Data in CloverDX (formerly CloverETL)
Transfer Presto using the visual workflow in the CloverDX data integration tool.
-
Write a Simple Go Application to work with Airtable Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Airtable.
-
Create Spark Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Spark from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate MessageBird Data Replication to Azure Synapse
Use CData Sync to customize and automate MessageBird replication to Azure Synapse.
-
Model, Search, and Visualize Live Sage Cloud Accounting Data in ThoughtSpot
Use CData Connect AI to connect to live Sage Business Cloud Accounting for modeling, searching, and visualizing.
-
Connect to Mailgun Data in DBArtisan
Use wizards in DBArtisan to configure Mailgun as a data source.
-
How to create an RPA flow for Clockify Data in UiPath Studio
Use the Clockify ODBC Driver to create workflows that access real-time Clockify without any coding.
-
Publish Tanda-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tanda.
-
Feed Teamwork Data into FineReport
How to set Teamwork as a JDBC data source in FineReport.
-
Work with Azure Data Catalog Data in FoxPro
Load Azure Data Catalog into a FoxPro database. This article includes full code and a walk-through of the process.
-
Migrating data from Nuclia to Google BigQuery using CData SSIS Components.
Easily push Nuclia to Google BigQuery using the CData SSIS Tasks for Nuclia and Google BigQuery.
-
Connect to Google Calendar Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Calendar.
-
How to Create Power BI Visual Reports with Real-Time AdRoll Data
Use CData Power BI Connectors to visualize AdRoll in Power BI.
-
Visualize CouchDB Data in Sisense
Create an ElastiCube in Sisense app with access to Apache CouchDB.
-
Visualize Avalara AvaTax Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Avalara AvaTax into TIBCO Spotfire.
-
How to Query Pingdom Data in MySQL Workbench
Execute MySQL queries against live Pingdom from MySQL Workbench.
-
Integrating Cursor CLI with Google Campaign Manager 360 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 Avro Data dashboards with Tableau Server
The CData ODBC driver for Avro enables you integrate Apache Avro into Tableau dashboards.
-
Analyze Live SAP Hybris C4C Data in SAS Viya
Use CData Connect AI to connect to SAP Hybris C4C from SAS Viya and deploy self-service analytics using live SAP Hybris C4C.
-
Automated Continuous Basecamp Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Basecamp replication to Amazon Redshift.
-
Build an OLAP Cube in SSAS from Timely Data
Establish a connection to Timely data from SQL Server Analysis Services, and use the Timely Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build eBay-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to eBay Data from Zoho Analytics and import live eBay.
-
Integrating Antigravity CLI with Drift via CData CLI
Connect Drift to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Getting Started with the CData JDBC Driver for Paylocity
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Paylocity.
-
Build an OLAP Cube in SSAS from SFTP Data
Establish a connection to SFTP data from SQL Server Analysis Services, and use the SFTP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Natively Connect to Couchbase Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Couchbase. Leverage the native support for ODBC in PHP.
-
Create Dashboards and Visualize Live Google Sheets Data in Geckoboard
Use CData Connect AI to connect to live Google Sheets and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Establish a Live Connection with Reckon Accounts Hosted Data using Tableau Bridge
The CData ODBC Driver for Reckon Accounts Hosted enables you to integrate live Reckon Accounts Hosted into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous SageHR Replication to MongoDB
Use CData Sync for automated, continuous, customizable SageHR replication to MongoDB.
-
Establish a Live Connection with Factorial Data using Tableau Bridge
The CData ODBC Driver for Factorial enables you to integrate live Factorial into Tableau Cloud dashboards using the Tableau Bridge.