CData Software - Knowledge Base
Recent Articles
-
How to Access Live Jira Assets Data in Visual Studio Code via Cline
Run CData MCP Server for Jira Assets on Windows Subsytem for Linux (WSL) and connect to live Jira Assets from the Cline extension in Visual Studio Code.
-
How to Connect to Live Zendesk Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Zendesk without replication.
-
Using the CData Software ODBC Driver for Oracle Financials Cloud in PyCharm
Connect to Oracle Financials Cloud as an ODBC data source in PyCharm using the CData Software ODBC Driver for Oracle Financials Cloud.
-
Automated Continuous Jumpseller Replication to Vertica
Use CData Sync for automated, continuous, customizable Jumpseller replication to Vertica.
-
CircleCI Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CircleCI facts in real time.
-
LINQ to GitHub 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 GitHub Data Provider.
-
Connect to Parallel Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Parallel using standard SQL.
-
Work with Browserless Data in FoxPro
Load Browserless into a FoxPro database. This article includes full code and a walk-through of the process.
-
Extend Google Sheets with Azure Data Lake Storage Data
Make calls to Azure Data Lake Storage from Google Apps Script via the API Server.
-
Integrating Cursor CLI with VWO 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.
-
Connect to Stripe from a Connection Pool in WebLogic
Use the CData JDBC Driver for Stripe to connect to Stripe from Web applications running on WebLogic.
-
Use the CData SSIS Components to Insert New or Update Existing Outreach.io Records from SQL Server
Easily push SQL Server data to Outreach.io using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Outreach.io or update existing records with data from a SQL Server database.
-
Connect to FreeAgent Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to FreeAgent and work with FreeAgent in your FileMaker applications.
-
Integrating LangGraph with Google Calendar Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Google Calendar within automated workflows.
-
Connect to Moosend Data from a Connection Pool in JBoss
Integrate Moosend into Java servlets: Use the Management Console in JBoss to install the Moosend JDBC Driver.
-
Connect ZohoInvoice to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZohoInvoice using the CData Python MCP Server.
-
Create Data Visualizations in Cognos BI with EnterpriseDB Data
Access EnterpriseDB as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Import Data from SharePoint Excel Services into Google Sheets
Import SharePoint Excel Services into a Google spreadsheet that is automatically refreshed.
-
Access Live MarkLogic Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live MarkLogic from your Excel spreadsheets.
-
Integrating OpenCode Terminal with Reckon 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.
-
Automate Google Forms Data Replication to Couchbase
Use CData Sync to Customize and automate Google Forms replication to Couchbase.
-
Build Microsoft Exchange-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Exchange Data and create custom apps in Mendix.
-
A PostgreSQL Interface for SQL Analysis Services Data using the CData ODBC Driver
Use the SQL Gateway and SQL Analysis Services ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to SAP Ariba Procurement from Asprova with CData Software ODBC Driver for SAP Ariba Procurement
This article shows how to connect faster to SAP Ariba Procurement data from Asprova.
-
Create Data Visualizations in Cognos BI with Twilio Data
Access Twilio as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Theia IDE with Live BambooHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Integrate Real-Time Access to Spark in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Apache Spark SQL in real time.
-
Automated Continuous Sage Cloud Accounting Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Sage Cloud Accounting replication to PostgreSQL.
-
How to connect SharePoint with Oracle Sales Data through external lists
Provide Oracle Sales to SharePoint users as an external list.
-
Automated Continuous Amplitude Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Amplitude replication to Amazon S3.
-
Integrating Codex CLI with Qualaroo 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.
-
Access Live Xero Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Xero Accounting in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Automated Continuous HubDB Replication to Snowflake
Use CData Sync for automated, continuous, customizable HubDB replication to Snowflake.
-
Integrate Aha! Data in the Pentaho Report Designer
Publish reports based on Aha! in the Pentaho BI tool.
-
Connect to Strava Data in Ruby
Connect to Strava in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous Acumatica Replication to Databricks
Use CData Sync for automated, continuous, customizable Acumatica replication to Databricks.
-
How to connect SharePoint with Active Directory Data through external lists
Provide Active Directory to SharePoint users as an external list.
-
Connect to Greenplum Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Greenplum to connect to Pivotal GreenPlum and execute queries in PowerBuilder.
-
Access Cloudflare Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Cloudflare.
-
Analyze Printify Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Printify with the CData JDBC Driver for Printify.
-
Model, Search, and Visualize Live Google Cloud Storage Data in ThoughtSpot
Use CData Connect AI to connect to live Google Cloud Storage for modeling, searching, and visualizing.
-
Build a PostgreSQL Interface for Reckon Accounts Hosted Data using the CData JDBC Driver
Use the Remoting features of the Reckon Accounts Hosted JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ConvertAPI Data in RapidMiner
Integrate ConvertAPI with standard components and data source configuration wizards in RapidMiner Studio.
-
A PostgreSQL Interface for Microsoft Teams Data (MySQL Remoting via JDBC)
Use the Remoting features of the Microsoft Teams JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Dynamics CRM Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dynamics CRM from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Spark Data in ColdFusion
Write standard ColdFusion data access code to connect to Apache Spark SQL.
-
Connect Amazon Athena to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Amazon Athena with IBM WebSphere for seamless data integration and connectivity.
-
Easily Integrate Front Data in Lazarus Pascal IDE
Learn how to easily integrate live Front in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Translate Data in DBArtisan
Use wizards in DBArtisan to configure Google Translate as a data source.
-
Deploy the ADO.NET Provider for SuiteCRM on an SSRS Report Server
Connect to SuiteCRM from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Getting Started with the CData Power BI Connector for SendGrid
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for SendGrid.
-
Build Semantic Layer Views for Monday.com Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Monday.com.
-
Access Live Freshsales Data in Coginiti Pro
Connect to and query live Freshsales from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Telegram Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Telegram using standard SQL.
-
Establish a Live Connection with Templated Data using Tableau Bridge
The CData ODBC Driver for Templated enables you to integrate live Templated into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate with Zuora Data in JReport Designer
Create charts and reports based on Zuora in JReport Designer.
-
Integrate Zoho Books Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zoho Books and integrate live Zoho Books into your Power Automate tasks.
-
Easily Integrate SuiteCRM Data in Lazarus Pascal IDE
Learn how to easily integrate live SuiteCRM in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Migrating data from ZohoSubscriptions to Google BigQuery using CData SSIS Components.
Easily push ZohoSubscriptions to Google BigQuery using the CData SSIS Tasks for ZohoSubscriptions and Google BigQuery.
-
Working with Epicor Kinetic Data in LINQPad
Execute LINQ queries to Epicor Kinetic in LINQPad.
-
Automated Continuous AlloyDB Replication to Oracle
Use CData Sync for automated, continuous, customizable AlloyDB replication to Oracle.
-
Automated Continuous Dotmailer Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dotmailer replication to delimited files (CSV/TSV).
-
Use the CData Software ODBC Driver for SAP Fieldglass in MicroStrategy
Connect to SAP Fieldglass in MicroStrategy Developer using the CData Software ODBC Driver for SAP Fieldglass.
-
Build Data Flows from SQL Server to Square through SSIS
Easily push SQL Server data to Square using the CData SSIS Tasks for Square.
-
Automated Continuous LionDesk Replication to Snowflake
Use CData Sync for automated, continuous, customizable LionDesk replication to Snowflake.
-
Visualize Billsby Data in TIBCO Spotfire through ADO.NET
Integrate Billsby into dashboards in TIBCO Spotfire.
-
Access Live CapsuleCRM Data in AWS Lambda
Connect to live CapsuleCRM in AWS Lambda using the CData JDBC Driver.
-
Integrate Live Dynamics 365 Business Central Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Dynamics 365 Business Central from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Dynamics 365 Business Central.
-
Connect to and Visualize Live SAP HANA XS Advanced Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP HANA XS Advanced.
-
Connect to Onfleet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Onfleet to connect to Onfleet and execute queries in PowerBuilder.
-
Build Visualizations of SingleStore Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SingleStore in Birst.
-
Connect to ElevenLabs from a Connection Pool in WebLogic
Use the CData JDBC Driver for ElevenLabs to connect to ElevenLabs from Web applications running on WebLogic.
-
Getting Started with the CData Excel Add-In for Marketo
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Marketo.
-
Build Pipedrive-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Pipedrive Data and create custom apps in Bubble.
-
Connect to Splunk Data in RapidMiner
Integrate Splunk with standard components and data source configuration wizards in RapidMiner Studio.
-
View Reports on Real-Time BambooHR Data in Power BI Report Server
Use the CData ODBC Driver for BambooHR to visualize BambooHR in Power BI Desktop and then publish them to Power BI Report Server.
-
How to publish and share SAP Hybris C4C Data dashboards with Tableau Server
The CData ODBC driver for SAP Hybris C4C enables you integrate SAP Hybris C4C into Tableau dashboards.
-
Build Azure Data Lake Storage-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Azure Data Lake Storage to explore live Azure Data Lake Storage Data in GitHub Copilot to assist with building Azure Data Lake Storage-powered applications.
-
Connect to Excel Online Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Excel Online Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Easily Integrate ZohoExpense Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoExpense in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connecting Pipedream with Zoom 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 Zoom data in real time.
-
Analyze MarkLogic Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of MarkLogic and visualize live MarkLogic in Infragistics Reveal.
-
Viewing Contentful Data in RAD Studio Data Explorer
How to view Contentful in RAD Studio Data Explorer using the CData ODBC Driver for Contentful.
-
Prepare, Blend, and Analyze HDFS Data in Alteryx Designer (ODBC)
Build workflows to access live Apache HDFS for self-service data analytics.
-
Creating Cosmos DB-Connected Applications in Unqork
You can use CData Connect AI to feed Azure Cosmos DB to Unqork and build custom business apps.
-
Build Automated Workflows with Live Sage 200 Data in Workato
Use CData Connect AI to connect to live Sage 200 and build automated workflows in Workato.
-
Provide OData Services of Outreach.io Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Outreach.io by developing a WCF Service Application.
-
Integrate PingOne with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate PingOne with External Services.
-
How to work with QuickBooks Online Data in Apache Spark using SQL
Access and process QuickBooks Online Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData ODBC Driver for SQL Analysis Services
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SQL Analysis Services.
-
Automated Continuous Xero Replication to Databricks
Use CData Sync for automated, continuous, customizable Xero replication to Databricks.
-
Replicate ShipEngine Data to Multiple Databases
Replicate ShipEngine to disparate databases with a point-and-click configuration.
-
Create Zendesk-Connected Applications in Appsmith
Connect to Zendesk Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Zendesk.
-
Connect to Dynamics 365 Business Central Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central and execute queries in PowerBuilder.
-
Use the CData Software ODBC Driver for HCL Domino in MicroStrategy
Connect to HCL Domino in MicroStrategy Developer using the CData Software ODBC Driver for HCL Domino.
-
Use the CData ODBC Driver for Sage Cloud Accounting in Microsoft Power Query
You can use the CData Sage Cloud Accounting ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sage Business Cloud Accounting into Microsoft Power Query.
-
Create Confluence Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Confluence from PowerBI.com to create Power BI Dataflows with real-time data.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy Web
Connect to SAP SuccessFactors LMS in MicroStrategy Web using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
How to Design Salesforce Marketing Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Salesforce Marketing from mobile and tablet Power Apps.
-
Integrate Live Vertica Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Vertica from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Vertica.