CData Software - Knowledge Base
Recent Articles
-
Build Pipelines with Live Spark Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Spark from Google Cloud Data Fusion, enabling the integration of live Spark data into the building and management of effective data pipelines.
-
Connect to Printify Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Printify and the SQL Gateway to access Printify data from Google Apps Script.
-
Building Dynamic Web Pages with BigQuery Data Using AngularJS
Create single-page applications with live connectivity to BigQuery using the CData API Server.
-
Use the CData Software JDBC Driver for Moosend in MicroStrategy Desktop
Connect to Moosend data in MicroStrategy Desktop using the CData Software JDBC Driver for Moosend.
-
Visualize Intercom Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Intercom data.
-
Analyze Hubstaff Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hubstaff data in Microsoft R Open.
-
DataBind Controls to Freshdesk Data in Delphi
DataBind to Freshdesk data in Delphi with standard data access components and controls.
-
Connect to Gong from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Gong data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Import Azure Data Catalog Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Data Catalog Data from Azure Data Factory and import live Azure Data Catalog data.
-
Use the CData Software ODBC Driver for Mode in MicroStrategy Web
Connect to Mode data in MicroStrategy Web using the CData Software ODBC Driver for Mode.
-
Choosing the Best Method to Connect Azure Data Catalog to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Azure Data Catalog data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for ZeroBounce in MicroStrategy Web
Connect to ZeroBounce data in MicroStrategy Web using the CData Software ODBC Driver for ZeroBounce.
-
Build an OLAP Cube in SSAS from ClickTime Data
Establish a connection to ClickTime data data from SQL Server Analysis Services, and use the ClickTime Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Live Bullhorn CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Bullhorn CRM data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate LibreChat with Live Microsoft Entra ID Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Entra ID data from within the chat interface.
-
Integrate MailChimp Data in Pentaho Data Integration
Build ETL pipelines based on MailChimp data in the Pentaho Data Integration tool.
-
Create SAP BusinessObjects BI-Connected Business Apps in AppSheet
Connect to SAP BusinessObjects BI Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP BusinessObjects BI data.
-
Use Manus AI to Talk to Your Shippo 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 Shippo data.
-
Trigger CouchDB IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for CouchDB with standard wizards in Logic Apps.
-
Seamlessly Bring Paylocity Data into Retool Using CData Connect AI
Integrate Paylocity data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Connect to & Open ZohoSubscriptions Data in Microsoft Excel
This article uses the CData ODBC driver for ZohoSubscriptions to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create Dynamic Bitbucket Grids Using the Infragistics XamDataGrid
Learn how you can connect Bitbucket to Infragistics XamDataGrid to build dynamic grids.
-
Access Live DB2 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live DB2 data from your Excel spreadsheets.
-
How to Work with SparkPost Data in AWS Glue Jobs Using JDBC
Connect to SparkPost from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Query Lakebase Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Lakebase entities in PHP by modeling them as objects.
-
Connect Basecamp to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Basecamp data using the CData Python MCP Server.
-
Create SurveyMonkey-Connected Business Apps in AppSheet
Connect to SurveyMonkey Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SurveyMonkey data.
-
Automated Continuous Amazon DynamoDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to IBM DB2.
-
Add ShipEngine Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ShipEngine with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Connect to Live SAP Business One Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your SAP Business One data for you.
-
Explore Geographical Relationships in Todoist Data with Power Map
Create data visualizations with Todoist data in Power Map.
-
Integrating Boomi Agentstudio with Excel Online Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Excel Online data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Connect to Microsoft Teams Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft Teams data from Appeon PowerBuilder using the CData ADO.NET Provider for Microsoft Teams.
-
Connect to Parquet Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Parquet and the SQL Gateway to access Parquet data from Google Apps Script.
-
Automated Continuous SAP Business One Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Business One replication to Snowflake.
-
Use ChatGPT to Talk to Your Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Snapchat Ads data for you.
-
How to Query Live ConstantContact Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ConstantContact data data in natural language using Python.
-
Getting Started with the CData Power BI Connector for Facebook Ads
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Facebook Ads.
-
Automated Continuous Helpscout Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Helpscout replication to delimited files (CSV/TSV).
-
Analyze Live Oracle Eloqua Data in SAS Viya
Use CData Connect AI to connect to Oracle Eloqua data from SAS Viya and deploy self-service analytics using live Oracle Eloqua data.
-
View Reports on Real-Time Shortcut Data in Power BI Report Server
Use the CData ODBC Driver for Shortcut to visualize Shortcut data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Active Directory Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Active Directory and the Script function in FileMaker Pro to connect to Active Directory and work with Active Directory data in your FileMaker application.
-
Integrating Dataiku with Asana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Asana data.
-
Model, Search, and Visualize Live SAP BusinessObjects BI Data in ThoughtSpot
Use CData Connect AI to connect to live SAP BusinessObjects BI data for modeling, searching, and visualizing.
-
Create ActiveCampaign-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ActiveCampaign Data from Klipfolio and build custom visualizations using live ActiveCampaign data.
-
Connect and Query Live eBay Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live eBay data into Databricks and enable direct, live querying and analysis without replication.
-
How to connect and process Facebook data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Facebook data.
-
Connect Recurly to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Recurly with IBM WebSphere for seamless data integration and connectivity.
-
How to use SQLAlchemy ORM to access Neo4J Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Neo4J data.
-
Provide OData Services of Front Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Front data by developing a WCF Service Application.
-
Moving Data from BenchmarkEmail to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live BenchmarkEmail data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Write a Simple Go Application to work with Cosmos DB Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cosmos DB data.
-
How to Visualize GitLab Data in Python with pandas
Use pandas and other modules to analyze and visualize live GitLab data in Python.
-
How to connect to Apify Data with Squirrel SQL client
Connect to Apify data and execute queries in the Squirrel SQL Client.
-
Automate Apollo Data Replication to Azure Data Lake
Use CData Sync to customize and automate Apollo data replication to Azure Data Lake.
-
Consume Google Drive OData Feeds in PowerBuilder
This article demonstrates how to consume Google Drive data as OData feeds from PowerBuilder using the API Server.
-
Connect to Factorial Data in Jaspersoft Studio
Execute SQL to remote Factorial data in Jaspersoft Studio.
-
Build a Singer.io Tap for SendPulse With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendPulse data using the CData Python Connector.
-
Getting Started with the CData Excel Add-In for Freshservice
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Freshservice.
-
How to integrate PDFMonkey with Apache Airflow
Access and process PDFMonkey data in Apache Airflow using the CData JDBC Driver.
-
Access Live Mocean Data in AWS Lambda
Connect to live Mocean data in AWS Lambda using the CData JDBC Driver.
-
Query HCL Domino Data as a SQL Server Database in Node.js
Execute SQL Server queries against HCL Domino data from Node.js.
-
Use the CData Software JDBC Driver for SageHR in MicroStrategy
Connect to SageHR data in MicroStrategy Developer using the CData Software JDBC Driver for SageHR.
-
Use Manus AI to Talk to Your GitHub 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 GitHub data.
-
Connecting Agentforce with OData Services 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 OData services for you.
-
Getting Started with the CData ODBC Driver for Shippo
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Shippo.
-
How to connect to Couchbase Data with Squirrel SQL client
Connect to Couchbase data and execute queries in the Squirrel SQL Client.
-
How to connect to MongoDB Data with Squirrel SQL client
Connect to MongoDB data and execute queries in the Squirrel SQL Client.
-
Replicate Basecamp Data in Heroku for Use in Salesforce Connect
Replicate Basecamp data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Redshift Data in JRuby
Create a simple JRuby app with access to live Redshift data.
-
Manage Timely Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Timely.
-
How to Access Live Dynamics 365 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Dynamics 365 enables you to integrate Dynamics 365 data into workflows built using Microsoft Power Automate Desktop.
-
Establish a Live Connection with Pingdom Data using Tableau Bridge
The CData ODBC Driver for Pingdom enables you to integrate live Pingdom data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use Manus AI to Talk to Your Teradata 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 Teradata data.
-
Connect to ZendeskSell 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 ZendeskSell and work with ZendeskSell data in your FileMaker application.
-
How to connect to SAP BusinessObjects BI Data with Squirrel SQL client
Connect to SAP BusinessObjects BI data and execute queries in the Squirrel SQL Client.
-
How to Query Mouseflow Data in MySQL Workbench
Execute MySQL queries against live Mouseflow data from MySQL Workbench.
-
Access LinkedIn Data from MySQL in PHP
Connect to LinkedIn through the standard MySQL libraries in PHP.
-
Migrating data from ScrapingBee to Snowflake using CData SSIS Components.
Easily push ScrapingBee data to Snowflake using the CData SSIS Tasks for ScrapingBee and Snowflake.
-
Build a Singer.io Tap for SAP Business One With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAP Business One data using the CData Python Connector.
-
Integrate Ontraport with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Ontraport with External Services.
-
Connect to Google Tasks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Google Tasks data using standard SQL.
-
Analyze Live SingleStore Data in SAS Viya
Use CData Connect AI to connect to SingleStore data from SAS Viya and deploy self-service analytics using live SingleStore data.
-
How to Visualize Harvest Data in Python with pandas
Use pandas and other modules to analyze and visualize live Harvest data in Python.
-
Build QuickBooks Time-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for QuickBooks Time Data and create custom apps in Bubble.
-
Replicate Multiple Figshare Accounts via the CData Sync CLI
Replicate multiple Figshare accounts to one or many databases.
-
Use the CData ODBC Driver for BenchmarkEmail in Microsoft Power Query
You can use the CData BenchmarkEmail ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import BenchmarkEmail data into Microsoft Power Query.
-
Connecting Agentforce with Okta 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 Okta data for you.
-
Configure the CData JDBC Driver for SAP Hybris C4C in a Connection Pool in Tomcat
Connect to SAP Hybris C4C data from a connection pool in Tomcat.
-
Build Agents in Relevance AI with Access to Live SAP ByDesign Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on SAP ByDesign data within intelligent agent workflows.
-
Connect to QuickBooks Data in RapidMiner
Integrate QuickBooks data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Databricks Data in Jaspersoft Studio
Execute SQL to remote Databricks data in Jaspersoft Studio.
-
Easily Integrate Zuora Data in Lazarus Pascal IDE
Learn how to easily integrate live Zuora data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Back Up Aha! data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Aha! data data.
-
Access Azure Table Data from MySQL in PHP
Connect to Azure Table through the standard MySQL libraries in PHP.
-
Create AlloyDB-Connected Nintex Workflows
Use CData Connect AI to connect to AlloyDB Data from Nintex Workflow Cloud and build custom workflows using live AlloyDB data.
-
Integrate Live Tanda Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Tanda data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Connect to Amazon DynamoDB Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Amazon DynamoDB data from Filemaker Pro on Mac.
-
How to Connect DBeaver to Salesloft via a JDBC Driver
Manage Salesloft data with visual tools in DBeaver like the query browser.
-
Query TaxJar Data in ColdFusion
Write standard ColdFusion data access code to connect to TaxJar data.