CData Software - Knowledge Base
Recent Articles
-
How to connect SharePoint with Dynamics 365 Business Central Data through external lists
Provide Dynamics 365 Business Central data to SharePoint users as an external list.
-
Access Live Close Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Close data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Grok to Talk to Your Sybase 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 Sybase data for you.
-
Getting Started with the CData SSIS Components for ChargeOver
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ChargeOver.
-
Build a PostgreSQL Interface for Productboard Data using the CData JDBC Driver
Use the Remoting features of the Productboard JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automate Adobe Experience Manager Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Adobe Experience Manager data from PowerShell? This article demonstrates how to utilize the Adobe Experience Manager Cmdlets for tasks like connecting to Adobe Experience Manager data, automating operations, downloading data, and more.
-
Create Redshift Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Redshift data access from reports, embedded analytics, and more.
-
How to load AgileCRM data into Elasticsearch via Logstash
Introducing a simple method to load AgileCRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Analyze Live SAP SuccessFactors LMS Data in SAS Viya
Use CData Connect AI to connect to SAP SuccessFactors LMS data from SAS Viya and deploy self-service analytics using live SAP SuccessFactors LMS data.
-
Connect to Templated Data in RazorSQL
Connect to Templated from wizards and query Templated data from the GUI in the RazorSQL database management tool.
-
Integrating LlamaIndex with TaxJar Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on TaxJar data in real time.
-
Create Couchbase-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Couchbase Data from Klipfolio and build custom visualizations using live Couchbase data.
-
Automated Continuous Google Cloud Storage Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to SingleStore.
-
Integrate Cline with Live Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Paymo data from within your IDE.
-
View Reports on Real-Time Placid Data in Power BI Report Server
Use the CData ODBC Driver for Placid to visualize Placid data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to API Data from HeidiSQL
Use CData Connect AI to connect to and query live API data from HeidiSQL.
-
A PostgreSQL Interface for Shippo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Shippo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous SQL Server Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable SQL Server replication to Google Cloud SQL.
-
How to Query SAP BusinessObjects BI Data in MySQL Workbench
Execute MySQL queries against live SAP BusinessObjects BI data from MySQL Workbench.
-
Use the CData ODBC Driver for RabbitMQ in Microsoft Power Query
You can use the CData RabbitMQ ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import RabbitMQ data into Microsoft Power Query.
-
Process & Analyze Perigon Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Perigon Data.
-
Query Mocean Data as a MySQL Database in Node.js
Execute MySQL queries against Mocean data from Node.js.
-
Create Adobe Target-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Adobe Target Data from Klipfolio and build custom visualizations using live Adobe Target data.
-
Create SSAS Tabular Models from Google Ads Data
How to build a SQL Server Analysis Service Tabular Model from Google Ads data using CData drivers.
-
Connect to ZarMoney Data from PowerBuilder via JDBC
This article demonstrates how to access ZarMoney data from PowerBuilder using the ZarMoney JDBC Driver.
-
Integrate OpenCode with Live Facebook Ads Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Facebook Ads data from within your AI coding agent.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Moosend
Provide connectivity to Moosend data through an SAP BusinessObjects universe.
-
Integrating LangChain with Confluence Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Confluence data within automated workflows.
-
Connect to Mixpanel Data in Ruby
Connect to Mixpanel data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Interact with Live Twilio Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Twilio data.
-
Connect to ScrapingBee Data in JRuby
Create a simple JRuby app with access to live ScrapingBee data.
-
Automated Continuous Google Campaign Manager 360 Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Apache Kafka.
-
Use the CData ODBC Driver for Gmail in Microsoft Power Query
You can use the CData Gmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Gmail data into Microsoft Power Query.
-
Connect to Bright Data Data from Crystal Reports
Use CData Connect AI to connect to and report on live Bright Data data from Crystal Reports.
-
Connect to Toggl Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Toggl.
-
How to create Snowflake federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Snowflake data in MySQL .
-
Connect to Aha! 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 Aha! and work with Aha! data in your FileMaker application.
-
Visualize Timely Data in TIBCO Spotfire through ADO.NET
Integrate Timely data into dashboards in TIBCO Spotfire.
-
Integrate Google Campaign Manager 360 Data into Power Automate Desktop using CData Connect
CData Connect for Google Campaign Manager 360 Data enables you to integrate Google Campaign Manager 360 data into workflows built using Microsoft Power Automate Desktop.
-
Integrating Claude Code CLI with PabblySubscriptions 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.
-
Using the CData Software ODBC Driver for OData in PyCharm
Connect to OData as an ODBC data source in PyCharm using the CData Software ODBC Driver for OData.
-
Connect to iContact Data from a Connection Pool in Jetty
The iContact JDBC Driver supports connection pooling: This article shows how to connect faster to iContact data from Web apps in Jetty.
-
DataBind Charts to HubSpot Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to HubSpot data 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 Perplexity with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Perplexity with External Services.
-
Choosing the Best Method to Connect Square to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Square data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect Greenplum to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Greenplum with IBM WebSphere for seamless data integration and connectivity.
-
Visualize GitLab Data in Sisense
Create an ElastiCube in Sisense app with access to GitLab data.
-
Build AI/ML Models with Live Paylocity Data using Dataiku
Connect Paylocity Data with Dataiku using the CData JDBC Driver for Paylocity.
-
Automated Continuous Landbot Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Landbot replication to Apache Cassandra.
-
How to Connect DBeaver to Salesforce CRM Analytics via a JDBC Driver
Manage Salesforce CRM Analytics data with visual tools in DBeaver like the query browser.
-
Integrate LibreChat with Live DB2 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live DB2 data from within the chat interface.
-
Automated Continuous Figshare Replication to SQLite
Use CData Sync for automated, continuous, customizable Figshare replication to SQLite.
-
Connect to Teamwork Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Teamwork and work with Teamwork data in your FileMaker applications.
-
Automated Continuous Perplexity Replication to Databricks
Use CData Sync for automated, continuous, customizable Perplexity replication to Databricks.
-
Connect to Azure Table Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure Table to connect to Azure Table data and execute queries in PowerBuilder.
-
Connect to PagerDuty Data from a Connection Pool in JBoss
Integrate PagerDuty data into Java servlets: Use the Management Console in JBoss to install the PagerDuty JDBC Driver.
-
Query SAP HANA Data as a SQL Server Database in Node.js
Execute SQL Server queries against SAP HANA data from Node.js.
-
Use the CData Software ODBC Driver for DocuSign in MicroStrategy Desktop
Connect to DocuSign data in MicroStrategy Desktop using the CData Software ODBC Driver for DocuSign.
-
Build Dynamics NAV Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Dynamics NAV data and build visualizations in Tableau Cloud.
-
Connect to SpaceX Data from a Connection Pool in Jetty
The SpaceX JDBC Driver supports connection pooling: This article shows how to connect faster to SpaceX data from Web apps in Jetty.
-
Replicate Multiple Qualaroo Accounts via the CData Sync CLI
Replicate multiple Qualaroo accounts to one or many databases.
-
How to Access Databricks Data Using Entity Framework
This article shows how to access Databricks data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Klaviyo Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Klaviyo to connect to Klaviyo data and execute queries in PowerBuilder.
-
BenchmarkEmail Reporting in OBIEE with the BenchmarkEmail JDBC Driver
Deploy the BenchmarkEmail JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish ZohoSubscriptions-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ZohoSubscriptions data.
-
Getting Started with the CData Power BI Connector for PayPal
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PayPal.
-
Build an OLAP Cube in SSAS from XML Data
Establish a connection to XML data data from SQL Server Analysis Services, and use the XML Data Provider to build OLAP cubes for use in analytics and reporting.
-
Operational Reporting on Active Directory Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Active Directory data.
-
Build Kintone-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Kintone data without replication.
-
Build MVC Applications with Connectivity to Azure Table Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Azure Table from an ASP.NET MVC application.
-
Build Agents in Relevance AI with Access to Live Cloudflare Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Cloudflare data within intelligent agent workflows.
-
Query ServiceNow Data in DataGrip
Create a Data Source for ServiceNow in DataGrip and use SQL to query live ServiceNow data.
-
Replicate Salesforce Data 360 Data from PowerShell
Write a quick PowerShell script to query Salesforce Data 360 data. Use connectivity to the live data to replicate Salesforce Data 360 data to SQL Server.
-
Provide OData Services of Sybase IQ Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Sybase IQ data by developing a WCF Service Application.
-
Build a Simple VCL Application for ConvertAPI Data
How to build a simple VCL Application to view ConvertAPI data in RAD Studio using the CData ODBC Driver for ConvertAPI.
-
Connect and Visualize Live Gmail Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Gmail data into the Databricks platform and create visualization dashboards with real-time Gmail data.
-
Use the CData Software JDBC Driver for Bright Data in MicroStrategy
Connect to Bright Data data in MicroStrategy Developer using the CData Software JDBC Driver for Bright Data.
-
Use JayDeBeApi to access SQL Analysis Services Data in Python
Use standard Python scripting and the development environment of your choice to access live SQL Analysis Services data.
-
Visualize Auth0 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Auth0 data.
-
Connect Smartsheet to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Smartsheet data using the CData Python MCP Server.
-
How to use SQLAlchemy ORM to access Epicor Kinetic Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Epicor Kinetic data.
-
Integrate Printful Data in Pentaho Data Integration
Build ETL pipelines based on Printful data in the Pentaho Data Integration tool.
-
Use the CData Software ODBC Driver for ConstantContact in SAS for Real-Time Reporting and Analytics
Connect to real-time ConstantContact data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for ConstantContact.
-
Write a Simple Go Application to work with Teradata Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Teradata data.
-
Connect and Visualize Live Box Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Box data into the Databricks platform and create visualization dashboards with real-time Box data.
-
Integrating OpenCode with Office 365 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 ODBC Driver for Insightly in Microsoft Power Query
You can use the CData Insightly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Insightly data into Microsoft Power Query.
-
How to Connect to Live GitHub Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your GitHub data for you.
-
Access Live PostgreSQL Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate PostgreSQL data into the statistical analysis tools available in SAS JMP. This article shows how to use PostgreSQL data in the Graph Builder and Query Builder.
-
How to create Workday federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Workday data in MySQL .
-
Excel Spreadsheet Automation on Yelp Data with the QUERY Formula
Pull data from Yelp, automate spreadsheets, and more with the QUERY formula.
-
Create Power BI Reports on Real-Time SendGrid Data
Use the CData ODBC Driver for SendGrid to visualize SendGrid data in Power BI Desktop.
-
DataBind Charts to Google Ads Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Ads data 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.
-
Migrating data from Quickbase to Databricks using CData SSIS Components.
Easily push Quickbase data to Databricks using the CData SSIS Tasks for Quickbase and Databricks.
-
How to use SQLAlchemy ORM to access Stripe Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Stripe data.
-
Automated Continuous ZarMoney Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZarMoney data replication to OneLake in Microsoft Fabric.
-
Integrate Goose with Live Adobe Target Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Adobe Target data from within the local AI agent.
-
How to create Visio diagrams from Couchbase Data
Automatically update Couchbase data with the changes you make to Visio master shapes.
-
Connect to Oracle Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Oracle data.
-
Query Everhour Data in DataGrip
Create a Data Source for Everhour in DataGrip and use SQL to query live Everhour data.