CData Software - Knowledge Base
Recent Articles
-
Connect Demio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Demio with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Live Oracle SCM Data in MicroStrategy through CData Connect AI
Create a live connection to Oracle SCM Data in CData Connect AI and connect to your Oracle SCM from MicroStrategy.
-
How to Connect to Live Acumatica 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 Acumatica ERP for you.
-
Connect to Live FreshBooks Data in PostGresSQL Interface through CData Connect AI
Create a live connection to FreshBooks in CData Connect AI and connect to your FreshBooks from PostgreSQL.
-
Replicate Oracle Eloqua Data to Multiple Databases via the CData Sync CLI
Replicate Oracle Eloqua to disparate databases with a single configuration.
-
How to Connect to Live Google Contacts 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 Google Contacts for you.
-
Connect to Real-Time Copper Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Copper in Power Apps.
-
Prepare, Blend, and Analyze Kintone Data in Alteryx Designer (Connect AI)
Build workflows to access live Kintone for self-service data analytics.
-
How to connect to Airtable Data from Spring Boot
Connect to Airtable in a Spring Boot Application using the CData JDBC Driver for Airtable
-
How to Build an ETL App for Dynamics NAV Data in Python with CData
Create ETL applications and real-time data pipelines for Microsoft Dynamics NAV in Python with petl.
-
Use Dash to Build to Web Apps on IBM Cloud Object Storage Data
Create Python applications that use pandas and Dash to build IBM Cloud Object Storage-connected web apps.
-
How to Use a Microsoft Access Database to Update YouTube Analytics Data in Real Time
Update YouTube Analytics data by creating a linked table in Microsoft Access with the CData YouTube Analytics ODBC Driver.
-
Use the CData Software ODBC Driver for Testmonitor in MicroStrategy
Connect to Testmonitor in MicroStrategy Developer using the CData Software ODBC Driver for Testmonitor.
-
Automate Adobe Analytics Data Replication to Azure Synapse
Use CData Sync to customize and automate Adobe Analytics replication to Azure Synapse.
-
Visualize Azure Synapse Data in TIBCO Spotfire through ADO.NET
Integrate Azure Synapse into dashboards in TIBCO Spotfire.
-
Automated Continuous SendInBlue Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable SendInBlue replication to Google BigQuery.
-
Write a Simple Go Application to work with Redis Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Redis.
-
Visualize Zoom Data in TIBCO Spotfire through ADO.NET
Integrate Zoom into dashboards in TIBCO Spotfire.
-
How to Connect to Live MarkLogic 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 MarkLogic for you.
-
Visualize Pinterest Data in TIBCO Spotfire through ADO.NET
Integrate Pinterest into dashboards in TIBCO Spotfire.
-
Getting Started with the CData SSIS Components for Coinbase
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Coinbase.
-
Visualize Sage Intacct Data in TIBCO Spotfire through OData
Integrate Sage Intacct into dashboards in TIBCO Spotfire.
-
Connect to Paddle from Asprova with CData Software ODBC Driver for Paddle
This article shows how to connect faster to Paddle data from Asprova.
-
Access Live Confluence Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Confluence data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Establish a Live Connection with Beeminder Data using Tableau Bridge
The CData ODBC Driver for Beeminder enables you to integrate live Beeminder into Tableau Cloud dashboards using the Tableau Bridge.
-
Build a Singer.io Tap for Amazon Marketplace With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Amazon Marketplace data using
-
Create Dynamic ClickUp Grids Using the Infragistics XamDataGrid
Learn how you can connect ClickUp to Infragistics XamDataGrid to build dynamic grids.
-
Migrating data from Rebilly to Databricks using CData SSIS Components.
Easily push Rebilly to Databricks using the CData SSIS Tasks for Rebilly and Databricks.
-
Build a Simple VCL Application for SAP Business Warehouse Data
How to build a simple VCL Application to view SAP Business Warehouse in RAD Studio using the CData ODBC Driver for SAP Business Warehouse.
-
Consume Bullhorn CRM OData Feeds in PowerBuilder
This article demonstrates how to consume Bullhorn CRM as OData feeds from PowerBuilder using the API Server.
-
Build AI/ML Models with Live LinkedIn Data using Dataiku
Connect LinkedIn Data with Dataiku using the CData JDBC Driver for LinkedIn.
-
Connect Confluence Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Atlassian Confluence using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Automated Continuous QuickBooks Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable QuickBooks replication to Google BigQuery.
-
LINQ to Sybase Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Sybase Data Provider.
-
Connect to and Visualize Live Cvent Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Cvent.
-
Visualize ZohoDesk Data in TIBCO Spotfire through ADO.NET
Integrate ZohoDesk into dashboards in TIBCO Spotfire.
-
Connect Guru to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Guru using the CData Python MCP Server.
-
Create Reports from Excel Online Data in Looker Studio
Use CData Connect AI to gain access to live Microsoft Excel Online and create custom reports in Looker Studio.
-
Analyze DB2 Data in Cognos Analytics
Use CData Connect AI to connect to DB2 Data from Cognos Analytics and analyze live IBM DB2.
-
Connect to Instagram Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Instagram.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Sybase IQ using the Model Context Protocol.
-
Build Charts with Redshift Data in Clear Analytics
Create dynamic charts and perform analytics based on Amazon Redshift in Clear Analytics.
-
Edit and Search Azure Table External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure Table Storage to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure Table objects that you can access from apps and the dashboard.
-
DataBind Controls to FHIR Data in C++Builder
DataBind to FHIR in C++Builder with standard components and controls.
-
Publish Reports with Teamgate Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Teamgate.
-
Access MYOB AccountRight Data from MySQL in PHP
Connect to MYOB AccountRight through the standard MySQL libraries in PHP.
-
How to create an RPA flow for Confluence Data in UiPath Studio
Use the Confluence ODBC Driver to create workflows that access real-time Atlassian Confluence without any coding.
-
How to create an RPA flow for DB2 Data in UiPath Studio
Use the DB2 ODBC Driver to create workflows that access real-time IBM DB2 without any coding.
-
Visualize Sage 200 Data in Tableau
The CData ODBC driver for Sage 200 enables you integrate Sage 200 into Tableau dashboards.
-
Visualize Live eBay Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live eBay Analytics using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live Stripe Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Stripe through natural language.
-
How to connect Amazon QuickSight to JSON Services
Create a connection to JSON in CData Connect AI and insert JSON into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Biml to Build SSIS Tasks to Replicate Workday Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Workday to SQL Server.
-
How to Connect Databricks 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 Databricks data in real time using natural language.
-
Back Up LinkedIn Ads to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for LinkedIn Ads. In this article, we will employ an SSIS workflow to populate a database with LinkedIn Ads data.
-
Getting Started with the CData Excel Add-In for Google Directory
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Google Directory.
-
Integrate LibreChat with Live Amazon Marketplace Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Amazon Marketplace from within the chat interface.
-
Integrate with Spark Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Apache Spark SQL in SnapLogic.
-
Publish Reports with SQL Analysis Services Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SQL Analysis Services.
-
Use the CData API Server to Access Oracle Eloqua Data in Microsoft PowerPivot
Use the CData API Server to connect to live Oracle Eloqua in the Power Pivot business intelligence tool.
-
Access Instagram Data from MySQL in Amazon QuickSight
Connect to Instagram and build visualizations of Instagram using a MySQL Connection in Amazon QuickSight.
-
How to Visualize Cvent 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 Cvent in Python.
-
Connect to Cvent Data in Aqua Data Studio
Access Cvent from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Access Pingdom Data from MySQL in Amazon QuickSight
Connect to Pingdom and build visualizations of Pingdom using a MySQL Connection in Amazon QuickSight.
-
Integrate Cline with Live HubSpot Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live HubSpot from within your IDE.
-
Connect to Asana Data in Google Apps Script via Connect AI
Use CData Connect AI to access Asana in Google Apps Script.
-
How to connect to SAS Data Sets Data with Squirrel SQL client
Connect to SAS Data Sets and execute queries in the Squirrel SQL Client.
-
Use the CData ODBC Driver for NetSuite in Microsoft Power Query
You can use the CData NetSuite ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import NetSuite CRM & ERP into Microsoft Power Query.
-
Use the CData ODBC Driver for Smartsheet in Microsoft Power Query
You can use the CData Smartsheet ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Smartsheet into Microsoft Power Query.
-
Automated Continuous JSON Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable JSON replication to Google BigQuery.
-
Replicate Eventbrite Data to Multiple Databases
Replicate Eventbrite to disparate databases with a point-and-click configuration.
-
Connect Google Campaign Manager 360 to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Google Campaign Manager 360 with IBM WebSphere for seamless data integration and connectivity.
-
How to connect to ConvertKit Data in DBVisualizer
Integrate ConvertKit with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Informatica Mappings From/To an ODBC Data Source for Salesforce Pardot
Create an ODBC connection to Salesforce Pardot in Informatica and browse and transfer Salesforce Pardot.
-
Model Zoho CRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoho CRM, enabling the direct import of real-time Zoho CRM.
-
Import Google Ads Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Google Ads Data and provide access to live Google Ads for custom reports in the Power BI Service.
-
Build a Simple VCL Application for Salesforce Pardot Data
How to build a simple VCL Application to view Salesforce Pardot in RAD Studio using the CData ODBC Driver for Salesforce Pardot.
-
Build Data Flows from MariaDB to SQL Server using SSIS
Easily back up MariaDB to SQL Server using the SSIS components for MariaDB.
-
Natively Connect to Typeform Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Typeform. Leverage the native support for ODBC in PHP.
-
Automate CData Connect AI Data Replication to Azure Data Lake
Use CData Sync to customize and automate CData Connect AI replication to Azure Data Lake.
-
Natively Connect to Gorgias Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Gorgias. Leverage the native support for ODBC in PHP.
-
Visualize Microsoft Exchange Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Exchange.
-
Easily Integrate Microsoft Entra ID Data in Lazarus Pascal IDE
Learn how to easily integrate live Microsoft Entra ID in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Sage 300 Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sage 300 from PowerShell? This article demonstrates how to utilize the Sage 300 Cmdlets for tasks like connecting to Sage 300, automating operations, downloading data, and more.
-
Natively Connect to SharePoint Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Microsoft SharePoint. Leverage the native support for ODBC in PHP.
-
Prepare, Blend, and Analyze Webex Data in Alteryx Designer (ODBC)
Build workflows to access live Webex for self-service data analytics.
-
Create GetResponse Dataflows on PowerBI.com
Connect to the CData Power BI Connector for GetResponse from PowerBI.com to create Power BI Dataflows with real-time data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for MessageBird
Provide connectivity to MessageBird through an SAP BusinessObjects universe.
-
Process & Analyze Quaderno Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Quaderno Data.
-
Use the CData Software JDBC Driver for Chargebee in MicroStrategy
Connect to Chargebee in MicroStrategy Developer using the CData Software JDBC Driver for Chargebee.
-
Build HCL Domino-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for HCL Domino Data and create custom apps in Mendix.
-
Use JayDeBeApi to access ADP Data in Python
Use standard Python scripting and the development environment of your choice to access live ADP.
-
Query Dynamics CRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Dynamics CRM and perform CRUD operations on Dynamics CRM from Node.js.
-
Publish Crystal Reports on SharePoint Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft SharePoint.
-
Viewing Flowlu Data in RAD Studio Data Explorer
How to view Flowlu in RAD Studio Data Explorer using the CData ODBC Driver for Flowlu.
-
How to connect to Gmail Data with Squirrel SQL client
Connect to Gmail and execute queries in the Squirrel SQL Client.
-
Start and Stop Windows Services Using the CData Excel Add-In for PowerShell
Share and organize scripts, start and stop services, and create system reports from within Excel.
-
How to Connect to Microsoft OneDrive Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft OneDrive. Leverage the pyodbc module for ODBC in Python.
-
Build Semantic Layer Views for PabblySubscriptions Data in APOS Live Data Gateway
Use the CData Connector for PabblySubscriptions in APOS Live Data Gateway to build Semantic Layer Views for PabblySubscriptions.
-
How to Build an ETL App for Aircall Data in Python with CData
Create ETL applications and real-time data pipelines for Aircall in Python with petl.