CData Software - Knowledge Base
Recent Articles
-
Import Real-Time NASA Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use NASA data in ColdFusion.
-
Edit and Search External Amazon Athena Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Amazon Athena data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Amazon Athena Data objects that you can access from apps and the dashboard.
-
Build Apps with Live Adobe Analytics data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Adobe Analytics data into the Adalo platform and build custom mobile and web applications with real-time Adobe Analytics data.
-
Automated Continuous GraphQL Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable GraphQL replication to Google Cloud SQL.
-
Build Data Flows from Google Directory to SQL Server using SSIS
Easily back up Google Directory data to SQL Server using the SSIS components for Google Directory.
-
Connect to Drip Data in NetBeans
Connect to Drip data in NetBeans with the data source configuration wizard.
-
Integrate OpenCode with Live Phoenix Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Phoenix data from within your AI coding agent.
-
Connect to DB2 Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for DB2 and the SQL Gateway to access DB2 data from Google Apps Script.
-
Integrate Salesforce Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Salesforce data and integrate live Salesforce data into your Power Automate tasks.
-
Connect to Snowflake Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Snowflake Data and connect to Snowflake data in Akorbi Digital RunMyProcess.
-
Connect Typeform Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Typeform data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to Intercom Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Intercom to connect to Intercom data and execute queries in PowerBuilder.
-
Feed ConvertAPI Data into FineReport
How to set ConvertAPI data as a JDBC data source in FineReport.
-
Connect and Query Live SAP Ariba Source Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live SAP Ariba Source data into Databricks and enable direct, live querying and analysis without replication.
-
Build a Singer.io Tap for ADP With the CData Python Connector
Learn how to easily build a Singer.io Tap for live ADP data using the CData Python Connector.
-
Connect to SpaceX Data from a Connection Pool in JBoss
Integrate SpaceX data into Java servlets: Use the Management Console in JBoss to install the SpaceX JDBC Driver.
-
How to import Reckon Accounts Hosted Data into Apache Solr
Use the CData Software JDBC Driver for Reckon Accounts Hosted in Data Import Handler and create an automated import of Reckon Accounts Hosted data to Apache Solr Enterprise Search platform.
-
Getting Started with the CData Excel Add-In for Sybase IQ
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Sybase IQ.
-
Connect to XML 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 XML data.
-
Configure the CData JDBC Driver for HDFS in a Connection Pool in Tomcat
Connect to HDFS data from a connection pool in Tomcat.
-
Consume Amazon DynamoDB OData Feeds in PowerBuilder
This article demonstrates how to consume Amazon DynamoDB data as OData feeds from PowerBuilder using the API Server.
-
How to Work with Sage 200 Data in AWS Glue Jobs Using JDBC
Connect to Sage 200 from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Load Office 365 Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Office 365 data to a database.
-
Integrate Goose with Live Figshare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Figshare data from within the local AI agent.
-
Connect to and Visualize Live CloudConvert Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live CloudConvert data.
-
Work with Guru Data in FoxPro
Load Guru data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex with Vercel 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.
-
Use the CData Software ODBC Driver for Calendly in MicroStrategy Desktop
Connect to Calendly data in MicroStrategy Desktop using the CData Software ODBC Driver for Calendly.
-
Getting Started with the CData Connect AI Python SDK for Sugar CRM
Install the CData Connect AI Python SDK to read and write live Sugar CRM data with standard DB-API 2.0 Python code.
-
Choosing the Best Method to Connect Spotify to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Spotify data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Build Microsoft OneDrive Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft OneDrive data and build visualizations in Tableau.
-
Automated Continuous Raisers Edge NXT Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to PostgreSQL.
-
Integrating PagerDuty Data in Talend Cloud Data Management Platform
Connect PagerDuty Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Creating MailChimp-Connected Applications in Unqork
You can use CData Connect AI to feed MailChimp data to Unqork and build custom business apps.
-
Connect to JSON Services in HULFT Integrate
Connect to JSON as a JDBC data source in HULFT Integrate
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Beeminder
Provide connectivity to Beeminder data through an SAP BusinessObjects universe.
-
Connect to Okta Data in Aqua Data Studio
Access Okta data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Live Webex Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Webex data into the statistical analysis tools available in SAS JMP. This article shows how to use Webex data in the Graph Builder and Query Builder.
-
How to Access Live FormSite Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FormSite enables you to integrate FormSite data into workflows built using Microsoft Power Automate Desktop.
-
Build Voice Agents in ElevenLabs with access to Live SAP ByDesign Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP ByDesign data.
-
Configure the CData JDBC Driver for Certinia in a Connection Pool in Tomcat
Connect to Certinia data from a connection pool in Tomcat.
-
How to Create Power BI Visual Reports with Real-Time Amazon S3 Data
Use CData Power BI Connectors to visualize Amazon S3 data in Power BI.
-
Use ChatGPT to Talk to Your Authorize.Net 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 Authorize.Net data for you.
-
Build Cloudant-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Cloudant Data and create custom apps in Bubble.
-
Create SSAS Tabular Models from Recurly Data
How to build a SQL Server Analysis Service Tabular Model from Recurly data using CData drivers.
-
Replicate Multiple Excel Online Accounts
Replicate multiple Excel Online accounts to one or many databases.
-
Integrate with live Zoho Inventory Data in Jitterbit
Use CData Connect AI to connect to and integrate live Zoho Inventory data in Jitterbit.
-
Connect to CapsuleCRM Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for CapsuleCRM data in Airbyte.
-
Getting Started with the CData Power BI Connector for NetSuite
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for NetSuite.
-
A PostgreSQL Interface for MariaDB Data (MySQL Remoting via JDBC)
Use the Remoting features of the MariaDB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Azure AI Foundry to Talk to Your MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your MYOB AccountRight data for you.
-
How to Build an ETL App for Adobe Analytics Data in Python with CData Connect AI
Extract and transform live Adobe Analytics data in Python with petl and the CData Connect AI Python SDK.
-
Connect and Query Live Oracle Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle data into Databricks and enable direct, live querying and analysis without replication.
-
Query IBM Cloud Object Storage Data in DataGrip
Create a Data Source for IBM Cloud Object Storage in DataGrip and use SQL to query live IBM Cloud Object Storage data.
-
Connect to Sage 300 from Asprova with CData Software ODBC Driver for Sage 300
This article shows how to connect faster to Sage 300 data from Asprova.
-
Build Semantic Layer Views for Neo4J Data in APOS Live Data Gateway
Use the CData Connector for Neo4J in APOS Live Data Gateway to build Semantic Layer Views for Neo4J data.
-
Automated Continuous Nuclia Replication to Vertica
Use CData Sync for automated, continuous, customizable Nuclia replication to Vertica.
-
Bind Live QuickBooks Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live QuickBooks data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Automate Shortcut Data Replication to Azure Synapse
Use CData Sync to customize and automate Shortcut data replication to Azure Synapse.
-
Integrate Perigon Data in the Pentaho Report Designer
Publish reports based on Perigon data in the Pentaho BI tool.
-
Automate Zoho Projects Data Replication to Couchbase
Use CData Sync to Customize and automate Zoho Projects data replication to Couchbase.
-
Create Salesforce Data 360 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Salesforce Data 360 data access from reports, embedded analytics, and more.
-
Use Microsoft Copilot Studio to talk to your Salesforce CRM Analytics 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 Salesforce CRM Analytics data for you.
-
Add Suadeo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Suadeo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use Grok to Talk to Your Klaviyo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Klaviyo data for you.
-
Manage Bitbucket Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Bitbucket.
-
Connect to Factorial Data in JRuby
Create a simple JRuby app with access to live Factorial data.
-
Connect to Deel Data in Ruby
Connect to Deel data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Visualize Mouseflow Data in Tableau
The CData ODBC driver for Mouseflow enables you integrate Mouseflow data into Tableau dashboards.
-
Build Apps with Live Bright Data data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Bright Data data into the Adalo platform and build custom mobile and web applications with real-time Bright Data data.
-
Work with Live Microsoft Planner Data in Power Query
Use CData Connect AI to connect to Microsoft Planner data and work with live Microsoft Planner data in Microsoft Power Query.
-
How to Connect to Live ServiceDesk Plus Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your ServiceDesk Plus data for you.
-
Connect to FreeAgent Data as an External Source in Dremio
Use the CData JDBC Driver to connect to FreeAgent as an External Source in Dremio.
-
Visualize Freshservice 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 Freshservice data into TIBCO Spotfire.
-
Natively Connect to Printify Data in PHP
The CData ODBC driver for Printify enables you to create PHP applications with connectivity to Printify data. Leverage the native support for ODBC in PHP.
-
Extract, Transform, and Load Avaza Data in Informatica PowerCenter
Create a simple Workflow for Avaza data in Informatica PowerCenter.
-
How to connect to Humanity Data with Squirrel SQL client
Connect to Humanity data and execute queries in the Squirrel SQL Client.
-
Using the CData Software ODBC Driver for Gong in PyCharm
Connect to Gong as an ODBC data source in PyCharm using the CData Software ODBC Driver for Gong.
-
How to Build an ETL App for BambooHR Data in Python with CData Connect AI
Extract and transform live BambooHR data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Live Adobe Experience Manager Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Adobe Experience Manager data to Blue Prism using the CData ODBC Driver for Adobe Experience Manager to create automated workflows for repetitive business tasks.
-
How to connect and process Google Translate data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Translate data.
-
Build a PostgreSQL Interface for Cosmos DB Data using the CData JDBC Driver
Use the Remoting features of the Cosmos DB JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Quickbase Data in DBxtra
Create dynamic dashboards and perform analytics based on Quickbase data in DBxtra.
-
Use the CData Software ODBC Driver for LDAP in MicroStrategy Desktop
Connect to LDAP objects in MicroStrategy Desktop using the CData Software ODBC Driver for LDAP.
-
Write a Simple Go Application to work with NASA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to NASA data.
-
Create Data Visualizations in Cognos BI with ZohoPeople Data
Access ZohoPeople data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Live Airtable Data in AWS Lambda
Connect to live Airtable data in AWS Lambda using the CData JDBC Driver.
-
Use Biml to Build SSIS Tasks to Replicate Paylocity Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Paylocity data to SQL Server.
-
How to create Landbot federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Landbot data in MySQL .
-
Build SuiteCRM-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SuiteCRM data and build SuiteCRM-connected web apps with Axios.
-
Integrate Amazon Athena Data in Pentaho Data Integration
Build ETL pipelines based on Amazon Athena data in the Pentaho Data Integration tool.
-
Connect to Monday.com Data from PowerBuilder via JDBC
This article demonstrates how to access Monday.com data from PowerBuilder using the Monday.com JDBC Driver.
-
DataBind Certinia Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Certinia with the DevExpress Windows Forms and Web controls to provide Certinia data to a chart.
-
Build Dashboards with CloudConvert Data in DBxtra
Create dynamic dashboards and perform analytics based on CloudConvert data in DBxtra.
-
Connect to Real-Time FormSite Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use FormSite data in Power Apps.
-
Build Data Flows from Google Contacts to SQL Server using SSIS
Easily back up Google Contacts data to SQL Server using the SSIS components for Google Contacts.
-
Build Visualizations of WordPress Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of WordPress data in Birst.
-
Operational Reporting on Microsoft Teams Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft Teams data.
-
Publish Crystal Reports on Dynamics NAV Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dynamics NAV data.
-
Access Live Campaigner Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Campaigner data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.