CData Software - Knowledge Base
Recent Articles
-
Perform Batch Operations with Elasticsearch Data in Apache NiFi
Connect to Elasticsearch data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for SuiteCRM
Learn to install and license the CData Python Connector and configure a connection to live SuiteCRM data.
-
Connect to and Query HubDB Data in QlikView over ODBC
Create data visualizations with HubDB data in QlikView.
-
A PostgreSQL Interface for LinkedIn Ads Data using the CData ODBC Driver
Use the SQL Gateway and LinkedIn Ads ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect Tableau to REST APIs Using the CData API Driver for Tableau
Learn how to connect Tableau to any REST API and build live visualizations using the CData API Driver for Tableau and a prebuilt API Profile.
-
Connecting GenSpark with Zendesk Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Zendesk data without any replication or custom integration required.
-
How to Query Access Data in MySQL Workbench
Execute MySQL queries against live Access data from MySQL Workbench.
-
Getting Started with the CData Excel Add-In for HubSpot
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HubSpot.
-
Build an OLAP Cube in SSAS from Freshsales Data
Establish a connection to Freshsales data data from SQL Server Analysis Services, and use the Freshsales Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connecting Agentforce with Sybase IQ Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Sybase IQ data for you.
-
Build Egnyte-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 Egnyte data without replication.
-
Use CData Connect AI to Access Basecamp Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Basecamp data in the Power Pivot business intelligence tool.
-
Natively Connect to Tally Data in PHP
The CData ODBC driver for Tally enables you to create PHP applications with connectivity to Tally data. Leverage the native support for ODBC in PHP.
-
Automated Continuous Dynamics CRM Replication to SQLite
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to SQLite.
-
Analyze Google Contacts Data in Looker
Use CData Connect AI to connect to Google Contacts Data from Looker and build custom apps using live Google Contacts data.
-
Visualize Live Kintone Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Kintone data.
-
Connect to Humanity Data from a Connection Pool in JBoss
Integrate Humanity data into Java servlets: Use the Management Console in JBoss to install the Humanity JDBC Driver.
-
Interact with Live Oracle HCM Cloud Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Oracle HCM Cloud data.
-
Bidirectional Access to Greenplum Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Greenplum data in Filemaker Pro for Mac or Windows.
-
Feed MessageBird Data into FineReport
How to set MessageBird data as a JDBC data source in FineReport.
-
A PostgreSQL Interface for Factorial Data using the CData ODBC Driver
Use the SQL Gateway and Factorial ODBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Antigravity CLI with Zendesk data via CData CLI
Connect Zendesk data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of Amplitude Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Amplitude data by developing a WCF Service Application.
-
How to update Sugar CRM from Excel
This article explains how to transfer data from Excel to Sugar CRM using the Excel Add-In for Sugar CRM.
-
Analyze Moosend Data in Cognos Analytics
Use CData Connect AI to connect to Moosend Data from Cognos Analytics and analyze live Moosend data.
-
How to Easily Query Unbounce Data in OpenOffice Base
Connect to Unbounce data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Connect to QuickBooks Time Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for QuickBooks Time data in the Denodo Virtual DataPort Administrator.
-
Query Close Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Close data from Node.js.
-
Integrate Open WebUI with Live Pipedrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Pipedrive data from within the chat interface.
-
Configure the CData JDBC Driver for Bright Data in a Connection Pool in Tomcat
Connect to Bright Data data from a connection pool in Tomcat.
-
Connect to Harvest in SpagoBI
Create reports featuring live Harvest data in SpagoBI Studio. Host Harvest reports on SpagoBI Server.
-
Connect to Act CRM from Asprova with CData Software ODBC Driver for Act CRM
This article shows how to connect faster to Act CRM data from Asprova.
-
Connect to Tally Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Tally data.
-
Import Amazon S3 Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Amazon S3 Data and provide access to live Amazon S3 data for custom reports in the Power BI Service.
-
Add ServiceDesk Plus Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ServiceDesk Plus with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrate SAP BusinessObjects BI Data in the Pentaho Report Designer
Publish reports based on SAP BusinessObjects BI data in the Pentaho BI tool.
-
Use Biml to Build SSIS Tasks to Replicate Greenhouse Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Greenhouse data to SQL Server.
-
Prepare, Blend, and Analyze VWO Data in Alteryx Designer (Connect AI)
Build workflows to access live VWO data for self-service data analytics.
-
Natively Connect to Epicor Kinetic Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Epicor Kinetic data. Leverage the native support for ODBC in PHP.
-
Connect Procore to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Procore data using the CData Python MCP Server.
-
How to work with Reply.io Data in Apache Spark using SQL
Access and process Reply.io Data in Apache Spark using the CData Software JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Pingdom Data
Use CData Power BI Connectors to visualize Pingdom data in Power BI.
-
Automated Continuous LaunchDarkly Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Apache Kafka.
-
Add Parallel Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Parallel with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Pipelines with Live DocuSign Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to DocuSign from Google Cloud Data Fusion, enabling the integration of live DocuSign data into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for PolarTeamPro in Microsoft Power Query
You can use the CData PolarTeamPro ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import PolarTeamPro data into Microsoft Power Query.
-
Model, Search, and Visualize Live Oracle Sales Data in ThoughtSpot
Use CData Connect AI to connect to live Oracle Sales data for modeling, searching, and visualizing.
-
Visualize Shortcut Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Shortcut data into TIBCO Spotfire.
-
Natively Connect to Invoiced Data in PHP
The CData ODBC driver for Invoiced enables you to create PHP applications with connectivity to Invoiced data. Leverage the native support for ODBC in PHP.
-
Access Microsoft Dataverse Data from MySQL in Amazon QuickSight
Connect to Microsoft Dataverse and build visualizations of Microsoft Dataverse data using a MySQL Connection in Amazon QuickSight.
-
Prepare, Blend, and Analyze Amazon S3 Data in Alteryx Designer (Connect AI)
Build workflows to access live Amazon S3 data for self-service data analytics.
-
Access Live Azure Synapse Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Azure Synapse data from your Excel spreadsheets.
-
Create a Data Access Object for SAP Ariba Procurement Data using JDBI
A brief overview of creating a SQL Object API for SAP Ariba Procurement data in JDBI.
-
Bidirectional Access to Act CRM Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Act CRM data in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time SAP HANA Data in Power BI Report Server
Use the CData ODBC Driver for SAP HANA to visualize SAP HANA data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Live Sentry Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Sentry data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to connect to Google Sheets Data in DBVisualizer
Integrate Google Sheets data with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrating Antigravity CLI with Tickspot data via CData CLI
Connect Tickspot data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Multiple Reckon Accounts Hosted Accounts
Replicate multiple Reckon Accounts Hosted accounts to one or many databases.
-
Connect to LinkedIn Data in RazorSQL
Connect to LinkedIn from wizards and query LinkedIn data from the GUI in the RazorSQL database management tool.
-
Integrate Cursor with Live SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live SAP SuccessFactors data from within the editor.
-
Use Dash to Build to Web Apps on Oracle Sales Data
Create Python applications that use pandas and Dash to build Oracle Sales-connected web apps.
-
Extract, Transform, and Load JSON Services in Informatica PowerCenter
Create a simple Workflow for JSON services in Informatica PowerCenter.
-
Connect to Presto Data in Google Apps Script via Connect AI
Use CData Connect AI to access Presto data in Google Apps Script.
-
Integrate Google Drive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Drive data and integrate live Google Drive data into your Power Automate tasks.
-
Create Informatica Mappings From/To an ODBC Data Source for Cassandra
Create an ODBC connection to Cassandra in Informatica and browse and transfer Cassandra data.
-
How to load NASA data into Elasticsearch via Logstash
Introducing a simple method to load NASA data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Power BI Connector for Authorize.Net
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Authorize.Net.
-
Access Autopilot Data from MySQL in Amazon QuickSight
Connect to Autopilot and build visualizations of Autopilot data using a MySQL Connection in Amazon QuickSight.
-
Create a Data Access Object for Oracle SCM Data using JDBI
A brief overview of creating a SQL Object API for Oracle SCM data in JDBI.
-
Connect to Perigon Data in RazorSQL
Connect to Perigon from wizards and query Perigon data from the GUI in the RazorSQL database management tool.
-
Easily Integrate Zoho Recruit Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Recruit data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Semantic Layer Views for Reply.io Data in APOS Live Data Gateway
Use the CData Connector for Reply.io in APOS Live Data Gateway to build Semantic Layer Views for Reply.io data.
-
Connect to MailerLite Data in Google Apps Script via Connect AI
Use CData Connect AI to access MailerLite data in Google Apps Script.
-
Access Live Salesforce Marketing Data in Excel 365 Online (Excel for the web)
Connect to Salesforce Marketing data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Analyze Reckon Accounts Hosted Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Reckon Accounts Hosted data and visualize Reckon Accounts Hosted data in SAP Analytics Cloud.
-
Use Databricks Agent Bricks to Talk to Your HubDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your HubDB data for you.
-
Integrate Browserless Data in the Pentaho Report Designer
Publish reports based on Browserless data in the Pentaho BI tool.
-
Connect CircleCI to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect CircleCI with IBM WebSphere for seamless data integration and connectivity.
-
Build NetSuite-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live NetSuite data and build NetSuite-connected web apps with Axios.
-
Trigger TaxJar IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for TaxJar with standard wizards in Logic Apps.
-
Query QuickBooks Data in DataGrip
Create a Data Source for QuickBooks in DataGrip and use SQL to query live QuickBooks data.
-
Access Live Paymo Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Paymo data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Replicate Multiple Neo4J Accounts
Replicate multiple Neo4J accounts to one or many databases.
-
Access OnePageCrm Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live OnePageCrm data from HeidiSQL.
-
Build Apps with Live Dynamics 365 Business Central Data Using the Low-Code Development Platform of Mendix
Connect Dynamics 365 Business Central data with Mendix to build apps using the CData JDBC Driver for Dynamics 365 Business Central.
-
Use Databricks Agent Bricks to Talk to Your MariaDB Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your MariaDB data for you.
-
Integrate with live Adobe Analytics Data in Jitterbit
Use CData Connect AI to connect to and integrate live Adobe Analytics data in Jitterbit.
-
Automated Continuous SendInBlue Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SendInBlue replication to Azure SQL Database.
-
How to connect to Lakebase Data with Squirrel SQL client
Connect to Lakebase data and execute queries in the Squirrel SQL Client.
-
How to connect to Timely Data from IntelliJ
Integrate connectivity to Timely data with wizards in IntelliJ.
-
Connect to Bullhorn CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Bullhorn CRM and the SQL Gateway to access Bullhorn CRM data from Google Apps Script.
-
Visualize PhantomBuster Data in Sisense
Create an ElastiCube in Sisense app with access to PhantomBuster data.
-
Build Data Flows from VWO to SQL Server using SSIS
Easily back up VWO data to SQL Server using the SSIS components for VWO.
-
How to create an RPA flow for ShipStation Data in UiPath Studio
Use the ShipStation ODBC Driver to create workflows that access real-time ShipStation data without any coding.
-
Use Microsoft Copilot Studio to talk to your Paylocity 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 Paylocity data for you.
-
Connect to Facebook Ads Data from HeidiSQL
Use CData Connect AI to connect to and query live Facebook Ads data from HeidiSQL.
-
Analyze MySQL Data in Cognos Analytics
Use CData Connect AI to connect to MySQL Data from Cognos Analytics and analyze live MySQL data.
-
Use CData Connect AI to Access Phoenix Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Phoenix data in the Power Pivot business intelligence tool.
-
Automated Continuous Splunk Replication to SingleStore
Use CData Sync for automated, continuous, customizable Splunk replication to SingleStore.