CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time PDFMonkey Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PDFMonkey in Power Apps.
-
How to connect to SQL Analysis Services Data with Squirrel SQL client
Connect to SQL Analysis Services and execute queries in the Squirrel SQL Client.
-
A PostgreSQL Interface for PostgreSQL Data (MySQL Remoting via JDBC)
Use the Remoting features of the PostgreSQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Viewing Highrise Data in RAD Studio Data Explorer
How to view Highrise CRM in RAD Studio Data Explorer using the CData ODBC Driver for Highrise.
-
How to create an RPA flow for SendInBlue Data in UiPath Studio
Use the SendInBlue ODBC Driver to create workflows that access real-time SendInBlue without any coding.
-
How to integrate Metabase with AlloyDB Data
Use CData Connect AI to connect to live Google AlloyDB and create an interactive dashboard in Metabase from Google AlloyDB.
-
Create Informatica Mappings From/To an ODBC Data Source for JotForm
Create an ODBC connection to JotForm in Informatica and browse and transfer JotForm.
-
Connect to Basecamp in SpagoBI
Create reports featuring live Basecamp in SpagoBI Studio. Host Basecamp reports on SpagoBI Server.
-
How to connect Amazon QuickSight to LinkedIn Ads Data
Create a connection to LinkedIn Ads in CData Connect AI and insert LinkedIn Ads into Amazon QuickSight SPICE to build interactive dashboards.
-
Replicate Google Tasks Data to Multiple Databases via the CData Sync CLI
Replicate Google Tasks to disparate databases with a single configuration.
-
Integrating Cursor CLI with Dropbox 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 Oracle Financials Cloud Data from PowerBuilder via JDBC
This article demonstrates how to access Oracle Financials Cloud from PowerBuilder using the Oracle Financials Cloud JDBC Driver.
-
How to create an RPA flow for Tickspot Data in UiPath Studio
Use the Tickspot ODBC Driver to create workflows that access real-time Tickspot without any coding.
-
Manage AlloyDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for AlloyDB.
-
Integrate Cursor with Live ADP Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live ADP from within the editor.
-
Replicate Multiple Google Forms Accounts
Replicate multiple Google Forms accounts to one or many databases.
-
Connect to Wistia Data in Ruby
Connect to Wistia in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build a Simple VCL Application for Helpscout Data
How to build a simple VCL Application to view Helpscout in RAD Studio using the CData ODBC Driver for Helpscout.
-
Connect to Short.io Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Short.io using standard SQL.
-
Easily Integrate Pinterest Data in Lazarus Pascal IDE
Learn how to easily integrate live Pinterest in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for GetResponse in Microsoft Power Query
You can use the CData GetResponse ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import GetResponse into Microsoft Power Query.
-
Connect to Azure Table Data in Ruby
Connect to Azure Table Storage in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to integrate Front with Apache Airflow
Access and process Front in Apache Airflow using the CData JDBC Driver.
-
Customer.io Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Customer.io facts in real time.
-
Design BIRT Reports on BigCommerce Data
Provide current BigCommerce to your embedded analytics.
-
Build Dashboards with Accelo Data in Dundas BI
Create dynamic dashboards and perform analytics based on Accelo in Dundas BI.
-
Query Calendly Data as a MySQL Database in Node.js
Execute MySQL queries against Calendly from Node.js.
-
Use the CData Software JDBC Driver for Discord in MicroStrategy Desktop
Connect to Discord in MicroStrategy Desktop using the CData Software JDBC Driver for Discord.
-
Easily Integrate Typeform Data in Lazarus Pascal IDE
Learn how to easily integrate live Typeform in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Excel Spreadsheet Automation on Aweber Data with the QUERY Formula
Pull data from Aweber, automate spreadsheets, and more with the QUERY formula.
-
Getting Started with the CData ODBC Driver for SparkPost
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SparkPost.
-
Use Dash to Build to Web Apps on Odoo Data
Create Python applications that use pandas and Dash to build Odoo-connected web apps.
-
Connect to Simplesat Data from a Connection Pool in Jetty
The Simplesat JDBC Driver supports connection pooling: This article shows how to connect faster to Simplesat from Web apps in Jetty.
-
Use the CData Software ODBC Driver for Accelo in SAS for Real-Time Reporting and Analytics
Connect to real-time Accelo in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Accelo.
-
How to publish and share MySQL Data dashboards with Tableau Server
The CData ODBC driver for MySQL enables you integrate MySQL into Tableau dashboards.
-
A PostgreSQL Interface for SAS Data Sets Data using the CData ODBC Driver
Use the SQL Gateway and SAS Data Sets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Live LinkedIn Ads Data in PostGresSQL Interface through CData Connect AI
Create a live connection to LinkedIn Ads in CData Connect AI and connect to your LinkedIn Ads from PostgreSQL.
-
Integrating GitHub Copilot CLI with Asana 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.
-
Configure the CData JDBC Driver for SingleStore in a Connection Pool in Tomcat
Connect to SingleStore from a connection pool in Tomcat.
-
Migrating data from ZohoDesk to Google BigQuery using CData SSIS Components.
Easily push ZohoDesk to Google BigQuery using the CData SSIS Tasks for ZohoDesk and Google BigQuery.
-
Connect to Real-Time Zuora Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Zuora and Dataflow to import and use Zuora in Power Apps.
-
Query Live Procore 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 Procore directly from the development environment.
-
Integrating Gumloop with SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Business One within automated workflows.
-
Replicate Billsby Data in Heroku for Use in Salesforce Connect
Replicate Billsby to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Query Avro Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Avro entities in PHP by modeling them as objects.
-
Import Real-Time Recurly Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Recurly in ColdFusion.
-
How to connect to SAP BusinessObjects BI Data from Spring Boot
Connect to SAP BusinessObjects BI in a Spring Boot Application using the CData JDBC Driver for SAP BusinessObjects BI
-
Extract, Transform, and Load Amazon Marketplace Data in Informatica PowerCenter
Create a simple Workflow for Amazon Marketplace in Informatica PowerCenter.
-
How to Work with CSV Data in ETL Validator JDBC
Connect to CSV from ETL Validator jobs using the CData Software JDBC Driver.
-
Create Microsoft Planner-Connected Dashboards in Grafana
Connect to Microsoft Planner Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Microsoft Planner.
-
How to connect to LinkedIn Ads Data from Spring Boot
Connect to LinkedIn Ads in a Spring Boot Application using the CData JDBC Driver for LinkedIn Ads
-
LINQ to REST 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 REST Data Provider.
-
Add Accelo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Accelo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Getting Started with the CData ODBC Driver for IBM Informix
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for IBM Informix.
-
Connect to OneNote Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Microsoft OneNote in the Denodo Virtual DataPort Administrator.
-
Getting Started with the CData JDBC Driver for Azure Data Catalog
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Azure Data Catalog.
-
Automated Continuous Freshdesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Freshdesk replication to SQL Server.
-
Connect to Gong Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Gong using standard SQL.
-
How to Connect to Live Pipedrive 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 Pipedrive for you.
-
Connect to ConvertKit Data in JRuby
Create a simple JRuby app with access to live ConvertKit.
-
Integrating Gumloop with Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Monday.com within automated workflows.
-
Connect to ElevenLabs Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Landbot in SpagoBI
Create reports featuring live Landbot in SpagoBI Studio. Host Landbot reports on SpagoBI Server.
-
Create Reports from Salesforce Pardot Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce Pardot and create custom reports in Looker Studio.
-
Connect to REST Data in Ruby
Connect to REST in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Create Reports with Azure Data Lake Storage Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure Data Lake Storage.
-
Automated DB2 Data Replication to Teradata
Use CData Sync to Customize and automate IBM DB2 replication to Teradata.
-
Access SAP Fieldglass 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 SAP Fieldglass.
-
Access Avro Data from MySQL in Amazon QuickSight
Connect to Avro and build visualizations of Apache Avro using a MySQL Connection in Amazon QuickSight.
-
Connect to Live Microsoft Dataverse Data in MicroStrategy through CData Connect AI
Create a live connection to Microsoft Dataverse Data in CData Connect AI and connect to your Microsoft Dataverse (CDS) from MicroStrategy.
-
Build Apps with Live SAP Concur Data Using the Low-Code Development Platform of Mendix
Connect SAP Concur with Mendix to build apps using the CData JDBC Driver for SAP Concur.
-
Visualize Live Sage 300 Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Sage 300 using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Google Search Replication to SingleStore
Use CData Sync for automated, continuous, customizable Google Search replication to SingleStore.
-
Connect to CircleCI Data in Aqua Data Studio
Access CircleCI from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports with HubDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubDB.
-
LINQ to SAP SuccessFactors LMS 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 SAP SuccessFactors LMS Data Provider.
-
Build Figshare-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Figshare.
-
Integrating Kiro CLI with Pingdom 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 Boomi Agentstudio with MarkLogic Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to MarkLogic, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Create Cloudant-Connected Applications in Appsmith
Connect to Cloudant Data via CData Connect AI in Appsmith and create custom business applications with real-time access to IBM Cloudant.
-
Using the CData Software ODBC Driver for Email in PyCharm
Connect to Email as an ODBC data source in PyCharm using the CData Software ODBC Driver for Email.
-
Stream Wrike Data into Apache Kafka Topics
Access and stream Wrike in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Google Contacts Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Contacts in Google Apps Script.
-
How to Easily Query Rootly Data in OpenOffice Base
Connect to Rootly data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Microsoft Dataverse Replication to MongoDB
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to MongoDB.
-
Access Brex Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Brex from your Oracle system.
-
Automated Continuous Splunk Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Splunk replication to Amazon S3.
-
Access Okta 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 Okta.
-
Integrate with EnterpriseDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live EnterpriseDB in SnapLogic.
-
Use Dash to Build Web Apps on Hive Data via CData Connect AI
Build interactive Dash web apps on live Apache Hive using pandas and the CData Connect AI Python SDK.
-
How to Query Live Clockify Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Clockify data in natural language using Python.
-
Automated Continuous SAP HANA XS Advanced Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Apache Cassandra.
-
Object-Relational Mapping (ORM) with Adobe Analytics 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 Adobe Analytics into a Java-based ORM framework, Hibernate.
-
Connect and Query Live Salesforce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce & Force.com into Databricks
-
Connecting Pipedream with Gmail 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 Gmail data in real time.
-
Build Automated Cvent-Connected Workflows in Zapier
Use CData Connect AI to connect to live Cvent and build automated workflows in Zapier.
-
Build Kintone-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Kintone to explore live Kintone Data in Gemini Code Assist to assist with building Kintone-powered applications.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshteam
Create an ODBC connection to Freshteam in Informatica and browse and transfer Freshteam.
-
Connect to Google Forms Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use Biml to Build SSIS Tasks to Replicate ZohoExpense Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate ZohoExpense to SQL Server.