CData Software - Knowledge Base
Recent Articles
-
Easily Integrate HubDB Data in Lazarus Pascal IDE
Learn how to easily integrate live HubDB in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Using the CData Software ODBC Driver for Simplesat in PyCharm
Connect to Simplesat as an ODBC data source in PyCharm using the CData Software ODBC Driver for Simplesat.
-
How to Connect to Live Amazon Athena 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 Amazon Athena for you.
-
Bridge Epicor Kinetic Connectivity with Apache NiFi
Access and process Epicor Kinetic in Apache NiFi using the CData JDBC Driver.
-
Analyze Unbounce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Unbounce with the CData JDBC Driver for Unbounce.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Snowflake using the Model Context Protocol.
-
How to integrate Metabase with Certinia Data
Use CData Connect AI to connect to live Certinia and create an interactive dashboard in Metabase from Certinia.
-
How to connect SharePoint with Gmail Data through external lists
Provide Gmail to SharePoint users as an external list.
-
How to Seamlessly Import Suadeo Data into IBM SPSS Modeler
Integrate Suadeo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import Real-Time Slack Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Slack in ColdFusion.
-
Build AI/ML Models with Live Sugar CRM Data using Dataiku
Connect Sugar CRM Data with Dataiku using the CData JDBC Driver for Sugar CRM.
-
How to Connect to Live LinkedIn Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your LinkedIn through natural language.
-
Connect to HelloSign Data in NetBeans
Connect to HelloSign in NetBeans with the data source configuration wizard.
-
A PostgreSQL Interface for Pinecone Data using the CData ODBC Driver
Use the SQL Gateway and Pinecone ODBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Live MariaDB Data in the Power BI Service
Use CData Connect AI to connect to live MariaDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create SSAS Tabular Models from Shippo Data
How to build a SQL Server Analysis Service Tabular Model from Shippo using CData drivers.
-
How to Visualize Copper Data in Python with pandas
Use pandas and other modules to analyze and visualize live Copper in Python.
-
Publish MYOB AccountRight-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live MYOB AccountRight.
-
Integrate Live Trello Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Trello to Blue Prism using the CData ODBC Driver for Trello to create automated workflows for repetitive business tasks.
-
Use the CData Software ODBC Driver for Oracle Eloqua Reporting in MicroStrategy Web
Connect to Oracle Eloqua Reporting in MicroStrategy Web using the CData Software ODBC Driver for Oracle Eloqua Reporting.
-
Query Asana Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Asana from Node.js.
-
Use the CData Software ODBC Driver for Greenplum in SAS for Real-Time Reporting and Analytics
Connect to real-time Pivotal GreenPlum in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Greenplum.
-
Migrating data from Insightly to Google BigQuery using CData SSIS Components.
Easily push Insightly to Google BigQuery using the CData SSIS Tasks for Insightly and Google BigQuery.
-
Build HDFS-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Apache HDFS and build web apps with connectivity to live Apache HDFS.
-
Automated Continuous Dynamics 365 Replication to Vertica
Use CData Sync for automated, continuous, customizable Dynamics 365 replication to Vertica.
-
Seamlessly Bring Okta Data into Retool Using CData Connect AI
Integrate Okta data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect to Reckon Data in Ruby
Connect to Reckon in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to Connect to Salesforce CRM Analytics Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Salesforce CRM Analytics. Leverage the pyodbc module for ODBC in Python.
-
Access Live Jumpseller Data in Coginiti Pro
Connect to and query live Jumpseller from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Feed ZohoMarketingHub Data into FineReport
How to set ZohoMarketingHub as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Oracle SCM in MicroStrategy
Connect to Oracle SCM in MicroStrategy Developer using the CData Software JDBC Driver for Oracle SCM.
-
Automated Continuous Email Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Email replication to Google BigQuery.
-
How to Connect to CSV Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to CSV/TSV Files. Leverage the pyodbc module for ODBC in Python.
-
Query Basecamp Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Basecamp and perform CRUD operations on Basecamp from Node.js.
-
Visualize Jira Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Atlassian Jira.
-
Create Rebilly Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Rebilly from PowerBI.com to create Power BI Dataflows with real-time data.
-
Rapidly Develop Paylocity-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Paylocity.
-
How to Work with Shopify Data in ETL Validator JDBC
Connect to Shopify from ETL Validator jobs using the CData Software JDBC Driver.
-
Migrating data from Microsoft Teams to Snowflake using CData SSIS Components.
Easily push Microsoft Teams to Snowflake using the CData SSIS Tasks for Microsoft Teams and Snowflake.
-
Validate Toggl Data with QuerySurge
Access and validate Toggl in QuerySurge using the CData JDBC Driver.
-
How to connect to DocuSign Data in DBVisualizer
Integrate DocuSign with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Amazon DynamoDB Data to Multiple Databases
Replicate Amazon DynamoDB to disparate databases with a point-and-click configuration.
-
Create MarkLogic Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time MarkLogic data access from reports, embedded analytics, and more.
-
Visualize BigQuery Data in TIBCO Spotfire through ADO.NET
Integrate Google BigQuery into dashboards in TIBCO Spotfire.
-
Use Manus AI to Talk to Your Okta Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Okta.
-
Analyze LinkedIn Ads Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze LinkedIn Ads with the CData JDBC Driver for LinkedIn Ads.
-
Use JayDeBeApi to access Oracle Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Database.
-
Connecting GenSpark with Active Directory Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Active Directory without any replication or custom integration required.
-
Connect to PhantomBuster Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PhantomBuster and work with PhantomBuster in your FileMaker applications.
-
Build Azure Table-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Azure Table Storage.
-
DataBind Controls to Google Tasks Data in Delphi
DataBind to Google Tasks in Delphi with standard data access components and controls.
-
How to Seamlessly Import Mode Data into IBM SPSS Modeler
Integrate Mode data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Feed Azure Table Data into FineReport
How to set Azure Table Storage as a JDBC data source in FineReport.
-
Connect to ScrapingBee Data as an External Source in Dremio
Use the CData JDBC Driver to connect to ScrapingBee as an External Source in Dremio.
-
Getting Started with the CData JDBC Driver for Email
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Email.
-
Automated Continuous Calendly Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Calendly replication to Apache Cassandra.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ActiveCampaign using the Model Context Protocol.
-
Analyze PingOne Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PingOne with the CData JDBC Driver for PingOne.
-
How to Easily Query JSON Services in OpenOffice Base
Connect to JSON data in OpenOffice Base using the CData ODBC Driver for JSON and generate reports with live data insights.
-
Integrating Kiro CLI with Notion 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 HelloSign Data in DBArtisan
Use wizards in DBArtisan to configure HelloSign as a data source.
-
Connect to SQL Analysis Services Data in DBeaver
Use the CData ODBC Driver to connect to SQL Analysis Services in DBeaver.
-
Visualize Copper Data in TIBCO Spotfire through ADO.NET
Integrate Copper into dashboards in TIBCO Spotfire.
-
Feed SharePoint Data into FineReport
How to set Microsoft SharePoint as a JDBC data source in FineReport.
-
Build a PostgreSQL Interface for Oracle SCM Data using the CData JDBC Driver
Use the Remoting features of the Oracle SCM JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Apify Replication to Snowflake
Use CData Sync for automated, continuous, customizable Apify replication to Snowflake.
-
How to Connect to SingleStore Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SingleStore. Leverage the pyodbc module for ODBC in Python.
-
Import Real-Time PostgreSQL Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use PostgreSQL in ColdFusion.
-
Connect to Jira Assets from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Jira Assets, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Automated Continuous EmailOctopus Replication to Databricks
Use CData Sync for automated, continuous, customizable EmailOctopus replication to Databricks.
-
How to Connect to Live Facebook Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Facebook without replication.
-
Connect to Dynamics 365 Data in Ruby
Connect to Microsoft Dynamics 365 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Integrate with Live Jira Assets Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Jira Assets from the MuleSoft Anypoint Platform to integrate live Jira Assets into custom reports and dashboards.
-
Analyze WordPress Data in Looker
Use CData Connect AI to connect to WordPress Data from Looker and build custom apps using live WordPress.
-
Access JotForm Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access JotForm from your Oracle system.
-
Integrating GitHub Copilot CLI with Scrapfly 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.
-
Integrate Cline with Live SAP BusinessObjects BI Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP BusinessObjects BI from within your IDE.
-
Build WooCommerce-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live WooCommerce and build WooCommerce-connected web apps with Axios.
-
Use Azure AI Foundry to Talk to Your Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Microsoft Entra ID for you.
-
Use the CData Software ODBC Driver for Campaigner in MicroStrategy Desktop
Connect to Campaigner in MicroStrategy Desktop using the CData Software ODBC Driver for Campaigner.
-
Work with Dynamics 365 Data in FoxPro
Load Microsoft Dynamics 365 into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Basecamp-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Basecamp Data and create custom apps in Bubble.
-
DataBind Charts to ZohoSubscriptions Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to ZohoSubscriptions 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 import Splunk Data into Apache Solr
Use the CData Software JDBC Driver for Splunk in Data Import Handler and create an automated import of Splunk to Apache Solr Enterprise Search platform.
-
Connecting Pipedream with Oracle Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Oracle data in real time.
-
Access Live BigCommerce Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live BigCommerce data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to CloudConvert Data in Ruby
Connect to CloudConvert in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous ClickTime Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ClickTime replication to AlloyDB.
-
Automated Continuous GitHub Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable GitHub replication to Google BigQuery.
-
Integrate Pipedrive Data in Pentaho Data Integration
Build ETL pipelines based on Pipedrive in the Pentaho Data Integration tool.
-
Create Reports from Procore Data in Looker Studio
Use CData Connect AI to gain access to live Procore and create custom reports in Looker Studio.
-
Connect to ChartMogul Data from a Connection Pool in JBoss
Integrate ChartMogul into Java servlets: Use the Management Console in JBoss to install the ChartMogul JDBC Driver.
-
Connect Neo4J to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Neo4J with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Bannerbear Data in Tableau
The CData ODBC driver for Bannerbear enables you integrate Bannerbear into Tableau dashboards.
-
Integrating LlamaIndex with Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Vertica in real time.
-
DataBind Controls to Excel Online Data in C++Builder
DataBind to Microsoft Excel Online in C++Builder with standard components and controls.
-
Integrate Theia IDE with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Dynamics CRM Data into Power Automate Desktop using CData Connect
CData Connect for Dynamics CRM Data enables you to integrate Microsoft Dynamics CRM into workflows built using Microsoft Power Automate Desktop.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Google Sheets actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
How to Connect to MongoDB Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to MongoDB. Leverage the pyodbc module for ODBC in Python.