CData Software - Knowledge Base
Recent Articles
-
Establish a Live Connection with Azure Data Catalog Data using Tableau Bridge
The CData ODBC Driver for Azure Data Catalog enables you to integrate live Azure Data Catalog data into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Open WebUI with Live Google Search Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Search results from within the chat interface.
-
How to Connect DBeaver to Gong via a JDBC Driver
Manage Gong data with visual tools in DBeaver like the query browser.
-
How to Connect to Live SQL Server Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your SQL Server data for you.
-
DB2 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on DB2 facts in real time.
-
Build Semantic Layer Views for XML Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for XML data.
-
Integrate OpenCode with Live Sage Cloud Accounting Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Sage Cloud Accounting data from within your AI coding agent.
-
Publish Crystal Reports on Planio Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Planio data.
-
Apache Log4j2 Overview
CData is aware of the recently disclosed Apache Log4j2 vulnerability (CVE-2021-44228).
-
Connect to ZendeskSell Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ZendeskSell.
-
LINQ to Optimizely 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 Optimizely Data Provider.
-
Manage CloudConvert Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CloudConvert.
-
Replicate FormSite Data from PowerShell
Write a quick PowerShell script to query FormSite data. Use connectivity to the live data to replicate FormSite data to SQL Server.
-
Search External Google Ads Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Ads data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Ads Data objects that you can access from apps and the dashboard.
-
Connect to Raisers Edge NXT Data in DBeaver
Use the CData ODBC Driver to connect to Raisers Edge NXT data in DBeaver.
-
Automated Continuous Dynamics NAV Replication to MySQL
Use CData Sync for automated, continuous, customizable Dynamics NAV replication to MySQL.
-
Integrating Kiro with Zuora 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 a PostgreSQL Interface for Lakebase Data using the CData JDBC Driver
Use the Remoting features of the Lakebase JDBC Driver to create a PostgreSQL entry-point for data access.
-
Excel Spreadsheet Automation on LightSpeedRetail Data with the QUERY Formula
Pull data from LightSpeedRetail, automate spreadsheets, and more with the QUERY formula.
-
Integrating Gumloop with Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Google Contacts data within automated workflows.
-
Connect to Email Data in HULFT Integrate
Connect to Email as a JDBC data source in HULFT Integrate
-
Use Biml to Build SSIS Tasks to Replicate SAP Ariba Procurement Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate SAP Ariba Procurement data to SQL Server.
-
Extract, Transform, and Load Odoo Data in Informatica PowerCenter
Create a simple Workflow for Odoo data in Informatica PowerCenter.
-
Getting Started with the CData Connect AI Python SDK for ZohoSubscriptions
Install the CData Connect AI Python SDK to read live ZohoSubscriptions data with standard DB-API 2.0 Python code.
-
Connect to Gmail Data in NetBeans
Connect to Gmail data in NetBeans with the data source configuration wizard.
-
Object-Relational Mapping (ORM) with Wrike 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 Wrike data into a Java-based ORM framework, Hibernate.
-
Build AI/ML Models with Live Facebook Ads Data using Dataiku
Connect Facebook Ads Data with Dataiku using the CData JDBC Driver for Facebook Ads.
-
Create Power BI Reports on Real-Time Oracle Data
Use the CData ODBC Driver for Oracle to visualize Oracle data in Power BI Desktop.
-
Build AI Agents with Attio 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 Attio data through CData Connect AI.
-
Work with Sage 300 Data in FoxPro
Load Sage 300 data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect JobNimbus to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect JobNimbus with IBM WebSphere for seamless data integration and connectivity.
-
How to publish and share Mistral AI Data dashboards with Tableau Server
The CData ODBC driver for Mistral AI enables you integrate Mistral AI data into Tableau dashboards.
-
Build a PostgreSQL Interface for Accelo Data using the CData JDBC Driver
Use the Remoting features of the Accelo JDBC Driver to create a PostgreSQL entry-point for data access.
-
Migrating data from IBM Cloud Object Storage to Google BigQuery using CData SSIS Components.
Easily push IBM Cloud Object Storage data to Google BigQuery using the CData SSIS Tasks for IBM Cloud Object Storage and Google BigQuery.
-
Connect to Suadeo in SpagoBI
Create reports featuring live Suadeo data in SpagoBI Studio. Host Suadeo reports on SpagoBI Server.
-
Back Up Bugsnag data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Bugsnag data data.
-
Integrating LangChain with PingOne Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on PingOne data within automated workflows.
-
Connect to Snowflake Data in HULFT Integrate
Connect to Snowflake as a JDBC data source in HULFT Integrate
-
Use the CData ODBC Driver for Raisers Edge NXT in Microsoft Power Query
You can use the CData Raisers Edge NXT ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Raisers Edge NXT data into Microsoft Power Query.
-
Build Semantic Layer Views for Oracle Eloqua Data in APOS Live Data Gateway
Use the CData Connector for Oracle Eloqua in APOS Live Data Gateway to build Semantic Layer Views for Oracle Eloqua data.
-
Configure the CData JDBC Driver for SendInBlue in a Connection Pool in Tomcat
Connect to SendInBlue data from a connection pool in Tomcat.
-
Model, Search, and Visualize Live Azure DevOps Data in ThoughtSpot
Use CData Connect AI to connect to live Azure DevOps data for modeling, searching, and visualizing.
-
Natively Connect to Ontraport Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Ontraport data. Leverage the native support for ODBC in PHP.
-
Create Informatica Mappings From/To an ODBC Data Source for Pushbullet
Create an ODBC connection to Pushbullet in Informatica and browse and transfer Pushbullet data.
-
Use the CData ODBC Driver for Typeform from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Typeform to connect to Typeform data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Typeform data in Excel.
-
Create Data Visualizations Based On SAP SuccessFactors LMS Data in Mode
Use CData Connect AI to connect to SAP SuccessFactors LMS Data from Mode and build visualizations using live SAP SuccessFactors LMS data.
-
Getting Started with the CData Power BI Connector for Paylocity
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Paylocity.
-
Use Grok to Talk to Your ShipStation 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 ShipStation data for you.
-
Model, Search, and Visualize Live Highrise Data in ThoughtSpot
Use CData Connect AI to connect to live Highrise data for modeling, searching, and visualizing.
-
Connect to Coinbase Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Coinbase data.
-
Build Agents in Relevance AI with Access to Live Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Kafka data within intelligent agent workflows.
-
Integrate with SAP HANA XS Advanced Data in JReport Designer
Create charts and reports based on SAP HANA XS Advanced data in JReport Designer.
-
Build a Singer.io Tap for Elasticsearch With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Elasticsearch data using the CData Python Connector.
-
How to connect Amazon QuickSight to HBase Data
Create a connection to HBase data in CData Connect AI and insert HBase data into Amazon QuickSight SPICE to build interactive dashboards.
-
Create Jira Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Jira from PowerBI.com to create Power BI Dataflows with real-time data.
-
Extract, Transform, and Load Redis Data in Informatica PowerCenter
Create a simple Workflow for Redis data in Informatica PowerCenter.
-
Use the CData ODBC Driver for Helpscout in Microsoft Power Query
You can use the CData Helpscout ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Helpscout data into Microsoft Power Query.
-
Integrating Boomi Agentstudio with Tavily Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Tavily data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Replicate Google Cloud Storage Data to Multiple Databases via the CData Sync CLI
Replicate Google Cloud Storage data to disparate databases with a single configuration.
-
Integrating OpenCode with NetSuite 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.
-
Access Live Workday Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Workday data from your Excel spreadsheets.
-
Use JayDeBeApi to access ShipEngine Data in Python
Use standard Python scripting and the development environment of your choice to access live ShipEngine data.
-
Getting Started with the CData JDBC Driver for HubDB
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for HubDB.
-
Replicate Scrapfly Data to Multiple Databases
Replicate Scrapfly data to disparate databases with a point-and-click configuration.
-
Migrating data from Pinterest to Google BigQuery using CData SSIS Components.
Easily push Pinterest data to Google BigQuery using the CData SSIS Tasks for Pinterest and Google BigQuery.
-
How to connect to Dynamics CRM Data from Spring Boot
Connect to Dynamics CRM in a Spring Boot Application using the CData JDBC Driver for Dynamics CRM
-
Connect to Live Cloudflare Data in MicroStrategy through CData Connect AI
Create a live connection to Cloudflare Data in CData Connect AI and connect to your Cloudflare data from MicroStrategy.
-
Automated Continuous Zendesk Replication to SQL Server
Use CData Sync for automated, continuous, customizable Zendesk replication to SQL Server.
-
Visualize Impala Data in Sisense
Create an ElastiCube in Sisense app with access to Impala data.
-
Integrating LangGraph with SendPulse Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on SendPulse data within automated workflows.
-
Automated Continuous HBase Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable HBase replication to Apache Kafka.
-
Build a Simple VCL Application for Auth0 Data
How to build a simple VCL Application to view Auth0 data in RAD Studio using the CData ODBC Driver for Auth0.
-
Automated Continuous Sage 200 Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage 200 data replication to OneLake in Microsoft Fabric.
-
Build Dashboards with Sage 300 Data in DBxtra
Create dynamic dashboards and perform analytics based on Sage 300 data in DBxtra.
-
Create Google Tasks Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Google Tasks data access from reports, embedded analytics, and more.
-
Build Apps with Live ChartMogul Data Using the Low-Code Development Platform of Mendix
Connect ChartMogul data with Mendix to build apps using the CData API Driver for JDBC.
-
Import Real-Time Harvest Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Harvest data in ColdFusion.
-
Getting Started with the CData Python Connector for Oracle
Learn to install and license the CData Python Connector and configure a connection to live Oracle data.
-
Build Semantic Layer Views for Email Data in APOS Live Data Gateway
Use the CData Connector for Email in APOS Live Data Gateway to build Semantic Layer Views for Email data.
-
Create Datasets from Authorize.Net in Domo Workbench and Build Visualizations of Authorize.Net Data in Domo
Use the CData Software ODBC Driver for Authorize.Net to create datasets from Authorize.Net data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Epicor Kinetic from a Connection Pool in WebLogic
Use the CData JDBC Driver for Epicor Kinetic to connect to Epicor Kinetic data from Web applications running on WebLogic.
-
Replicate SFTP Data from PowerShell
Write a quick PowerShell script to query SFTP data. Use connectivity to the live data to replicate SFTP data to SQL Server.
-
A PostgreSQL Interface for Google Tasks Data using the CData ODBC Driver
Use the SQL Gateway and Google Tasks ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Mailjet Data in Excel 365 Online (Excel for the web)
Connect to Mailjet data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Connect to and Query Suadeo Data in QlikView over ODBC
Create data visualizations with Suadeo data in QlikView.
-
Migrating data from Printify to Snowflake using CData SSIS Components.
Easily push Printify data to Snowflake using the CData SSIS Tasks for Printify and Snowflake.
-
How to Connect to & Open Okta Data in Microsoft Excel
This article uses the CData ODBC driver for Okta to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Access Freshteam Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Freshteam data from HeidiSQL.
-
A PostgreSQL Interface for Dynamics 365 Business Central Data (MySQL Remoting via JDBC)
Use the Remoting features of the Dynamics 365 Business Central JDBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Apollo Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Apollo data.
-
Automated Continuous Apollo Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Apollo replication to Google Cloud SQL.
-
Build Visualizations of Zoho Recruit Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Recruit data in Birst.
-
Choosing the Best Method to Connect Parquet to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Parquet data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Using the CData Software ODBC Driver for Beeminder in PyCharm
Connect to Beeminder as an ODBC data source in PyCharm using the CData Software ODBC Driver for Beeminder.
-
Replicate SAP HANA XS Advanced Data to Multiple Databases
Replicate SAP HANA XS Advanced data to disparate databases with a point-and-click configuration.
-
Excel Spreadsheet Automation on Datadog Data with the QUERY Formula
Pull data from Datadog, automate spreadsheets, and more with the QUERY formula.
-
How to Connect Greenplum 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 Greenplum data in real time using natural language.
-
How to integrate ElevenLabs with Apache Airflow
Access and process ElevenLabs data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Accelo Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Accelo data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Live Reckon Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Reckon data to Blue Prism using the CData ODBC Driver for Reckon to create automated workflows for repetitive business tasks.