CData Software - Knowledge Base
Recent Articles
-
Build Voice Agents in ElevenLabs with access to Live HCL Domino Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live HCL Domino data.
-
Publish Workable-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Workable data.
-
A PostgreSQL Interface for Webflow Data (MySQL Remoting via JDBC)
Use the Remoting features of the Webflow JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to update Lakebase from Excel
This article explains how to transfer data from Excel to Lakebase using the Excel Add-In for Lakebase.
-
Connecting Pipedream with Shippo Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Shippo data in real time.
-
Connecting GenSpark with Avalara AvaTax Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Avalara AvaTax data without any replication or custom integration required.
-
Use the CData Software ODBC Driver for SAP SuccessFactors in MicroStrategy Web
Connect to SAP SuccessFactors data in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors.
-
Build a PostgreSQL Interface for PDFMonkey Data using the CData JDBC Driver
Use the Remoting features of the PDFMonkey JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Freshservice Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Freshservice data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Semantic Layer Views for Printify Data in APOS Live Data Gateway
Use the CData Connector for Printify in APOS Live Data Gateway to build Semantic Layer Views for Printify data.
-
How to Access ConstantContact Data Using Entity Framework
This article shows how to access ConstantContact data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Analyze Pinterest Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Pinterest data and visualize live Pinterest data in Infragistics Reveal.
-
Provide OData Services of Timely Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Timely data by developing a WCF Service Application.
-
Analyze GitLab Data in Cognos Analytics
Use CData Connect AI to connect to GitLab Data from Cognos Analytics and analyze live GitLab data.
-
Getting Started with the CData Power BI Connector for PingOne
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for PingOne.
-
Import Real-Time Salesforce CRM Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Salesforce CRM Analytics data in ColdFusion.
-
Automated Continuous AlloyDB Replication to Databricks
Use CData Sync for automated, continuous, customizable AlloyDB replication to Databricks.
-
Automated Continuous Telegram Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Telegram replication to delimited files (CSV/TSV).
-
Connect Adobe Commerce to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Commerce with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Billsby in SpagoBI
Create reports featuring live Billsby data in SpagoBI Studio. Host Billsby reports on SpagoBI Server.
-
Connect to Placid Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Placid data.
-
How to Access SharePoint Excel Services Data Using Entity Framework
This article shows how to access SharePoint Excel Services data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automate Telegram Data Replication to Azure Synapse
Use CData Sync to customize and automate Telegram data replication to Azure Synapse.
-
Use the CData SSIS Components to Insert New or Update Existing AlloyDB Records from SQL Server
Easily push SQL Server data to AlloyDB using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into AlloyDB or update existing records with data from a SQL Server database.
-
Integrating LangGraph with Dynamics 365 Business Central Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Dynamics 365 Business Central data within automated workflows.
-
Analyze Office 365 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Office 365 data. You can visually build the import query or use any SQL supported by the driver.
-
Connect to Azure DevOps Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Azure DevOps to connect to Azure DevOps data and execute queries in PowerBuilder.
-
Work with TigerGraph Data in FoxPro
Load TigerGraph data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex with Okta 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.
-
Working with Freshteam Data in LINQPad
Execute LINQ queries to Freshteam data in LINQPad.
-
Write a Simple Go Application to work with Cloudant Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Cloudant data.
-
Integrate Live Microsoft Entra ID Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Microsoft Entra ID data from within the IDE.
-
View Reports on Real-Time Certinia Data in Power BI Report Server
Use the CData ODBC Driver for Certinia to visualize Certinia data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Stripe Data in DBArtisan
Use wizards in DBArtisan to configure Stripe data as a data source.
-
How to Connect to Live Workday 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 Workday data for you.
-
Automated Continuous RSS Replication to Oracle
Use CData Sync for automated, continuous, customizable RSS replication to Oracle.
-
How to Access Live Google Drive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Drive enables you to integrate Google Drive data into workflows built using Microsoft Power Automate Desktop.
-
Model QuickBooks Online Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and QuickBooks Online, enabling the direct import of real-time QuickBooks Online data.
-
Feed Elorus Data into FineReport
How to set Elorus data as a JDBC data source in FineReport.
-
Build a Singer.io Tap for Cloudant With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Cloudant data using the CData Python Connector.
-
Integrate ConvertAPI with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ConvertAPI with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ConvertAPI data.
-
Integrate OpenCode with Live Asana Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Asana data from within your AI coding agent.
-
Connect to Gumroad Data in NetBeans
Connect to Gumroad data in NetBeans with the data source configuration wizard.
-
Create PingOne Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PingOne data access from reports, embedded analytics, and more.
-
Publish Crystal Reports on Rebilly Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Rebilly data.
-
Integrate with XML Data in SnapLogic
Use CData Connect AI to connect to and integrate with live XML data in SnapLogic.
-
Automate SAP SuccessFactors Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SAP SuccessFactors data from PowerShell? This article demonstrates how to utilize the SAP SuccessFactors Cmdlets for tasks like connecting to SAP SuccessFactors data, automating operations, downloading data, and more.
-
Use the CData Software JDBC Driver for Reckon Accounts Hosted in MicroStrategy Web
Connect to Reckon Accounts Hosted data in MicroStrategy Web using the CData Software JDBC Driver for Reckon Accounts Hosted.
-
Replicate Zoho CRM Data from PowerShell
Write a quick PowerShell script to query Zoho CRM data. Use connectivity to the live data to replicate Zoho CRM data to SQL Server.
-
Query Opsgenie Data as a MySQL Database in Node.js
Execute MySQL queries against Opsgenie data from Node.js.
-
Connect to Keap Data from PowerBuilder via ADO.NET
This article demonstrates how to access Keap data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Integrate LibreChat with Live Salesforce Marketing Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Salesforce Marketing data from within the chat interface.
-
Automated Continuous ZeroBounce Replication to IBM DB2
Use CData Sync for automated, continuous, customizable ZeroBounce replication to IBM DB2.
-
Build Agents in Relevance AI with Access to Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Zendesk data within intelligent agent workflows.
-
Visualize Missive Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Missive data.
-
How to connect and process Salesforce data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Salesforce data.
-
Access MongoDB Data from MySQL in Amazon QuickSight
Connect to MongoDB and build visualizations of MongoDB data using a MySQL Connection in Amazon QuickSight.
-
Integrating Twilio Data in Talend Cloud Data Management Platform
Connect Twilio Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Twilio.
-
Access Excel Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Excel data from HeidiSQL.
-
Integrating BigCommerce Data in Talend Cloud Data Management Platform
Connect BigCommerce Data with Talend Cloud Data Management Platform using the CData JDBC Driver for BigCommerce.
-
Build Visualizations of Teradata Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Teradata data in Birst.
-
Build Semantic Layer Views for Anaplan Data in APOS Live Data Gateway
Use the CData Connector for Anaplan in APOS Live Data Gateway to build Semantic Layer Views for Anaplan data.
-
Automated Continuous Phoenix Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Phoenix replication to Amazon Redshift.
-
Create Data Visualizations Based On Toggl Data in Mode
Use CData Connect AI to connect to Toggl Data from Mode and build visualizations using live Toggl data.
-
Integrate Real-Time Access to Adobe Analytics in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Adobe Analytics data in real time.
-
Visualize Live SparkPost Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live SparkPost data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Configure the CData JDBC Driver for ConvertKit in a Connection Pool in Tomcat
Connect to ConvertKit data from a connection pool in Tomcat.
-
Create Informatica Mappings From/To an ODBC Data Source for Snowflake
Create an ODBC connection to Snowflake in Informatica and browse and transfer Snowflake data.
-
Automated Continuous SAP SuccessFactors Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to Apache Cassandra.
-
Visualize Live Oracle Service Cloud Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Oracle Service Cloud data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Data Flows from Avaza to SQL Server using SSIS
Easily back up Avaza data to SQL Server using the SSIS components for Avaza.
-
Integrate Anaplan with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Anaplan with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Anaplan data.
-
Connect to Sybase from Asprova with CData Software ODBC Driver for Sybase
This article shows how to connect faster to Sybase data from Asprova.
-
How to Access Live Sybase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Sybase enables you to integrate Sybase data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData SSIS Components to Insert New or Update Existing Jira Assets Records from SQL Server
Easily push SQL Server data to Jira Assets using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Jira Assets or update existing records with data from a SQL Server database.
-
Integrate Cursor with Live Microsoft OneDrive Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft OneDrive data from within the editor.
-
DataBind Controls to Lakebase Data in Delphi
DataBind to Lakebase data in Delphi with standard data access components and controls.
-
Operational Reporting on Zuora Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Zuora data.
-
Import Real-Time Twilio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Twilio data in ColdFusion.
-
Connect to API Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with API Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Real-Time ZohoInvoice Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use ZohoInvoice data in Power Apps.
-
Publish Reports with Oracle HCM Cloud Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Oracle HCM Cloud data.
-
Integrate with SAS xpt Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy SAS xpt data to a JSON file on disk.
-
Visualize Live LDAP Objects in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live LDAP objects.
-
Automated Continuous Square Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Square data replication to OneLake in Microsoft Fabric.
-
Import Stripe Data Using Azure Data Factory
Use CData Connect AI to connect to Stripe Data from Azure Data Factory and import live Stripe data.
-
Query Bright Data Data in DataGrip
Create a Data Source for Bright Data in DataGrip and use SQL to query live Bright Data data.
-
Use the CData Software JDBC Driver for Stack Exchange in MicroStrategy Desktop
Connect to Stack Exchange data in MicroStrategy Desktop using the CData Software JDBC Driver for Stack Exchange.
-
Use the CData ODBC Driver for QuickBooks in Microsoft Power Query
You can use the CData QuickBooks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import QuickBooks data into Microsoft Power Query.
-
Replicate Multiple Paylocity Accounts
Replicate multiple Paylocity accounts to one or many databases.
-
Visualize Parallel Data in Tableau
The CData ODBC driver for Parallel enables you integrate Parallel data into Tableau dashboards.
-
Automated Continuous Power BI XMLA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Power BI XMLA replication to IBM DB2.
-
Create SSAS Tabular Models from Egnyte Data
How to build a SQL Server Analysis Service Tabular Model from Egnyte data using CData drivers.
-
Working with AfterShip Data in LINQPad
Execute LINQ queries to AfterShip data in LINQPad.
-
Build Gmail-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Gmail data.
-
Migrating data from Monday.com to Databricks using CData SSIS Components.
Easily push Monday.com data to Databricks using the CData SSIS Tasks for Monday.com and Databricks.
-
Integrate Google's Vertex AI Agent with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Stripe data within intelligent workflows.
-
Work with Shippo Data in FoxPro
Load Shippo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Consume EnterpriseDB OData Feeds in PowerBuilder
This article demonstrates how to consume EnterpriseDB data as OData feeds from PowerBuilder using the API Server.
-
Replicate Wave Financial Data in Heroku for Use in Salesforce Connect
Replicate Wave Financial data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.