CData Software - Knowledge Base
Recent Articles
-
Stream Oracle SCM Data into Apache Kafka Topics
Access and stream Oracle SCM data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrate Real-Time Access to Elasticsearch in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Elasticsearch data in real time.
-
Analyze Dynamics 365 Business Central Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Dynamics 365 Business Central data with the CData JDBC Driver for Dynamics 365 Business Central.
-
Create Reports from PostgreSQL Data in Looker Studio
Use CData Connect AI to gain access to live PostgreSQL data and create custom reports in Looker Studio.
-
Build AfterShip-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for AfterShip Data and create custom apps in Mendix.
-
REST Easy with CData Drivers
Our Drivers offer unmatched utility in connecting to and integrating with REST resources as databases.
-
Integrate OpenWeatherMap with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate OpenWeatherMap with External Services.
-
How to connect Amazon QuickSight to SAS Data Sets Data
Create a connection to SAS Data Sets data in CData Connect AI and insert SAS Data Sets data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to DocuSign from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from DocuSign data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access Live Wave Financial Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Wave Financial data from your Excel spreadsheets.
-
Use the CData Software ODBC Driver for Apollo in SAS for Real-Time Reporting and Analytics
Connect to real-time Apollo data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Apollo.
-
Write a Simple Go Application to work with Oracle Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Oracle data.
-
Automated Continuous Adobe Commerce Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Adobe Commerce replication to Azure SQL Database.
-
Integrating LlamaIndex with SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SQL Server data in real time.
-
Configure the CData JDBC Driver for Zendesk in a Connection Pool in Tomcat
Connect to Zendesk data from a connection pool in Tomcat.
-
Getting Started with the CData JDBC Driver for Amazon Athena
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Amazon Athena.
-
Stream Avalara AvaTax Data into Apache Kafka Topics
Access and stream Avalara AvaTax data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Claude Code with Spark Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Spark data within assisted coding and automated development workflows.
-
How to Create Power BI Visual Reports with Real-Time Jumpseller Data
Use CData Power BI Connectors to visualize Jumpseller data in Power BI.
-
View Reports on Real-Time Monday.com Data in Power BI Report Server
Use the CData ODBC Driver for Monday.com to visualize Monday.com data in Power BI Desktop and then publish them to Power BI Report Server.
-
Migrating data from Smartsheet to Google BigQuery using CData SSIS Components.
Easily push Smartsheet data to Google BigQuery using the CData SSIS Tasks for Smartsheet and Google BigQuery.
-
Integrate with Live OneNote Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to OneNote from the MuleSoft Anypoint Platform to integrate live OneNote data into custom reports and dashboards.
-
Integrating Boomi Agentstudio with Figshare Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Figshare data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Use Dash to Build to Web Apps on Marketo Data
Create Python applications that use pandas and Dash to build Marketo-connected web apps.
-
Connect to Real-Time Auth0 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Auth0 data in Power Apps.
-
Integrate Cline with Live Square Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Square data from within your IDE.
-
Automated Continuous Accelo Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Accelo replication to Apache Kafka.
-
Create Oracle Eloqua Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Oracle Eloqua from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Bullhorn CRM Data from PowerBuilder via JDBC
This article demonstrates how to access Bullhorn CRM data from PowerBuilder using the Bullhorn CRM JDBC Driver.
-
Replicate Multiple Neo4J Accounts via the CData Sync CLI
Replicate multiple Neo4J accounts to one or many databases.
-
Access Live Microsoft Ads Data in Excel 365 Online (Excel for the web)
Connect to Microsoft Ads data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Work with Live Gong Data in Power Query
Use CData Connect AI to connect to Gong data and work with live Gong data in Microsoft Power Query.
-
Create SSAS Tabular Models from PDFMonkey Data
How to build a SQL Server Analysis Service Tabular Model from PDFMonkey data using CData drivers.
-
Access Live LinkedIn Data in Coginiti Pro
Connect to and query live LinkedIn data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Edit and Search External Google Ad Manager Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Ad Manager data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Ad Manager Data objects that you can access from apps and the dashboard.
-
Integrate SageHR Data into Power Automate Desktop using CData Connect
CData Connect for SageHR Data enables you to integrate SageHR data into workflows built using Microsoft Power Automate Desktop.
-
Integrate with live Microsoft Exchange Data in Jitterbit
Use CData Connect AI to connect to and integrate live Microsoft Exchange data in Jitterbit.
-
How to Easily Query xBase Data in OpenOffice Base
Connect to xBase data in OpenOffice Base using the CData ODBC Driver for xBase and generate reports with live data insights.
-
Integrating Claude Code CLI with Cosmos DB 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.
-
Create a Data Access Object for Instantly Data using JDBI
A brief overview of creating a SQL Object API for Instantly data in JDBI.
-
Connect SFTP to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SFTP with IBM WebSphere for seamless data integration and connectivity.
-
Import and Visualize LDAP Objects in Power View
Create data visualizations based on LDAP objects in Excel.
-
Integrate Cline with Live Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Adobe Target data from within your IDE.
-
Connect to Kintone Data in Claris FileMaker Pro
Use the CData ODBC Driver for Kintone in FileMaker Pro to connect to Kintone and work with Kintone data in your FileMaker applications.
-
Build Visualizations of Dynamics 365 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Dynamics 365 data in Birst.
-
Build Visualizations of Pinecone Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Pinecone data in Birst.
-
Integrate with TaxJar Data in SnapLogic
Use CData Connect AI to connect to and integrate with live TaxJar data in SnapLogic.
-
How to Connect to Spark Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Spark data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google's Vertex AI Agent with Live Instagram Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Instagram data within intelligent workflows.
-
Import Apollo Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Apollo Data and provide access to live Apollo data for custom reports in the Power BI Service.
-
Connect to ZohoPeople Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for ZohoPeople data in Airbyte.
-
Connect to Smartsheet Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Smartsheet and the Script function in FileMaker Pro to connect to Smartsheet and work with Smartsheet data in your FileMaker application.
-
Automated Continuous ADP Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ADP replication to Apache Kafka.
-
Build Mailgun-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Mailgun Data and create custom apps in Bubble.
-
Easily Integrate SAP Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Object-Relational Mapping (ORM) with Splunk 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 Splunk data into a Java-based ORM framework, Hibernate.
-
Explore Geographical Relationships in Oracle SCM Data with Power Map
Create data visualizations with Oracle SCM data in Power Map.
-
Automated Zoom Data Replication to Teradata
Use CData Sync to Customize and automate Zoom data replication to Teradata.
-
Analyze YouTube Analytics Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze YouTube Analytics data with the CData JDBC Driver for YouTube Analytics.
-
How to load ConstantContact data into Elasticsearch via Logstash
Introducing a simple method to load ConstantContact data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Create Informatica Mappings From/To an ODBC Data Source for BigQuery
Create an ODBC connection to BigQuery in Informatica and browse and transfer BigQuery data.
-
Access Live NetSuite Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to NetSuite data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Getting Started with the CData Excel Add-In for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Oracle HCM Cloud.
-
Integrate with Bannerbear Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bannerbear data to a JSON file on disk.
-
Prepare, Blend, and Analyze Stripe Data in Alteryx Designer (ODBC)
Build workflows to access live Stripe data for self-service data analytics.
-
Create Power BI Reports on Real-Time Qualaroo Data
Use the CData ODBC Driver for Qualaroo to visualize Qualaroo data in Power BI Desktop.
-
Build Active Directory-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Active Directory data and build Active Directory-connected web apps with Axios.
-
How to Build an ETL App for Salesforce Marketing Data in Python with CData
Create ETL applications and real-time data pipelines for Salesforce Marketing data in Python with petl.
-
Build a Simple VCL Application for Qualaroo Data
How to build a simple VCL Application to view Qualaroo data in RAD Studio using the CData ODBC Driver for Qualaroo.
-
Use the CData Software JDBC Driver for Google Ads in MicroStrategy
Connect to Google Ads data in MicroStrategy Developer using the CData Software JDBC Driver for Google Ads.
-
Visualize Live Dynamics NAV Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Dynamics NAV data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import Real-Time Webex Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Webex data in ColdFusion.
-
Create a Data Access Object for Jira Assets Data using JDBI
A brief overview of creating a SQL Object API for Jira Assets data in JDBI.
-
Access Procore Data from MySQL in PHP
Connect to Procore through the standard MySQL libraries in PHP.
-
Automated Continuous Printful Replication to Oracle
Use CData Sync for automated, continuous, customizable Printful replication to Oracle.
-
Build Microsoft Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Microsoft Ads data and build visualizations in Tableau.
-
Build Agents in Relevance AI with Access to Live ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on ConstantContact data within intelligent agent workflows.
-
Build Data Flows from SQL Server to MailChimp through SSIS
Easily push SQL Server data to MailChimp using the CData SSIS Tasks for MailChimp.
-
Integrating GitHub Copilot with Tanda 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 Amazon DynamoDB in MicroStrategy Web
Connect to Amazon DynamoDB data in MicroStrategy Web using the CData Software ODBC Driver for Amazon DynamoDB.
-
Getting Started with the CData Power BI Connector for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Dynamics 365.
-
Publish Crystal Reports on Clio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Clio data.
-
How to create Rebilly federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Rebilly data in MySQL .
-
Build AI/ML Models with Live SharePoint Data using Dataiku
Connect SharePoint Data with Dataiku using the CData JDBC Driver for SharePoint.
-
Getting Started with the CData Excel Add-In for Google Translate
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Translate.
-
Connect Spotify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Spotify data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Access Instantly 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 Instantly data.
-
Visualize Salesforce Data in Sisense
Create an ElastiCube in Sisense app with access to Salesforce data.
-
Interact with Live Presto Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Presto data.
-
Automated Continuous iContact Replication to MongoDB
Use CData Sync for automated, continuous, customizable iContact replication to MongoDB.
-
Create NetSuite SuiteAnalytics-Connected Dashboards in Grafana
Connect to NetSuite SuiteAnalytics Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to NetSuite SuiteAnalytics data.
-
Automated Continuous Coinbase Replication to Vertica
Use CData Sync for automated, continuous, customizable Coinbase replication to Vertica.
-
Connect to MySQL Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for MySQL to connect to MySQL data and execute queries in PowerBuilder.
-
Integrating Gumloop with SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SendPulse data within automated workflows.
-
Migrating data from MessageBird to Snowflake using CData SSIS Components.
Easily push MessageBird data to Snowflake using the CData SSIS Tasks for MessageBird and Snowflake.
-
Validate Microsoft Entra ID Data with QuerySurge
Access and validate Microsoft Entra ID data in QuerySurge using the CData JDBC Driver.
-
Integrate Live WordPress Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to WordPress data and integrate live WordPress data into apps built in Microsoft Power Apps.
-
IBM Cloud Object Storage Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on IBM Cloud Object Storage facts in real time.
-
Connect to SAP Netweaver Gateway from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from SAP Netweaver Gateway data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Edit and Search External Dynamics CRM Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Dynamics CRM data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Dynamics CRM Data objects that you can access from apps and the dashboard.