CData Software - Knowledge Base
Recent Articles
-
Feed Reckon Accounts Hosted Data into FineReport
How to set Reckon Accounts Hosted data as a JDBC data source in FineReport.
-
Integrate with Email Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Email data to a JSON file on disk.
-
Connect to Todoist Data in DBArtisan
Use wizards in DBArtisan to configure Todoist data as a data source.
-
Validate Zoho Creator Data with QuerySurge
Access and validate Zoho Creator data in QuerySurge using the CData JDBC Driver.
-
Integrate Cursor with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live MongoDB data from within the editor.
-
Use the CData ODBC Driver for ServiceDesk Plus in Microsoft Power Query
You can use the CData ServiceDesk Plus ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ServiceDesk Plus data into Microsoft Power Query.
-
Replicate Mode Data to Multiple Databases via the CData Sync CLI
Replicate Mode data to disparate databases with a single configuration.
-
Back Up Adobe Commerce data 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 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 data securely in real time.
-
Explore Geographical Relationships in Google Calendar Data with Power Map
Create data visualizations with Google Calendar data 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 data.
-
Connect to Azure Data Lake Storage Data from a Connection Pool in JBoss
Integrate Azure Data Lake Storage data 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 Confluence data 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 data 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 Kafka data by developing a WCF Service Application.
-
Integrate Google's Vertex AI Agent with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live SAP SuccessFactors data within intelligent workflows.
-
Use the CData Software JDBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services data 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 data 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 data 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 data.
-
Build an OLAP Cube in SSAS from Omnisend Data
Establish a connection to Omnisend data 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 data.
-
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 data.
-
How to Access Live Facebook Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Facebook enables you to integrate Facebook data 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 data for you.
-
Publish Sage Cloud Accounting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Sage Cloud Accounting data.
-
Automated Continuous Apollo Replication to Oracle
Use CData Sync for automated, continuous, customizable Apollo replication to Oracle.
-
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 data to disparate databases with a single configuration.
-
Automated Bright Data Data Replication to Teradata
Use CData Sync to Customize and automate Bright Data data replication to Teradata.
-
Connect to Omnisend Data in RazorSQL
Connect to Omnisend from wizards and query Omnisend data 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 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 data 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 data 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 data 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 data 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 data 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 data.
-
LinkedIn Ads Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to LinkedIn Ads data through CData Connect AI using different applications and tools.
-
ETL Float in Oracle Data Integrator
This article shows how to transfer Float data 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 data.
-
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 data in your FileMaker application.
-
Connect to Azure Synapse Data in Ruby
Connect to Azure Synapse data 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.
-
Build Coda-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Coda data and build Coda-connected web apps with Axios.
-
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.
-
Access Live Mode Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Mode data from your Excel spreadsheets.
-
Build Cosmos DB Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Cosmos DB data 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.
-
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 data.
-
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 data.
-
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 Vault CRM data 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 data and work with live Azure Synapse data in Microsoft Power Query.
-
Integrating Dataiku with Mode Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Mode data.
-
Migrating data from Lakebase to Google BigQuery using CData SSIS Components.
Easily push Lakebase data 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 data.
-
Integrate Hive Data in the Pentaho Report Designer
Publish reports based on Hive data in the Pentaho BI tool.
-
Connect to ZohoDesk Data in ACL Analytics
Connect to ZohoDesk data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to ZohoDesk data.
-
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 SharePoint data 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 data 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 data 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 data 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 data in Power Map.
-
Connect to Flowlu Data from PowerBuilder via ADO.NET
This article demonstrates how to access Flowlu data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Back Up Salesloft data 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 data.
-
Extract, Transform, and Load Gorgias Data in Informatica PowerCenter
Create a simple Workflow for Gorgias data in Informatica PowerCenter.
-
Explore Geographical Relationships in Bannerbear Data with Power Map
Create data visualizations with Bannerbear data in Power Map.
-
Automated Continuous Google Ad Manager Replication to Databricks
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Databricks.
-
Getting Started with the CData Connect AI Python SDK for LDAP
Install the CData Connect AI Python SDK to read and write live LDAP objects with standard DB-API 2.0 Python code.
-
How to Connect to Bright Data Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bright Data 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 data into Tableau dashboards.
-
Access Bugsnag Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Bugsnag data from HeidiSQL.
-
Automate XML Data Replication to Couchbase
Use CData Sync to Customize and automate XML data replication to Couchbase.
-
How to connect and process Landbot data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Landbot data.
-
Connect to FormSite Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for FormSite to connect to FormSite data 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 data.
-
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 data from MicroStrategy.
-
Build Dynamics NAV-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Dynamics NAV data without replication.
-
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 data 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 data without any coding.
-
How to connect and process Avaza data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Avaza data.
-
Perform Batch Operations with Wave Financial Data in Apache NiFi
Connect to Wave Financial data 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 Redshift data 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 data from HeidiSQL.
-
Establish a Live Connection with SAP Data using Tableau Bridge
The CData ODBC Driver for SAP enables you to integrate live SAP data into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Sage 300 Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage 300 data from your Oracle system.
-
Model, Search, and Visualize Live Paylocity Data in ThoughtSpot
Use CData Connect AI to connect to live Paylocity data for modeling, searching, and visualizing.