CData Software - Knowledge Base
Recent Articles
-
Getting Started with the CData SSIS Components for Elorus
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Elorus.
-
Build HubSpot Visualizations in Tableau Cloud
Use CData Connect AI to connect to live HubSpot data and build visualizations in Tableau Cloud.
-
How to Work with LDAP Objects in AWS Glue Jobs Using JDBC
Connect to LDAP from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
DataBind Controls to Recurly Data in C++Builder
DataBind to Recurly data in C++Builder with standard components and controls.
-
Visualize Amazon Marketplace Data in Sisense
Create an ElastiCube in Sisense app with access to Amazon Marketplace data.
-
How to connect to DB2 Data with Squirrel SQL client
Connect to DB2 data and execute queries in the Squirrel SQL Client.
-
How to Work with Omnisend Data in ETL Validator JDBC
Connect to Omnisend from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous Oracle Eloqua Reporting Replication to Oracle
Use CData Sync for automated, continuous, customizable Oracle Eloqua Reporting replication to Oracle.
-
Query SFTP Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SFTP entities in PHP by modeling them as objects.
-
How to connect PolyBase to Zendesk
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zendesk data.
-
Build Data Flows from SingleStore to SQL Server using SSIS
Easily back up SingleStore data to SQL Server using the SSIS components for SingleStore.
-
Connect Attio Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Attio data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Publish LDAP-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live LDAP objects.
-
Connect to ChartMogul 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 ChartMogul and work with ChartMogul data in your FileMaker application.
-
Integrate PingOne with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate PingOne with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to PingOne data.
-
Automated Continuous Sage Cloud Accounting Replication to Snowflake
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to Snowflake.
-
How to Query Live Procore Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Procore data data in natural language using Python.
-
Getting Started with the CData Python Connector for Google Drive
Learn to install and license the CData Python Connector and configure a connection to live Google Drive data.
-
Visualize Copper Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Copper data.
-
Connect to Planio Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Planio to connect to Planio data and execute queries in PowerBuilder.
-
Integrate LibreChat with Live LinkedIn Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live LinkedIn data from within the chat interface.
-
Replicate Multiple Microsoft OneLake Accounts via the CData Sync CLI
Replicate multiple Microsoft OneLake accounts to one or many databases.
-
How to connect to Outlook Data from Spring Boot
Connect to Outlook in a Spring Boot Application using the CData API Driver for JDBC
-
Choosing the Best Method to Connect ScrapingBee to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ScrapingBee data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
SparkPost Reporting in OBIEE with the SparkPost JDBC Driver
Deploy the SparkPost JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect and process Mistral AI data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Mistral AI data.
-
Connect to Outreach.io Data in RazorSQL
Connect to Outreach.io from wizards and query Outreach.io data from the GUI in the RazorSQL database management tool.
-
Build ServiceDesk Plus Visualizations in Tableau Desktop
Use CData Connect AI to connect to live ServiceDesk Plus data and build visualizations in Tableau.
-
Query, Visualize, and Share live Reckon Accounts Hosted Data in Redash
Use CData Connect AI to connect to live Reckon Accounts Hosted data in Redash for querying, visualizing, and sharing.
-
How to Connect to HelloSign Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to HelloSign data. Leverage the pyodbc module for ODBC in Python.
-
Load Telegram Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Telegram data to a database.
-
Connect to Sentry Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Sentry data.
-
Add ZohoSubscriptions Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ZohoSubscriptions with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating OpenCode with Freshservice 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.
-
Integrate Live Dynamics NAV Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Dynamics NAV data from within the IDE.
-
Automated Continuous eBay Replication to MySQL
Use CData Sync for automated, continuous, customizable eBay replication to MySQL.
-
Visualize Dropbox Data in Sisense
Create an ElastiCube in Sisense app with access to Dropbox data.
-
Connect to Zoom Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Zoom.
-
Connect to IBM Informix Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for IBM Informix and the Script function in FileMaker Pro to connect to IBM Informix and work with IBM Informix data in your FileMaker application.
-
Connect to SAP Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP data.
-
Integrate Trae with Live Salesforce Data 360 Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Salesforce Data 360 data from within the AI-powered IDE.
-
How to Create Power BI Visual Reports with Real-Time Pipedrive Data
Use CData Power BI Connectors to visualize Pipedrive data in Power BI.
-
Connecting Mastra with Raisers Edge NXT 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 Raisers Edge NXT data, no replication required.
-
Moving Data from Zoho Creator to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Creator data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Prepare, Blend, and Analyze SAP Netweaver Gateway Data in Alteryx Designer (ODBC)
Build workflows to access live SAP Netweaver Gateway data for self-service data analytics.
-
Visualize BigQuery Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to BigQuery data.
-
How to Easily Query Rebilly Data in OpenOffice Base
Connect to Rebilly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Use Microsoft Copilot Studio to talk to your MailChimp 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 MailChimp data for you.
-
Visualize HDFS Data in TIBCO Spotfire through OData
Integrate HDFS data into dashboards in TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Paylocity
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Paylocity.
-
Getting Started with the CData Python Connector for OData
Learn to install and license the CData Python Connector and configure a connection to live OData services.
-
How to Query Egnyte Data in MySQL Workbench
Execute MySQL queries against live Egnyte data from MySQL Workbench.
-
Connect to ZohoInvoice Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZohoInvoice and the SQL Gateway to access ZohoInvoice data from Google Apps Script.
-
Access Live Odoo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Odoo data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Prepare, Blend, and Analyze MySQL Data in Alteryx Designer (Connect AI)
Build workflows to access live MySQL data for self-service data analytics.
-
How to Visualize Avro 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 Avro data in Python.
-
Build Semantic Layer Views for Google Directory Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Directory data.
-
How to Easily Query Mixpanel Data in OpenOffice Base
Connect to Mixpanel data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Visualize Live HubSpot Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live HubSpot data.
-
Access Live Mailjet Data in AWS Lambda
Connect to live Mailjet data in AWS Lambda using the CData JDBC Driver.
-
Migrating data from Aweber to Google BigQuery using CData SSIS Components.
Easily push Aweber data to Google BigQuery using the CData SSIS Tasks for Aweber and Google BigQuery.
-
Integrating Claude Code CLI with Trello 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.
-
Load Gong Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Gong data to a database.
-
ServiceDesk Plus Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to ServiceDesk Plus data through CData Connect AI using different applications and tools.
-
Access Nethunt 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 Nethunt data.
-
Work with Hugging Face Data in FoxPro
Load Hugging Face data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Shippo Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Shippo data with the CData JDBC Driver for Shippo.
-
Replicate BambooHR Data to Multiple Databases via the CData Sync CLI
Replicate BambooHR data to disparate databases with a single configuration.
-
Integrate with Datadog Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Datadog data to a JSON file on disk.
-
Build GitLab-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GitLab data.
-
Analyze Spotify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Spotify data with the CData JDBC Driver for Spotify.
-
How to publish and share Twilio Data dashboards with Tableau Server
The CData ODBC driver for Twilio enables you integrate Twilio data into Tableau dashboards.
-
Integrating Cursor with Auth0 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.
-
View Reports on Real-Time MariaDB Data in Power BI Report Server
Use the CData ODBC Driver for MariaDB to visualize MariaDB data in Power BI Desktop and then publish them to Power BI Report Server.
-
Use the CData Software ODBC Driver for Guru in MicroStrategy
Connect to Guru data in MicroStrategy Developer using the CData Software ODBC Driver for Guru.
-
How to update CouchDB from Excel
This article explains how to transfer data from Excel to CouchDB using the Excel Add-In for CouchDB.
-
Integrating Gumloop with Paymo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Paymo data within automated workflows.
-
Query, Visualize, and Share live Neo4J Data in Redash
Use CData Connect AI to connect to live Neo4J data in Redash for querying, visualizing, and sharing.
-
Automated Continuous Microsoft Entra ID Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to Apache Kafka.
-
Use the CData Software JDBC Driver for Templated in MicroStrategy Web
Connect to Templated data in MicroStrategy Web using the CData Software JDBC Driver for Templated.
-
Access Live Salesforce CRM Analytics Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Salesforce CRM Analytics data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData Python Connector for MYOB AccountRight
Learn to install and license the CData Python Connector and configure a connection to live MYOB AccountRight data.
-
Create SSAS Tabular Models from SendPulse Data
How to build a SQL Server Analysis Service Tabular Model from SendPulse data using CData drivers.
-
Automate ZeroBounce Data Replication to SAP HANA
Use CData Sync to customize and automate ZeroBounce data replication to SAP HANA.
-
Use JayDeBeApi to access ZohoMarketingHub Data in Python
Use standard Python scripting and the development environment of your choice to access live ZohoMarketingHub data.
-
Replicate On-Premises Data to Microsoft Fabric with Compliance Controls using CData Sync
Learn how to selectively replicate on-premises data to Microsoft Fabric OneLake using CData Sync while maintaining compliance with HIPAA, SOX, and data sovereignty regulations
-
Connect to Bugsnag Data in Ruby
Connect to Bugsnag data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Deploy the ADO.NET Provider for Zuora on an SSRS Report Server
Connect to Zuora data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Build MVC Applications with Connectivity to Microsoft Planner Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Microsoft Planner from an ASP.NET MVC application.
-
Automated Continuous Greenplum Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Greenplum replication to Apache Kafka.
-
Use the CData SSIS Components to Insert New or Update Existing Couchbase Records from SQL Server
Easily push SQL Server data to Couchbase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Couchbase or update existing records with data from a SQL Server database.
-
Integrating OpenCode with Shopify 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.
-
Getting Started with the CData ADO.NET Provider for Google Ads
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Google Ads.
-
Build Dashboards with Mistral AI Data in Dundas BI
Create dynamic dashboards and perform analytics based on Mistral AI data in Dundas BI.
-
Explore Geographical Relationships in Webex Data with Power Map
Create data visualizations with Webex data in Power Map.
-
How to Create Power BI Visual Reports with Real-Time Superchat Data
Use CData Power BI Connectors to visualize Superchat data in Power BI.
-
Build Semantic Layer Views for Guru Data in APOS Live Data Gateway
Use the CData Connector for Guru in APOS Live Data Gateway to build Semantic Layer Views for Guru data.
-
Using the CData Software ODBC Driver for ConvertAPI in PyCharm
Connect to ConvertAPI as an ODBC data source in PyCharm using the CData Software ODBC Driver for ConvertAPI.
-
Connect to Act CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Act CRM data using standard SQL.
-
How to Build an ETL App for SageHR Data in Python with CData Connect AI
Extract and transform live SageHR data in Python with petl and the CData Connect AI Python SDK.