CData Software - Knowledge Base
Recent Articles
-
Edit and Search External BigQuery Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google BigQuery to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create BigQuery Data objects that you can access from apps and the dashboard.
-
Automated Continuous LinkedIn Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable LinkedIn replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Qualaroo in MicroStrategy
Connect to Qualaroo in MicroStrategy Developer using the CData Software ODBC Driver for Qualaroo.
-
Stream Sage Intacct Data into Apache Kafka Topics
Access and stream Sage Intacct in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import and Visualize ShipStation Data in Power View
Create data visualizations based on ShipStation in Excel.
-
Automated Continuous Cosmos DB Replication to Oracle
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Oracle.
-
How to use SQLAlchemy ORM to access Google Forms Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Forms.
-
Create Power BI Reports on Real-Time Pingdom Data
Use the CData ODBC Driver for Pingdom to visualize Pingdom in Power BI Desktop.
-
View Reports on Real-Time Aha! Data in Power BI Report Server
Use the CData ODBC Driver for Aha! to visualize Aha! in Power BI Desktop and then publish them to Power BI Report Server.
-
Seamlessly Bring HubSpot Data into Retool Using CData Connect AI
Integrate HubSpot data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Atlassian Confluence within intelligent workflows.
-
Getting Started with the CData Excel Add-In for PivotalTracker
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PivotalTracker.
-
How to Query Live Close Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Close data in natural language using Python.
-
Design BIRT Reports on Adobe Experience Manager Data
Provide current Adobe Experience Manager to your embedded analytics.
-
Create Act CRM-Connected Applications in Appsmith
Connect to Act CRM Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Act CRM.
-
Analyze Live Zoho Projects Data in SAS Viya
Use CData Connect AI to connect to Zoho Projects from SAS Viya and deploy self-service analytics using live Zoho Projects.
-
Automated Continuous Dynamics 365 Business Central Replication to Oracle
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Oracle.
-
Analyze eBay Analytics Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze eBay Analytics in Microsoft R Open.
-
Query SAP HANA Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SAP HANA and perform CRUD operations on SAP HANA from Node.js.
-
Analyze DocuSign Data in Cognos Analytics
Use CData Connect AI to connect to DocuSign Data from Cognos Analytics and analyze live DocuSign.
-
Integrate MailerSend Data in Pentaho Data Integration
Build ETL pipelines based on MailerSend in the Pentaho Data Integration tool.
-
A PostgreSQL Interface for Retently Data (MySQL Remoting via JDBC)
Use the Remoting features of the Retently JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Unbounce in MicroStrategy Desktop
Connect to Unbounce in MicroStrategy Desktop using the CData Software ODBC Driver for Unbounce.
-
Replicate Datadog Data to Multiple Databases
Replicate Datadog to disparate databases with a point-and-click configuration.
-
Explore Geographical Relationships in SingleStore Data with Power Map
Create data visualizations with SingleStore in Power Map.
-
Connect to PabblySubscriptions Data in DBeaver
Use the CData ODBC Driver to connect to PabblySubscriptions in DBeaver.
-
Connecting Pipedream with SAP ByDesign Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on SAP ByDesign data in real time.
-
Manage Twilio Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Twilio.
-
Build AI Agents with ADP Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live ADP through CData Connect AI.
-
Automated Continuous SAP HANA XS Advanced Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Amazon S3.
-
Establish a Live Connection with Google Spanner Data using Tableau Bridge
The CData ODBC Driver for Google Spanner enables you to integrate live Google Spanner into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze SAP SuccessFactors Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of SAP SuccessFactors and visualize live SAP SuccessFactors in Infragistics Reveal.
-
Load Acumatica Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Acumatica ERP to a database.
-
Query Excel Data as a MySQL Database in Node.js
Execute MySQL queries against Microsoft Excel from Node.js.
-
Import Zendesk Data Using Azure Data Factory
Use CData Connect AI to connect to Zendesk Data from Azure Data Factory and import live Zendesk.
-
Connect Dropbox to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Dropbox with IBM WebSphere for seamless data integration and connectivity.
-
How to Seamlessly Import Snowflake Data into IBM SPSS Modeler
Integrate Snowflake data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Natively Connect to Phoenix Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Phoenix. Leverage the native support for ODBC in PHP.
-
Connect to and Query Billsby Data in QlikView over ODBC
Create data visualizations with Billsby in QlikView.
-
How to integrate CampaignMonitor with Apache Airflow
Access and process CampaignMonitor in Apache Airflow using the CData JDBC Driver.
-
Connect to FreshBooks from a Connection Pool in WebLogic
Use the CData JDBC Driver for FreshBooks to connect to FreshBooks from Web applications running on WebLogic.
-
Connect to Egnyte Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Egnyte as an External Source in Dremio.
-
Add Gong Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Gong with the Informatica Enterprise Data Catalog to classify and organize data.
-
Bidirectional Access to CockroachDB Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate CockroachDB in Filemaker Pro for Mac or Windows.
-
How to connect to Couchbase Data from IntelliJ
Integrate connectivity to Couchbase with wizards in IntelliJ.
-
Explore Geographical Relationships in Hubstaff Data with Power Map
Create data visualizations with Hubstaff in Power Map.
-
Integrate with live Twitter Ads Data in Jitterbit
Use CData Connect AI to connect to and integrate live Twitter Ads in Jitterbit.
-
Connect to Pushbullet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automated Continuous Odoo Replication to MySQL
Use CData Sync for automated, continuous, customizable Odoo replication to MySQL.
-
How to connect to Tanda Data from IntelliJ
Integrate connectivity to Tanda with wizards in IntelliJ.
-
Connect to Yelp Data in RapidMiner
Integrate Yelp with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous SAP Fieldglass Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Amazon Redshift.
-
Easily Integrate Oracle Financials Cloud Data in Lazarus Pascal IDE
Learn how to easily integrate live Oracle Financials Cloud in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Seamlessly Import Testmonitor Data into IBM SPSS Modeler
Integrate Testmonitor data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Claude Code CLI with Anaplan 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.
-
Connect to Workable Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Workable and work with Workable in your FileMaker application.
-
Automated Continuous Hubstaff Replication to Snowflake
Use CData Sync for automated, continuous, customizable Hubstaff replication to Snowflake.
-
Replicate Multiple Zendesk Accounts via the CData Sync CLI
Replicate multiple Zendesk accounts to one or many databases.
-
Write a Simple Go Application to work with Optimizely Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Optimizely.
-
How to integrate ScrapingBee with Apache Airflow
Access and process ScrapingBee in Apache Airflow using the CData JDBC Driver.
-
Automated Continuous Typeform Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Typeform replication to Apache Cassandra.
-
Build SAP Ariba Source Visualizations in Tableau Desktop
Use CData Connect AI to connect to live SAP Ariba Source and build visualizations in Tableau.
-
How to connect and process Brex from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Brex.
-
Analyze Blackbaud FE NXT Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Blackbaud FE NXT and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Keap Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Keap and the SQL Gateway to access Keap from Google Apps Script.
-
Integrating Codex CLI with Azure Cosmos DB 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 MarkLogic Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MarkLogic from Power Pivot. You will use the Table Import Wizard to load MarkLogic. You can visually build the import query or use any SQL supported by the driver.
-
Integrating Cursor CLI with SpaceX 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.
-
Automated Continuous Invoiced Replication to Databricks
Use CData Sync for automated, continuous, customizable Invoiced replication to Databricks.
-
How to Use a Microsoft Access Database to Update MYOB AccountRight Data in Real Time
Update MYOB AccountRight data by creating a linked table in Microsoft Access with the CData MYOB AccountRight ODBC Driver.
-
Manage HelloSign Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HelloSign.
-
Build Dashboards with Productboard Data in Dundas BI
Create dynamic dashboards and perform analytics based on Productboard in Dundas BI.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Harvest
Provide connectivity to Harvest through an SAP BusinessObjects universe.
-
Extract, Transform, and Load Miro Data in Informatica PowerCenter
Create a simple Workflow for Miro in Informatica PowerCenter.
-
Access Live Microsoft Entra ID Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Microsoft Entra ID in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Visualizations of HCL Domino Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of HCL Domino in Birst.
-
Connect and Visualize Live Bullhorn CRM Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Bullhorn CRM into the Databricks platform and create visualization dashboards with real-time Bullhorn CRM.
-
Visualize Live Datadog Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Datadog using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Paymo Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Paymo. Leverage the native support for ODBC in PHP.
-
How to load Accelo data into Elasticsearch via Logstash
Introducing a simple method to load Accelo data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrating Campaigner Data in Talend Cloud Data Management Platform
Connect Campaigner Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
How to Create Power BI Visual Reports with Real-Time Microsoft OneDrive Data
Use CData Power BI Connectors to visualize Microsoft OneDrive in Power BI.
-
Use Biml to Build SSIS Tasks to Replicate SageHR Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SageHR to SQL Server.
-
Create Dashboards and Visualize Live Google Contacts Data in Geckoboard
Use CData Connect AI to connect to live Google Contacts and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Query Twitter Ads Data as a SQL Server Database in Node.js
Execute SQL Server queries against Twitter Ads from Node.js.
-
Visualize Printful Data in TIBCO Spotfire through ADO.NET
Integrate Printful into dashboards in TIBCO Spotfire.
-
DataBind Charts to FHIR Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to FHIR 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 Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live EnterpriseDB within intelligent workflows.
-
Access Live Azure Analysis Services Data in AWS Lambda
Connect to live Azure Analysis Services in AWS Lambda using the CData JDBC Driver.
-
Connect to OpenWeatherMap Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time OpenWeatherMap using standard SQL.
-
How to update Xero from Excel
This article explains how to transfer data from Excel to Xero using the Excel Add-In for Xero.
-
Connect to Planio Data from a Connection Pool in Jetty
The Planio JDBC Driver supports connection pooling: This article shows how to connect faster to Planio from Web apps in Jetty.
-
Connect and Visualize Live ShipStation Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live ShipStation into the Databricks platform and create visualization dashboards with real-time ShipStation.
-
Use Biml to Build SSIS Tasks to Replicate Sage 200 Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Sage 200 to SQL Server.
-
Connect to Microsoft Dataverse Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Microsoft Dataverse (CDS) from Filemaker Pro on Mac.
-
Rapidly Develop Pipeline CRM-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 Pipeline CRM.
-
Visualize Live Redis Data in the Power BI Service
Use CData Connect AI to connect to live Redis and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating OpenCode Terminal with Kafka 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.
-
Import Real-Time Campaigner Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Campaigner in ColdFusion.
-
Publish Impala-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Apache Impala.