CData Software - Knowledge Base
Recent Articles
-
Create Data Visualizations Based On AlloyDB Data in Mode
Use CData Connect AI to connect to AlloyDB Data from Mode and build visualizations using live
-
Connect to Adobe Commerce Data from PowerBuilder via JDBC
This article demonstrates how to access Adobe Commerce from PowerBuilder using the Adobe Commerce JDBC Driver.
-
Connect to Adobe Commerce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Adobe Commerce from Filemaker Pro on Mac.
-
Integrate Live PivotalTracker Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live PivotalTracker to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
How to work with Pinecone Data in Apache Spark using SQL
Access and process Pinecone Data in Apache Spark using the CData Software JDBC Driver.
-
Create Data Visualizations in Cognos BI with ZohoDesk Data
Access ZohoDesk as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Replicate Multiple SAP Business One Accounts
Replicate multiple SAP Business One accounts to one or many databases.
-
Connect to Gumroad Data from a Connection Pool in Jetty
The Gumroad JDBC Driver supports connection pooling: This article shows how to connect faster to Gumroad from Web apps in Jetty.
-
Connect to VWO 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 VWO and work with VWO in your FileMaker application.
-
Import Real-Time Amazon Marketplace Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Amazon Marketplace in ColdFusion.
-
Bind Live Exact Online Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Exact Online data
-
Configure the CData JDBC Driver for LinkedIn Ads in a Connection Pool in Tomcat
Connect to LinkedIn Ads from a connection pool in Tomcat.
-
Import Real-Time Oracle SCM Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Oracle SCM in ColdFusion.
-
Automate Egnyte Data Replication to SAP HANA
Use CData Sync to customize and automate Egnyte replication to SAP HANA.
-
Connect to Office 365 Data in NetBeans
Connect to Microsoft Office 365 in NetBeans with the data source configuration wizard.
-
Integrate with Paylocity Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Paylocity in SnapLogic.
-
Visualize Live Amazon S3 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Amazon S3 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Access AlloyDB Data Using Entity Framework
This article shows how to access Google AlloyDB using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Work with PagerDuty Data in FoxPro
Load PagerDuty into a FoxPro database. This article includes full code and a walk-through of the process.
-
How to connect and process Microsoft Access from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Access.
-
Build SAP Ariba Source-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for SAP Ariba Source to explore live SAP Ariba Source Data in Cursor to assist with building SAP Ariba Source-powered applications.
-
Query SingleStore Data as a SQL Server Database in Node.js
Execute SQL Server queries against SingleStore from Node.js.
-
Connect to MongoDB Data in ACL Analytics
Connect to MongoDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MongoDB.
-
Migrating data from AdRoll to Google BigQuery using CData SSIS Components.
Easily push AdRoll to Google BigQuery using the CData SSIS Tasks for AdRoll and Google BigQuery.
-
Integrate with Greenplum Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Pivotal GreenPlum in SnapLogic.
-
Replicate Gmail Data from PowerShell
Write a quick PowerShell script to query Gmail. Use connectivity to the live data to replicate Gmail to SQL Server.
-
Connect to Front Data in Ruby
Connect to Front in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Greenhouse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Greenhouse.
-
Connecting Mastra with Lakebase Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Lakebase, no replication required.
-
How to Connect to Zuora Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Zuora. Leverage the pyodbc module for ODBC in Python.
-
Integrate Goose with Live ShipStation Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live ShipStation from within the local AI agent.
-
Publish Crystal Reports on Quickbase Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Quickbase.
-
Visualize Pingdom Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Pingdom into TIBCO Spotfire.
-
Connect to Microsoft Ads Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft Ads.
-
Import Real-Time Kintone Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Kintone in ColdFusion.
-
Connect to and Visualize Live Oracle HCM Cloud Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Oracle HCM Cloud.
-
How to Easily Query Jira Assets Data in OpenOffice Base
Connect to Jira Assets data in OpenOffice Base using the CData ODBC Driver for Jira Assets and generate reports with live data insights.
-
Bidirectional Access to Zoom Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoom in Filemaker Pro for Mac or Windows.
-
Access Live Sage Cloud Accounting Data in AWS Lambda
Connect to live Sage Business Cloud Accounting in AWS Lambda using the CData JDBC Driver.
-
Bidirectional Access to WooCommerce Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate WooCommerce in Filemaker Pro for Mac or Windows.
-
Access Zendesk 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 Zendesk.
-
Build Semantic Layer Views for Google Cloud Storage Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Cloud Storage.
-
Integrating LangGraph with Dynamics 365 Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Microsoft Dynamics 365 within automated workflows.
-
Build AI Agents with Amazon S3 Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Amazon S3 through CData Connect AI.
-
ETL QuickBooks in Oracle Data Integrator
This article shows how to transfer QuickBooks Desktop into a data warehouse using Oracle Data Integrator.
-
Automate Tasks in Power Automate Using the CData API Server
Automate SAP HANA actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Connect to YouTube Analytics Data as an External Source in Dremio
Use the CData JDBC Driver to connect to YouTube Analytics as an External Source in Dremio.
-
Connect to Reckon Accounts Hosted Data from HeidiSQL
Use CData Connect AI to connect to and query live Reckon Accounts Hosted from HeidiSQL.
-
Create Datasets from Stripe in Domo Workbench and Build Visualizations of Stripe Data in Domo
Use the CData Software ODBC Driver for Stripe to create datasets from Stripe in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Greenhouse Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Greenhouse and the SQL Gateway to access Greenhouse from Google Apps Script.
-
Automate Spark Data Replication to Azure Synapse
Use CData Sync to customize and automate Apache Spark SQL replication to Azure Synapse.
-
A PostgreSQL Interface for Okta Data (MySQL Remoting via JDBC)
Use the Remoting features of the Okta JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Kintone-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Kintone Data and create custom apps in Bubble.
-
How to Design MariaDB Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to MariaDB from mobile and tablet Power Apps.
-
Connect to HDFS Data in Jaspersoft Studio
Execute SQL to remote Apache HDFS in Jaspersoft Studio.
-
Create Reports with OneNote Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft OneNote.
-
Create Zoho Recruit Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Zoho Recruit data access from reports, embedded analytics, and more.
-
Build Visualizations of Anaplan Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Anaplan in Birst.
-
How to import Redshift Data into Apache Solr
Use the CData Software JDBC Driver for Redshift in Data Import Handler and create an automated import of Amazon Redshift to Apache Solr Enterprise Search platform.
-
Connect to Mocean Data from a Connection Pool in Jetty
The Mocean JDBC Driver supports connection pooling: This article shows how to connect faster to Mocean from Web apps in Jetty.
-
Connect to Printful Data in DBeaver
Use the CData ODBC Driver to connect to Printful in DBeaver.
-
Getting Started with the CData ADO.NET Provider for ServiceNow
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for ServiceNow.
-
Replicate TigerGraph Data from PowerShell
Write a quick PowerShell script to query TigerGraph. Use connectivity to the live data to replicate TigerGraph to SQL Server.
-
How to connect to Outreach.io Data from Spring Boot
Connect to Outreach.io in a Spring Boot Application using the CData JDBC Driver for Outreach.io
-
How to work with Qualaroo Data in Apache Spark using SQL
Access and process Qualaroo Data in Apache Spark using the CData Software JDBC Driver.
-
Extract, Transform, and Load Procore Data in Informatica PowerCenter
Create a simple Workflow for Procore in Informatica PowerCenter.
-
Visualize DB2 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to IBM DB2.
-
Automated Continuous Zoho Inventory Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to AlloyDB.
-
Connect to Real-Time Telegram Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Telegram in Power Apps.
-
Automate Lakebase Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Lakebase and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Create Dashboards and Visualize Live LinkedIn Ads Data in Geckoboard
Use CData Connect AI to connect to live LinkedIn Ads and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Build an ETL App for Google Drive Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Drive in Python with petl and the CData Connect AI Python SDK.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Asana to Power BI dashboards. Simply drag and drop Asana into data visuals on the Power BI canvas.
-
How to connect Amazon QuickSight to Basecamp Data
Create a connection to Basecamp in CData Connect AI and insert Basecamp into Amazon QuickSight SPICE to build interactive dashboards.
-
Process & Analyze Gorgias Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Gorgias Data.
-
How to create an RPA flow for Slack Data in UiPath Studio
Use the Slack ODBC Driver to create workflows that access real-time Slack without any coding.
-
Automated Continuous Google Calendar Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Calendar replication to AlloyDB.
-
Excel Spreadsheet Automation on Cvent Data with the QUERY Formula
Pull data from Cvent, automate spreadsheets, and more with the QUERY formula.
-
Access Live Authorize.Net Data in TIBCO Data Virtualization
Use the Authorize.Net Tibco DV Adapter to create a Authorize.Net data source in TIBCO Data Virtualization Studio and gain access to live Authorize.Net from your TDV Server.
-
Work with Phoenix Data in FoxPro
Load Apache Phoenix into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Basecamp-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Basecamp Data and create custom apps in Mendix.
-
Query Live Highrise Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Highrise CRM directly from the development environment.
-
Import Real-Time LaunchDarkly Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use LaunchDarkly in ColdFusion.
-
LINQ to eBay 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 eBay Data Provider.
-
Automated Continuous Exa Replication to MySQL
Use CData Sync for automated, continuous, customizable Exa replication to MySQL.
-
How to Query Live Sugar CRM Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Sugar CRM data in natural language using Python.
-
Build a PostgreSQL Interface for Microsoft Planner Data using the CData JDBC Driver
Use the Remoting features of the Microsoft Planner JDBC Driver to create a PostgreSQL entry-point for data access.
-
Deploy the ADO.NET Provider for Webflow on an SSRS Report Server
Connect to Webflow 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.
-
How to connect and process Teamgate from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Teamgate.
-
Integrate Real-Time Access to Google Search in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Google Search in real time.
-
Connect to Neo4J Data in NetBeans
Connect to Neo4J in NetBeans with the data source configuration wizard.
-
Create IBM Cloud Object Storage-Connected Business Apps in AppSheet
Connect to IBM Cloud Object Storage Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to IBM Cloud Object Storage.
-
Datadog Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Datadog facts in real time.
-
Create a Data Access Object for Clockify Data using JDBI
A brief overview of creating a SQL Object API for Clockify in JDBI.
-
Automate Vault CRM Data Replication to Couchbase
Use CData Sync to Customize and automate Veeva Vault & Vault CRM replication to Couchbase.
-
Build Agents in Relevance AI with Access to Live IBM Informix Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on IBM Informix within intelligent agent workflows.
-
Use the CData Software ODBC Driver for Nethunt in MicroStrategy Web
Connect to Nethunt in MicroStrategy Web using the CData Software ODBC Driver for Nethunt.
-
Integrating Kiro CLI with Unbounce 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.
-
Analyze Asana Data in Looker
Use CData Connect AI to connect to Asana Data from Looker and build custom apps using live Asana.
-
Connect to Microsoft OneDrive Data in DBeaver
Use the CData ODBC Driver to connect to Microsoft OneDrive in DBeaver.