CData Software - Knowledge Base
Recent Articles
-
Automated Continuous Microsoft Planner Replication to SQLite
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to SQLite.
-
Integrating Claude Code CLI with Typeform 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.
-
Replicate BigCommerce Data from PowerShell
Write a quick PowerShell script to query BigCommerce. Use connectivity to the live data to replicate BigCommerce to SQL Server.
-
How to Work with CouchDB Data in ETL Validator JDBC
Connect to CouchDB from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to NASA Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect PostgreSQL to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live PostgreSQL using the CData Python MCP Server.
-
How to connect PolyBase to SendInBlue
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SendInBlue.
-
Use Claude to Talk to Your FHIR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your FHIR for you.
-
Access Live MarkLogic Data in Excel 365 Online (Excel for the web)
Connect to MarkLogic from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to Bitbucket Data in JRuby
Create a simple JRuby app with access to live Bitbucket.
-
Import Real-Time PolarTeamPro Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use PolarTeamPro in ColdFusion.
-
Build Semantic Layer Views for MYOB AccountRight Data in APOS Live Data Gateway
Use the CData Connector for MYOB AccountRight in APOS Live Data Gateway to build Semantic Layer Views for MYOB AccountRight.
-
How to integrate AlloyDB with Apache Airflow
Access and process Google AlloyDB in Apache Airflow using the CData JDBC Driver.
-
Use Azure AI Foundry to Talk to Your WooCommerce 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 WooCommerce for you.
-
Visualize Live Gumroad Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Gumroad.
-
Import IBM Cloud Object Storage Data Using Azure Data Factory
Use CData Connect AI to connect to IBM Cloud Object Storage Data from Azure Data Factory and import live IBM Cloud Object Storage.
-
Automated Continuous iContact Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable iContact replication to Apache Kafka.
-
Visualize Moosend Data in Sisense
Create an ElastiCube in Sisense app with access to Moosend.
-
How to Connect to Live Google Directory 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 Google Directory without replication.
-
Connect to Cosmos DB Data in Google Apps Script via Connect AI
Use CData Connect AI to access Azure Cosmos DB in Google Apps Script.
-
DataBind Charts to Smartsheet Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Smartsheet 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.
-
Build Exact Online-Connected Apps in Choreo
Use CData Connect AI to connect to Exact Online Data from Choreo and build custom apps using live Exact Online.
-
Use the CData Software JDBC Driver for Oracle Eloqua in MicroStrategy Desktop
Connect to Oracle Eloqua in MicroStrategy Desktop using the CData Software JDBC Driver for Oracle Eloqua.
-
Integrate Webflow with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Webflow with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Webflow.
-
Connect to DB2 Data as an External Source in Dremio
Use the CData JDBC Driver to connect to DB2 as an External Source in Dremio.
-
Explore Geographical Relationships in Exact Online Data with Power Map
Create data visualizations with Exact Online in Power Map.
-
How to update Pipedrive from Excel
This article explains how to transfer data from Excel to Pipedrive using the Excel Add-In for Pipedrive.
-
Visualize Shortcut Data in Tableau
The CData ODBC driver for Shortcut enables you integrate Shortcut into Tableau dashboards.
-
Build ShipStation-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for ShipStation Data and create custom apps in Mendix.
-
Create Zoho Projects-Connected Dashboards in Grafana
Connect to Zoho Projects Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Zoho Projects.
-
Create a Data Access Object for HubDB Data using JDBI
A brief overview of creating a SQL Object API for HubDB in JDBI.
-
How to Connect to Live Xero 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 Xero Accounting without replication.
-
Stream AdRoll Data into Apache Kafka Topics
Access and stream AdRoll in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Snapchat Ads Data Replication to Teradata
Use CData Sync to Customize and automate Snapchat Ads replication to Teradata.
-
Access Bright Data Data from MySQL in PHP
Connect to Bright Data through the standard MySQL libraries in PHP.
-
How to create DB2 federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for IBM DB2 in MySQL .
-
Build Charts with Close Data in Clear Analytics
Create dynamic charts and perform analytics based on Close in Clear Analytics.
-
Connect to Front Data in RapidMiner
Integrate Front with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting Mastra with MYOB AccountRight 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 MYOB AccountRight, no replication required.
-
Work with Live Apollo Data in Power Query
Use CData Connect AI to connect to Apollo and work with live Apollo in Microsoft Power Query.
-
Rapidly Develop BigQuery-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 BigQuery.
-
Replicate Multiple Flowlu Accounts
Replicate multiple Flowlu accounts to one or many databases.
-
Access Live SAP SuccessFactors LMS Data in AWS Lambda
Connect to live SAP SuccessFactors LMS in AWS Lambda using the CData JDBC Driver.
-
Connect to Missive Data from a Connection Pool in JBoss
Integrate Missive into Java servlets: Use the Management Console in JBoss to install the Missive JDBC Driver.
-
Natively Connect to GraphQL Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to GraphQL. Leverage the native support for ODBC in PHP.
-
Connect to Landbot from Asprova with CData Software ODBC Driver for Landbot
This article shows how to connect faster to Landbot data from Asprova.
-
DataBind Charts to Kintone Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Kintone 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.
-
Access Live Twitter Ads Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Twitter Ads into the statistical analysis tools available in SAS JMP. This article shows how to use Twitter Ads in the Graph Builder and Query Builder.
-
Connecting Mastra with NetSuite 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 NetSuite CRM & ERP, no replication required.
-
Create Elasticsearch-Connected Applications in Appsmith
Connect to Elasticsearch Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Elasticsearch.
-
How to Query Live Aha! Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Aha! data in natural language using Python.
-
Building Dynamic Web Pages with CouchDB Data Using AngularJS
Create single-page applications with live connectivity to CouchDB using the CData API Server.
-
Connect to ZohoSubscriptions Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ZohoSubscriptions using standard SQL.
-
Connect to Real-Time JSON Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for JSON and Dataflow to import and use JSON in Power Apps.
-
Automate Avalara AvaTax Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Avalara AvaTax and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to publish and share Browserless Data dashboards with Tableau Server
The CData ODBC driver for Browserless enables you integrate Browserless into Tableau dashboards.
-
Use the CData ODBC Driver for HCL Domino in Microsoft Power Query
You can use the CData HCL Domino ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HCL Domino into Microsoft Power Query.
-
How to connect to Asana Data in DBVisualizer
Integrate Asana with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple Printful Accounts
Replicate multiple Printful accounts to one or many databases.
-
Create CSV-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to CSV Data from Klipfolio and build custom visualizations using live CSV/TSV Files.
-
How to integrate ZohoInvoice with Apache Airflow
Access and process ZohoInvoice in Apache Airflow using the CData JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Hacker News Data
Use CData Power BI Connectors to visualize Hacker News in Power BI.
-
Replicate CockroachDB Data to Multiple Databases
Replicate CockroachDB to disparate databases with a point-and-click configuration.
-
A PostgreSQL Interface for ZohoExpense Data using the CData ODBC Driver
Use the SQL Gateway and ZohoExpense ODBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for Google Sheets in PyCharm
Connect to Google Sheets as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Sheets.
-
How to use SQLAlchemy ORM to access Tally Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Tally ERP.
-
Add IBM Cloud Object Storage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for IBM Cloud Object Storage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automated Continuous QuickBooks Online Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable QuickBooks Online replication to Apache Cassandra.
-
How to load Google Contacts data into Elasticsearch via Logstash
Introducing a simple method to load Google Contacts data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Dotmailer Data in RapidMiner
Integrate Dotmailer with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated VWO Data Replication to Teradata
Use CData Sync to Customize and automate VWO replication to Teradata.
-
Use the CData Software JDBC Driver for LinkedIn Ads in MicroStrategy
Connect to LinkedIn Ads in MicroStrategy Developer using the CData Software JDBC Driver for LinkedIn Ads.
-
How to Connect to Live Shopify Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Shopify securely in real time.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy Web
Connect to NetSuite CRM & ERP in MicroStrategy Web using the CData Software JDBC Driver for NetSuite.
-
Visualize Live Microsoft Dataverse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Microsoft Dataverse (CDS) using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Dashboards with Mixpanel Data in DBxtra
Create dynamic dashboards and perform analytics based on Mixpanel in DBxtra.
-
Build Pipelines with Live Monday.com Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Monday.com from Google Cloud Data Fusion, enabling the integration of live Monday.com into the building and management of effective data pipelines.
-
How to create Visio diagrams from EnterpriseDB Data
Automatically update EnterpriseDB with the changes you make to Visio master shapes.
-
Replicate EmailOctopus Data in Heroku for Use in Salesforce Connect
Replicate EmailOctopus to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Real-Time Klipfolio Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Klipfolio in Power Apps.
-
Easily Integrate AfterShip Data in Lazarus Pascal IDE
Learn how to easily integrate live AfterShip in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Search Results in Claris FileMaker Pro
Use the CData ODBC Driver for Google Search in FileMaker Pro to connect to Google Search and work with Google Search in your FileMaker applications.
-
Automated Continuous Google Contacts Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Contacts replication to Azure SQL Database.
-
Automated Continuous Google Calendar Replication to Snowflake
Use CData Sync for automated, continuous, customizable Google Calendar replication to Snowflake.
-
Access Live SFTP Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate SFTP into the statistical analysis tools available in SAS JMP. This article shows how to use SFTP in the Graph Builder and Query Builder.
-
Replicate LionDesk Data to Multiple Databases via the CData Sync CLI
Replicate LionDesk to disparate databases with a single configuration.
-
Use the CData Software JDBC Driver for SingleStore in MicroStrategy Desktop
Connect to SingleStore in MicroStrategy Desktop using the CData Software JDBC Driver for SingleStore.
-
Analyze WooCommerce Data in Looker
Use CData Connect AI to connect to WooCommerce Data from Looker and build custom apps using live WooCommerce.
-
How to connect PolyBase to ClickUp
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ClickUp.
-
How to connect to Office 365 Data from IntelliJ
Integrate connectivity to Microsoft Office 365 with wizards in IntelliJ.
-
Automated Continuous AfterShip Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable AfterShip replication to Google Cloud SQL.
-
Access BigCommerce 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 BigCommerce.
-
Use JayDeBeApi to access PingOne Data in Python
Use standard Python scripting and the development environment of your choice to access live PingOne.
-
Write a Simple Go Application to work with xBase Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to xBase.
-
Connect to Samanage Data from PowerBuilder via JDBC
This article demonstrates how to access Samanage from PowerBuilder using the Samanage JDBC Driver.
-
Choosing the Best Method to Connect Calendly to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Calendly from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Pipeline CRM Reporting in OBIEE with the Pipeline CRM JDBC Driver
Deploy the Pipeline CRM JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with Odoo Data in AWS Glue Jobs Using JDBC
Connect to Odoo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Reports with LeadDesk Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LeadDesk.
-
Manage Kintone Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Kintone.