CData Software - Knowledge Base
Recent Articles
-
Connect Azure Table to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Azure Table with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Live Exact Online Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Exact Online using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
A PostgreSQL Interface for Email Data (MySQL Remoting via JDBC)
Use the Remoting features of the Email JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Spark Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Apache Spark SQL from Filemaker Pro on Mac.
-
Use Azure AI Foundry to Talk to Your Presto 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 Presto for you.
-
Integrating OpenCode Terminal with LDAP Objects 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 RabbitMQ Data in Aqua Data Studio
Access RabbitMQ from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Using the CData Software ODBC Driver for LeadDesk in PyCharm
Connect to LeadDesk as an ODBC data source in PyCharm using the CData Software ODBC Driver for LeadDesk.
-
Integrate Cursor with Live Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Snapchat Ads from within the editor.
-
How to Work with Power BI XMLA Data in ETL Validator JDBC
Connect to Power BI XMLA from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Reports from Sybase IQ Data in Looker Studio
Use CData Connect AI to gain access to live Sybase IQ and create custom reports in Looker Studio.
-
Migrating data from Printify to Databricks using CData SSIS Components.
Easily push Printify to Databricks using the CData SSIS Tasks for Printify and Databricks.
-
Create ShipStation Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time ShipStation data access from reports, embedded analytics, and more.
-
Query Delighted Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Delighted from Node.js.
-
Replicate Multiple Google Calendar Accounts via the CData Sync CLI
Replicate multiple Google Calendar accounts to one or many databases.
-
Connect to and Query Yelp Data in QlikView over ODBC
Create data visualizations with Yelp in QlikView.
-
Connect to Facebook Data in Google Apps Script via Connect AI
Use CData Connect AI to access Facebook in Google Apps Script.
-
Replicate GitHub Data in Heroku for Use in Salesforce Connect
Replicate GitHub to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Analyze Phoenix Data in Looker
Use CData Connect AI to connect to Phoenix Data from Looker and build custom apps using live Apache Phoenix.
-
Amazon Athena Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amazon Athena facts in real time.
-
Import Real-Time Kintone Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Kintone in ColdFusion.
-
Visualize Live LinkedIn Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live LinkedIn using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To a JDBC Data Source for ChargeOver
Create ChargeOver data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Query Live QuickBooks Online Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live QuickBooks Online directly from the development environment.
-
Build a Singer.io Tap for Amazon DynamoDB With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon DynamoDB data using
-
Connect to Salesforce CRM Analytics Data in ACL Analytics
Connect to Salesforce CRM Analytics via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Salesforce CRM Analytics.
-
Connect to FTP Data from HeidiSQL
Use CData Connect AI to connect to and query live FTP Servers from HeidiSQL.
-
Connect to Eventbrite Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Eventbrite in the Denodo Virtual DataPort Administrator.
-
Migrating data from SendInBlue to Snowflake using CData SSIS Components.
Easily push SendInBlue to Snowflake using the CData SSIS Tasks for SendInBlue and Snowflake.
-
Integrating LangGraph with Basecamp Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Basecamp within automated workflows.
-
Use Claude to Talk to Your Greenplum 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 Pivotal GreenPlum for you.
-
How to integrate Okta with Apache Airflow
Access and process Okta in Apache Airflow using the CData JDBC Driver.
-
Access Confluence 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 Atlassian Confluence.
-
Replicate Instagram Data to Multiple Databases via the CData Sync CLI
Replicate Instagram to disparate databases with a single configuration.
-
Connect to Twilio Data from HeidiSQL
Use CData Connect AI to connect to and query live Twilio from HeidiSQL.
-
Create Google Contacts-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Contacts Data from Klipfolio and build custom visualizations using live Google Contacts.
-
Replicate Multiple Act-On Accounts via the CData Sync CLI
Replicate multiple Act-On accounts to one or many databases.
-
Migrating data from Dropbox to Snowflake using CData SSIS Components.
Easily push Dropbox to Snowflake using the CData SSIS Tasks for Dropbox and Snowflake.
-
How to Query BigCommerce Data in MySQL Workbench
Execute MySQL queries against live BigCommerce from MySQL Workbench.
-
Model Monday.com Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Monday.com, enabling the direct import of real-time Monday.com.
-
Create Reports with Gorgias Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Gorgias.
-
How to Connect to LightSpeedRetail Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LightSpeedRetail. Leverage the pyodbc module for ODBC in Python.
-
Connect to Moosend Data in DBeaver
Use the CData ODBC Driver to connect to Moosend in DBeaver.
-
Write a Simple Go Application to work with ChargeOver Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ChargeOver.
-
Connect to Highrise 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 Highrise CRM.
-
Connect to Typeform Data in RapidMiner
Integrate Typeform with standard components and data source configuration wizards in RapidMiner Studio.
-
Integrate Live AgileCRM Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live AgileCRM to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Create Datasets from Tickspot in Domo Workbench and Build Visualizations of Tickspot Data in Domo
Use the CData Software ODBC Driver for Tickspot to create datasets from Tickspot in Domo Workbench and then build visualizations in the Domo service.
-
Create Data Visualizations in Cognos BI with Calendly Data
Access Calendly as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Visualize Live FTP Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live FTP Servers using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Lakebase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Lakebase and build Lakebase-connected web apps with Axios.
-
Natively Connect to ConstantContact Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to ConstantContact. Leverage the native support for ODBC in PHP.
-
Connect to Pipeline CRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Pipeline CRM to connect to Pipeline CRM and execute queries in PowerBuilder.
-
Build Microsoft Ads-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Microsoft Ads to explore live Microsoft Ads Data in Gemini Code Assist to assist with building Microsoft Ads-powered applications.
-
Use JayDeBeApi to access Anaplan Data in Python
Use standard Python scripting and the development environment of your choice to access live Anaplan.
-
How to use SQLAlchemy ORM to access Anaplan Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Anaplan.
-
Integrating Apollo Data in Talend Cloud Data Management Platform
Connect Apollo Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Operational Reporting on ElevenLabs Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ElevenLabs.
-
Connect to and Query Redis Data in QlikView over ODBC
Create data visualizations with Redis in QlikView.
-
Build MVC Applications with Connectivity to Trello Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Trello from an ASP.NET MVC application.
-
Add Teamwork Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Teamwork with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Access SQL Analysis Services Data Using Entity Framework
This article shows how to access SQL Analysis Services using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Design BIRT Reports on Superchat Data
Provide current Superchat to your embedded analytics.
-
Connect to Elorus Data from a Connection Pool in Jetty
The Elorus JDBC Driver supports connection pooling: This article shows how to connect faster to Elorus from Web apps in Jetty.
-
Integrating Dataiku with Zoho Books Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zoho Books.
-
Use the CData Software JDBC Driver for CouchDB in MicroStrategy
Connect to Apache CouchDB in MicroStrategy Developer using the CData Software JDBC Driver for CouchDB.
-
Visualize Live Google Campaign Manager 360 Data in the Power BI Service
Use CData Connect AI to connect to live Google Campaign Manager 360 and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Visualize Templated Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Templated.
-
Build Apps with Live Grafana Data Using the Low-Code Development Platform of Mendix
Connect Grafana with Mendix to build apps using the CData API Driver for JDBC.
-
Build Dashboards with Placid Data in DBxtra
Create dynamic dashboards and perform analytics based on Placid in DBxtra.
-
Replicate Sybase Data to Multiple Databases
Replicate Sybase to disparate databases with a point-and-click configuration.
-
Analyze Adobe Analytics Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Analytics and visualize live Adobe Analytics in Infragistics Reveal.
-
Visualize NetSuite Data in Tableau
The CData ODBC driver for NetSuite enables you integrate NetSuite CRM & ERP into Tableau dashboards.
-
Integrate Real-Time Access to Hive in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Hive in real time.
-
Publish Reports with ClickUp Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ClickUp.
-
Replicate CouchDB Data to Multiple Databases via the CData Sync CLI
Replicate Apache CouchDB to disparate databases with a single configuration.
-
Working with Cosmos DB Data in LINQPad
Execute LINQ queries to Azure Cosmos DB in LINQPad.
-
Use the CData Software ODBC Driver for Printful in MicroStrategy Desktop
Connect to Printful in MicroStrategy Desktop using the CData Software ODBC Driver for Printful.
-
Connect to Billsby Data in RazorSQL
Connect to Billsby from wizards and query Billsby from the GUI in the RazorSQL database management tool.
-
Integrate with Quickbase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Quickbase to a JSON file on disk.
-
Automate Codat Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Codat from PowerShell? This article demonstrates how to utilize the Codat Cmdlets for tasks like connecting to Codat, automating operations, downloading data, and more.
-
Connect to and Visualize Live SendGrid Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SendGrid.
-
Rapidly Develop Sybase-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 Sybase.
-
Enable the Microsoft Exchange JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Exchange.
-
Perform Batch Operations with Xero Data in Apache NiFi
Connect to Xero Accounting and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Automated Continuous MarkLogic Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MarkLogic replication to AlloyDB.
-
Integrating Antigravity CLI with Intercom via CData CLI
Connect Intercom to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automate Avaza Data Replication to Couchbase
Use CData Sync to Customize and automate Avaza replication to Couchbase.
-
Connect to Klaviyo Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Klaviyo and the Script function in FileMaker Pro to connect to Klaviyo and work with Klaviyo in your FileMaker application.
-
How to Connect to Live OneNote Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft OneNote for you.
-
Integrate Marketo Data in the Pentaho Report Designer
Publish reports based on Marketo in the Pentaho BI tool.
-
How to Connect to Live SingleStore 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 SingleStore for you.
-
Create Sage Intacct-Connected Business Apps in AppSheet
Connect to Sage Intacct Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Sage Intacct.
-
Publish LionDesk-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live LionDesk.
-
Enable the OnePageCrm JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with OnePageCrm.
-
Automated Twitter Ads Data Replication to Teradata
Use CData Sync to Customize and automate Twitter Ads replication to Teradata.
-
LINQ to Bullhorn CRM Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Bullhorn CRM Data Provider.
-
How to Connect to & Open PingOne Data in Microsoft Excel
This article uses the CData ODBC driver for PingOne to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Using the CData Software ODBC Driver for BigQuery in PyCharm
Connect to BigQuery as an ODBC data source in PyCharm using the CData Software ODBC Driver for BigQuery.
-
Getting Started with the CData ADO.NET Provider for TaxJar
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for TaxJar.