CData Software - Knowledge Base
Recent Articles
-
Connect to Live Twilio Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Twilio in CData Connect AI and connect to your Twilio data from PostgreSQL.
-
Connect to Harvest Data in DBeaver
Use the CData ODBC Driver to connect to Harvest data in DBeaver.
-
Use Databricks Agent Bricks to Talk to Your Perplexity Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Perplexity data for you.
-
Replicate MySQL Data to Multiple Databases
Replicate MySQL data to disparate databases with a point-and-click configuration.
-
Getting Started with the CData Excel Add-In for Perigon
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Perigon.
-
Connect to and Visualize Live ScrapingBee Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ScrapingBee data.
-
Integrate Sentry Data in Pentaho Data Integration
Build ETL pipelines based on Sentry data in the Pentaho Data Integration tool.
-
How to Connect Flowise AI Agents to Live Sage 300 Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Sage 300 data without replication.
-
DataBind Intercom Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Intercom data to a chart.
-
Visualize Live Okta Data in the Power BI Service
Use CData Connect AI to connect to live Okta data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Jumpseller Reporting in OBIEE with the Jumpseller JDBC Driver
Deploy the Jumpseller JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Mixpanel Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Mixpanel data.
-
Connect to Telegram Data from a Connection Pool in Jetty
The Telegram JDBC Driver supports connection pooling: This article shows how to connect faster to Telegram data from Web apps in Jetty.
-
Search External Apify Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Apify data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Apify Data objects that you can access from apps and the dashboard.
-
Query Email Data as a MySQL Database in Node.js
Execute MySQL queries against Email data from Node.js.
-
Create Reports with OneNote Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date OneNote data.
-
Visualize Redis Data in TIBCO Spotfire through ADO.NET
Integrate Redis data into dashboards in TIBCO Spotfire.
-
How to Connect to Live Office 365 Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Office 365 data for you.
-
LINQ to Zoho Recruit 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 Zoho Recruit Data Provider.
-
Import and Visualize Reply.io Data in Power View
Create data visualizations based on Reply.io data in Excel.
-
Create Informatica Mappings From/To a JDBC Data Source for CapsuleCRM
Create CapsuleCRM data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Build an ETL App for Google Drive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Drive data in Python with petl and the CData Connect AI Python SDK.
-
LINQ to Zoho Inventory 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 Zoho Inventory Data Provider.
-
Validate SAP HANA XS Advanced Data with QuerySurge
Access and validate SAP HANA XS Advanced data in QuerySurge using the CData JDBC Driver.
-
Natively Connect to MarkLogic Data in PHP
The CData ODBC driver for MarkLogic enables you to create PHP applications with connectivity to MarkLogic data. Leverage the native support for ODBC in PHP.
-
Process & Analyze Gorgias Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gorgias Data.
-
Object-Relational Mapping (ORM) with MailChimp 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 MailChimp data into a Java-based ORM framework, Hibernate.
-
Use the CData ODBC Driver for DocuSign in Microsoft Power Query
You can use the CData DocuSign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import DocuSign data into Microsoft Power Query.
-
Automated Continuous Google Calendar Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Calendar replication to AlloyDB.
-
Build Spark-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Spark data.
-
Query Live Highrise 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 Highrise data directly from the development environment.
-
Import Real-Time LaunchDarkly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LaunchDarkly data in ColdFusion.
-
Automated Continuous Exa Replication to MySQL
Use CData Sync for automated, continuous, customizable Exa replication to MySQL.
-
Connect to Amazon S3 from Asprova with CData Software ODBC Driver for Amazon S3
This article shows how to connect faster to Amazon S3 data from Asprova.
-
Use Dash to Build Web Apps on MongoDB Data via CData Connect AI
Build interactive Dash web apps on live MongoDB data using pandas and the CData Connect AI Python SDK.
-
Provide OData Services of SendInBlue Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SendInBlue data by developing a WCF Service Application.
-
How to Work with Couchbase Data in ETL Validator JDBC
Connect to Couchbase from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Visualize Zoho Projects 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 Zoho Projects data in Python.
-
Integrate Real-Time Access to Google Search in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Search results in real time.
-
Link Samanage with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Samanage data in Filemaker Pro for Mac or Windows.
-
Build Charts with Snapchat Ads Data in Clear Analytics
Create dynamic charts and perform analytics based on Snapchat Ads data in Clear Analytics.
-
Connecting Mastra with Adobe Experience Manager Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Adobe Experience Manager data, no replication required.
-
Query ZeroBounce Data as a MySQL Database in Node.js
Execute MySQL queries against ZeroBounce data from Node.js.
-
How to create an RPA flow for PDFMonkey Data in UiPath Studio
Use the PDFMonkey ODBC Driver to create workflows that access real-time PDFMonkey data without any coding.
-
Access JobNimbus Data from MySQL in PHP
Connect to JobNimbus through the standard MySQL libraries in PHP.
-
Configure the CData JDBC Driver for Supabase in a Connection Pool in Tomcat
Connect to Supabase data from a connection pool in Tomcat.
-
Connect to FTP Data from a Connection Pool in Jetty
The FTP JDBC Driver supports connection pooling: This article shows how to connect faster to FTP data from Web apps in Jetty.
-
Integrate Google's Vertex AI Agent with Live SAS Data Sets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAS Data Sets data within intelligent workflows.
-
Build Azure Synapse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Synapse Data from Zoho Analytics and import live Azure Synapse data.
-
How to Connect to Live Wistia 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 Wistia data for you.
-
How to connect to Teradata Data from IntelliJ
Integrate connectivity to Teradata data with wizards in IntelliJ.
-
Migrating data from Avro to Snowflake using CData SSIS Components.
Easily push Avro data to Snowflake using the CData SSIS Tasks for Avro and Snowflake.
-
Build a PostgreSQL Interface for Outlook Data using the CData JDBC Driver
Use the Remoting features of the Outlook JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Oracle Service Cloud Data in RazorSQL
Connect to Oracle Service Cloud from wizards and query Oracle Service Cloud data from the GUI in the RazorSQL database management tool.
-
Connect to Microsoft OneDrive Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft OneDrive data in DBeaver.
-
Connect to Dynamics 365 Business Central Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Dynamics 365 Business Central data.
-
Query ServiceNow Data as a MySQL Database in Node.js
Execute MySQL queries against ServiceNow data from Node.js.
-
Integrating LangChain with Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Grafana data within automated workflows.
-
Integrate Real-Time Access to Neo4J in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Neo4J data in real time.
-
Process & Analyze Planio Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Planio Data.
-
Back Up PostgreSQL data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for PostgreSQL. In this article, we will employ an SSIS workflow to populate a database with PostgreSQL data data.
-
Create PolarTeamPro-Connected Nintex Workflows
Use CData Connect AI to connect to PolarTeamPro Data from Nintex Workflow Cloud and build custom workflows using live PolarTeamPro data.
-
How to connect PolyBase to CockroachDB
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live CockroachDB data.
-
Integrate with BenchmarkEmail Data in JReport Designer
Create charts and reports based on BenchmarkEmail data in JReport Designer.
-
Connect to eBay Analytics Data in Aqua Data Studio
Access eBay Analytics data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Build Semantic Layer Views for GetResponse Data in APOS Live Data Gateway
Use the CData Connector for GetResponse in APOS Live Data Gateway to build Semantic Layer Views for GetResponse data.
-
Build a Simple VCL Application for ZohoExpense Data
How to build a simple VCL Application to view ZohoExpense data in RAD Studio using the CData ODBC Driver for ZohoExpense.
-
Automate Foursquare Data Replication to Azure Data Lake
Use CData Sync to customize and automate Foursquare data replication to Azure Data Lake.
-
Use the CData Software JDBC Driver for Testmonitor in MicroStrategy Desktop
Connect to Testmonitor data in MicroStrategy Desktop using the CData Software JDBC Driver for Testmonitor.
-
Connect to Hubstaff Data in DBArtisan
Use wizards in DBArtisan to configure Hubstaff data as a data source.
-
Build SendPulse-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SendPulse Data from Zoho Analytics and import live SendPulse data.
-
Create MongoDB-Connected Applications in Appsmith
Connect to MongoDB Data via CData Connect AI in Appsmith and create custom business applications with real-time access to MongoDB data.
-
Query Factorial Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Factorial data from Node.js.
-
Visualize Access Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Access data into TIBCO Spotfire.
-
How to connect Amazon QuickSight to ConstantContact Data
Create a connection to ConstantContact data in CData Connect AI and insert ConstantContact data into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Dash to Build to Web Apps on Sage Intacct Data
Create Python applications that use pandas and Dash to build Sage Intacct-connected web apps.
-
Access Live Cloudant Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Cloudant data into the statistical analysis tools available in SAS JMP. This article shows how to use Cloudant data in the Graph Builder and Query Builder.
-
Integrate Theia IDE with Live Kafka 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 Kafka data from within the development environment.
-
Publish Crystal Reports on SAP Business One Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date SAP Business One data.
-
Access FreeAgent Data from MySQL in PHP
Connect to FreeAgent through the standard MySQL libraries in PHP.
-
How to import EmailOctopus Data into Apache Solr
Use the CData Software JDBC Driver for EmailOctopus in Data Import Handler and create an automated import of EmailOctopus data to Apache Solr Enterprise Search platform.
-
Build Data Flows from SQL Server to Databricks through SSIS
Easily push SQL Server data to Databricks using the CData SSIS Tasks for Databricks.
-
Build Teradata-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Teradata data.
-
Visualize Live Exa Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Exa data into custom reports in Power BI.
-
Automated Continuous Apollo Replication to SQLite
Use CData Sync for automated, continuous, customizable Apollo replication to SQLite.
-
Integrate Theia IDE with Live Tavily 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 Tavily data from within the development environment.
-
Connect to PingOne Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live PingOne data.
-
Connecting Agentforce with Google Sheets 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 Google Sheets data for you.
-
Connect to Phoenix Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Phoenix and the SQL Gateway to access Phoenix data from Google Apps Script.
-
Build Automated Workflows with Live ZohoDesk Data in Workato
Use CData Connect AI to connect to live ZohoDesk data and build automated workflows in Workato.
-
Connect to BigQuery from a Connection Pool in WebLogic
Use the CData JDBC Driver for BigQuery to connect to BigQuery data from Web applications running on WebLogic.
-
Integrate Google's Antigravity Agent with Live Email Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Email data using the Model Context Protocol.
-
Publish Zoom-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Zoom data.
-
Automated Continuous SAP SuccessFactors Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to delimited files (CSV/TSV).
-
Connect to Paddle Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Paddle to connect to Paddle data and execute queries in PowerBuilder.
-
Connect to Outreach.io Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Outreach.io to connect to Outreach.io data and execute queries in PowerBuilder.
-
Integrate with Aircall Data in JReport Designer
Create charts and reports based on Aircall data in JReport Designer.
-
How to Visualize Avalara AvaTax 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 Avalara AvaTax data in Python.
-
Integrate Live ServiceDesk Plus Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live ServiceDesk Plus data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData ADO.NET Provider for Pipeliner CRM
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.