CData Software - Knowledge Base
Recent Articles
-
A PostgreSQL Interface for Supabase Data (MySQL Remoting via JDBC)
Use the Remoting features of the Supabase JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect EnterpriseDB Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live EnterpriseDB data in real time using natural language.
-
Automate Procore Data Replication to Azure Data Lake
Use CData Sync to customize and automate Procore replication to Azure Data Lake.
-
Integrating Gumloop with Google Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Analytics within automated workflows.
-
Migrating data from Gumroad to Snowflake using CData SSIS Components.
Easily push Gumroad to Snowflake using the CData SSIS Tasks for Gumroad and Snowflake.
-
Automate Delighted Data Replication to SAP HANA
Use CData Sync to customize and automate Delighted replication to SAP HANA.
-
How to Query Live Power BI XMLA Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Power BI XMLA data in natural language using Python.
-
Build Visualizations of Sybase Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Sybase in Birst.
-
Use the CData Software ODBC Driver for Instagram in MicroStrategy
Connect to Instagram in MicroStrategy Developer using the CData Software ODBC Driver for Instagram.
-
Bridge Highrise Connectivity with Apache NiFi
Access and process Highrise CRM in Apache NiFi using the CData JDBC Driver.
-
Build MVC Applications with Connectivity to Salesloft Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Salesloft from an ASP.NET MVC application.
-
Automated Continuous FreeAgent Replication to Oracle
Use CData Sync for automated, continuous, customizable FreeAgent replication to Oracle.
-
Access Live Humanity Data in AWS Lambda
Connect to live Humanity in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Azure Blob Storage Replication to SQLite
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to SQLite.
-
Build Neo4J-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Neo4J to explore live Neo4J Data in GitHub Copilot to assist with building Neo4J-powered applications.
-
Create Informatica Mappings From/To a JDBC Data Source for Everhour
Create Everhour data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Use the CData Software JDBC Driver for Cohere in MicroStrategy Web
Connect to Cohere in MicroStrategy Web using the CData Software JDBC Driver for Cohere.
-
Back Up Xero Accounting to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Xero. In this article, we will employ an SSIS workflow to populate a database with Xero Accounting data.
-
Write a Simple Go Application to work with ServiceDesk Plus Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ServiceDesk Plus.
-
Import Real-Time Sage Intacct Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Sage Intacct in ColdFusion.
-
Access Live Perigon Data in AWS Lambda
Connect to live Perigon in AWS Lambda using the CData JDBC Driver.
-
Excel Spreadsheet Automation on Insightly Data with the QUERY Formula
Pull data from Insightly, automate spreadsheets, and more with the QUERY formula.
-
Migrating data from MongoDB to Databricks using CData SSIS Components.
Easily push MongoDB to Databricks using the CData SSIS Tasks for MongoDB and Databricks.
-
Connecting Mastra with OData Services 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 OData, no replication required.
-
How to Connect to Live Avalara AvaTax 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 Avalara AvaTax through natural language.
-
Access Hacker News Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Hacker News from HeidiSQL.
-
Connecting Pipedream with eBay 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 eBay data in real time.
-
Connect to NetSuite Data in Ruby
Connect to NetSuite CRM & ERP in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous eBay Replication to Oracle
Use CData Sync for automated, continuous, customizable eBay replication to Oracle.
-
Connect to Snowflake Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Snowflake and the Script function in FileMaker Pro to connect to Snowflake and work with Snowflake in your FileMaker application.
-
Visualize DocuSign 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 DocuSign into TIBCO Spotfire.
-
Automated Continuous Jodoo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Jodoo replication to Google BigQuery.
-
How to Visualize Dropbox 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 Dropbox in Python.
-
Replicate Multiple Front Accounts
Replicate multiple Front accounts to one or many databases.
-
Automated Continuous Shortcut Replication to SQLite
Use CData Sync for automated, continuous, customizable Shortcut replication to SQLite.
-
Connect to ClickUp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ClickUp and the SQL Gateway to access ClickUp from Google Apps Script.
-
Add Retently Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Retently with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Dropbox Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Dropbox and build visualizations in Tableau Cloud.
-
Automated RSS Feeds Replication to Teradata
Use CData Sync to Customize and automate RSS Feeds replication to Teradata.
-
Automated Continuous Active Directory Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Active Directory replication to OneLake in Microsoft Fabric.
-
Connecting GenSpark with Azure DevOps Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure DevOps without any replication or custom integration required.
-
How to publish and share ShipEngine Data dashboards with Tableau Server
The CData ODBC driver for ShipEngine enables you integrate ShipEngine into Tableau dashboards.
-
Integrating Cursor CLI with LinkedIn Ads 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 Salesforce Pardot Data with Squirrel SQL client
Connect to Salesforce Pardot and execute queries in the Squirrel SQL Client.
-
Publish Parallel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Parallel.
-
Consume Kintone OData Feeds in PowerBuilder
This article demonstrates how to consume Kintone as OData feeds from PowerBuilder using the API Server.
-
Integrating Claude Code CLI with PostgreSQL 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.
-
Automate GetResponse Data Replication to SAP HANA
Use CData Sync to customize and automate GetResponse replication to SAP HANA.
-
Use the CData Software ODBC Driver for Azure DevOps in SAS for Real-Time Reporting and Analytics
Connect to real-time Azure DevOps in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Azure DevOps.
-
Visualize Live Copper Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Copper using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Query Live QuickBooks Time Data in Perplexity MacOS Desktop
Connect to and query live QuickBooks Time Data in Perplexity Desktop using CData MCP Server.
-
Create Reports from Pipedrive Data in Looker Studio
Use CData Connect AI to gain access to live Pipedrive and create custom reports in Looker Studio.
-
Access Live Amplitude Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Amplitude in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Cursor CLI with Twitter Ads 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.
-
Provide OData Services of Egnyte Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Egnyte by developing a WCF Service Application.
-
Automate Vault CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Veeva Vault & Vault CRM from PowerShell? This article demonstrates how to utilize the Vault CRM Cmdlets for tasks like connecting to Veeva Vault & Vault CRM, automating operations, downloading data, and more.
-
How to Build an ETL App for Monday.com Data in Python with CData Connect AI
Build ETL pipelines that read and write live Monday.com in Python with petl and the CData Connect AI Python SDK.
-
Use Grok to Talk to Your Reckon Accounts Hosted 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 Reckon Accounts Hosted for you.
-
Access Authorize.Net 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 Authorize.Net.
-
Connect to Odoo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Odoo ERP, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to CockroachDB from Asprova with CData Software ODBC Driver for CockroachDB
This article shows how to connect faster to CockroachDB data from Asprova.
-
Integrating Antigravity CLI with DocuSign via CData CLI
Connect DocuSign to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Amazon Athena Data to Multiple Databases
Replicate Amazon Athena to disparate databases with a point-and-click configuration.
-
Connect to eBay Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time eBay using standard SQL.
-
Create Impala-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Impala Data from OutSystems and build custom enterprise apps using live Apache Impala.
-
Connect to Brex from a Connection Pool in WebLogic
Use the CData JDBC Driver for Brex to connect to Brex from Web applications running on WebLogic.
-
Replicate NetSuite SuiteAnalytics Data to Multiple Databases via the CData Sync CLI
Replicate NetSuite SuiteAnalytics to disparate databases with a single configuration.
-
Choosing the Best Method to Connect Amplitude to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Amplitude from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous ClickUp Replication to Vertica
Use CData Sync for automated, continuous, customizable ClickUp replication to Vertica.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Mailjet
Provide connectivity to Mailjet through an SAP BusinessObjects universe.
-
Connect to BigCommerce Data in RapidMiner
Integrate BigCommerce with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to and Visualize Live Slack Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Slack.
-
Migrating data from Bitbucket to Google BigQuery using CData SSIS Components.
Easily push Bitbucket to Google BigQuery using the CData SSIS Tasks for Bitbucket and Google BigQuery.
-
Build AI/ML Models with Live Reply.io Data using Dataiku
Connect Reply.io Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To an ODBC Data Source for CockroachDB
Create an ODBC connection to CockroachDB in Informatica and browse and transfer CockroachDB.
-
Build Apps with Live Quickbase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Quickbase into the Adalo platform and build custom mobile and web applications with real-time Quickbase.
-
Automate PayPal Data Replication to Azure Data Lake
Use CData Sync to customize and automate PayPal replication to Azure Data Lake.
-
Model Zendesk Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zendesk, enabling the direct import of real-time Zendesk.
-
Automate Smartsheet Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Smartsheet from PowerShell? This article demonstrates how to utilize the Smartsheet Cmdlets for tasks like connecting to Smartsheet, automating operations, downloading data, and more.
-
How to connect to Act-On Data from IntelliJ
Integrate connectivity to Act-On with wizards in IntelliJ.
-
Use JayDeBeApi to access Splunk Data in Python
Use standard Python scripting and the development environment of your choice to access live Splunk.
-
Integrate Coda with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Coda with External Services.
-
Create Adobe Commerce-Connected Dashboards in Grafana
Connect to Adobe Commerce Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Adobe Commerce.
-
Connect to Outlook Data in DBeaver
Use the CData ODBC Driver to connect to Outlook in DBeaver.
-
How to connect to Freshteam Data in DBVisualizer
Integrate Freshteam with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Azure Data Lake Storage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Lake Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live PabblySubscriptions Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PabblySubscriptions using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to create an RPA flow for Vault CRM Data in UiPath Studio
Use the Vault CRM ODBC Driver to create workflows that access real-time Veeva Vault & Vault CRM without any coding.
-
Import Real-Time EmailOctopus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use EmailOctopus in ColdFusion.
-
Automate Power BI XMLA Data Replication to SAP HANA
Use CData Sync to customize and automate Power BI XMLA replication to SAP HANA.
-
Connect and Query Live MariaDB Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MariaDB into Databricks
-
How to connect and process Telegram from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Telegram.
-
Getting Started with the CData Power BI Connector for Mailjet
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
How to Connect to Cloudflare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Cloudflare. Leverage the pyodbc module for ODBC in Python.
-
Create Dashboards and Visualize Live MarkLogic Data in Geckoboard
Use CData Connect AI to connect to live MarkLogic and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous ConstantContact Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ConstantContact replication to IBM DB2.
-
Build Reckon Accounts Hosted-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Reckon Accounts Hosted to explore live Reckon Accounts Hosted Data in Claude Code to assist with building Reckon Accounts Hosted-powered applications.
-
Build an OLAP Cube in SSAS from Azure Data Lake Storage Data
Establish a connection to Azure Data Lake Storage data from SQL Server Analysis Services, and use the Azure Data Lake Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Replicate CSV Data in Heroku for Use in Salesforce Connect
Replicate CSV/TSV Files to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Access Live FHIR Data in Visual Studio Code via Cline
Run CData MCP Server for FHIR on Windows Subsytem for Linux (WSL) and connect to live FHIR from the Cline extension in Visual Studio Code.