CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Mailjet Data
Create Python applications that use pandas and Dash to build Mailjet-connected web apps.
-
Automated Continuous Adobe Analytics Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Google Cloud SQL.
-
Automated Continuous SurveyMonkey Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SurveyMonkey replication to Apache Cassandra.
-
Build Semantic Layer Views for Azure Data Catalog Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Azure Data Catalog data.
-
Build a Singer.io Tap for HelloSign With the CData Python Connector
Learn how to easily build a Singer.io Tap for live HelloSign data using the CData Python Connector.
-
Replicate Multiple Excel Accounts via the CData Sync CLI
Replicate multiple Excel accounts to one or many databases.
-
Build Workday-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Workday data and build Workday-connected web apps with Axios.
-
Connect and Query Live Google Contacts Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Contacts data into Databricks and enable direct, live querying and analysis without replication.
-
ETL Teamwork in Oracle Data Integrator
This article shows how to transfer Teamwork data into a data warehouse using Oracle Data Integrator.
-
Connect to Live HBase Data in MicroStrategy through CData Connect AI
Create a live connection to HBase Data in CData Connect AI and connect to your HBase data from MicroStrategy.
-
Automated Continuous Yelp Replication to SQLite
Use CData Sync for automated, continuous, customizable Yelp replication to SQLite.
-
Automated Continuous ScrapingBee Replication to SQL Server
Use CData Sync for automated, continuous, customizable ScrapingBee replication to SQL Server.
-
Access Quickbase Data from MySQL in PHP
Connect to Quickbase through the standard MySQL libraries in PHP.
-
Bridge Chargebee Connectivity with Apache NiFi
Access and process Chargebee data in Apache NiFi using the CData JDBC Driver.
-
Provide OData Services of Google Sheets Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Sheets data by developing a WCF Service Application.
-
Connect to SharePoint Data in RapidMiner
Integrate SharePoint data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous Exa Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Exa replication to AlloyDB.
-
Design BIRT Reports on Adobe Analytics Data
Provide current Adobe Analytics data to your embedded analytics.
-
Connect to HCL Domino Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HCL Domino and the SQL Gateway to access HCL Domino data from Google Apps Script.
-
Analyze Oracle Sales Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Sales from Power Pivot. You will use the Table Import Wizard to load Oracle Sales data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Workday Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Workday Data and connect to Workday data in Akorbi Digital RunMyProcess.
-
Getting Started with the CData Python Connector for Salesforce Pardot
Learn to install and license the CData Python Connector and configure a connection to live Salesforce Pardot data.
-
Work with Cvent Data in FoxPro
Load Cvent data into a FoxPro database. This article includes full code and a walk-through of the process.
-
A PostgreSQL Interface for SAP Business One Data using the CData ODBC Driver
Use the SQL Gateway and SAP Business One ODBC Driver to create a PostgreSQL entry-point for data access.
-
MariaDB Reporting in OBIEE with the MariaDB JDBC Driver
Deploy the MariaDB JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software ODBC Driver for Google Campaign Manager 360 in MicroStrategy Desktop
Connect to Google Campaign Manager 360 data in MicroStrategy Desktop using the CData Software ODBC Driver for Google Campaign Manager 360.
-
Viewing Oracle Eloqua Data in RAD Studio Data Explorer
How to view Oracle Eloqua data in RAD Studio Data Explorer using the CData ODBC Driver for Oracle Eloqua.
-
Query Live JSON Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live JSON services through a conversational interface.
-
Operational Reporting on Toggl Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Toggl data.
-
Working with Greenhouse Data in LINQPad
Execute LINQ queries to Greenhouse data in LINQPad.
-
Use Claude to Talk to Your HBase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your HBase data for you.
-
How to Visualize Quickbase Data in Python with pandas
Use pandas and other modules to analyze and visualize live Quickbase data in Python.
-
How to publish and share Neo4J Data dashboards with Tableau Server
The CData ODBC driver for Neo4J enables you integrate Neo4J data into Tableau dashboards.
-
Connect to ShipEngine Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ShipEngine Data and connect to ShipEngine data in Akorbi Digital RunMyProcess.
-
Choosing the Best Method to Connect Kintone to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Kintone data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate with Miro Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Miro data to a JSON file on disk.
-
Access Live Google Directory Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Directory data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Directory data in the Graph Builder and Query Builder.
-
Connecting Mastra with Freshteam Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Freshteam data, no replication required.
-
Automated Continuous Basecamp Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Basecamp replication to delimited files (CSV/TSV).
-
Building Dynamic Web Pages with Kintone Data Using AngularJS
Create single-page applications with live connectivity to Kintone using the CData API Server.
-
Creating Adobe Experience Manager-Connected Applications in Unqork
You can use CData Connect AI to feed Adobe Experience Manager data to Unqork and build custom business apps.
-
Build a Singer.io Tap for Klaviyo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Klaviyo data using the CData Python Connector.
-
Integrate Cvent Data in Pentaho Data Integration
Build ETL pipelines based on Cvent data in the Pentaho Data Integration tool.
-
Publish Reports with SAP ByDesign Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP ByDesign data.
-
Query HubSpot Data in DataGrip
Create a Data Source for HubSpot in DataGrip and use SQL to query live HubSpot data.
-
Use Agno to Talk to Your Hive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Hive data for you.
-
Create Informatica Mappings From/To a JDBC Data Source for GetResponse
Create GetResponse data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Access Strava Data from MySQL in Amazon QuickSight
Connect to Strava and build visualizations of Strava data using a MySQL Connection in Amazon QuickSight.
-
Query Everhour Data as a MySQL Database in Node.js
Execute MySQL queries against Everhour data from Node.js.
-
Connect to Bullhorn CRM Data in NetBeans
Connect to Bullhorn CRM data in NetBeans with the data source configuration wizard.
-
Access Live Sage Cloud Accounting Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live Sage Cloud Accounting data through MCP integration.
-
Interact with Live Acumatica Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Acumatica data.
-
Integrating Claude Code with SAP Business One Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on SAP Business One data within assisted coding and automated development workflows.
-
Automated Continuous Gong Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Gong data replication to OneLake in Microsoft Fabric.
-
Manage Snowflake Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Snowflake.
-
How to publish and share Excel Data dashboards with Tableau Server
The CData ODBC driver for Excel enables you integrate Excel data into Tableau dashboards.
-
Create Power BI Reports on Real-Time Klaviyo Data
Use the CData ODBC Driver for Klaviyo to visualize Klaviyo data in Power BI Desktop.
-
Connect to Splunk Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Splunk data in Airbyte.
-
Create Sugar CRM-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sugar CRM Data from OutSystems and build custom enterprise apps using live Sugar CRM data.
-
Connect to Sage Intacct Data in CloverDX (formerly CloverETL)
Transfer Sage Intacct data using the visual workflow in the CloverDX data integration tool.
-
Build Charts with Superchat Data in Clear Analytics
Create dynamic charts and perform analytics based on Superchat data in Clear Analytics.
-
Query WordPress Data in ColdFusion
Write standard ColdFusion data access code to connect to WordPress data.
-
Build Automated Workflows with Live SAP Business Warehouse Data in Workato
Use CData Connect AI to connect to live SAP Business Warehouse data and build automated workflows in Workato.
-
Use the CData Software ODBC Driver for Procore in MicroStrategy
Connect to Procore data in MicroStrategy Developer using the CData Software ODBC Driver for Procore.
-
How to connect and process SAP Ariba Procurement data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SAP Ariba Procurement data.
-
Connect to NetSuite SuiteAnalytics Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live NetSuite SuiteAnalytics data.
-
Publish GetResponse-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live GetResponse data.
-
Use Dash to Build Web Apps on Omnisend Data via CData Connect AI
Build interactive Dash web apps on live Omnisend data using pandas and the CData Connect AI Python SDK.
-
Use the CData Software ODBC Driver for Pinecone in SAS for Real-Time Reporting and Analytics
Connect to real-time Pinecone data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Pinecone.
-
View Reports on Real-Time Microsoft Entra ID Data in Power BI Report Server
Use the CData ODBC Driver for Microsoft Entra ID to visualize Microsoft Entra ID data in Power BI Desktop and then publish them to Power BI Report Server.
-
Publish Reports with Supabase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Supabase data.
-
Build Adobe Analytics-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Adobe Analytics data.
-
Integrate Cline with Live SAP Ariba Procurement Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SAP Ariba Procurement data from within your IDE.
-
Create Reckon-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Reckon Data from OutSystems and build custom enterprise apps using live Reckon data.
-
Integrate with live Jira Data in Jitterbit
Use CData Connect AI to connect to and integrate live Jira data in Jitterbit.
-
How to create Visio diagrams from Snowflake Data
Automatically update Snowflake data with the changes you make to Visio master shapes.
-
Integrate Azure Synapse Data in Pentaho Data Integration
Build ETL pipelines based on Azure Synapse data in the Pentaho Data Integration tool.
-
Create Data Visualizations in Cognos BI with Klipfolio Data
Access Klipfolio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate with ServiceDesk Plus Data in JReport Designer
Create charts and reports based on ServiceDesk Plus data in JReport Designer.
-
Use Agno to Talk to Your LDAP Objects via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your LDAP objects for you.
-
Connect to SQL Server Data from a Connection Pool in JBoss
Integrate SQL Server data into Java servlets: Use the Management Console in JBoss to install the SQL Server JDBC Driver.
-
Seamlessly Bring MarkLogic Data into Retool Using CData Connect AI
Integrate MarkLogic data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
How to Access Google Tasks Data Using Entity Framework
This article shows how to access Google Tasks data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
LINQ to MariaDB 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 MariaDB Data Provider.
-
Use CData Connect AI to Access SAP ByDesign Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SAP ByDesign data in the Power Pivot business intelligence tool.
-
Create Dynamic Xero Grids Using the Infragistics XamDataGrid
Learn how you can connect Xero to Infragistics XamDataGrid to build dynamic grids.
-
Trigger MySQL IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for MySQL with standard wizards in Logic Apps.
-
Create YouTube Analytics-Connected Applications in Appsmith
Connect to YouTube Analytics Data via CData Connect AI in Appsmith and create custom business applications with real-time access to YouTube Analytics data.
-
Integrate Google's Antigravity Agent with Live Bannerbear Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Bannerbear data using the Model Context Protocol.
-
How to Query LinkedIn Data in MySQL Workbench
Execute MySQL queries against live LinkedIn data from MySQL Workbench.
-
Using the CData Software ODBC Driver for HubDB in PyCharm
Connect to HubDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for HubDB.
-
Access Vault CRM Data from MySQL in PHP
Connect to Vault CRM through the standard MySQL libraries in PHP.
-
Building Dynamic Web Pages with Adobe Analytics Data Using AngularJS
Create single-page applications with live connectivity to Adobe Analytics using the CData API Server.
-
Access Live Authorize.Net Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Authorize.Net data into the statistical analysis tools available in SAS JMP. This article shows how to use Authorize.Net data in the Graph Builder and Query Builder.
-
Integrating Productboard Data in Talend Cloud Data Management Platform
Connect Productboard Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Create Data Visualizations in Cognos BI with Google Analytics Data
Access Google Analytics data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Build MVC Applications with Connectivity to SharePoint Excel Services Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SharePoint Excel Services from an ASP.NET MVC application.
-
Use Dash to Build to Web Apps on RabbitMQ Data
Create Python applications that use pandas and Dash to build RabbitMQ-connected web apps.
-
Build Basecamp-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Basecamp data and build Basecamp-connected web apps with Axios.
-
Explore Geographical Relationships in Paylocity Data with Power Map
Create data visualizations with Paylocity data in Power Map.