CData Software - Knowledge Base
Recent Articles
-
How to Visualize GetResponse 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 GetResponse data in Python.
-
Back Up Zoho Inventory data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Zoho Inventory. In this article, we will employ an SSIS workflow to populate a database with Zoho Inventory data data.
-
Access Live Dynamics NAV Data in AWS Lambda
Connect to live Dynamics NAV data in AWS Lambda using the CData JDBC Driver.
-
Model, Search, and Visualize Live ServiceNow Data in ThoughtSpot
Use CData Connect AI to connect to live ServiceNow data for modeling, searching, and visualizing.
-
Publish Reports with SAP SuccessFactors Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP SuccessFactors data.
-
Use Databricks Agent Bricks to Talk to Your GetResponse Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your GetResponse data for you.
-
Analyze Azure DevOps Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Azure DevOps data with the CData JDBC Driver for Azure DevOps.
-
Getting Started with the CData Tableau Connector for PabblySubscriptions
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Connect to ZohoMarketingHub Data from a Connection Pool in JBoss
Integrate ZohoMarketingHub data into Java servlets: Use the Management Console in JBoss to install the ZohoMarketingHub JDBC Driver.
-
Analyze Qualaroo Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Qualaroo from Power Pivot. You will use the Table Import Wizard to load Qualaroo data. You can visually build the import query or use any SQL supported by the driver.
-
How to Connect Marketo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Marketo data in real time using natural language.
-
Replicate ZohoInvoice Data to Multiple Databases via the CData Sync CLI
Replicate ZohoInvoice data to disparate databases with a single configuration.
-
Connect to Hubstaff Data in Aqua Data Studio
Access Hubstaff data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Sage 300 Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Sage 300 data from Filemaker Pro on Mac.
-
Getting Started with the CData Python Connector for Quaderno
Learn to install and license the CData Python Connector and configure a connection to live Quaderno data.
-
Build Dashboards with Phoenix Data in DBxtra
Create dynamic dashboards and perform analytics based on Phoenix data in DBxtra.
-
Use JayDeBeApi to access Salesforce Pardot Data in Python
Use standard Python scripting and the development environment of your choice to access live Salesforce Pardot data.
-
Connect to Intercom Data in DBArtisan
Use wizards in DBArtisan to configure Intercom data as a data source.
-
Migrating data from Facebook to Google BigQuery using CData SSIS Components.
Easily push Facebook data to Google BigQuery using the CData SSIS Tasks for Facebook and Google BigQuery.
-
Create Datasets from Tanda in Domo Workbench and Build Visualizations of Tanda Data in Domo
Use the CData Software ODBC Driver for Tanda to create datasets from Tanda data in Domo Workbench and then build visualizations in the Domo service.
-
Use the CData Software ODBC Driver for Microsoft Teams in MicroStrategy Desktop
Connect to Microsoft Teams data in MicroStrategy Desktop using the CData Software ODBC Driver for Microsoft Teams.
-
Build Dashboards with SparkPost Data in Dundas BI
Create dynamic dashboards and perform analytics based on SparkPost data in Dundas BI.
-
Build Gmail-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Gmail data.
-
Access Live Act CRM Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Act CRM data from your Excel spreadsheets.
-
Visualize Moosend Data in TIBCO Spotfire through ADO.NET
Integrate Moosend data into dashboards in TIBCO Spotfire.
-
Connect AI Guide: Derived Views, Saved Queries, and Custom Reports
A basic guide to creating Derived Views, Saved Queries, and Custom Reports in Connect AI.
-
How to create an RPA flow for Instagram Data in UiPath Studio
Use the Instagram ODBC Driver to create workflows that access real-time Instagram data without any coding.
-
Connect to Discord Data in CloverDX (formerly CloverETL)
Transfer Discord data using the visual workflow in the CloverDX data integration tool.
-
How to create Brex federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Brex data in MySQL .
-
How to connect to Flowlu Data in DBVisualizer
Integrate Flowlu data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build FreshBooks Visualizations in Tableau Desktop
Use CData Connect AI to connect to live FreshBooks data and build visualizations in Tableau.
-
Analyze MySQL Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of MySQL data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Getting Started with the CData Python Connector for Amazon DynamoDB
Learn to install and license the CData Python Connector and configure a connection to live Amazon DynamoDB data.
-
Use the CData Software JDBC Driver for Adobe Target in MicroStrategy Desktop
Connect to Adobe Target data in MicroStrategy Desktop using the CData Software JDBC Driver for Adobe Target.
-
Integrate PolarTeamPro Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live PolarTeamPro data from Informatica Cloud.
-
Connect to Airtable Data in Jaspersoft Studio
Execute SQL to remote Airtable data in Jaspersoft Studio.
-
Create SAS xpt-Connected Nintex Workflows
Use CData Connect AI to connect to SAS xpt Data from Nintex Workflow Cloud and build custom workflows using live SAS xpt data.
-
ZohoPeople Reporting in OBIEE with the ZohoPeople JDBC Driver
Deploy the ZohoPeople JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating Clari Data in Talend Cloud Data Management Platform
Connect Clari Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Analyze Freshteam Data in Cognos Analytics
Use CData Connect AI to connect to Freshteam Data from Cognos Analytics and analyze live Freshteam data.
-
Publish Reports with MailerLite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date MailerLite data.
-
Getting Started with the CData Power BI Connector for SendPulse
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Choosing the Best Method to Connect Google Spanner to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Google Spanner data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Connect Bannerbear Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Bannerbear data in real time using natural language.
-
Query ActiveCampaign Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume ActiveCampaign entities in PHP by modeling them as objects.
-
Connect to Azure Synapse Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Azure Synapse.
-
Establish a Live Connection with SAP Business One Data using Tableau Bridge
The CData ODBC Driver for SAP Business One enables you to integrate live SAP Business One data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to create MessageBird federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MessageBird data in MySQL .
-
How to Query Live Klipfolio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Klipfolio data data in natural language using Python.
-
Connect to Wistia Data from PowerBuilder via JDBC
This article demonstrates how to access Wistia data from PowerBuilder using the Wistia JDBC Driver.
-
Use the CData ODBC Driver for Pushbullet in Microsoft Power Query
You can use the CData Pushbullet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Pushbullet data into Microsoft Power Query.
-
Configure the CData JDBC Driver for Discord in a Connection Pool in Tomcat
Connect to Discord data from a connection pool in Tomcat.
-
Automated Continuous Float Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Float replication to AlloyDB.
-
Use Databricks Agent Bricks to Talk to Your Toggl Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Toggl data for you.
-
Query, Visualize, and Share live Wistia Data in Redash
Use CData Connect AI to connect to live Wistia data in Redash for querying, visualizing, and sharing.
-
Connect to Azure Table Data in DBArtisan
Use wizards in DBArtisan to configure Azure Table data as a data source.
-
Work with Live EnterpriseDB Data in Power Query
Use CData Connect AI to connect to EnterpriseDB data and work with live EnterpriseDB data in Microsoft Power Query.
-
Build BigCommerce-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live BigCommerce data.
-
Integrating Codex with Parallel 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 with Xero Data in JReport Designer
Create charts and reports based on Xero data in JReport Designer.
-
Connect to Real-Time Foursquare Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Foursquare data in Power Apps.
-
How to Seamlessly Import AgileCRM Data into IBM SPSS Modeler
Integrate AgileCRM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Bridge LinkedIn Ads Connectivity with Apache NiFi
Access and process LinkedIn Ads data in Apache NiFi using the CData JDBC Driver.
-
Integrate Cline with Live Amazon S3 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Amazon S3 data from within your IDE.
-
Connecting Moonlit Workflow with Zoho Inventory Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Zoho Inventory data in real time.
-
Automate MYOB AccountRight Data Replication to Azure Data Lake
Use CData Sync to customize and automate MYOB AccountRight data replication to Azure Data Lake.
-
Automated Continuous DocuSign Replication to AlloyDB
Use CData Sync for automated, continuous, customizable DocuSign replication to AlloyDB.
-
How to load Vault CRM data into Elasticsearch via Logstash
Introducing a simple method to load Vault CRM data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to Salesforce CRM Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce CRM Analytics and the SQL Gateway to access Salesforce CRM Analytics data from Google Apps Script.
-
Connect to Cohere Data in NetBeans
Connect to Cohere data in NetBeans with the data source configuration wizard.
-
Provide OData Services of Aweber Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Aweber data by developing a WCF Service Application.
-
Use the CData Software ODBC Driver for Stack Exchange in MicroStrategy Web
Connect to Stack Exchange data in MicroStrategy Web using the CData Software ODBC Driver for Stack Exchange.
-
Query Instagram Data as a SQL Server Database in Node.js
Execute SQL Server queries against Instagram data from Node.js.
-
Build Visualizations of QuickBooks Online Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of QuickBooks Online data in Birst.
-
Access SurveyMonkey Data from MySQL in PHP
Connect to SurveyMonkey through the standard MySQL libraries in PHP.
-
Integrate Open WebUI with Live SparkPost Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SparkPost data from within the chat interface.
-
Create Reckon Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Reckon from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Omnisend Replication to SingleStore
Use CData Sync for automated, continuous, customizable Omnisend replication to SingleStore.
-
Integrating OpenCode with CSV 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 LibreChat with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Oracle Financials Cloud data from within the chat interface.
-
How to Connect to & Open Salesforce CRM Analytics Data in Microsoft Excel
This article uses the CData ODBC driver for Salesforce CRM Analytics to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect and Visualize Live Outreach.io Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Outreach.io data into the Databricks platform and create visualization dashboards with real-time Outreach.io data.
-
Connect to Cassandra Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Cassandra and the SQL Gateway to access Cassandra data from Google Apps Script.
-
Create Dynamic ZohoSubscriptions Grids Using the Infragistics XamDataGrid
Learn how you can connect ZohoSubscriptions to Infragistics XamDataGrid to build dynamic grids.
-
How to Access Live VWO Data in Power Automate Desktop via ODBC
The CData ODBC Driver for VWO enables you to integrate VWO data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous BambooHR Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable BambooHR replication to delimited files (CSV/TSV).
-
Integrate with Live Snowflake Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Snowflake from the MuleSoft Anypoint Platform to integrate live Snowflake data into custom reports and dashboards.
-
Integrate with Live GraphQL Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from the MuleSoft Anypoint Platform to integrate live GraphQL data into custom reports and dashboards.
-
Integrate with live QuickBooks Time Data in Jitterbit
Use CData Connect AI to connect to and integrate live QuickBooks Time data in Jitterbit.
-
Import Real-Time Autopilot Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Autopilot data in ColdFusion.
-
Connect to Greenplum Data in RazorSQL
Connect to Greenplum from wizards and query Greenplum data from the GUI in the RazorSQL database management tool.
-
Integrate Phoenix Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Phoenix data and integrate live Phoenix data into your Power Automate tasks.
-
Integrate Cursor with Live WooCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live WooCommerce data from within the editor.
-
Zoho Creator Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Creator facts in real time.
-
How to Visualize Slack 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 Slack data in Python.
-
Create Google Analytics-Connected Applications in Appsmith
Connect to Google Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Analytics data.
-
Build Zoho Inventory-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Zoho Inventory Data and create custom apps in Mendix.
-
Automated Continuous Drip Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Drip replication to Azure SQL Database.
-
Automate ZohoDesk Data Replication to Couchbase
Use CData Sync to Customize and automate ZohoDesk data replication to Couchbase.
-
Stream WordPress Data into Apache Kafka Topics
Access and stream WordPress data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.