CData Software - Knowledge Base
Recent Articles
-
Automated CockroachDB Data Replication to Teradata
Use CData Sync to Customize and automate CockroachDB data replication to Teradata.
-
View Reports on Real-Time SAP Concur Data in Power BI Report Server
Use the CData ODBC Driver for SAP Concur to visualize SAP Concur data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Kiro with Act-On 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.
-
Connect to SharePoint Excel Services Data in RazorSQL
Connect to SharePoint Excel Services from wizards and query SharePoint Excel Services data from the GUI in the RazorSQL database management tool.
-
Changelog: Driver Update 2024.14
Review the driver-specific changes from the 2024.1 CData Driver release.
-
How to Connect to Live Snowflake Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Snowflake data without replication.
-
How to Connect to Live Google Ad Manager 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 Google Ad Manager data for you.
-
Connect to Nethunt Data in HULFT Integrate
Connect to Nethunt as a JDBC data source in HULFT Integrate
-
DataBind Controls to Box Data in C++Builder
DataBind to Box data in C++Builder with standard components and controls.
-
Connect to MySQL Data from PowerBuilder via ADO.NET
This article demonstrates how to access MySQL data from Appeon PowerBuilder using the CData ADO.NET Provider for MySQL.
-
Analyze ZeroBounce Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZeroBounce data in Microsoft R Open.
-
Automated Continuous EnterpriseDB Replication to Amazon S3
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to Amazon S3.
-
How to integrate Salesforce Data 360 with Apache Airflow
Access and process Salesforce Data 360 data in Apache Airflow using the CData JDBC Driver.
-
A PostgreSQL Interface for Active Directory Data (MySQL Remoting via JDBC)
Use the Remoting features of the Active Directory JDBC Driver to create a PostgreSQL entry-point for data access.
-
Design BIRT Reports on Recurly Data
Provide current Recurly data to your embedded analytics.
-
Access Live Unbounce Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Unbounce data into the statistical analysis tools available in SAS JMP. This article shows how to use Unbounce data in the Graph Builder and Query Builder.
-
Automate Mailjet Data Replication to SAP HANA
Use CData Sync to customize and automate Mailjet data replication to SAP HANA.
-
Import SAP Netweaver Gateway Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Azure Data Factory and import live SAP Netweaver Gateway data.
-
Integrating Cursor with Couchbase 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.
-
Access Live Tally Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Tally data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous LinkedIn Replication to Snowflake
Use CData Sync for automated, continuous, customizable LinkedIn replication to Snowflake.
-
Create Data Visualizations in Cognos BI with ZeroBounce Data
Access ZeroBounce data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to SQL Server Data from PowerBuilder via JDBC
This article demonstrates how to access SQL Server data from PowerBuilder using the SQL Server JDBC Driver.
-
Create Data Visualizations in Cognos BI with Active Directory Data
Access Active Directory data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Dataiku with SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SageHR data.
-
Replicate Odoo Data in Heroku for Use in Salesforce Connect
Replicate Odoo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to and Query Sage 300 Data in QlikView over ODBC
Create data visualizations with Sage 300 data in QlikView.
-
Connect to Raisers Edge NXT in SpagoBI
Create reports featuring live Raisers Edge NXT data in SpagoBI Studio. Host Raisers Edge NXT reports on SpagoBI Server.
-
Connect to Snapchat Ads Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Snapchat Ads and the SQL Gateway to access Snapchat Ads data from Google Apps Script.
-
Access Aha! Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Aha! data from HeidiSQL.
-
How to Connect to Live Bitly Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Bitly data without replication.
-
Connect to Simplesat from a Connection Pool in WebLogic
Use the CData JDBC Driver for Simplesat to connect to Simplesat data from Web applications running on WebLogic.
-
Access Live Nuclia Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Nuclia data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate SAP Netweaver Gateway with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP Netweaver Gateway with External Services.
-
Query Live ConstantContact Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live ConstantContact data through a conversational interface.
-
Integrating Zendesk Data in Talend Cloud Data Management Platform
Connect Zendesk Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zendesk.
-
Use the CData Software ODBC Driver for Nuclia in MicroStrategy
Connect to Nuclia data in MicroStrategy Developer using the CData Software ODBC Driver for Nuclia.
-
Working with AgileCRM Data in LINQPad
Execute LINQ queries to AgileCRM data in LINQPad.
-
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 data 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 data in natural language using Python.
-
Connect to Discord Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Discord Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to SQL Server Data in RapidMiner
Integrate SQL Server data 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 data 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 data 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 data for you.
-
Create Power BI Reports on Real-Time Todoist Data
Use the CData ODBC Driver for Todoist to visualize Todoist data in Power BI Desktop.
-
Connect to Bugsnag from a Connection Pool in WebLogic
Use the CData JDBC Driver for Bugsnag to connect to Bugsnag data 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 data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect to ServiceDesk Plus Data from IntelliJ
Integrate connectivity to ServiceDesk Plus data 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 data 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 data 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 data 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 data.
-
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 data for you.
-
Establish a Live Connection with eBay Data using Tableau Bridge
The CData ODBC Driver for eBay enables you to integrate live eBay data 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 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.
-
Connect to Egnyte Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Egnyte and the SQL Gateway to access Egnyte data 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 data.
-
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 data.
-
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 data 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 data using the CData Python MCP Server.
-
Access Live Timely Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Timely data 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 data from Appeon PowerBuilder using the CData ADO.NET Provider for Facebook.
-
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 data in Akorbi Digital RunMyProcess.
-
Build Apps with Live Salesloft data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Salesloft data into the Adalo platform and build custom mobile and web applications with real-time Salesloft data.
-
Create Dashboards and Visualize Live PostgreSQL Data in Geckoboard
Use CData Connect AI to connect to live PostgreSQL data 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 data 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 data into custom reports and dashboards.
-
Connect to SQL Server Data in ACL Analytics
Connect to SQL Server data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SQL Server data.
-
How to connect to Samanage Data from IntelliJ
Integrate connectivity to Samanage data with wizards in IntelliJ.
-
Build Dashboards with Asana Data in DBxtra
Create dynamic dashboards and perform analytics based on Asana data 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 data 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 data.
-
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 xpt data.
-
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 data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MailChimp data 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 data for custom reports in the Power BI Service.
-
Migrating data from Aircall to Google BigQuery using CData SSIS Components.
Easily push Aircall data to Google BigQuery using the CData SSIS Tasks for Aircall and Google BigQuery.
-
DataBind Controls to Amazon Athena Data in C++Builder
DataBind to Amazon Athena data in C++Builder with standard components and controls.
-
Integrate with SQL Server Data in JReport Designer
Create charts and reports based on SQL Server data in JReport Designer.
-
How to connect to Mixpanel Data in DBVisualizer
Integrate Mixpanel data 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 Dynamics NAV data replication to SAP HANA.
-
Design BIRT Reports on Confluence Data
Provide current Confluence data 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 data 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.
-
Seamlessly Bring Adobe Experience Manager Data into Retool Using CData Connect AI
Integrate Adobe Experience Manager data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
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 data.
-
Connect Acumatica to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Acumatica data 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 data in Python.
-
Automate Facebook Ads Data Replication to Couchbase
Use CData Sync to Customize and automate Facebook Ads data replication to Couchbase.
-
Build Office 365-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Office 365 data and build web apps with connectivity to live Office 365 data.
-
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 data 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 data.