CData Software - Knowledge Base
Recent Articles
-
Replicate Mode Data to Multiple Databases via the CData Sync CLI
Replicate Mode to disparate databases with a single configuration.
-
Back Up Adobe Commerce to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Adobe Commerce. In this article, we will employ an SSIS workflow to populate a database with Adobe Commerce data.
-
How to Connect to Live Marketo Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Marketo securely in real time.
-
Explore Geographical Relationships in Google Calendar Data with Power Map
Create data visualizations with Google Calendar in Power Map.
-
How to connect PolyBase to Parallel
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Parallel.
-
Connect to Azure Data Lake Storage Data from a Connection Pool in JBoss
Integrate Azure Data Lake Storage into Java servlets: Use the Management Console in JBoss to install the Azure Data Lake Storage JDBC Driver.
-
Replicate Confluence Data to Multiple Databases
Replicate Atlassian Confluence to disparate databases with a point-and-click configuration.
-
How to work with OnePageCrm Data in Apache Spark using SQL
Access and process OnePageCrm Data in Apache Spark using the CData Software JDBC Driver.
-
Integrate MarkLogic Data in Pentaho Data Integration
Build ETL pipelines based on MarkLogic in the Pentaho Data Integration tool.
-
Provide OData Services of Kafka Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Apache Kafka by developing a WCF Service Application.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP SuccessFactors within intelligent workflows.
-
Use the CData Software JDBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services in MicroStrategy Developer using the CData Software JDBC Driver for SQL Analysis Services.
-
Integrate Cline with Live Zoho Projects Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Zoho Projects from within your IDE.
-
Choosing the Best Method to Connect Notion to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Notion from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Manus AI to Talk to Your NetSuite 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 NetSuite CRM & ERP.
-
Build an OLAP Cube in SSAS from Omnisend Data
Establish a connection to Omnisend data from SQL Server Analysis Services, and use the Omnisend Data Provider to build OLAP cubes for use in analytics and reporting.
-
Create Twitter Ads-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Twitter Ads Data from Klipfolio and build custom visualizations using live Twitter Ads.
-
How to use SQLAlchemy ORM to access Zoho Creator Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Zoho Creator.
-
How to Access Live Facebook Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Facebook enables you to integrate Facebook into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Instagram 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 Instagram for you.
-
Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage Business Cloud Accounting.
-
Replicate Multiple LinkedIn Accounts via the CData Sync CLI
Replicate multiple LinkedIn accounts to one or many databases.
-
Replicate Bugsnag Data to Multiple Databases via the CData Sync CLI
Replicate Bugsnag to disparate databases with a single configuration.
-
Connect to Omnisend Data in RazorSQL
Connect to Omnisend from wizards and query Omnisend from the GUI in the RazorSQL database management tool.
-
Automated Continuous Supabase Replication to MySQL
Use CData Sync for automated, continuous, customizable Supabase replication to MySQL.
-
Integrating OpenCode Terminal with BenchmarkEmail 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 Nuclia Data in Aqua Data Studio
Access Nuclia from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Real-Time ZohoSubscriptions Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoSubscriptions in Power Apps.
-
Manage HBase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HBase.
-
Integrate with Shortcut Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Shortcut to a JSON file on disk.
-
Create Dashboards and Visualize Live Azure Synapse Data in Geckoboard
Use CData Connect AI to connect to live Azure Synapse and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Build Databricks-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Databricks Data and create custom apps in Mendix.
-
Access Aweber Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Aweber from your Oracle system.
-
How to Work with Clari Data in ETL Validator JDBC
Connect to Clari from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect PolyBase to Active Directory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Active Directory.
-
How to Access Live Lakebase Data in Visual Studio Code via Cline
Run CData MCP Server for Lakebase on Windows Subsytem for Linux (WSL) and connect to live Lakebase from the Cline extension in Visual Studio Code.
-
LinkedIn Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to LinkedIn Ads through CData Connect AI using different applications and tools.
-
ETL Float in Oracle Data Integrator
This article shows how to transfer Float into a data warehouse using Oracle Data Integrator.
-
How to Connect to & Open Customer.io Data in Microsoft Excel
This article uses the CData ODBC driver for Customer.io to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create BambooHR-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to BambooHR Data from Klipfolio and build custom visualizations using live BambooHR.
-
Connect to Parallel Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Parallel and work with Parallel in your FileMaker application.
-
Connect to Azure Synapse Data in Ruby
Connect to Azure Synapse in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous GitLab Replication to Snowflake
Use CData Sync for automated, continuous, customizable GitLab replication to Snowflake.
-
How to load Excel Online data into Elasticsearch via Logstash
Introducing a simple method to load Excel Online data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Cosmos DB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Azure Cosmos DB and build visualizations in Tableau Cloud.
-
How to Work with HelloSign Data in AWS Glue Jobs Using JDBC
Connect to HelloSign from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Manage Exact Online Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Exact Online.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Microsoft Teams to Power BI dashboards. Simply drag and drop Microsoft Teams into data visuals on the Power BI canvas.
-
Automated Continuous Jumpseller Replication to SQLite
Use CData Sync for automated, continuous, customizable Jumpseller replication to SQLite.
-
Connect to and Visualize Live Azure Analysis Services Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Azure Analysis Services.
-
Integrate Teamwork with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Teamwork with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Teamwork.
-
Access TaxJar Data from MySQL in PHP
Connect to TaxJar through the standard MySQL libraries in PHP.
-
Connect to Vault CRM Data from a Connection Pool in JBoss
Integrate Veeva Vault & Vault CRM into Java servlets: Use the Management Console in JBoss to install the Vault CRM JDBC Driver.
-
Work with Live Azure Synapse Data in Power Query
Use CData Connect AI to connect to Azure Synapse and work with live Azure Synapse in Microsoft Power Query.
-
Migrating data from Lakebase to Google BigQuery using CData SSIS Components.
Easily push Lakebase to Google BigQuery using the CData SSIS Tasks for Lakebase and Google BigQuery.
-
How to use SQLAlchemy ORM to access Helpscout Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Helpscout.
-
Integrate Hive Data in the Pentaho Report Designer
Publish reports based on Apache Hive in the Pentaho BI tool.
-
Connect to Live SharePoint Data in MicroStrategy through CData Connect AI
Create a live connection to SharePoint Data in CData Connect AI and connect to your Microsoft SharePoint from MicroStrategy.
-
How to Visualize SAP SuccessFactors LMS 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 SAP SuccessFactors LMS in Python.
-
Use Microsoft Copilot Studio to talk to your Dynamics 365 Business Central Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Dynamics 365 Business Central for you.
-
Create Datasets from Bullhorn CRM in Domo Workbench and Build Visualizations of Bullhorn CRM Data in Domo
Use the CData Software ODBC Driver for Bullhorn CRM to create datasets from Bullhorn CRM in Domo Workbench and then build visualizations in the Domo service.
-
Explore Geographical Relationships in ElevenLabs Data with Power Map
Create data visualizations with ElevenLabs in Power Map.
-
Build SAP Ariba Procurement-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for SAP Ariba Procurement to explore live SAP Ariba Procurement Data in Claude Code to assist with building SAP Ariba Procurement-powered applications.
-
Connect to Flowlu Data from PowerBuilder via ADO.NET
This article demonstrates how to access Flowlu from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Back Up Salesloft to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Salesloft. In this article, we will employ an SSIS workflow to populate a database with Salesloft data.
-
Extract, Transform, and Load Gorgias Data in Informatica PowerCenter
Create a simple Workflow for Gorgias in Informatica PowerCenter.
-
Explore Geographical Relationships in Bannerbear Data with Power Map
Create data visualizations with Bannerbear in Power Map.
-
Automated Continuous Google Ad Manager Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Databricks.
-
How to Connect to Bright Data Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bright Data. Leverage the pyodbc module for ODBC in Python.
-
How to load Telegram data into Elasticsearch via Logstash
Introducing a simple method to load Telegram data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to publish and share Splunk Data dashboards with Tableau Server
The CData ODBC driver for Splunk enables you integrate Splunk into Tableau dashboards.
-
Access Bugsnag Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bugsnag from HeidiSQL.
-
Automate XML Data Replication to Couchbase
Use CData Sync to Customize and automate XML Files replication to Couchbase.
-
How to connect and process Landbot from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Landbot.
-
Connect to FormSite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FormSite to connect to FormSite and execute queries in PowerBuilder.
-
Create HCL Domino-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to HCL Domino Data from Klipfolio and build custom visualizations using live HCL Domino.
-
Connect to Live Salesforce Pardot Data in MicroStrategy through CData Connect AI
Create a live connection to Salesforce Pardot Data in CData Connect AI and connect to your Salesforce Pardot from MicroStrategy.
-
Excel Spreadsheet Automation on Freshservice Data with the QUERY Formula
Pull data from Freshservice, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Pipeliner CRM Data in AWS Glue Jobs Using JDBC
Connect to Pipeliner CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to connect to MariaDB Data with Squirrel SQL client
Connect to MariaDB and execute queries in the Squirrel SQL Client.
-
How to create an RPA flow for SendGrid Data in UiPath Studio
Use the SendGrid ODBC Driver to create workflows that access real-time SendGrid without any coding.
-
How to connect and process Avaza from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Avaza.
-
Perform Batch Operations with Wave Financial Data in Apache NiFi
Connect to Wave Financial and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Extract, Transform, and Load Redshift Data in Informatica PowerCenter
Create a simple Workflow for Amazon Redshift in Informatica PowerCenter.
-
Automated Continuous Optimizely Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Optimizely replication to Amazon S3.
-
Access LaunchDarkly Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LaunchDarkly from HeidiSQL.
-
Establish a Live Connection with SAP Data using Tableau Bridge
The CData ODBC Driver for SAP enables you to integrate live SAP ERP/NetWeaver into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live SAP Hybris C4C Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SAP Hybris C4C data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Access Sage 300 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 300 from your Oracle system.
-
Model, Search, and Visualize Live Paylocity Data in ThoughtSpot
Use CData Connect AI to connect to live Paylocity for modeling, searching, and visualizing.
-
Use ChatGPT to Talk to Your DocuSign 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 DocuSign for you.
-
Connect and Query Live GraphQL Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GraphQL into Databricks
-
Integrate Theia IDE with Live NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Use JayDeBeApi to access Authorize.Net Data in Python
Use standard Python scripting and the development environment of your choice to access live Authorize.Net.
-
Query ShipStation Data from Node.js
Use the OData endpoint of the CData API Server to connect to your ShipStation and perform CRUD operations on ShipStation from Node.js.
-
How to connect to REST Data from IntelliJ
Integrate connectivity to REST with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for Helpscout in MicroStrategy
Connect to Helpscout in MicroStrategy Developer using the CData Software ODBC Driver for Helpscout.
-
Build Salesforce Pardot-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Salesforce Pardot Data and create custom apps in Mendix.
-
Connect to SAP Business Warehouse Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAP Business Warehouse in FileMaker Pro to connect to SAP Business Warehouse and work with SAP Business Warehouse in your FileMaker applications.
-
How to publish and share ZohoExpense Data dashboards with Tableau Server
The CData ODBC driver for ZohoExpense enables you integrate ZohoExpense into Tableau dashboards.