CData Software - Knowledge Base
Recent Articles
-
How to Connect DBeaver to SendPulse via a JDBC Driver
Manage SendPulse with visual tools in DBeaver like the query browser.
-
Query OneNote Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft OneNote and perform CRUD operations on OneNote from Node.js.
-
Use JayDeBeApi to access Google Sheets Data in Python
Use standard Python scripting and the development environment of your choice to access live Google Sheets.
-
How to create an RPA flow for Azure Analysis Services Data in UiPath Studio
Use the Azure Analysis Services ODBC Driver to create workflows that access real-time Azure Analysis Services without any coding.
-
Build a PostgreSQL Interface for Adobe Target Data using the CData JDBC Driver
Use the Remoting features of the Adobe Target JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Excel Add-In for Blackbaud FE NXT
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Blackbaud FE NXT.
-
Analyze Box Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Box and visualize live Box in Infragistics Reveal.
-
Connect to Google Cloud Storage Data from Crystal Reports
Use CData Connect AI to connect to and report on live Google Cloud Storage from Crystal Reports.
-
Create PostgreSQL Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PostgreSQL from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Perplexity Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Perplexity from Node.js.
-
Integrate Jodoo Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Jodoo from Informatica Cloud.
-
Using the CData Software ODBC Driver for MailerSend in PyCharm
Connect to MailerSend as an ODBC data source in PyCharm using the CData Software ODBC Driver for MailerSend.
-
Use the CData Software ODBC Driver for Webex in MicroStrategy Desktop
Connect to Webex in MicroStrategy Desktop using the CData Software ODBC Driver for Webex.
-
A PostgreSQL Interface for Insightly Data using the CData ODBC Driver
Use the SQL Gateway and Insightly ODBC Driver to create a PostgreSQL entry-point for data access.
-
Enable the Scrapfly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Scrapfly.
-
Publish LaunchDarkly-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LaunchDarkly.
-
Build a Singer.io Tap for Hive With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Hive data using
-
Publish Amplitude-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Amplitude.
-
Automated Continuous JotForm Replication to MongoDB
Use CData Sync for automated, continuous, customizable JotForm replication to MongoDB.
-
ETL Marketo in Oracle Data Integrator
This article shows how to transfer Marketo into a data warehouse using Oracle Data Integrator.
-
Integrate with Azure Synapse Data in JReport Designer
Create charts and reports based on Azure Synapse in JReport Designer.
-
Build Sendwithus-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Sendwithus.
-
Analyze Freshteam Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Freshteam in Microsoft R Open.
-
How to connect and process Google Forms from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Google Forms.
-
Access Intercom Data from MySQL in Amazon QuickSight
Connect to Intercom and build visualizations of Intercom using a MySQL Connection in Amazon QuickSight.
-
Extend Google Sheets with Neo4J Data
Make calls to Neo4J from Google Apps Script via the API Server.
-
Connect to Azure Data Catalog Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Data Catalog to connect to Azure Data Catalog and execute queries in PowerBuilder.
-
How to Access Trello Data Using Entity Framework
This article shows how to access Trello using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to ConvertKit Data in NetBeans
Connect to ConvertKit in NetBeans with the data source configuration wizard.
-
Access LinkedIn Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access LinkedIn from your Oracle system.
-
Consume Google Directory OData Feeds in PowerBuilder
This article demonstrates how to consume Google Directory as OData feeds from PowerBuilder using the API Server.
-
How to connect to Drift Data with Squirrel SQL client
Connect to Drift and execute queries in the Squirrel SQL Client.
-
Integrate Missive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Missive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Missive.
-
Connect to Elasticsearch from Asprova with CData Software ODBC Driver for Elasticsearch
This article shows how to connect faster to Elasticsearch data from Asprova.
-
Deploy the ADO.NET Provider for SAP Business One on an SSRS Report Server
Connect to SAP Business One 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.
-
Automated Continuous Hive Replication to Vertica
Use CData Sync for automated, continuous, customizable Hive replication to Vertica.
-
Dynamics 365 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Dynamics 365 facts in real time.
-
Query, Visualize, and Share live Oracle Financials Cloud Data in Redash
Use CData Connect AI to connect to live Oracle Financials Cloud in Redash for querying, visualizing, and sharing.
-
Automated Continuous JSON Replication to AlloyDB
Use CData Sync for automated, continuous, customizable JSON replication to AlloyDB.
-
DataBind Controls to LionDesk Data in C++Builder
DataBind to LionDesk in C++Builder with standard components and controls.
-
Integrating Claude Code CLI with Adobe Experience Manager 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.
-
Replicate Multiple Hubstaff Accounts via the CData Sync CLI
Replicate multiple Hubstaff accounts to one or many databases.
-
How to Seamlessly Import SQL Server Data into IBM SPSS Modeler
Integrate SQL Server data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate with Live Microsoft Exchange Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Microsoft Exchange from the MuleSoft Anypoint Platform to integrate live Microsoft Exchange into custom reports and dashboards.
-
Connect to Sendwithus from Asprova with CData Software ODBC Driver for Sendwithus
This article shows how to connect faster to Sendwithus data from Asprova.
-
Create Data Visualizations Based On Oracle Service Cloud Data in Mode
Use CData Connect AI to connect to Oracle Service Cloud Data from Mode and build visualizations using live
-
Build Dashboards with Sentry Data in Dundas BI
Create dynamic dashboards and perform analytics based on Sentry in Dundas BI.
-
DataBind Controls to ChartMogul Data in C++Builder
DataBind to ChartMogul in C++Builder with standard components and controls.
-
Connect to Live Databricks Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Databricks in CData Connect AI and connect to your Databricks from PostgreSQL.
-
Integrate Lakebase Data in the Pentaho Report Designer
Publish reports based on Lakebase in the Pentaho BI tool.
-
Build AI/ML Models with Live Cvent Data using Dataiku
Connect Cvent Data with Dataiku using the CData JDBC Driver for Cvent.
-
Connect to Mixpanel Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mixpanel to connect to Mixpanel and execute queries in PowerBuilder.
-
How to Build an ETL App for SAP Business One Data in Python with CData
Create ETL applications and real-time data pipelines for SAP Business One in Python with petl.
-
How to Work with Reply.io Data in AWS Glue Jobs Using JDBC
Connect to Reply.io from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query PayPal Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume PayPal entities in PHP by modeling them as objects.
-
Create Reports with Sage Intacct Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Sage Intacct.
-
Query Pipeline CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Pipeline CRM.
-
Bind Live Microsoft Dataverse Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Dataverse data
-
Building Dynamic Web Pages with Snowflake Data Using AngularJS
Create single-page applications with live connectivity to Snowflake using the CData API Server.
-
Access Live Avalara AvaTax Data in Excel 365 Online (Excel for the web)
Connect to Avalara AvaTax from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Query FreshBooks Data in ColdFusion
Write standard ColdFusion data access code to connect to FreshBooks.
-
Analyze OpenWeatherMap Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for OpenWeatherMap from Power Pivot. You will use the Table Import Wizard to load OpenWeatherMap. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Quickbase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Quickbase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Placid Data from PowerBuilder via JDBC
This article demonstrates how to access Placid from PowerBuilder using the Placid JDBC Driver.
-
Integrate Salesforce Data 360 Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce Data 360 in the Pentaho Data Integration tool.
-
Building Dynamic Web Pages with Acumatica Data Using AngularJS
Create single-page applications with live connectivity to Acumatica using the CData API Server.
-
Connect to Real-Time Raisers Edge NXT Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Raisers Edge NXT and Dataflow to import and use Raisers Edge NXT in Power Apps.
-
Build Charts with PingOne Data in Clear Analytics
Create dynamic charts and perform analytics based on PingOne in Clear Analytics.
-
Access Live VWO Data in AWS Lambda
Connect to live VWO in AWS Lambda using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for MYOB AccountRight in MicroStrategy Web
Connect to MYOB AccountRight in MicroStrategy Web using the CData Software ODBC Driver for MYOB AccountRight.
-
How to Visualize iContact Data in Python with pandas
Use pandas and other modules to analyze and visualize live iContact in Python.
-
Integrate with Raisers Edge NXT Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Raisers Edge NXT in SnapLogic.
-
Integrating Antigravity CLI with Sage 300 via CData CLI
Connect Sage 300 to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Access Teradata Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teradata from your Oracle system.
-
Use Claude to Talk to Your DB2 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 IBM DB2 for you.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Cloudant actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Bridge Parquet Connectivity with Apache NiFi
Access and process Apache Parquet in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software ODBC Driver for Mailgun in MicroStrategy
Connect to Mailgun in MicroStrategy Developer using the CData Software ODBC Driver for Mailgun.
-
Getting Started with the CData Python Connector for Recurly
Learn to install and license the CData Python Connector
-
How to update Sybase IQ from Excel
This article explains how to transfer data from Excel to Sybase IQ using the Excel Add-In for Sybase IQ.
-
Import Real-Time Accelo Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Accelo in ColdFusion.
-
How to Connect to & Open Short.io Data in Microsoft Excel
This article uses the CData ODBC driver for Short.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Dropbox Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Dropbox Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Access Live Dynamics CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Dynamics CRM into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dynamics CRM in the Graph Builder and Query Builder.
-
How to publish and share Cloudflare Data dashboards with Tableau Server
The CData ODBC driver for Cloudflare enables you integrate Cloudflare into Tableau dashboards.
-
Automated Continuous EmailOctopus Replication to AlloyDB
Use CData Sync for automated, continuous, customizable EmailOctopus replication to AlloyDB.
-
Build ConvertKit-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to ConvertKit and build web apps with connectivity to live ConvertKit.
-
Connecting Moonlit Workflow with LinkedIn Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your LinkedIn in real time.
-
How to Connect the Power BI Service to LinkedIn Ads: Complete Guide
Connect to the CData Software Power BI Connector for LinkedIn Ads from PowerBI.com to provide real-time LinkedIn Ads across the organization.
-
How to connect to Email Data from Spring Boot
Connect to Email in a Spring Boot Application using the CData JDBC Driver for Email
-
Replicate Oracle Data in Heroku for Use in Salesforce Connect
Replicate Oracle Database to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Oracle Financials Cloud Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Oracle Financials Cloud to connect to Oracle Financials Cloud and execute queries in PowerBuilder.
-
Visualize LightSpeedRetail Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to LightSpeedRetail.
-
Use the CData Software ODBC Driver for Landbot in MicroStrategy Web
Connect to Landbot in MicroStrategy Web using the CData Software ODBC Driver for Landbot.
-
Access Live MongoDB Data in Excel 365 Online (Excel for the web)
Connect to MongoDB from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Publish MongoDB-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live MongoDB.
-
Automated Continuous Blackbaud FE NXT Replication to Databricks
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Databricks.
-
Connect to Live Zoho Books Data in MicroStrategy through CData Connect AI
Create a live connection to Zoho Books Data in CData Connect AI and connect to your Zoho Books from MicroStrategy.
-
How to Connect to Live QuickBooks Time Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your QuickBooks Time for you.
-
Connecting GenSpark with Procore Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Procore without any replication or custom integration required.