CData Software - Knowledge Base
Recent Articles
-
Use Manus AI to Talk to Your Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Oracle Sales data.
-
Publish Foursquare-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Foursquare data.
-
Connect to LDAP from Asprova with CData Software ODBC Driver for LDAP
This article shows how to connect faster to LDAP data from Asprova.
-
Access Live PingOne Data in Coginiti Pro
Connect to and query live PingOne data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze PabblySubscriptions Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PabblySubscriptions data with the CData JDBC Driver for PabblySubscriptions.
-
Build Voice Agents in ElevenLabs with access to Live xBase Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live xBase data.
-
Access Live Keap Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Keap data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Live Zendesk Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Zendesk in CData Connect AI and connect to your Zendesk data from PostgreSQL.
-
Build Voice Agents in ElevenLabs with access to Live SAP Fieldglass Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Fieldglass data.
-
How to Easily Query Asana Data in OpenOffice Base
Connect to Asana data in OpenOffice Base using the CData ODBC Driver for Asana and generate reports with live data insights.
-
Visualize Live MYOB AccountRight Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live MYOB AccountRight data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Browserless Data with Squirrel SQL client
Connect to Browserless data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Cvent Replication to Databricks
Use CData Sync for automated, continuous, customizable Cvent replication to Databricks.
-
Connect to Recurly Data in Jaspersoft Studio
Execute SQL to remote Recurly data in Jaspersoft Studio.
-
How to Work with ScrapingBee Data in ETL Validator JDBC
Connect to ScrapingBee from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Work with CapsuleCRM Data in ETL Validator JDBC
Connect to CapsuleCRM from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Keep Microsoft Access Working After an ERP Cloud Migration
A guide on using the CData ODBC Driver to restore Microsoft Access connectivity after a cloud ERP migration to NetSuite, Acumatica, or Business Central, enabling finance teams to run existing queries against live ERP data without rebuilding workflows.
-
Query Microsoft OneDrive Data as a SQL Server Database in Node.js
Execute SQL Server queries against Microsoft OneDrive data from Node.js.
-
Migrating data from Everhour to Databricks using CData SSIS Components.
Easily push Everhour data to Databricks using the CData SSIS Tasks for Everhour and Databricks.
-
Natively Connect to Cvent Data in PHP
The CData ODBC driver for Cvent enables you to create PHP applications with connectivity to Cvent data. Leverage the native support for ODBC in PHP.
-
Replicate Mouseflow Data from PowerShell
Write a quick PowerShell script to query Mouseflow data. Use connectivity to the live data to replicate Mouseflow data to SQL Server.
-
Connect to Authorize.Net Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Authorize.Net data.
-
Moving Data from SAP Fieldglass to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live SAP Fieldglass data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Live DB2 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live DB2 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Gmail 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 Gmail data.
-
Build AgileCRM-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to AgileCRM Data from Zoho Analytics and import live AgileCRM data.
-
Integrate Theia IDE with Live PolarTeamPro Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live PolarTeamPro data from within the development environment.
-
Connect to Pipeliner CRM Data in NetBeans
Connect to Pipeliner CRM data in NetBeans with the data source configuration wizard.
-
How to Visualize SAP SuccessFactors Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live SAP SuccessFactors data in Python.
-
Connecting Pipedream with Azure Data Lake Storage 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 Azure Data Lake Storage data in real time.
-
Load Retently Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Retently data to a database.
-
How to Access PolarTeamPro Data Using Entity Framework
This article shows how to access PolarTeamPro data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
View Reports on Real-Time Adobe Analytics Data in Power BI Report Server
Use the CData ODBC Driver for Adobe Analytics to visualize Adobe Analytics data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Live Active Directory 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 Active Directory data for you.
-
Choosing the Best Method to Connect AdRoll to SQL Server: 5 Options Explained
Discover multiple ways to connect and use AdRoll data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Oracle SCM Data from HeidiSQL
Use CData Connect AI to connect to and query live Oracle SCM data from HeidiSQL.
-
How to Connect to Live Exa Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Exa data through natural language.
-
Connect to Live Epicor Kinetic Data in MicroStrategy through CData Connect AI
Create a live connection to Epicor Kinetic Data in CData Connect AI and connect to your Epicor Kinetic data from MicroStrategy.
-
Analyze Google Cloud Storage Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Google Cloud Storage data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Hubstaff Data from PowerBuilder via ADO.NET
This article demonstrates how to access Hubstaff data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Replicate Helpscout Data in Heroku for Use in Salesforce Connect
Replicate Helpscout data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Integrating Claude Code with Cassandra Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Cassandra data within assisted coding and automated development workflows.
-
Use Manus AI to Talk to Your MailChimp Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on MailChimp data.
-
Build Omnisend-Connected Apps in Choreo
Use CData Connect AI to connect to Omnisend Data from Choreo and build custom apps using live Omnisend data.
-
Excel Spreadsheet Automation on Microsoft Entra ID Data with the QUERY Formula
Pull data from Microsoft Entra ID, automate spreadsheets, and more with the QUERY formula.
-
Integrate with live Salesforce Data 360 Data in Jitterbit
Use CData Connect AI to connect to and integrate live Salesforce Data 360 data in Jitterbit.
-
Bind Live WordPress Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live WordPress data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
How to Visualize Airtable Data in Python with pandas
Use pandas and other modules to analyze and visualize live Airtable data in Python.
-
Use the CData Software JDBC Driver for Aircall in MicroStrategy Web
Connect to Aircall data in MicroStrategy Web using the CData Software JDBC Driver for Aircall.
-
Connect to XML Data in Google Apps Script via Connect AI
Use CData Connect AI to access XML data in Google Apps Script.
-
How to Work with Elasticsearch Data in AWS Glue Jobs Using JDBC
Connect to Elasticsearch from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
LINQ to Redshift 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 Redshift Data Provider.
-
Import Real-Time HubSpot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use HubSpot data in ColdFusion.
-
Connect to ConvertKit Data from PowerBuilder via JDBC
This article demonstrates how to access ConvertKit data from PowerBuilder using the ConvertKit JDBC Driver.
-
Integrate Live Campaigner Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Campaigner data and integrate live Campaigner data into apps built in Microsoft Power Apps.
-
How to Connect to & Open Google Campaign Manager 360 Data in Microsoft Excel
This article uses the CData ODBC driver for Google Campaign Manager 360 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
ETL Raisers Edge NXT in Oracle Data Integrator
This article shows how to transfer Raisers Edge NXT data into a data warehouse using Oracle Data Integrator.
-
Build Apps with Live Contentful Data Using the Low-Code Development Platform of Mendix
Connect Contentful data with Mendix to build apps using the CData API Driver for JDBC.
-
Automated Continuous Jira Assets Replication to SingleStore
Use CData Sync for automated, continuous, customizable Jira Assets replication to SingleStore.
-
How to load Todoist data into Elasticsearch via Logstash
Introducing a simple method to load Todoist data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate GitHub with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate GitHub with External Services.
-
Migrating data from Sendwithus to Snowflake using CData SSIS Components.
Easily push Sendwithus data to Snowflake using the CData SSIS Tasks for Sendwithus and Snowflake.
-
Build a Simple VCL Application for JobNimbus Data
How to build a simple VCL Application to view JobNimbus data in RAD Studio using the CData ODBC Driver for JobNimbus.
-
Integrating Gumloop with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Acumatica data within automated workflows.
-
Process & Analyze Google Cloud Storage Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Google Cloud Storage Data.
-
Access Redshift 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 Redshift data.
-
Integrate Cursor with Live Twitter Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Twitter Ads data from within the editor.
-
Using the CData Software ODBC Driver for Certinia in PyCharm
Connect to Certinia as an ODBC data source in PyCharm using the CData Software ODBC Driver for Certinia.
-
Use Agno to Talk to Your Dynamics CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Dynamics CRM data for you.
-
Search External PolarTeamPro Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PolarTeamPro data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PolarTeamPro Data objects that you can access from apps and the dashboard.
-
Connect to Certinia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Certinia data from Appeon PowerBuilder using the CData ADO.NET Provider for Certinia.
-
How to connect Amazon QuickSight to PolarTeamPro Data
Create a connection to PolarTeamPro data in CData Connect AI and insert PolarTeamPro data into Amazon QuickSight SPICE to build interactive dashboards.
-
Add Azure DevOps Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Azure DevOps with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate Cursor with Live ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ConstantContact data from within the editor.
-
How to Build an ETL App for Shopify Data in Python with CData Connect AI
Build ETL pipelines that read and write live Shopify data in Python with petl and the CData Connect AI Python SDK.
-
Build Omnisend-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Omnisend data and build web apps with connectivity to live Omnisend data.
-
Visualize Live FTP Data in the Power BI Service
Use CData Connect AI to connect to live FTP data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from SQL Server to Azure Table through SSIS
Easily push SQL Server data to Azure Table using the CData SSIS Tasks for Azure Table.
-
Access Cassandra Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Cassandra data from HeidiSQL.
-
Design BIRT Reports on xBase Data
Provide current xBase data to your embedded analytics.
-
Access Shopify Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Shopify data from your Oracle system.
-
Visualize Freshdesk Data in TIBCO Spotfire through ADO.NET
Integrate Freshdesk data into dashboards in TIBCO Spotfire.
-
Build Data Flows from Neo4J to SQL Server using SSIS
Easily back up Neo4J data to SQL Server using the SSIS components for Neo4J.
-
Integrating Boomi Agentstudio with TaxJar Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to TaxJar data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Automated Continuous ZarMoney Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable ZarMoney replication to Google Cloud SQL.
-
Connect to Copper Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Copper data in the Denodo Virtual DataPort Administrator.
-
Connect to SAP BusinessObjects BI Data in RapidMiner
Integrate SAP BusinessObjects BI data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Create Power BI Visual Reports with Real-Time Jira Data
Use CData Power BI Connectors to visualize Jira data in Power BI.
-
Visualize Okta Data in Tableau
The CData ODBC driver for Okta enables you integrate Okta data into Tableau dashboards.
-
Integrating Cursor with Databricks 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.
-
Integrate Outreach.io Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Outreach.io data and integrate live Outreach.io data into your Power Automate tasks.
-
ETL VWO in Oracle Data Integrator
This article shows how to transfer VWO data into a data warehouse using Oracle Data Integrator.
-
Integrate Open WebUI with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live ADP data from within the chat interface.
-
Replicate Brex Data from PowerShell
Write a quick PowerShell script to query Brex data. Use connectivity to the live data to replicate Brex data to SQL Server.
-
Integrate with live ShipStation Data in Jitterbit
Use CData Connect AI to connect to and integrate live ShipStation data in Jitterbit.
-
Natively Connect to AlloyDB Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to AlloyDB data. Leverage the native support for ODBC in PHP.
-
How to Easily Query GraphQL Data in OpenOffice Base
Connect to GraphQL data in OpenOffice Base using the CData ODBC Driver for GraphQL and generate reports with live data insights.
-
How to Connect the Power BI Service to Amplitude: Complete Guide
Connect to the CData Software Power BI Connector for Amplitude from PowerBI.com to provide real-time Amplitude data across the organization.
-
Analyze MessageBird Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze MessageBird data in Microsoft R Open.
-
Visualize Databricks Data in TIBCO Spotfire through OData
Integrate Databricks data into dashboards in TIBCO Spotfire.