CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Accelo in SAS for Real-Time Reporting and Analytics
Connect to real-time Accelo data 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 data 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 data from PostgreSQL.
-
Integrating GitHub Copilot with Asana 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.
-
Build Pipelines with Live iContact Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to iContact from Google Cloud Data Fusion, enabling the integration of live iContact data into the building and management of effective data pipelines.
-
Configure the CData JDBC Driver for SingleStore in a Connection Pool in Tomcat
Connect to SingleStore data from a connection pool in Tomcat.
-
Migrating data from ZohoDesk to Google BigQuery using CData SSIS Components.
Easily push ZohoDesk data to Google BigQuery using the CData SSIS Tasks for ZohoDesk and Google BigQuery.
-
Create Data Visualizations Based On Bitbucket Data in Mode
Use CData Connect AI to connect to Bitbucket Data from Mode and build visualizations using live Bitbucket data.
-
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 data 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 data 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 data within automated workflows.
-
Replicate Billsby Data in Heroku for Use in Salesforce Connect
Replicate Billsby data 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 data 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 data 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 data.
-
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 OneNote data 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 data 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 data for you.
-
Connect to ConvertKit Data in JRuby
Create a simple JRuby app with access to live ConvertKit data.
-
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 data within automated workflows.
-
Connect to ElevenLabs Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ElevenLabs.
-
Connect to Landbot in SpagoBI
Create reports featuring live Landbot data in SpagoBI Studio. Host Landbot reports on SpagoBI Server.
-
Connecting Moonlit Workflow with HubDB 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 HubDB data in real time.
-
Integrate ZohoPeople Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to ZohoPeople data and integrate live ZohoPeople data into your Power Automate tasks.
-
Create Reports from Salesforce Pardot Data in Looker Studio
Use CData Connect AI to gain access to live Salesforce Pardot data and create custom reports in Looker Studio.
-
Connect to REST Data in Ruby
Connect to REST data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query, Visualize, and Share live Discord Data in Redash
Use CData Connect AI to connect to live Discord data in Redash for querying, visualizing, and sharing.
-
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 data.
-
Automated DB2 Data Replication to Teradata
Use CData Sync to Customize and automate DB2 data 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 data.
-
Connect to Figshare Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Figshare data from Filemaker Pro on Mac.
-
Access Avro Data from MySQL in Amazon QuickSight
Connect to Avro and build visualizations of Avro data 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 data from MicroStrategy.
-
Build Apps with Live SAP Concur Data Using the Low-Code Development Platform of Mendix
Connect SAP Concur data 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 data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Samanage Data from HeidiSQL
Use CData Connect AI to connect to and query live Samanage data from HeidiSQL.
-
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 data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Dynamics NAV Data from Crystal Reports
Use CData Connect AI to connect to and report on live Dynamics NAV data from Crystal Reports.
-
Create Reports with HubDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date HubDB data.
-
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 data.
-
Integrating Kiro 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 data, 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 Cloudant data.
-
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.
-
Automated Continuous ConvertAPI Replication to Databricks
Use CData Sync for automated, continuous, customizable ConvertAPI replication to Databricks.
-
Stream Wrike Data into Apache Kafka Topics
Access and stream Wrike data 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 data 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 data 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 data.
-
Integrate with EnterpriseDB Data in SnapLogic
Use CData Connect AI to connect to and integrate with live EnterpriseDB data in SnapLogic.
-
Use Dash to Build Web Apps on Hive Data via CData Connect AI
Build interactive Dash web apps on live Hive data 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 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 data into a Java-based ORM framework, Hibernate.
-
Integrating LangChain with Adobe Experience Manager Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Adobe Experience Manager data within automated workflows.
-
Connect and Query Live Salesforce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Salesforce data into Databricks and enable direct, live querying and analysis without replication.
-
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 data and build automated workflows in Zapier.
-
Create Informatica Mappings From/To an ODBC Data Source for Freshteam
Create an ODBC connection to Freshteam in Informatica and browse and transfer Freshteam data.
-
Automated Continuous Reply.io Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Reply.io data replication to OneLake in Microsoft Fabric.
-
Connect to Google Forms Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Google Forms.
-
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 data to SQL Server.
-
Use the CData Software ODBC Driver for SendInBlue in MicroStrategy Web
Connect to SendInBlue data in MicroStrategy Web using the CData Software ODBC Driver for SendInBlue.
-
Query, Visualize, and Share live Sugar CRM Data in Redash
Use CData Connect AI to connect to live Sugar CRM data in Redash for querying, visualizing, and sharing.
-
Connect to AdRoll Data as an External Source in Dremio
Use the CData JDBC Driver to connect to AdRoll as an External Source in Dremio.
-
ETL LinkedIn Ads in Oracle Data Integrator
This article shows how to transfer LinkedIn Ads data into a data warehouse using Oracle Data Integrator.
-
Integrating LangChain with Sybase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sybase data within automated workflows.
-
How to Connect to Live Sage 200 Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sage 200 data without replication.
-
Connect to FreshBooks Data in ACL Analytics
Connect to FreshBooks data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FreshBooks data.
-
Transfer Google Calendars to SharePoint in Talend
Access SharePoint data in Talend using the CData JDBC Driver for SharePoint.
-
Visualize SAP HANA 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 SAP HANA data into TIBCO Spotfire.
-
Connect to Real-Time NetSuite Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for NetSuite and Dataflow to import and use NetSuite data in Power Apps.
-
Connect to Jumpseller from Asprova with CData Software ODBC Driver for Jumpseller
This article shows how to connect faster to Jumpseller data from Asprova.
-
Connect to Typeform Data in NetBeans
Connect to Typeform data in NetBeans with the data source configuration wizard.
-
Analyze CockroachDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for CockroachDB from Power Pivot. You will use the Table Import Wizard to load CockroachDB data. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for ShipStation
Learn to install and license the CData Python Connector and configure a connection to live ShipStation data.
-
How to Build an ETL App for Sage Intacct Data in Python with CData
Create ETL applications and real-time data pipelines for Sage Intacct data in Python with petl.
-
Integrate Adobe Analytics Data in Pentaho Data Integration
Build ETL pipelines based on Adobe Analytics data in the Pentaho Data Integration tool.
-
Missive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Missive facts in real time.
-
Integrating Gumloop with Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Marketo data within automated workflows.
-
Use Azure AI Foundry to Talk to Your Samanage 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 Samanage data for you.
-
Analyze LeadDesk Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze LeadDesk data in Microsoft R Open.
-
Automated Continuous GetResponse Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable GetResponse data replication to OneLake in Microsoft Fabric.
-
Automated Continuous SpaceX Replication to SQLite
Use CData Sync for automated, continuous, customizable SpaceX replication to SQLite.
-
Connect and Query Live Sage Cloud Accounting Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sage Cloud Accounting data into Databricks and enable direct, live querying and analysis without replication.