CData Software - Knowledge Base
Recent Articles
-
Rapidly Develop Oracle-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Oracle.
-
Connect to Instantly Data from a Connection Pool in Jetty
The Instantly JDBC Driver supports connection pooling: This article shows how to connect faster to Instantly from Web apps in Jetty.
-
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 from within the editor.
-
Consume PolarTeamPro OData Feeds in SAP Lumira
Use the API Server to create data visualizations on PolarTeamPro feeds that reflect any changes in SAP Lumira.
-
Connect to NASA Data in Jaspersoft Studio
Execute SQL to remote NASA in Jaspersoft Studio.
-
Import Real-Time Twilio Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Twilio in ColdFusion.
-
Automated Continuous Samanage Replication to Oracle
Use CData Sync for automated, continuous, customizable Samanage replication to Oracle.
-
Connecting Pipedream with Google Directory 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 Google Directory data in real time.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for ZohoExpense
Provide connectivity to ZohoExpense through an SAP BusinessObjects universe.
-
Build Sybase-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Sybase to explore live Sybase Data in Cursor to assist with building Sybase-powered applications.
-
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 in Power Apps.
-
Analyze Flowlu Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Flowlu from Power Pivot. You will use the Table Import Wizard to load Flowlu. You can visually build the import query or use any SQL supported by the driver.
-
Load Cloudant Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load IBM Cloudant to a database.
-
Connect to Azure Table Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Automate Microsoft Teams Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Teams and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
LINQ to LightSpeedRetail 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 LightSpeedRetail Data Provider.
-
Getting Started with the CData Python Connector for Impala
Learn to install and license the CData Python Connector
-
Build a Singer.io Tap for Tickspot With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Tickspot data using
-
Connect MessageBird Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your MessageBird using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Getting Started with the CData Tableau Connector for LinkedIn
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for LinkedIn.
-
Automate Cloudflare Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Cloudflare from PowerShell? This article demonstrates how to utilize the Cloudflare Cmdlets for tasks like connecting to Cloudflare, automating operations, downloading data, and more.
-
Import Stripe Data Using Azure Data Factory
Use CData Connect AI to connect to Stripe Data from Azure Data Factory and import live Stripe.
-
Query Monday.com Data in ColdFusion
Write standard ColdFusion data access code to connect to Monday.com.
-
Query Bright Data Data in DataGrip
Create a Data Source for Bright Data in DataGrip and use SQL to query live Bright Data.
-
LINQ to Outlook 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 Outlook Data Provider.
-
Use the CData Software JDBC Driver for Stack Exchange in MicroStrategy Desktop
Connect to Stack Exchange in MicroStrategy Desktop using the CData Software JDBC Driver for Stack Exchange.
-
LINQ to Demio 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 Demio Data Provider.
-
Build SAP Ariba Source-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SAP Ariba Source to explore live SAP Ariba Source Data in Gemini Code Assist to assist with building SAP Ariba Source-powered applications.
-
Visualize Parallel Data in Tableau
The CData ODBC driver for Parallel enables you integrate Parallel 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.
-
Working with AfterShip Data in LINQPad
Execute LINQ queries to AfterShip in LINQPad.
-
How to Connect the Power BI Service to Webflow: Complete Guide
Connect to the CData Software Power BI Connector for Webflow from PowerBI.com to provide real-time Webflow across the organization.
-
How to connect and process Billsby from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Billsby.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Stripe within intelligent workflows.
-
Connect to ConvertAPI Data in RazorSQL
Connect to ConvertAPI from wizards and query ConvertAPI from the GUI in the RazorSQL database management tool.
-
Use the CData API Server to Access Instantly Data in Microsoft PowerPivot
Use the CData API Server to connect to live Instantly in the Power Pivot business intelligence tool.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Ads
Create Google Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Work with Shippo Data in FoxPro
Load Shippo into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to Access Live Demio Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Demio from the Cline extension in Visual Studio Code.
-
Connect to Guru Data from a Connection Pool in JBoss
Integrate Guru into Java servlets: Use the Management Console in JBoss to install the Guru JDBC Driver.
-
Analyze Spark Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Apache Spark SQL and visualize live Apache Spark SQL in Infragistics Reveal.
-
Connect to HBase Data in Jaspersoft Studio
Execute SQL to remote Apache HBase in Jaspersoft Studio.
-
How to Access Live Acumatica Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Acumatica enables you to integrate Acumatica ERP into workflows built using Microsoft Power Automate Desktop.
-
Query SAS Data Sets Data in ColdFusion
Write standard ColdFusion data access code to connect to SAS Data Sets.
-
Access Live CouchDB Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Apache CouchDB from your Google Sheets.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZeroBounce
Provide connectivity to ZeroBounce through an SAP BusinessObjects universe.
-
Build Pipelines with Live Google Search Results in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Google Search from Google Cloud Data Fusion, enabling the integration of live Google Search into the building and management of effective data pipelines.
-
Query Sugar CRM Data in ColdFusion
Write standard ColdFusion data access code to connect to Sugar CRM.
-
Integrating OpenCode Terminal with TigerGraph 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.
-
Integrating Teradata Data in Talend Cloud Data Management Platform
Connect Teradata Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Teradata.
-
Getting Started with the CData JDBC Driver for Strava
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Strava.
-
Use the CData Software JDBC Driver for NetSuite in MicroStrategy Desktop
Connect to NetSuite CRM & ERP in MicroStrategy Desktop using the CData Software JDBC Driver for NetSuite.
-
Use JayDeBeApi to access Zoho CRM Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho CRM.
-
Rapidly Develop Salesloft-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Salesloft.
-
Use the CData Software JDBC Driver for MailerLite in MicroStrategy
Connect to MailerLite in MicroStrategy Developer using the CData Software JDBC Driver for MailerLite.
-
Using the CData Software ODBC Driver for Pinecone in PyCharm
Connect to Pinecone as an ODBC data source in PyCharm using the CData Software ODBC Driver for Pinecone.
-
Connect to Azure Analysis Services Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Azure Analysis Services in Airbyte.
-
Write a Simple Go Application to work with Recurly Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Recurly.
-
Replicate Multiple ConstantContact Accounts via the CData Sync CLI
Replicate multiple ConstantContact accounts to one or many databases.
-
Build Dashboards with Gumroad Data in DBxtra
Create dynamic dashboards and perform analytics based on Gumroad in DBxtra.
-
Connect to Real-Time Mailjet Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Mailjet in Power Apps.
-
Replicate Active Directory Data to Multiple Databases
Replicate Active Directory to disparate databases with a point-and-click configuration.
-
Build Templated-Powered Applications in Claude Code with CData MCP Server
Use the CData API Driver for MCP Server to explore live Templated Data in Claude Code to assist with building Templated-powered applications.
-
View Reports on Real-Time ZohoDesk Data in Power BI Report Server
Use the CData ODBC Driver for ZohoDesk to visualize ZohoDesk in Power BI Desktop and then publish them to Power BI Report Server.
-
Access SAS Data Sets Data from MySQL in Amazon QuickSight
Connect to SAS Data Sets and build visualizations of SAS Data Sets using a MySQL Connection in Amazon QuickSight.
-
Migrating data from Eventbrite to Google BigQuery using CData SSIS Components.
Easily push Eventbrite to Google BigQuery using the CData SSIS Tasks for Eventbrite and Google BigQuery.
-
Enable the Hive JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Apache Hive.
-
Analyze MySQL Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of MySQL and visualize MySQL in SAP Analytics Cloud.
-
Create Dynamic Guru Grids Using the Infragistics XamDataGrid
Learn how you can connect Guru to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Clio Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clio replication to AlloyDB.
-
Natively Connect to Google Sheets Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.
-
How to Work with Telegram Data in ETL Validator JDBC
Connect to Telegram from ETL Validator jobs using the CData Software JDBC Driver.
-
Aircall Reporting in OBIEE with the Aircall JDBC Driver
Deploy the Aircall JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Replicate Autopilot Data to Multiple Databases
Replicate Autopilot to disparate databases with a point-and-click configuration.
-
Connect to Contentful Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Contentful using standard SQL.
-
Create PabblySubscriptions Dataflows on PowerBI.com
Connect to the CData Power BI Connector for PabblySubscriptions from PowerBI.com to create Power BI Dataflows with real-time data.
-
Build MVC Applications with Connectivity to Excel Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Excel from an ASP.NET MVC application.
-
How to create Ontraport federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Ontraport in MySQL .
-
Prepare, Blend, and Analyze Sage 200 Data in Alteryx Designer (Connect AI)
Build workflows to access live Sage 200 for self-service data analytics.
-
Working with Klaviyo Data in LINQPad
Execute LINQ queries to Klaviyo in LINQPad.
-
How to Query XML Data in MySQL Workbench
Execute MySQL queries against live XML Files from MySQL Workbench.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed VWO to Power BI dashboards. Simply drag and drop VWO into data visuals on the Power BI canvas.
-
How to create an RPA flow for Tally Data in UiPath Studio
Use the Tally ODBC Driver to create workflows that access real-time Tally ERP without any coding.
-
Visualize PagerDuty Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to PagerDuty.
-
Migrating data from MailChimp to Snowflake using CData SSIS Components.
Easily push MailChimp to Snowflake using the CData SSIS Tasks for MailChimp and Snowflake.
-
Integrate Cursor with Live PostgreSQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live PostgreSQL from within the editor.
-
Create Dynamic Cohere Grids Using the Infragistics XamDataGrid
Learn how you can connect Cohere to Infragistics XamDataGrid to build dynamic grids.
-
Create Informatica Mappings From/To a JDBC Data Source for Spark
Create Spark data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Integrate VWO Data in Pentaho Data Integration
Build ETL pipelines based on VWO in the Pentaho Data Integration tool.
-
Tavily Reporting in OBIEE with the Tavily JDBC Driver
Deploy the Tavily JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
View Reports on Real-Time Wistia Data in Power BI Report Server
Use the CData ODBC Driver for Wistia to visualize Wistia in Power BI Desktop and then publish them to Power BI Report Server.
-
Create a Data Access Object for Dynamics 365 Business Central Data using JDBI
A brief overview of creating a SQL Object API for Dynamics 365 Business Central in JDBI.
-
Use Claude to Talk to Your MariaDB 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 MariaDB for you.
-
Consume Factorial OData Feeds in PowerBuilder
This article demonstrates how to consume Factorial as OData feeds from PowerBuilder using the API Server.
-
Add PolarTeamPro Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for PolarTeamPro with the Informatica Enterprise Data Catalog to classify and organize data.
-
Integrating OpenCode Terminal with SQL Server 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.
-
Feed LaunchDarkly Data into FineReport
How to set LaunchDarkly as a JDBC data source in FineReport.
-
Connect to HelloSign Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for HelloSign and the SQL Gateway to access HelloSign from Google Apps Script.
-
Analyze Highrise Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Highrise CRM and visualize live Highrise CRM in Infragistics Reveal.
-
How to integrate Metabase with Shopify Data
Use CData Connect AI to connect to live Shopify and create an interactive dashboard in Metabase from Shopify.