CData Software - Knowledge Base
Recent Articles
-
Connect to LinkedIn Ads Data in HULFT Integrate
Connect to LinkedIn Ads as a JDBC data source in HULFT Integrate
-
Build Voice Agents in ElevenLabs with access to Live Procore Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Procore.
-
Replicate Microsoft OneLake Data in Heroku for Use in Salesforce Connect
Replicate Microsoft OneLake to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Load Hubstaff Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Hubstaff to a database.
-
Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid
Learn how you can connect Excel Online to Infragistics XamDataGrid to build dynamic grids.
-
Prepare, Blend, and Analyze Amazon DynamoDB Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon DynamoDB for self-service data analytics.
-
Getting Started with the CData Connect AI Python SDK for Sage Cloud Accounting
Install the CData Connect AI Python SDK to read and write live Sage Business Cloud Accounting with standard DB-API 2.0 Python code.
-
Connect to SAP Business Warehouse Data in Aqua Data Studio
Access SAP Business Warehouse from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
A PostgreSQL Interface for Cloudant Data (MySQL Remoting via JDBC)
Use the Remoting features of the Cloudant JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Charts with LightSpeedRetail Data in Clear Analytics
Create dynamic charts and perform analytics based on LightSpeedRetail in Clear Analytics.
-
Work with Onfleet Data in FoxPro
Load Onfleet into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect to Mailgun Data with Squirrel SQL client
Connect to Mailgun and execute queries in the Squirrel SQL Client.
-
Connect to Freshdesk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Freshdesk in Airbyte.
-
Viewing SAP Netweaver Gateway Data in RAD Studio Data Explorer
How to view SAP Netweaver Gateway in RAD Studio Data Explorer using the CData ODBC Driver for SAP Netweaver Gateway.
-
How to Connect DBeaver to Tavily via a JDBC Driver
Manage Tavily with visual tools in DBeaver like the query browser.
-
Build Visualizations of ZohoMarketingHub Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZohoMarketingHub in Birst.
-
Automate YouTube Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access YouTube Analytics from PowerShell? This article demonstrates how to utilize the YouTube Analytics Cmdlets for tasks like connecting to YouTube Analytics, automating operations, downloading data, and more.
-
Connect to Perplexity Data in HULFT Integrate
Connect to Perplexity as a JDBC data source in HULFT Integrate
-
Analyze Clio Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Clio from Power Pivot. You will use the Table Import Wizard to load Clio. You can visually build the import query or use any SQL supported by the driver.
-
Query Google Campaign Manager 360 Data as a MySQL Database in Node.js
Execute MySQL queries against Google Campaign Manager 360 from Node.js.
-
Process & Analyze Drift Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Drift Data.
-
How to Connect the Power BI Service to Clockify: Complete Guide
Connect to the CData Software Power BI Connector for Clockify from PowerBI.com to provide real-time Clockify across the organization.
-
Create Google Contacts-Connected Applications in Appsmith
Connect to Google Contacts Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Contacts.
-
Connect to Quickbase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Quickbase and the SQL Gateway to access Quickbase from Google Apps Script.
-
Connect Reply.io to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Reply.io with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Jira Data in MySQL Workbench
Execute MySQL queries against live Atlassian Jira from MySQL Workbench.
-
Bidirectional Access to Bugsnag Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Bugsnag in Filemaker Pro for Mac or Windows.
-
Getting Started with the CData JDBC Driver for Sage Cloud Accounting
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Sage Cloud Accounting.
-
Visualize Vimeo Data in TIBCO Spotfire through ADO.NET
Integrate Vimeo into dashboards in TIBCO Spotfire.
-
Connect to ZohoExpense in SpagoBI
Create reports featuring live ZohoExpense in SpagoBI Studio. Host ZohoExpense reports on SpagoBI Server.
-
Analyze WordPress Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of WordPress and visualize live WordPress in Infragistics Reveal.
-
Create Confluence-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Confluence Data from OutSystems and build custom enterprise apps using live Atlassian Confluence.
-
How to integrate Amplitude with Apache Airflow
Access and process Amplitude in Apache Airflow using the CData JDBC Driver.
-
How to create an RPA flow for Shopify Data in UiPath Studio
Use the Shopify ODBC Driver to create workflows that access real-time Shopify without any coding.
-
Connect to Salesforce CRM Analytics Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Salesforce CRM Analytics Data and connect to Salesforce CRM Analytics in Akorbi Digital RunMyProcess.
-
Integrate Pipeliner CRM Data in the Pentaho Report Designer
Publish reports based on Pipeliner CRM in the Pentaho BI tool.
-
DataBind Charts to VWO Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to VWO 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.
-
ETL Sugar CRM in Oracle Data Integrator
This article shows how to transfer Sugar CRM into a data warehouse using Oracle Data Integrator.
-
Integrate with Pinterest Data in JReport Designer
Create charts and reports based on Pinterest in JReport Designer.
-
Getting Started with the CData ADO.NET Provider for Missive
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous xBase Replication to SQLite
Use CData Sync for automated, continuous, customizable xBase replication to SQLite.
-
Automated Continuous Teradata Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Teradata replication to Amazon Redshift.
-
How to Connect the Power BI Service to Dynamics CRM: Complete Guide
Connect to the CData Software Power BI Connector for Dynamics CRM from PowerBI.com to provide real-time Microsoft Dynamics CRM across the organization.
-
Enable the ShipEngine JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ShipEngine.
-
How to create an RPA flow for GraphQL Data in UiPath Studio
Use the GraphQL ODBC Driver to create workflows that access real-time GraphQL without any coding.
-
Codat Reporting in OBIEE with the Codat JDBC Driver
Deploy the Codat JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automate Snapchat Ads Data Replication to Azure Synapse
Use CData Sync to customize and automate Snapchat Ads replication to Azure Synapse.
-
Automate Azure Data Lake Storage Data Replication to SAP HANA
Use CData Sync to customize and automate Azure Data Lake Storage replication to SAP HANA.
-
Process & Analyze Float Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Float Data.
-
How to Connect to Live HCL Domino 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 HCL Domino for you.
-
Access Live QuickBooks Data in AWS Lambda (with IntelliJ IDEA)
Connect to live QuickBooks Desktop in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Trigger Active Directory IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Active Directory with standard wizards in Logic Apps.
-
Access Live Blackbaud FE NXT 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 Blackbaud FE NXT through MCP integration.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy
Connect to Moosend in MicroStrategy Developer using the CData Software JDBC Driver for Moosend.
-
Build Dashboards with Landbot Data in DBxtra
Create dynamic dashboards and perform analytics based on Landbot in DBxtra.
-
Access Miro 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 Miro.
-
Access QuickBooks Company File Data from DBeaver
Use the CData JDBC Driver for QuickBooks to access QuickBooks as a JDBC data source through the DBeaver connection manager.
-
Build Data Flows from Google Translate to SQL Server using SSIS
Easily back up Google Translate to SQL Server using the SSIS components for Google Translate.
-
Connect to Phoenix from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Apache Phoenix, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to Connect to Live BambooHR 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 BambooHR for you.
-
How to Query Live ChartMogul Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ChartMogul data in natural language using Python.
-
How to Connect to Live Cvent 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 Cvent for you.
-
Build AI/ML Models with Live Amazon Athena Data using Dataiku
Connect Amazon Athena Data with Dataiku using the CData JDBC Driver for Amazon Athena.
-
Publish Discord-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Discord.
-
Create SAP Business One Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP Business One data access from reports, embedded analytics, and more.
-
Analyze Salesforce Marketing Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Salesforce Marketing Cloud with the CData JDBC Driver for Salesforce Marketing.
-
Integrating OpenCode Terminal with Close 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.
-
Analyze Snowflake Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Snowflake in Microsoft R Open.
-
How to connect to Foursquare Data in DBVisualizer
Integrate Foursquare with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Avro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Apache Avro from Informatica Cloud.
-
Create Informatica Mappings From/To a JDBC Data Source for Outreach.io
Create Outreach.io data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Create Sage 300 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Sage 300 data access from reports, embedded analytics, and more.
-
How to Connect Flowise AI Agents to Live SAP Business One 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 SAP Business One without replication.
-
Integrate Theia IDE with Live Shopify Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Natively Connect to SendGrid Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SendGrid. Leverage the native support for ODBC in PHP.
-
Validate GitLab Data with QuerySurge
Access and validate GitLab in QuerySurge using the CData JDBC Driver.
-
Connect Kintone Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Kintone using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Easily Integrate HBase Data in Lazarus Pascal IDE
Learn how to easily integrate live Apache HBase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Visualize Campaigner Data in Tableau
The CData ODBC driver for Campaigner enables you integrate Campaigner into Tableau dashboards.
-
Connect to Missive Data from a Connection Pool in Jetty
The Missive JDBC Driver supports connection pooling: This article shows how to connect faster to Missive from Web apps in Jetty.
-
View Reports on Real-Time Blackbaud FE NXT Data in Power BI Report Server
Use the CData ODBC Driver for Blackbaud FE NXT to visualize Blackbaud FE NXT in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to SuiteCRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SuiteCRM. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous WordPress Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable WordPress replication to Apache Kafka.
-
How to Work with Campaigner Data in ETL Validator JDBC
Connect to Campaigner from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for Harvest
Learn to install and license the CData Python Connector
-
Access Live Shopify Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Shopify in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automate SendGrid Data Replication to Couchbase
Use CData Sync to Customize and automate SendGrid replication to Couchbase.
-
Work with Supabase Data in FoxPro
Load Supabase into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect to MySQL Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for MySQL Data and connect to MySQL in Akorbi Digital RunMyProcess.
-
How to use SQLAlchemy ORM to access Egnyte Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Egnyte.
-
Integrating Codex CLI with MarkLogic 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 MongoDB Data Replication to Teradata
Use CData Sync to Customize and automate MongoDB replication to Teradata.
-
Connect to PostgreSQL Data in JRuby
Create a simple JRuby app with access to live PostgreSQL.
-
Moving Data from Front to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Front data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
How to integrate Metabase with SAS Data Sets Data
Use CData Connect AI to connect to live SAS Data Sets and create an interactive dashboard in Metabase from SAS Data Sets.
-
Publish Cloudflare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Cloudflare.
-
Query AgileCRM Data in DataGrip
Create a Data Source for AgileCRM in DataGrip and use SQL to query live AgileCRM.
-
Create SAP Concur-Connected Business Apps in AppSheet
Connect to SAP Concur Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Concur.
-
Explore Geographical Relationships in EnterpriseDB Data with Power Map
Create data visualizations with EnterpriseDB in Power Map.
-
Build Agents in Relevance AI with Access to Live Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Acumatica ERP within intelligent agent workflows.