CData Software - Knowledge Base
Recent Articles
-
Connect to Freshservice Data in JRuby
Create a simple JRuby app with access to live Freshservice data.
-
Consume Oracle Eloqua OData Feeds in PowerBuilder
This article demonstrates how to consume Oracle Eloqua data as OData feeds from PowerBuilder using the API Server.
-
Query Live Reckon Accounts Hosted Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Reckon Accounts Hosted data through a conversational interface.
-
Create Reports with Short.io Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Short.io data.
-
Design BIRT Reports on AgileCRM Data
Provide current AgileCRM data to your embedded analytics.
-
PolarTeamPro Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PolarTeamPro data through CData Connect AI using different applications and tools.
-
Visualize Live Azure Data Catalog Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Data Catalog data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Seamlessly Bring MailChimp Data into Retool Using CData Connect AI
Integrate MailChimp data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Natively Connect to Bannerbear Data in PHP
The CData ODBC driver for Bannerbear enables you to create PHP applications with connectivity to Bannerbear data. Leverage the native support for ODBC in PHP.
-
How to Create Power BI Visual Reports with Real-Time SAP Ariba Source Data
Use CData Power BI Connectors to visualize SAP Ariba Source data in Power BI.
-
Visualize Live Zoho Inventory Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Zoho Inventory data.
-
Create SSAS Tabular Models from Act CRM Data
How to build a SQL Server Analysis Service Tabular Model from Act CRM data using CData drivers.
-
Design BIRT Reports on PingOne Data
Provide current PingOne data to your embedded analytics.
-
Getting Started with the CData Connect AI Python SDK for Pipedrive
Install the CData Connect AI Python SDK to read and write live Pipedrive data with standard DB-API 2.0 Python code.
-
Import Xero Data Using Azure Data Factory
Use CData Connect AI to connect to Xero Data from Azure Data Factory and import live Xero data.
-
Connect to JDBC-ODBC Bridge Data in CloverDX (formerly CloverETL)
Transfer JDBC-ODBC Bridge data using the visual workflow in the CloverDX data integration tool.
-
How to Connect DBeaver to Google Sheets via a JDBC Driver
Manage Google Sheets data with visual tools in DBeaver like the query browser.
-
Integrate Azure Data Lake Storage Data in Pentaho Data Integration
Build ETL pipelines based on Azure Data Lake Storage data in the Pentaho Data Integration tool.
-
Integrating Boomi Agentstudio with Amazon Athena Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Amazon Athena data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Establish a Live Connection with QuickBooks Online Data using Tableau Bridge
The CData ODBC Driver for QuickBooks Online enables you to integrate live QuickBooks Online data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to XML Data with Squirrel SQL client
Connect to XML data and execute queries in the Squirrel SQL Client.
-
Integrate Google's Antigravity Agent with Live Freshdesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Freshdesk data using the Model Context Protocol.
-
Visualize Microsoft Dataverse Data in TIBCO Spotfire through OData
Integrate Microsoft Dataverse data into dashboards in TIBCO Spotfire.
-
Use the CData Software ODBC Driver for Avaza in MicroStrategy Desktop
Connect to Avaza data in MicroStrategy Desktop using the CData Software ODBC Driver for Avaza.
-
Connect to Clio Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Clio and work with Clio data in your FileMaker applications.
-
Build Stack Exchange-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Stack Exchange data.
-
A PostgreSQL Interface for MarkLogic Data (MySQL Remoting via JDBC)
Use the Remoting features of the MarkLogic JDBC Driver to create a PostgreSQL entry-point for data access.
-
Choosing the Best Method to Connect ShipEngine to SQL Server: 5 Options Explained
Discover multiple ways to connect and use ShipEngine data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to Pipedrive Data in DBeaver
Use the CData ODBC Driver to connect to Pipedrive data in DBeaver.
-
Connect to Landbot Data in Aqua Data Studio
Access Landbot data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Agno to Talk to Your Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Omnisend data for you.
-
Analyze Hive Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Hive data in Microsoft R Open.
-
Create Informatica Mappings From/To a JDBC Data Source for Snapchat Ads
Create Snapchat Ads data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time FreshBooks Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use FreshBooks data in ColdFusion.
-
Provide OData Services of iContact Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for iContact data by developing a WCF Service Application.
-
Access Live Oracle Sales Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Oracle Sales data through MCP integration.
-
MariaDB Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MariaDB data through CData Connect AI using different applications and tools.
-
How to connect Amazon QuickSight to Google Ads Data
Create a connection to Google Ads data in CData Connect AI and insert Google Ads data into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect to ConvertKit Data from PowerBuilder via ADO.NET
This article demonstrates how to access ConvertKit data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Extract, Transform, and Load Everhour Data in Informatica PowerCenter
Create a simple Workflow for Everhour data in Informatica PowerCenter.
-
How to connect PolyBase to MailerSend
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live MailerSend data.
-
Migrating data from Foursquare to Databricks using CData SSIS Components.
Easily push Foursquare data to Databricks using the CData SSIS Tasks for Foursquare and Databricks.
-
Using the CData Software ODBC Driver for YouTube Analytics in PyCharm
Connect to YouTube Analytics as an ODBC data source in PyCharm using the CData Software ODBC Driver for YouTube Analytics.
-
Connect to Reckon Accounts Hosted Data in ACL Analytics
Connect to Reckon Accounts Hosted data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Reckon Accounts Hosted data.
-
How to Connect DBeaver to Testmonitor via a JDBC Driver
Manage Testmonitor data with visual tools in DBeaver like the query browser.
-
Create DocuSign-Connected Nintex Workflows
Use CData Connect AI to connect to DocuSign Data from Nintex Workflow Cloud and build custom workflows using live DocuSign data.
-
How to Connect to Pipeline CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Pipeline CRM data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Google's Vertex AI Agent with Live GetResponse 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 GetResponse data within intelligent workflows.
-
Automated Continuous Elasticsearch Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Elasticsearch replication to Apache Kafka.
-
Connect to Elasticsearch Data from PowerBuilder via JDBC
This article demonstrates how to access Elasticsearch data from PowerBuilder using the Elasticsearch JDBC Driver.
-
Analyze Airtable Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Airtable data and visualize Airtable data in SAP Analytics Cloud.
-
Integrating Cloudflare Data in Talend Cloud Data Management Platform
Connect Cloudflare Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Link Google Tasks with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Google Tasks data in Filemaker Pro for Mac or Windows.
-
Access Live Greenhouse Data in Coginiti Pro
Connect to and query live Greenhouse data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Query IBM Informix Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume IBM Informix entities in PHP by modeling them as objects.
-
Integrate Live Greenhouse Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Greenhouse data and integrate live Greenhouse data into apps built in Microsoft Power Apps.
-
Automate Freshsales Data Replication to SAP HANA
Use CData Sync to customize and automate Freshsales data replication to SAP HANA.
-
Integrate WooCommerce with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate WooCommerce with External Services.
-
Connect to REST Data from PowerBuilder via JDBC
This article demonstrates how to access REST data from PowerBuilder using the REST JDBC Driver.
-
Automated Continuous Azure Blob Storage Replication to SingleStore
Use CData Sync for automated, continuous, customizable Azure Blob Storage replication to SingleStore.
-
Model, Search, and Visualize Live SFTP Data in ThoughtSpot
Use CData Connect AI to connect to live SFTP data for modeling, searching, and visualizing.
-
Migrating data from Freshsales to Google BigQuery using CData SSIS Components.
Easily push Freshsales data to Google BigQuery using the CData SSIS Tasks for Freshsales and Google BigQuery.
-
Access Drip Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Drip data from your Oracle system.
-
Work with Amazon DynamoDB Data in FoxPro
Load Amazon DynamoDB data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrating Codex with Lakebase 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.
-
Create SSAS Tabular Models from Bright Data Data
How to build a SQL Server Analysis Service Tabular Model from Bright Data data using CData drivers.
-
How to work with Smartsheet Data in Apache Spark using SQL
Access and process Smartsheet Data in Apache Spark using the CData Software JDBC Driver.
-
Build Semantic Layer Views for PayPal Data in APOS Live Data Gateway
Use the CData Connector for PayPal in APOS Live Data Gateway to build Semantic Layer Views for PayPal data.
-
Replicate Multiple LightSpeedRetail Accounts
Replicate multiple LightSpeedRetail accounts to one or many databases.
-
Automated Continuous SingleStore Replication to SQL Server
Use CData Sync for automated, continuous, customizable SingleStore replication to SQL Server.
-
Replicate IBM Cloud Object Storage Data to Multiple Databases
Replicate IBM Cloud Object Storage data to disparate databases with a point-and-click configuration.
-
Automated Continuous SAP Concur Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP Concur replication to Databricks.
-
Automate CockroachDB Data Replication to Couchbase
Use CData Sync to Customize and automate CockroachDB data replication to Couchbase.
-
Use the CData Software ODBC Driver for Figshare in MicroStrategy Web
Connect to Figshare data in MicroStrategy Web using the CData Software ODBC Driver for Figshare.
-
Migrating data from Excel to Databricks using CData SSIS Components.
Easily push Excel data to Databricks using the CData SSIS Tasks for Excel and Databricks.
-
Connect to HubSpot Data in Jaspersoft Studio
Execute SQL to remote HubSpot data in Jaspersoft Studio.
-
How to Connect Freshteam Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Freshteam data in real time using natural language.
-
Import Oracle HCM Cloud Data Using Azure Data Factory
Use CData Connect AI to connect to Oracle HCM Cloud Data from Azure Data Factory and import live Oracle HCM Cloud data.
-
Access Live FreshBooks Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live FreshBooks data through MCP integration.
-
Build Amazon Athena-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Amazon Athena Data and create custom apps in Bubble.
-
Connect to ServiceDesk Plus Data in HULFT Integrate
Connect to ServiceDesk Plus as a JDBC data source in HULFT Integrate
-
Connecting Moonlit Workflow with Zoho Books 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 Zoho Books data in real time.
-
Excel Spreadsheet Automation on AlloyDB Data with the QUERY Formula
Pull data from AlloyDB, automate spreadsheets, and more with the QUERY formula.
-
Use the CData Software ODBC Driver for SAP ByDesign in MicroStrategy Desktop
Connect to SAP ByDesign data in MicroStrategy Desktop using the CData Software ODBC Driver for SAP ByDesign.
-
A PostgreSQL Interface for Browserless Data using the CData ODBC Driver
Use the SQL Gateway and Browserless ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Dropbox Data from MySQL in PHP
Connect to Dropbox through the standard MySQL libraries in PHP.
-
Manage SingleStore Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for SingleStore.
-
Create REST Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time REST data access from reports, embedded analytics, and more.
-
Connect to Jira Assets from Asprova with CData Software ODBC Driver for Jira Assets
This article shows how to connect faster to Jira Assets data from Asprova.
-
Build Semantic Layer Views for Sybase IQ Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Sybase IQ data.
-
How to Connect to Live Greenhouse 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 Greenhouse data for you.
-
Analyze Optimizely Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Optimizely data and visualize live Optimizely data in Infragistics Reveal.
-
Use Microsoft Copilot Studio to talk to your Moosend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Moosend data for you.
-
Automated Continuous Discourse Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Discourse replication to Azure SQL Database.
-
Visualize Live Paylocity Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Paylocity data.
-
DataBind Charts to Jira Assets Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Jira Assets data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Write a Simple Go Application to work with Grafana Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Grafana data.
-
LINQ to Cloudflare 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 Cloudflare Data Provider.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Bullhorn CRM
Provide connectivity to Bullhorn CRM data through an SAP BusinessObjects universe.
-
How to Connect Jira Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Jira data in real time using natural language.