CData Software - Knowledge Base
Recent Articles
-
Build Pinterest-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Pinterest data.
-
Stream Quaderno Data into Apache Kafka Topics
Access and stream Quaderno data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Analyze Certinia Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Certinia from Power Pivot. You will use the Table Import Wizard to load Certinia data. You can visually build the import query or use any SQL supported by the driver.
-
Integrate Certinia Data in Pentaho Data Integration
Build ETL pipelines based on Certinia data in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with SAP HANA Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP HANA data.
-
View Reports on Real-Time DB2 Data in Power BI Report Server
Use the CData ODBC Driver for DB2 to visualize DB2 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Antigravity CLI with Close data via CData CLI
Connect Close data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to integrate Metabase with Salesforce Marketing Data
Use CData Connect AI to connect to live Salesforce Marketing data and create an interactive dashboard in Metabase from Salesforce Marketing data.
-
Use the CData Software JDBC Driver for Redis in MicroStrategy Desktop
Connect to Redis data in MicroStrategy Desktop using the CData Software JDBC Driver for Redis.
-
How to publish and share Mouseflow Data dashboards with Tableau Server
The CData ODBC driver for Mouseflow enables you integrate Mouseflow data into Tableau dashboards.
-
Automated Continuous SAP BusinessObjects BI Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to Vertica.
-
Write a Simple Go Application to work with Splunk Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Splunk data.
-
Build Pipelines with Live Vertica Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Vertica from Google Cloud Data Fusion, enabling the integration of live Vertica data into the building and management of effective data pipelines.
-
Access Live MailChimp Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live MailChimp data through MCP integration.
-
Connect to CircleCI Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to CircleCI and work with CircleCI data in your FileMaker applications.
-
Query eBay Data as a SQL Server Database in Node.js
Execute SQL Server queries against eBay data from Node.js.
-
Extract, Transform, and Load Productboard Data in Informatica PowerCenter
Create a simple Workflow for Productboard data in Informatica PowerCenter.
-
Automated Continuous Bannerbear Replication to MySQL
Use CData Sync for automated, continuous, customizable Bannerbear replication to MySQL.
-
Build Slack Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Slack data and build visualizations in Tableau Cloud.
-
How to connect to Short.io Data from IntelliJ
Integrate connectivity to Short.io data with wizards in IntelliJ.
-
Model, Search, and Visualize Live HDFS Data in ThoughtSpot
Use CData Connect AI to connect to live HDFS data for modeling, searching, and visualizing.
-
Create Mode-Connected Applications in Appsmith
Connect to Mode Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Mode data.
-
Getting Started with the CData ADO.NET Provider for Superchat
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to ClickUp Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time ClickUp data using standard SQL.
-
How to update SFTP from Excel
This article explains how to transfer data from Excel to SFTP using the Excel Add-In for SFTP.
-
Query, Visualize, and Share live Freshdesk Data in Redash
Use CData Connect AI to connect to live Freshdesk data in Redash for querying, visualizing, and sharing.
-
How to Easily Query Browserless Data in OpenOffice Base
Connect to Browserless data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Access CockroachDB 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 CockroachDB data.
-
Publish RSS-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live RSS feeds.
-
How to Connect JSON Services to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live JSON data in real time using natural language.
-
Create Dynamic Landbot Grids Using the Infragistics XamDataGrid
Learn how you can connect Landbot to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to Cassandra Data from IntelliJ
Integrate connectivity to Cassandra data with wizards in IntelliJ.
-
ETL Rebilly in Oracle Data Integrator
This article shows how to transfer Rebilly data into a data warehouse using Oracle Data Integrator.
-
Connect to Oracle HCM Cloud Data in DBeaver
Use the CData ODBC Driver to connect to Oracle HCM Cloud data in DBeaver.
-
Connect to ConvertAPI Data from a Connection Pool in JBoss
Integrate ConvertAPI data into Java servlets: Use the Management Console in JBoss to install the ConvertAPI JDBC Driver.
-
Getting Started with the CData JDBC Driver for Guru
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Guru.
-
Model, Search, and Visualize Live Xero Data in ThoughtSpot
Use CData Connect AI to connect to live Xero data for modeling, searching, and visualizing.
-
How to integrate Email with Apache Airflow
Access and process Email data in Apache Airflow using the CData JDBC Driver.
-
Migrating data from Hubstaff to Google BigQuery using CData SSIS Components.
Easily push Hubstaff data to Google BigQuery using the CData SSIS Tasks for Hubstaff and Google BigQuery.
-
Connect to and Visualize Live Epicor Kinetic Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Epicor Kinetic data.
-
Replicate Deel Data to Multiple Databases
Replicate Deel data to disparate databases with a point-and-click configuration.
-
Connect to eBay Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for eBay data in Airbyte.
-
Build Semantic Layer Views for IBM Informix Data in APOS Live Data Gateway
Use the CData Connector for IBM Informix in APOS Live Data Gateway to build Semantic Layer Views for IBM Informix data.
-
Connect to Microsoft Exchange Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Exchange data from PowerBuilder using the Microsoft Exchange JDBC Driver.
-
How to create an RPA flow for Drip Data in UiPath Studio
Use the Drip ODBC Driver to create workflows that access real-time Drip data without any coding.
-
Build Voice Agents in ElevenLabs with access to Live MariaDB Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live MariaDB data.
-
Replicate Nuclia Data in Heroku for Use in Salesforce Connect
Replicate Nuclia data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Work with Sage 200 Data in FoxPro
Load Sage 200 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software JDBC Driver for Suadeo in MicroStrategy Web
Connect to Suadeo data in MicroStrategy Web using the CData Software JDBC Driver for Suadeo.
-
How to Connect to Live eBay Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your eBay data for you.
-
Access SuiteCRM Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live SuiteCRM data from HeidiSQL.
-
Access Tanda 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 Tanda data.
-
Build Charts with ElevenLabs Data in Clear Analytics
Create dynamic charts and perform analytics based on ElevenLabs data in Clear Analytics.
-
Connect to Microsoft Entra ID Data in RapidMiner
Integrate Microsoft Entra ID data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connecting GenSpark with Workday Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Workday data without any replication or custom integration required.
-
Build Dashboards with SAP Business One Data in DBxtra
Create dynamic dashboards and perform analytics based on SAP Business One data in DBxtra.
-
Access Live Clio Data in Coginiti Pro
Connect to and query live Clio data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Build an OLAP Cube in SSAS from Teamwork Data
Establish a connection to Teamwork data data from SQL Server Analysis Services, and use the Teamwork Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to QuickBooks Time Data in NetBeans
Connect to QuickBooks Time data in NetBeans with the data source configuration wizard.
-
Import SAP Ariba Source Data Using Azure Data Factory
Use CData Connect AI to connect to SAP Ariba Source Data from Azure Data Factory and import live SAP Ariba Source data.
-
How to Visualize Act-On 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 Act-On data in Python.
-
Automate MYOB AccountRight Data Replication to SAP HANA
Use CData Sync to customize and automate MYOB AccountRight data replication to SAP HANA.
-
Rapidly Develop Wave Financial-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 Wave Financial.
-
How to Connect to & Open Highrise Data in Microsoft Excel
This article uses the CData ODBC driver for Highrise to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Building Dynamic Web Pages with QuickBooks Online Data Using AngularJS
Create single-page applications with live connectivity to QuickBooks Online using the CData API Server.
-
How to Connect the Power BI Service to Certinia: Complete Guide
Connect to the CData Software Power BI Connector for Certinia from PowerBI.com to provide real-time Certinia data across the organization.
-
Connect to GitHub Data as an External Source in Dremio
Use the CData JDBC Driver to connect to GitHub as an External Source in Dremio.
-
Using the CData Software ODBC Driver for Facebook in PyCharm
Connect to Facebook as an ODBC data source in PyCharm using the CData Software ODBC Driver for Facebook.
-
Choosing the Best Method to Connect Beeminder to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Beeminder data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Automated Continuous Retently Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Retently replication to Amazon Redshift.
-
How to Connect to Freshteam Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Freshteam data. Leverage the pyodbc module for ODBC in Python.
-
Build Semantic Layer Views for Azure Analysis Services Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Analysis Services data.
-
Connect to Microsoft Dataverse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Microsoft Dataverse and the SQL Gateway to access Microsoft Dataverse data from Google Apps Script.
-
How to Query SAP Data in MySQL Workbench
Execute MySQL queries against live SAP data from MySQL Workbench.
-
Model, Search, and Visualize Live SAP Concur Data in ThoughtSpot
Use CData Connect AI to connect to live SAP Concur data for modeling, searching, and visualizing.
-
Access Live Zuora Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zuora data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Connect to Nuclia Data from PowerBuilder via ADO.NET
This article demonstrates how to access Nuclia data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Link Tanda with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Tanda data in Filemaker Pro for Mac or Windows.
-
How to Access Live JobNimbus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for JobNimbus enables you to integrate JobNimbus data into workflows built using Microsoft Power Automate Desktop.
-
How to Connect to Live Google Calendar Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Google Calendar data for you.
-
Use Dash to Build Web Apps on Discord Data via CData Connect AI
Build interactive Dash web apps on live Discord data using pandas and the CData Connect AI Python SDK.
-
Build Automated Workflows with Live Adobe Target Data in Workato
Use CData Connect AI to connect to live Adobe Target data and build automated workflows in Workato.
-
Moving Data from Perigon to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Perigon data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Automated Continuous Google Spanner Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Spanner replication to SingleStore.
-
Getting Started with the CData SSIS Components for Discourse
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Discourse.
-
Visualize WooCommerce Data in Sisense
Create an ElastiCube in Sisense app with access to WooCommerce data.
-
Automated Continuous Salesforce Marketing Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Salesforce Marketing replication to Amazon S3.
-
Integrate Dify with Live iContact Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live iContact data.
-
How to connect Amazon QuickSight to Redis Data
Create a connection to Redis data in CData Connect AI and insert Redis data into Amazon QuickSight SPICE to build interactive dashboards.
-
Working with BigCommerce Data in LINQPad
Execute LINQ queries to BigCommerce data in LINQPad.
-
Getting Started with the CData ADO.NET Provider for FormSite
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Automated Continuous Excel Online Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Excel Online replication to delimited files (CSV/TSV).
-
Visualize MailChimp Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MailChimp data.
-
Access Live PostgreSQL Data in Coginiti Pro
Connect to and query live PostgreSQL data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Visualize Live SuiteCRM Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SuiteCRM data into custom reports in Power BI.
-
Create Freshdesk-Connected Applications in Appsmith
Connect to Freshdesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Freshdesk data.
-
Connect to ZendeskSell Data in RazorSQL
Connect to ZendeskSell from wizards and query ZendeskSell data from the GUI in the RazorSQL database management tool.
-
Replicate Rebilly Data to Multiple Databases
Replicate Rebilly data to disparate databases with a point-and-click configuration.
-
Connect to Hubstaff Data in NetBeans
Connect to Hubstaff data in NetBeans with the data source configuration wizard.
-
Access Live Amazon Marketplace Data in TIBCO Data Virtualization
Use the Amazon Marketplace Tibco DV Adapter to create a Amazon Marketplace data data source in TIBCO Data Virtualization Studio and gain access to live Amazon Marketplace data from your TDV Server.