CData Software - Knowledge Base
Recent Articles
-
Use Agno to Talk to Your Oracle HCM Cloud 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 Oracle HCM Cloud for you.
-
How to Seamlessly Import Harvest Data into IBM SPSS Modeler
Integrate Harvest data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Add Rootly Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Rootly with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Query Live Aweber Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Aweber data in natural language using Python.
-
Connect to SQL Server Data in RapidMiner
Integrate Microsoft SQL Server with standard components and data source configuration wizards in RapidMiner Studio.
-
Using the CData Software ODBC Driver for BambooHR in PyCharm
Connect to BambooHR as an ODBC data source in PyCharm using the CData Software ODBC Driver for BambooHR.
-
Query Klaviyo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Klaviyo from Node.js.
-
Connect to Insightly Data from a Connection Pool in Jetty
The Insightly JDBC Driver supports connection pooling: This article shows how to connect faster to Insightly from Web apps in Jetty.
-
Connecting Agentforce with Email Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Email for you.
-
Create Power BI Reports on Real-Time Todoist Data
Use the CData ODBC Driver for Todoist to visualize Todoist in Power BI Desktop.
-
Connect to Bugsnag from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bugsnag to connect to Bugsnag from Web applications running on WebLogic.
-
Connect and Query Live Oracle Service Cloud Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Oracle Service Cloud into Databricks
-
Access Live Microsoft Teams Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Teams data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to connect to ServiceDesk Plus Data from IntelliJ
Integrate connectivity to ServiceDesk Plus with wizards in IntelliJ.
-
Automated Continuous Stack Exchange Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Google Cloud SQL.
-
Use CData Connect AI to Access Google Cloud Storage Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Google Cloud Storage in the Power Pivot business intelligence tool.
-
Connect Google Directory to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Directory with IBM WebSphere for seamless data integration and connectivity.
-
How to Connect DBeaver to ADP via a JDBC Driver
Manage ADP with visual tools in DBeaver like the query browser.
-
A PostgreSQL Interface for Microsoft Dataverse Data using the CData ODBC Driver
Use the SQL Gateway and Microsoft Dataverse ODBC Driver to create a PostgreSQL entry-point for data access.
-
Import Real-Time PolarTeamPro Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PolarTeamPro in ColdFusion.
-
Connect to GraphQL 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 GraphQL.
-
Use Databricks Agent Bricks to Talk to Your MailChimp Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MailChimp for you.
-
Establish a Live Connection with eBay Data using Tableau Bridge
The CData ODBC Driver for eBay enables you to integrate live eBay into Tableau Cloud dashboards using the Tableau Bridge.
-
DataBind Charts to Adobe Target Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Adobe Target 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.
-
Connect to Egnyte Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Egnyte and the SQL Gateway to access Egnyte from Google Apps Script.
-
Reply.io Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reply.io facts in real time.
-
Build Semantic Layer Views for Snowflake Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Snowflake.
-
How to connect PolyBase to SAP BusinessObjects BI
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP BusinessObjects BI.
-
How to Connect to Live MariaDB 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 MariaDB for you.
-
Connect Eventbrite to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Eventbrite using the CData Python MCP Server.
-
Access Live Timely Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Timely in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Facebook Data from PowerBuilder via ADO.NET
This article demonstrates how to access Facebook from Appeon PowerBuilder using the CData ADO.NET Provider for Facebook.
-
Query Epicor Kinetic Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Epicor Kinetic and perform CRUD operations on Epicor Kinetic from Node.js.
-
Connect to Azure DevOps Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Azure DevOps Data and connect to Azure DevOps in Akorbi Digital RunMyProcess.
-
Create Dashboards and Visualize Live PostgreSQL Data in Geckoboard
Use CData Connect AI to connect to live PostgreSQL and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Analyze Zoho Books Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Zoho Books in Microsoft R Open.
-
Integrate with Live Stripe Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Stripe from the MuleSoft Anypoint Platform to integrate live Stripe into custom reports and dashboards.
-
Connect to SQL Server Data in ACL Analytics
Connect to Microsoft SQL Server via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Microsoft SQL Server.
-
How to connect to Samanage Data from IntelliJ
Integrate connectivity to Samanage with wizards in IntelliJ.
-
Build Dashboards with Asana Data in DBxtra
Create dynamic dashboards and perform analytics based on Asana in DBxtra.
-
How to Connect to Live Jira Assets 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 Jira Assets for you.
-
Create Reports with Pingdom Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pingdom.
-
How to use SQLAlchemy ORM to access SAS xpt Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAS XPORT.
-
Use the CData ODBC Driver for MailChimp from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MailChimp to connect to MailChimp from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MailChimp in Excel.
-
Import Vertica Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Vertica Data and provide access to live Vertica for custom reports in the Power BI Service.
-
Migrating data from Aircall to Google BigQuery using CData SSIS Components.
Easily push Aircall to Google BigQuery using the CData SSIS Tasks for Aircall and Google BigQuery.
-
Build Google Directory-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Google Directory to explore live Google Directory Data in GitHub Copilot to assist with building Google Directory-powered applications.
-
DataBind Controls to Amazon Athena Data in C++Builder
DataBind to Amazon Athena in C++Builder with standard components and controls.
-
Integrate with SQL Server Data in JReport Designer
Create charts and reports based on Microsoft SQL Server in JReport Designer.
-
How to connect to Mixpanel Data in DBVisualizer
Integrate Mixpanel with visual data analysis tools and data connection wizards in DBVisualizer
-
Automate Dynamics NAV Data Replication to SAP HANA
Use CData Sync to customize and automate Microsoft Dynamics NAV replication to SAP HANA.
-
Design BIRT Reports on Confluence Data
Provide current Atlassian Confluence to your embedded analytics.
-
Connect to SAP Netweaver Gateway Data from AWS Glue
Use CData Connect AI to gain access to live SAP Netweaver Gateway from your AWS Glue jobs.
-
Server Error: No pg_hba.conf Entry for Host
In this entry, you will find resolutions for this error when attempting to connect remotely to a PostgreSQL database.
-
Moving Data from HCL Domino to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live HCL Domino data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Publish Crystal Reports on Amplitude Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Amplitude.
-
Connect Acumatica to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Acumatica ERP using the CData Python MCP Server.
-
How to Visualize Clari Data in Python with pandas
Use pandas and other modules to analyze and visualize live Clari in Python.
-
Automate Facebook Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Facebook Ads replication to Couchbase.
-
Build Office 365-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Microsoft Office 365 and build web apps with connectivity to live Microsoft Office 365.
-
Connect to Live Gong Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Gong in CData Connect AI and connect to your Gong from PostgreSQL.
-
Build Smartsheet-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Smartsheet.
-
Getting Started with the CData ADO.NET Provider for HubSpot
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HubSpot.
-
How to connect to PagerDuty Data from IntelliJ
Integrate connectivity to PagerDuty with wizards in IntelliJ.
-
Automated Continuous HubSpot Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable HubSpot replication to delimited files (CSV/TSV).
-
DataBind ChargeOver Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ChargeOver to a chart.
-
Use the CData Software ODBC Driver for REST in MicroStrategy Desktop
Connect to REST in MicroStrategy Desktop using the CData Software ODBC Driver for REST.
-
How to Access Live Salesforce Data 360 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Salesforce Data 360 enables you to integrate Salesforce Data 360 into workflows built using Microsoft Power Automate Desktop.
-
Connect to Hive Data in DBArtisan
Use wizards in DBArtisan to configure Apache Hive as a data source.
-
Analyze ServiceDesk Plus Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze ServiceDesk Plus with the CData JDBC Driver for ServiceDesk Plus.
-
Build SingleStore-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SingleStore to explore live SingleStore Data in Claude Code to assist with building SingleStore-powered applications.
-
Build a PostgreSQL Interface for Apify Data using the CData JDBC Driver
Use the Remoting features of the Apify JDBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Charts to SuiteCRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SuiteCRM 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.
-
How to Access eBay Analytics Data Using Entity Framework
This article shows how to access eBay Analytics using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Connect to Freshsales Data from a Connection Pool in JBoss
Integrate Freshsales into Java servlets: Use the Management Console in JBoss to install the Freshsales JDBC Driver.
-
Natively Connect to Sage 300 Data in PHP
The CData ODBC driver for Sage 300 enables you to create PHP applications with connectivity to Sage 300. Leverage the native support for ODBC in PHP.
-
How to publish and share Wave Financial Data dashboards with Tableau Server
The CData ODBC driver for Wave Financial enables you integrate Wave Financial into Tableau dashboards.
-
How to connect and process Epicor Kinetic from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Epicor Kinetic.
-
How to Create Power BI Visual Reports with Real-Time Epicor Kinetic Data
Use CData Power BI Connectors to visualize Epicor Kinetic in Power BI.
-
Publish Reports with Spotify Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Spotify.
-
Manage Nethunt Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Nethunt.
-
Work with Live Cloudant Data in Power Query
Use CData Connect AI to connect to IBM Cloudant and work with live IBM Cloudant in Microsoft Power Query.
-
Establish a Live Connection with ZohoInvoice Data using Tableau Bridge
The CData ODBC Driver for ZohoInvoice enables you to integrate live ZohoInvoice into Tableau Cloud dashboards using the Tableau Bridge.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Timely
Provide connectivity to Timely through an SAP BusinessObjects universe.
-
Automated Continuous Stack Exchange Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Stack Exchange replication to Azure SQL Database.
-
Integrating OpenCode Terminal with ZohoPeople 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.
-
How to work with Sage Intacct Data in Apache Spark using SQL
Access and process Sage Intacct Data in Apache Spark using the CData Software JDBC Driver.
-
Integrating Cursor CLI with Float 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 Optimizely Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Optimizely replication to Apache Cassandra.
-
How to Work with ZohoMarketingHub Data in AWS Glue Jobs Using JDBC
Connect to ZohoMarketingHub from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Datasets from TigerGraph in Domo Workbench and Build Visualizations of TigerGraph Data in Domo
Use the CData Software ODBC Driver for TigerGraph to create datasets from TigerGraph in Domo Workbench and then build visualizations in the Domo service.
-
Integrating GitHub Copilot CLI with Todoist 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 DB2 Data in Heroku for Use in Salesforce Connect
Replicate IBM DB2 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Access Live Drip Data in Coginiti Pro
Connect to and query live Drip from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect and Visualize Live Procore Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Procore into the Databricks platform and create visualization dashboards with real-time Procore.
-
Object-Relational Mapping (ORM) with ElevenLabs Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to ElevenLabs into a Java-based ORM framework, Hibernate.
-
Access Live Microsoft Entra ID Data in Coginiti Pro
Connect to and query live Microsoft Entra ID from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use ChatGPT to Talk to Your Oracle Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Oracle Database for you.
-
Access Live Sage 300 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sage 300 into the statistical analysis tools available in SAS JMP. This article shows how to use Sage 300 in the Graph Builder and Query Builder.
-
Access Live Adobe Analytics Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Adobe Analytics through MCP integration.