CData Software - Knowledge Base
Recent Articles
-
How to connect to SuiteCRM Data in DBVisualizer
Integrate SuiteCRM data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Live VWO Data in PostGresSQL Interface through CData Connect AI
Create a live connection to VWO in CData Connect AI and connect to your VWO data from PostgreSQL.
-
Bridge Harvest Connectivity with Apache NiFi
Access and process Harvest data in Apache NiFi using the CData JDBC Driver.
-
Create Datasets from LinkedIn in Domo Workbench and Build Visualizations of LinkedIn Data in Domo
Use the CData Software ODBC Driver for LinkedIn to create datasets from LinkedIn data in Domo Workbench and then build visualizations in the Domo service.
-
Access Live Cloudflare Data in Coginiti Pro
Connect to and query live Cloudflare data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Replicate Shippo Data in Heroku for Use in Salesforce Connect
Replicate Shippo data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Use Grok to Talk to Your Perplexity 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 Perplexity data for you.
-
Import Real-Time Eventbrite Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Eventbrite data in ColdFusion.
-
Connect to Landbot Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Landbot to connect to Landbot data and execute queries in PowerBuilder.
-
Analyze Live Sage 300 Data in SAS Viya
Use CData Connect AI to connect to Sage 300 data from SAS Viya and deploy self-service analytics using live Sage 300 data.
-
Stream Salesforce Data 360 Data into Apache Kafka Topics
Access and stream Salesforce Data 360 data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Model MarkLogic Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and MarkLogic, enabling the direct import of real-time MarkLogic data.
-
Access Facebook Ads Data from MySQL in Amazon QuickSight
Connect to Facebook Ads and build visualizations of Facebook Ads data using a MySQL Connection in Amazon QuickSight.
-
How to Connect to Live Google Sheets Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Google Sheets data for you.
-
Connect to Greenplum Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Greenplum data using standard SQL.
-
Getting Started with the CData ODBC Driver for Teamwork
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Teamwork.
-
Integrating Dataiku with SendPulse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SendPulse data.
-
Automated Continuous QuickBooks Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable QuickBooks replication to Apache Kafka.
-
How to Access Live Mouseflow Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Mouseflow enables you to integrate Mouseflow data into workflows built using Microsoft Power Automate Desktop.
-
Operational Reporting on SAP HANA Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SAP HANA data.
-
Integrate eBay Data into Power Automate Desktop using CData Connect
CData Connect for eBay Data enables you to integrate eBay data into workflows built using Microsoft Power Automate Desktop.
-
Access Live CockroachDB Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live CockroachDB data through MCP integration.
-
How to Seamlessly Import HBase Data into IBM SPSS Modeler
Integrate HBase data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Azure Data Lake Storage Replication to MongoDB
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to MongoDB.
-
Build MVC Applications with Connectivity to PagerDuty Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access PagerDuty from an ASP.NET MVC application.
-
Connect to Facebook Ads Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Facebook Ads and the Script function in FileMaker Pro to connect to Facebook Ads and work with Facebook Ads data in your FileMaker application.
-
Connect to Jira from a Connection Pool in WebLogic
Use the CData JDBC Driver for Jira to connect to Jira data from Web applications running on WebLogic.
-
How to Connect to Live Snapchat Ads 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 Snapchat Ads data for you.
-
Integrating OpenCode with iContact 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 connect to NetSuite Data from IntelliJ
Integrate connectivity to NetSuite data with wizards in IntelliJ.
-
How to work with ZohoInvoice Data in Apache Spark using SQL
Access and process ZohoInvoice Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live Notion 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 Notion data through MCP integration.
-
Add REST Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for REST with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating Kiro with Supabase 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 Sentry to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Sentry data using the CData Python MCP Server.
-
Create Power BI Reports on Real-Time Google Campaign Manager 360 Data
Use the CData ODBC Driver for Google Campaign Manager 360 to visualize Google Campaign Manager 360 data in Power BI Desktop.
-
How to Connect the Power BI Service to QuickBooks Online: Complete Guide
Connect to the CData Software Power BI Connector for QuickBooks Online from PowerBI.com to provide real-time QuickBooks Online data across the organization.
-
Moving Data from Pipeliner CRM to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Pipeliner CRM data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Access PayPal Data from MySQL in PHP
Connect to PayPal through the standard MySQL libraries in PHP.
-
Model ZohoMarketingHub Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and ZohoMarketingHub, enabling the direct import of real-time ZohoMarketingHub data.
-
Natively Connect to Dynamics 365 Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Dynamics 365 data. Leverage the native support for ODBC in PHP.
-
Connect to Cloudflare Data in DBeaver
Use the CData ODBC Driver to connect to Cloudflare data in DBeaver.
-
Analyze DocuSign Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze DocuSign data with the CData JDBC Driver for DocuSign.
-
Seamlessly Bring Zoho Inventory Data into Retool Using CData Connect AI
Integrate Zoho Inventory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
LINQ to Bitly 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 Bitly Data Provider.
-
How to Connect the Power BI Service to Google Translate: Complete Guide
Connect to the CData Software Power BI Connector for Google Translate from PowerBI.com to provide real-time Google Translate data across the organization.
-
Integrating JotForm Data in Talend Cloud Data Management Platform
Connect JotForm Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Power BI Reports on Real-Time EnterpriseDB Data
Use the CData ODBC Driver for EnterpriseDB to visualize EnterpriseDB data in Power BI Desktop.
-
Snowflake Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Snowflake data through CData Connect AI using different applications and tools.
-
Natively Connect to MailerSend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailerSend data. Leverage the native support for ODBC in PHP.
-
Connect to Exa Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Exa as an External Source in Dremio.
-
Integrate Google's Vertex AI Agent with Live Google Calendar 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 Google Calendar data within intelligent workflows.
-
Access Live Hive Data in AWS Lambda
Connect to live Hive data in AWS Lambda using the CData JDBC Driver.
-
How to connect PolyBase to Billsby
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Billsby data.
-
Create ZohoSubscriptions-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ZohoSubscriptions Data from Klipfolio and build custom visualizations using live ZohoSubscriptions data.
-
Access Live Lakebase Data in AWS Lambda
Connect to live Lakebase data in AWS Lambda using the CData JDBC Driver.
-
Create Dashboards and Visualize Live Oracle Data in Geckoboard
Use CData Connect AI to connect to live Oracle data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Access Live Greenhouse Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Greenhouse data through MCP integration.
-
Migrating data from MYOB AccountRight to Google BigQuery using CData SSIS Components.
Easily push MYOB AccountRight data to Google BigQuery using the CData SSIS Tasks for MYOB AccountRight and Google BigQuery.
-
How to integrate LightSpeedRetail with Apache Airflow
Access and process LightSpeedRetail data in Apache Airflow using the CData JDBC Driver.
-
Integrate with Live Wistia Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Wistia from the MuleSoft Anypoint Platform to integrate live Wistia data into custom reports and dashboards.
-
Replicate Pinecone Data to Multiple Databases via the CData Sync CLI
Replicate Pinecone data to disparate databases with a single configuration.
-
Use ChatGPT to Talk to Your Pipedrive 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 Pipedrive data for you.
-
Access Live SurveyMonkey Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live SurveyMonkey data through MCP integration.
-
How to integrate Dynamics 365 Business Central with Apache Airflow
Access and process Dynamics 365 Business Central data in Apache Airflow using the CData JDBC Driver.
-
Create Informatica Mappings From/To a JDBC Data Source for Phoenix
Create Phoenix data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to OneNote Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for OneNote and the Script function in FileMaker Pro to connect to OneNote and work with OneNote data in your FileMaker application.
-
Excel Spreadsheet Automation on JSON Services with the QUERY Formula
Pull data from JSON, automate spreadsheets, and more with the QUERY formula.
-
Build Agents in Relevance AI with Access to Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on HCL Domino data within intelligent agent workflows.
-
Stream CSV Data into Apache Kafka Topics
Access and stream CSV data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Create Informatica Mappings From/To a JDBC Data Source for ADP
Create ADP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData ODBC Driver for Autopilot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Autopilot.
-
Access Live Zoho Inventory Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Zoho Inventory data from your Excel spreadsheets.
-
Automated Continuous Xero Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Xero replication to Google BigQuery.
-
Moving Data from Reckon Accounts Hosted to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Reckon Accounts Hosted data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Reply.io with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Reply.io with External Services.
-
Integrate Devin with Live Dynamics 365 Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Dynamics 365 data.
-
Automated Continuous Excel Replication to SQL Server
Use CData Sync for automated, continuous, customizable Excel replication to SQL Server.
-
Automated Continuous AdRoll Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable AdRoll replication to delimited files (CSV/TSV).
-
Use Agno to Talk to Your SAS Data Sets 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 SAS Data Sets data for you.
-
How to Access ServiceDesk Plus Data Using Entity Framework
This article shows how to access ServiceDesk Plus data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Integrate with ZohoMarketingHub Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ZohoMarketingHub data to a JSON file on disk.
-
Build SparkPost-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live SparkPost data and build SparkPost-connected web apps with Axios.
-
Connect to Mailjet Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Mailjet data.
-
How to publish and share Exa Data dashboards with Tableau Server
The CData ODBC driver for Exa enables you integrate Exa data into Tableau dashboards.
-
How to connect to ConvertKit Data with Squirrel SQL client
Connect to ConvertKit data and execute queries in the Squirrel SQL Client.
-
Connect to SingleStore Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for SingleStore to connect to SingleStore data and execute queries in PowerBuilder.
-
Automate Teradata Data Replication to SAP HANA
Use CData Sync to customize and automate Teradata data replication to SAP HANA.
-
How to import IBM Cloud Object Storage Data into Apache Solr
Use the CData Software JDBC Driver for IBM Cloud Object Storage in Data Import Handler and create an automated import of IBM Cloud Object Storage data to Apache Solr Enterprise Search platform.
-
Connect to HubSpot from a Connection Pool in WebLogic
Use the CData JDBC Driver for HubSpot to connect to HubSpot data from Web applications running on WebLogic.
-
Using the CData Software ODBC Driver for Dynamics CRM in PyCharm
Connect to Dynamics CRM as an ODBC data source in PyCharm using the CData Software ODBC Driver for Dynamics CRM.
-
ETL Freshservice in Oracle Data Integrator
This article shows how to transfer Freshservice data into a data warehouse using Oracle Data Integrator.
-
Build Hive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Hive data and build web apps with connectivity to live Hive data.
-
Moving Data from IBM Informix to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live IBM Informix data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrating OpenCode with SAP Business One 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 and Visualize Live Parallel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Parallel data.
-
Trigger Teradata IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Teradata with standard wizards in Logic Apps.
-
Create Datasets from PabblySubscriptions in Domo Workbench and Build Visualizations of PabblySubscriptions Data in Domo
Use the CData Software ODBC Driver for PabblySubscriptions to create datasets from PabblySubscriptions data in Domo Workbench and then build visualizations in the Domo service.
-
How to use SQLAlchemy ORM to access Mocean Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Mocean data.
-
Integrating Boomi Agentstudio with Instagram Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Instagram data, enabling AI agents to act on live enterprise data within your integration and automation workflows.