CData Software - Knowledge Base
Recent Articles
-
Use Azure AI Foundry to Talk to Your Jira Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Atlassian Jira for you.
-
Connect to Yelp Data in DBeaver
Use the CData ODBC Driver to connect to Yelp in DBeaver.
-
A PostgreSQL Interface for SAP Concur Data using the CData ODBC Driver
Use the SQL Gateway and SAP Concur ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Cassandra Data in DBeaver
Use the CData ODBC Driver to connect to Apache Cassandra in DBeaver.
-
Connect to Tickspot Data in RapidMiner
Integrate Tickspot with standard components and data source configuration wizards in RapidMiner Studio.
-
Use Grok to Talk to Your IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your IBM Informix for you.
-
Import MarkLogic Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access MarkLogic. In this article, you will use the OData format to import MarkLogic into Microsoft Power Query.
-
View Reports on Real-Time SQL Analysis Services Data in Power BI Report Server
Use the CData ODBC Driver for SQL Analysis Services to visualize SQL Analysis Services in Power BI Desktop and then publish them to Power BI Report Server.
-
Perform Batch Operations with Google Ad Manager Data in Apache NiFi
Connect to Google Ad Manager and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Use Dash to Build Web Apps on QuickBooks Online Data via CData Connect AI
Build interactive Dash web apps on live QuickBooks Online using pandas and the CData Connect AI Python SDK.
-
Access Live Guru Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Guru in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrating Boomi Agentstudio with Phoenix Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Apache Phoenix, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Establish a Live Connection with Splunk Data using Tableau Bridge
The CData ODBC Driver for Splunk enables you to integrate live Splunk into Tableau Cloud dashboards using the Tableau Bridge.
-
Use the CData Software JDBC Driver for Parquet in MicroStrategy Web
Connect to Apache Parquet in MicroStrategy Web using the CData Software JDBC Driver for Parquet.
-
Analyze IBM Informix Data in Looker
Use CData Connect AI to connect to IBM Informix Data from Looker and build custom apps using live IBM Informix.
-
Import and Visualize Salesforce CRM Analytics Data in Power View
Create data visualizations based on Salesforce CRM Analytics in Excel.
-
Integrating Codex CLI with Google Translate 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 Dashboards with MailerLite Data in DBxtra
Create dynamic dashboards and perform analytics based on MailerLite in DBxtra.
-
Use CData Connect AI to Access MongoDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MongoDB in the Power Pivot business intelligence tool.
-
Connect to Live Salesforce Marketing Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesforce Marketing in CData Connect AI and connect to your Salesforce Marketing Cloud from PostgreSQL.
-
Build Dashboards with Spotify Data in Dundas BI
Create dynamic dashboards and perform analytics based on Spotify in Dundas BI.
-
Integrating LlamaIndex with Gmail Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Gmail in real time.
-
Automate Monday.com Data Replication to Couchbase
Use CData Sync to Customize and automate Monday.com replication to Couchbase.
-
Deploy the ADO.NET Provider for Front on an SSRS Report Server
Connect to Front 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.
-
Use the CData Software ODBC Driver for AlloyDB in MicroStrategy Desktop
Connect to Google AlloyDB in MicroStrategy Desktop using the CData Software ODBC Driver for AlloyDB.
-
Create Epicor Kinetic Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Epicor Kinetic from PowerBI.com to create Power BI Dataflows with real-time data.
-
Add Monday.com Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Monday.com with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Freshdesk from a Connection Pool in WebLogic
Use the CData JDBC Driver for Freshdesk to connect to Freshdesk from Web applications running on WebLogic.
-
Create Dynamic ServiceNow Grids Using the Infragistics XamDataGrid
Learn how you can connect ServiceNow to Infragistics XamDataGrid to build dynamic grids.
-
Moving Data from Printify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Printify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Build Semantic Layer Views for HelloSign Data in APOS Live Data Gateway
Use the CData Connector for HelloSign in APOS Live Data Gateway to build Semantic Layer Views for HelloSign.
-
Extend Google Sheets with JSON Services
Make calls to JSON from Google Apps Script via the API Server.
-
A PostgreSQL Interface for OnePageCrm Data (MySQL Remoting via JDBC)
Use the Remoting features of the OnePageCrm JDBC Driver to create a PostgreSQL entry-point for data access.
-
Bind Live Workday Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Workday data
-
Visualize Live xBase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live xBase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build GetResponse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to GetResponse and build web apps with connectivity to live GetResponse.
-
How to Connect to Live Basecamp Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Basecamp for you.
-
Integrate Live Marketo Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
LINQ to Bannerbear 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 Bannerbear Data Provider.
-
Integrate Freshteam Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Freshteam from Informatica Cloud.
-
Explore Geographical Relationships in Databricks Data with Power Map
Create data visualizations with Databricks in Power Map.
-
Integrate Live Microsoft Teams Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrate with ChartMogul Data in JReport Designer
Create charts and reports based on ChartMogul in JReport Designer.
-
Connect to Google Calendar Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Calendar as an External Source in Dremio.
-
Use the CData API Server to Access Dynamics CRM Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft Dynamics CRM in the Power Pivot business intelligence tool.
-
Import Real-Time Telegram Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Telegram in ColdFusion.
-
Prepare, Blend, and Analyze Aha! Data in Alteryx Designer (ODBC)
Build workflows to access live Aha! for self-service data analytics.
-
Access Exa 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 Exa.
-
Use the CData API Server to Access SQL Server Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft SQL Server in the Power Pivot business intelligence tool.
-
Connect to Azure Data Lake Storage from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Data Lake Storage, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate SAP ByDesign Data in the Pentaho Report Designer
Publish reports based on SAP Business ByDesign in the Pentaho BI tool.
-
Connecting Agentforce with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Apache Avro for you.
-
Connect to FTP Data in RazorSQL
Connect to FTP from wizards and query FTP Servers from the GUI in the RazorSQL database management tool.
-
Work with Live Lakebase Data in Power Query
Use CData Connect AI to connect to Lakebase and work with live Lakebase in Microsoft Power Query.
-
Connect to Gumroad Data in CloverDX (formerly CloverETL)
Transfer Gumroad using the visual workflow in the CloverDX data integration tool.
-
Build Pipelines with Live QuickBooks Online Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to QuickBooks Online from Google Cloud Data Fusion, enabling the integration of live QuickBooks Online into the building and management of effective data pipelines.
-
Access Live Azure Data Lake Storage Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Data Lake Storage from your Google Sheets.
-
Process & Analyze Square Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Square Data.
-
Connect to MessageBird Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for MessageBird.
-
Connect Asana to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Asana with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with Accelo Data in JReport Designer
Create charts and reports based on Accelo in JReport Designer.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for ZendeskSell
Provide connectivity to ZendeskSell through an SAP BusinessObjects universe.
-
Edit and Search External SAP HANA Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAP HANA to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAP HANA Data objects that you can access from apps and the dashboard.
-
Create Informatica Mappings From/To a JDBC Data Source for FreshBooks
Create FreshBooks data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Harvest Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Harvest and work with Harvest in your FileMaker application.
-
Connect to ADP from a Connection Pool in WebLogic
Use the CData JDBC Driver for ADP to connect to ADP from Web applications running on WebLogic.
-
Configure the CData JDBC Driver for Tanda in a Connection Pool in Tomcat
Connect to Tanda from a connection pool in Tomcat.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for GetResponse
Provide connectivity to GetResponse through an SAP BusinessObjects universe.
-
A PostgreSQL Interface for Clio Data (MySQL Remoting via JDBC)
Use the Remoting features of the Clio JDBC Driver to create a PostgreSQL entry-point for data access.
-
Load Stack Exchange Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Stack Exchange to a database.
-
Integrate Live Zoho Books Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Zoho Books and integrate live Zoho Books into apps built in Microsoft Power Apps.
-
Use the CData Software ODBC Driver for Samanage in MicroStrategy Desktop
Connect to Samanage in MicroStrategy Desktop using the CData Software ODBC Driver for Samanage.
-
How to Connect to Live SAP Hybris C4C Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your SAP Hybris C4C for you.
-
Establish a Live Connection with Sugar CRM Data using Tableau Bridge
The CData ODBC Driver for Sugar CRM enables you to integrate live Sugar CRM into Tableau Cloud dashboards using the Tableau Bridge.
-
Access Live Freshdesk Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Freshdesk from your Excel spreadsheets.
-
How to Visualize Avaza Data in Python with pandas
Use pandas and other modules to analyze and visualize live Avaza in Python.
-
Connect to Customer.io Data from a Connection Pool in Jetty
The Customer.io JDBC Driver supports connection pooling: This article shows how to connect faster to Customer.io from Web apps in Jetty.
-
Automated Continuous Authorize.Net Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Authorize.Net replication to PostgreSQL.
-
Build OneNote Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Microsoft OneNote and build visualizations in Tableau Cloud.
-
Excel Spreadsheet Automation on Clockify Data with the QUERY Formula
Pull data from Clockify, automate spreadsheets, and more with the QUERY formula.
-
Automated Continuous Authorize.Net Replication to Databricks
Use CData Sync for automated, continuous, customizable Authorize.Net replication to Databricks.
-
Object-Relational Mapping (ORM) with Procore Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Procore into a Java-based ORM framework, Hibernate.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Wave Financial to Power BI dashboards. Simply drag and drop Wave Financial into data visuals on the Power BI canvas.
-
How to Work with CouchDB Data in AWS Glue Jobs Using JDBC
Connect to CouchDB from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Visualize Zoho Inventory Data in TIBCO Spotfire through ADO.NET
Integrate Zoho Inventory into dashboards in TIBCO Spotfire.
-
Use Grok to Talk to Your Cassandra Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Apache Cassandra for you.
-
Build Mixpanel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mixpanel and build web apps with connectivity to live Mixpanel.
-
Create SAP Ariba Procurement-Connected Business Apps in AppSheet
Connect to SAP Ariba Procurement Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to SAP Ariba Procurement.
-
How to Access Live Google Analytics Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Analytics enables you to integrate Google Analytics into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Jira Assets in SAS for Real-Time Reporting and Analytics
Connect to real-time Jira Assets in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Jira Assets.
-
Import Real-Time Reckon Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Reckon in ColdFusion.
-
Analyze Dropbox Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Dropbox and visualize live Dropbox in Infragistics Reveal.
-
Natively Connect to Spark Data in PHP
The CData ODBC driver for Spark enables you to create PHP applications with connectivity to Apache Spark SQL. Leverage the native support for ODBC in PHP.
-
Analyze IBM Informix Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of IBM Informix and visualize live IBM Informix in Infragistics Reveal.
-
How to Connect to & Open ADP Data in Microsoft Excel
This article uses the CData ODBC driver for ADP to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to AgileCRM Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for AgileCRM to connect to AgileCRM and execute queries in PowerBuilder.
-
Integrate Google Directory Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Google Directory from Informatica Cloud.
-
Integrating Gumloop with Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Cvent within automated workflows.
-
Access Google Contacts Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Contacts from your Oracle system.
-
Natively Connect to Excel Data in PHP
The CData ODBC driver for Excel enables you to create PHP applications with connectivity to Microsoft Excel. Leverage the native support for ODBC in PHP.