CData Software - Knowledge Base
Recent Articles
-
Connect to Pipeliner CRM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Pipeliner CRM using standard SQL.
-
Automate Amazon Marketplace Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon Marketplace replication to Azure Data Lake.
-
How to Build an ETL App for SharePoint Excel Services Data in Python with CData
Create ETL applications and real-time data pipelines for SharePoint Excel Services in Python with petl.
-
Automated Continuous Adobe Analytics Replication to Snowflake
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Snowflake.
-
Access Live Zendesk Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Zendesk in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Analyze Avalara AvaTax Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Avalara AvaTax from Power Pivot. You will use the Table Import Wizard to load Avalara AvaTax. You can visually build the import query or use any SQL supported by the driver.
-
Query Google Cloud Storage Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Google Cloud Storage and perform CRUD operations on Google Cloud Storage from Node.js.
-
Use Biml to Build SSIS Tasks to Replicate Odoo Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Odoo ERP to SQL Server.
-
Connect to Figshare Data from PowerBuilder via ADO.NET
This article demonstrates how to access Figshare from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Automated Continuous Sybase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sybase replication to Amazon Redshift.
-
Connect to Sage 200 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Sage 200, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Stripe Data in Claris FileMaker Pro
Use the CData ODBC Driver for Stripe in FileMaker Pro to connect to Stripe and work with Stripe in your FileMaker applications.
-
Prepare, Blend, and Analyze Sybase IQ Data in Alteryx Designer (Connect AI)
Build workflows to access live Sybase IQ for self-service data analytics.
-
Model Square Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Square, enabling the direct import of real-time Square.
-
Integrate Mistral AI Data in the Pentaho Report Designer
Publish reports based on Mistral AI in the Pentaho BI tool.
-
Access Helpscout Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Helpscout from your Oracle system.
-
Automated Continuous Pingdom Replication to MySQL
Use CData Sync for automated, continuous, customizable Pingdom replication to MySQL.
-
Analyze Monday.com Data in Cognos Analytics
Use CData Connect AI to connect to Monday.com Data from Cognos Analytics and analyze live Monday.com.
-
Create Datasets from NASA in Domo Workbench and Build Visualizations of NASA Data in Domo
Use the CData Software ODBC Driver for NASA to create datasets from NASA in Domo Workbench and then build visualizations in the Domo service.
-
Feed Salesloft Data into FineReport
How to set Salesloft as a JDBC data source in FineReport.
-
Connect to Reply.io Data from a Connection Pool in JBoss
Integrate Reply.io into Java servlets: Use the Management Console in JBoss to install the Reply.io JDBC Driver.
-
Access Live Kafka Data in AWS Lambda
Connect to live Apache Kafka in AWS Lambda using the CData JDBC Driver.
-
Build a Singer.io Tap for Shippo With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Shippo data using
-
A PostgreSQL Interface for Hugging Face Data using the CData ODBC Driver
Use the SQL Gateway and Hugging Face ODBC Driver to create a PostgreSQL entry-point for data access.
-
Load Vault CRM Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Veeva Vault & Vault CRM to a database.
-
Integrate Live DocuSign Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live DocuSign to Blue Prism using the CData ODBC Driver for DocuSign to create automated workflows for repetitive business tasks.
-
Integrate Cohere with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Cohere with External Services.
-
Use the CData ODBC Driver for ScrapingBee from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ScrapingBee to connect to ScrapingBee from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ScrapingBee in Excel.
-
Integrating Claude Code CLI with ZohoMarketingHub 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.
-
Build Visualizations of ZarMoney Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of ZarMoney in Birst.
-
Connect to SAP SuccessFactors LMS Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP SuccessFactors LMS.
-
Seamlessly Bring MariaDB Data into Retool Using CData Connect AI
Integrate MariaDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect SageHR to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SageHR with IBM WebSphere for seamless data integration and connectivity.
-
Connect to ConvertAPI Data in CloverDX (formerly CloverETL)
Transfer ConvertAPI using the visual workflow in the CloverDX data integration tool.
-
Create Vault CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Vault CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Real-Time Workday Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Workday and Dataflow to import and use Workday in Power Apps.
-
Connect to SendGrid Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SendGrid.
-
Connecting Moonlit Workflow with SQL Server 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 Microsoft SQL Server in real time.
-
Access Live DB2 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate IBM DB2 into the statistical analysis tools available in SAS JMP. This article shows how to use IBM DB2 in the Graph Builder and Query Builder.
-
Build AI/ML Models with Live Monday.com Data using Dataiku
Connect Monday.com Data with Dataiku using the CData JDBC Driver for Monday.com.
-
Back Up Klipfolio 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 Klipfolio data.
-
Automated Continuous Microsoft Entra ID Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Entra ID replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for LinkedIn Ads in MicroStrategy Desktop
Connect to LinkedIn Ads in MicroStrategy Desktop using the CData Software JDBC Driver for LinkedIn Ads.
-
Operational Reporting on Coinbase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Coinbase.
-
Automate Timely Data Replication to Azure Data Lake
Use CData Sync to customize and automate Timely replication to Azure Data Lake.
-
Seamlessly Bring Blackbaud FE NXT Data into Retool Using CData Connect AI
Integrate Blackbaud FE NXT data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Oracle HCM Cloud Data in DataGrip
Create a Data Source for Oracle HCM Cloud in DataGrip and use SQL to query live Oracle HCM Cloud.
-
Use JayDeBeApi to access Nethunt Data in Python
Use standard Python scripting and the development environment of your choice to access live Nethunt.
-
Load Factorial Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Factorial to a database.
-
Create Avro-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Avro Data from OutSystems and build custom enterprise apps using live Apache Avro.
-
Automate Jumpseller Data Replication to Azure Synapse
Use CData Sync to customize and automate Jumpseller replication to Azure Synapse.
-
Integrate LaunchDarkly Data in Pentaho Data Integration
Build ETL pipelines based on LaunchDarkly in the Pentaho Data Integration tool.
-
Creating LinkedIn-Connected Applications in Unqork
You can use CData Connect AI to feed LinkedIn to Unqork and build custom business apps.
-
Build Zoho Books-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Zoho Books to explore live Zoho Books Data in GitHub Copilot to assist with building Zoho Books-powered applications.
-
Work with Stack Exchange Data in FoxPro
Load Stack Exchange into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use Claude to Talk to Your ADP 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 ADP for you.
-
How to Connect to Live Elasticsearch Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Elasticsearch for you.
-
Integrate Live Dynamics 365 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Microsoft Dynamics 365 and integrate live Microsoft Dynamics 365 into apps built in Microsoft Power Apps.
-
Use the CData Software JDBC Driver for Salesforce CRM Analytics in MicroStrategy Web
Connect to Salesforce CRM Analytics in MicroStrategy Web using the CData Software JDBC Driver for Salesforce CRM Analytics.
-
A PostgreSQL Interface for Marketo Data (MySQL Remoting via JDBC)
Use the Remoting features of the Marketo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Visualize Wave Financial 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 Wave Financial into TIBCO Spotfire.
-
Amazon DynamoDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Amazon DynamoDB through CData Connect AI using different applications and tools.
-
Use the CData ODBC Driver for Recurly in Microsoft Power Query
You can use the CData Recurly ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Recurly into Microsoft Power Query.
-
Automated Continuous ADP Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable ADP replication to Amazon Redshift.
-
How to create an RPA flow for CampaignMonitor Data in UiPath Studio
Use the CampaignMonitor ODBC Driver to create workflows that access real-time CampaignMonitor without any coding.
-
Create Data Visualizations in Cognos BI with Insightly Data
Access Insightly as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ActiveCampaign Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for ActiveCampaign Data and connect to ActiveCampaign in Akorbi Digital RunMyProcess.
-
Zoho Inventory Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Zoho Inventory facts in real time.
-
How to Query Placid Data in MySQL Workbench
Execute MySQL queries against live Placid from MySQL Workbench.
-
Operational Reporting on Lakebase Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Lakebase.
-
How to connect Amazon QuickSight to ShipStation Data
Create a connection to ShipStation in CData Connect AI and insert ShipStation into Amazon QuickSight SPICE to build interactive dashboards.
-
How to Easily Query Twitter Ads Data in OpenOffice Base
Connect to Twitter Ads data in OpenOffice Base using the CData ODBC Driver for Twitter Ads and generate reports with live data insights.
-
Build Voice Agents in ElevenLabs with access to Live Paylocity Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Paylocity.
-
How to connect to Salesforce Data 360 Data in DBVisualizer
Integrate Salesforce Data 360 with visual data analysis tools and data connection wizards in DBVisualizer
-
XML Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on XML facts in real time.
-
Operational Reporting on Sage Intacct Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Sage Intacct.
-
Integrating LlamaIndex with Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Freshdesk in real time.
-
View Reports on Real-Time Beeminder Data in Power BI Report Server
Use the CData ODBC Driver for Beeminder to visualize Beeminder in Power BI Desktop and then publish them to Power BI Report Server.
-
Analyze Mocean Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Mocean from Power Pivot. You will use the Table Import Wizard to load Mocean. You can visually build the import query or use any SQL supported by the driver.
-
Automate MailChimp Data Replication to Azure Data Lake
Use CData Sync to customize and automate MailChimp replication to Azure Data Lake.
-
Create Highrise-Connected Dashboards in Grafana
Connect to Highrise Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Highrise CRM.
-
Connect to and Query Qualaroo Data in QlikView over ODBC
Create data visualizations with Qualaroo in QlikView.
-
Access Live Eventbrite Data in Coginiti Pro
Connect to and query live Eventbrite from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Explore Geographical Relationships in PostgreSQL Data with Power Map
Create data visualizations with PostgreSQL in Power Map.
-
Build Apps with Live FHIR Data Using the Low-Code Development Platform of Mendix
Connect FHIR with Mendix to build apps using the CData JDBC Driver for FHIR.
-
Integrate Foursquare with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Foursquare with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Foursquare.
-
Create Dynamic Oracle HCM Cloud Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle HCM Cloud to Infragistics XamDataGrid to build dynamic grids.
-
How to create an RPA flow for Greenplum Data in UiPath Studio
Use the Greenplum ODBC Driver to create workflows that access real-time Pivotal GreenPlum without any coding.
-
Enable the Square JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Square.
-
Automate AlloyDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google AlloyDB replication to Azure Data Lake.
-
Creating Freshdesk-Connected Applications in Unqork
You can use CData Connect AI to feed Freshdesk to Unqork and build custom business apps.
-
How to connect and process MarkLogic from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live MarkLogic.
-
Connect to iContact Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for iContact.
-
Build Dashboards with PabblySubscriptions Data in DBxtra
Create dynamic dashboards and perform analytics based on PabblySubscriptions in DBxtra.
-
Integrate with live PayPal Data in Jitterbit
Use CData Connect AI to connect to and integrate live PayPal in Jitterbit.
-
Access Live Avaza Data in AWS Lambda
Connect to live Avaza in AWS Lambda using the CData JDBC Driver.
-
Create Datasets from Hubstaff in Domo Workbench and Build Visualizations of Hubstaff Data in Domo
Use the CData Software ODBC Driver for Hubstaff to create datasets from Hubstaff in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Dropbox Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dropbox JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Perigon Data in DBxtra
Create dynamic dashboards and perform analytics based on Perigon in DBxtra.
-
Use Manus AI to Talk to Your Gmail 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 Gmail.