CData Software - Knowledge Base
Recent Articles
-
Access LDAP Objects from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live LDAP from HeidiSQL.
-
Build TigerGraph-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to TigerGraph and build web apps with connectivity to live TigerGraph.
-
Create Datasets from Microsoft Ads in Domo Workbench and Build Visualizations of Microsoft Ads Data in Domo
Use the CData Software ODBC Driver for Microsoft Ads to create datasets from Microsoft Ads in Domo Workbench and then build visualizations in the Domo service.
-
How to connect to Greenplum Data from IntelliJ
Integrate connectivity to Pivotal GreenPlum with wizards in IntelliJ.
-
Connect and Query Live BigCommerce Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live BigCommerce into Databricks
-
Replicate Multiple ZohoSubscriptions Accounts via the CData Sync CLI
Replicate multiple ZohoSubscriptions accounts to one or many databases.
-
Publish Crystal Reports on Box Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Box.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Azure Data Catalog
Provide connectivity to Azure Data Catalog through an SAP BusinessObjects universe.
-
Build Semantic Layer Views for SAP BusinessObjects BI Data in APOS Live Data Gateway
Use the CData Connector for SAP BusinessObjects BI in APOS Live Data Gateway to build Semantic Layer Views for SAP BusinessObjects BI.
-
Analyze Coinbase Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Coinbase in Microsoft R Open.
-
How to Visualize ConstantContact Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConstantContact in Python.
-
Integrate ServiceNow Data in Pentaho Data Integration
Build ETL pipelines based on ServiceNow in the Pentaho Data Integration tool.
-
Visualize Beeminder Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Beeminder.
-
Access Gorgias Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Gorgias from your Oracle system.
-
Visualize Live Pipeline CRM Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pipeline CRM using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Semantic Layer Views for Neo4J Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Neo4J.
-
Sugar CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Sugar CRM through CData Connect AI using different applications and tools.
-
Migrating data from Dynamics 365 Business Central to Snowflake using CData SSIS Components.
Easily push Dynamics 365 Business Central to Snowflake using the CData SSIS Tasks for Dynamics 365 Business Central and Snowflake.
-
Integrating OpenCode Terminal with Billsby 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.
-
How to Access Qualaroo Data Using Entity Framework
This article shows how to access Qualaroo using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with Notion Data in LINQPad
Execute LINQ queries to Notion in LINQPad.
-
Build Oracle Service Cloud-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Oracle Service Cloud to explore live Oracle Service Cloud Data in GitHub Copilot to assist with building Oracle Service Cloud-powered applications.
-
Automated Continuous Splunk Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Splunk replication to Amazon Redshift.
-
Query Office 365 Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Microsoft Office 365 and perform CRUD operations on Office 365 from Node.js.
-
Create Data Visualizations in Cognos BI with Impala Data
Access Apache Impala as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to Zuora Data in DBeaver
Use the CData ODBC Driver to connect to Zuora in DBeaver.
-
A PostgreSQL Interface for IBM Informix Data using the CData ODBC Driver
Use the SQL Gateway and IBM Informix ODBC Driver to create a PostgreSQL entry-point for data access.
-
Access Live Dynamics 365 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Dynamics 365 from your Excel spreadsheets.
-
Automated Continuous Basecamp Replication to MongoDB
Use CData Sync for automated, continuous, customizable Basecamp replication to MongoDB.
-
Build AI Agents with Redshift 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 Redshift through CData Connect AI.
-
Build Semantic Layer Views for Marketo Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Marketo.
-
Build a Singer.io Tap for Azure DevOps With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Azure DevOps data using
-
Build Charts with Contentful Data in Clear Analytics
Create dynamic charts and perform analytics based on Contentful in Clear Analytics.
-
How to Visualize Teradata Data in Python with pandas
Use pandas and other modules to analyze and visualize live Teradata in Python.
-
A PostgreSQL Interface for Phoenix Data (MySQL Remoting via JDBC)
Use the Remoting features of the Phoenix JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Tableau Connector for IBM Informix
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for IBM Informix.
-
Connect to BigQuery Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google BigQuery.
-
How to publish and share Lakebase Data dashboards with Tableau Server
The CData ODBC driver for Lakebase enables you integrate Lakebase into Tableau dashboards.
-
Publish Reports with LinkedIn Ads Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date LinkedIn Ads.
-
Build Dashboards with Ontraport Data in Dundas BI
Create dynamic dashboards and perform analytics based on Ontraport in Dundas BI.
-
Automated Continuous Microsoft Exchange Replication to Vertica
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Vertica.
-
Bind Live MarkLogic Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live MarkLogic data
-
Integrating Claude Code CLI with Qualaroo 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 SAP Netweaver Gateway Data from HeidiSQL
Use CData Connect AI to connect to and query live SAP Netweaver Gateway from HeidiSQL.
-
Connect to Raisers Edge NXT Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Raisers Edge NXT as an External Source in Dremio.
-
Load Deel Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Deel to a database.
-
Connect to Slack Data in ACL Analytics
Connect to Slack via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Slack.
-
Use CData Connect AI to Access Avro Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Apache Avro in the Power Pivot business intelligence tool.
-
Connect to Oracle SCM Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Oracle SCM using standard SQL.
-
Connect to Salesforce Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Salesforce as an External Source in Dremio.
-
Connect to Tavily Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Tavily as an External Source in Dremio.
-
How to Query Live Qualaroo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Qualaroo data in natural language using Python.
-
How to Connect to Live MariaDB 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 MariaDB for you.
-
Query Reply.io Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Reply.io from Node.js.
-
Build Dashboards with Samanage Data in Dundas BI
Create dynamic dashboards and perform analytics based on Samanage in Dundas BI.
-
Easily Integrate Quickbase Data in Lazarus Pascal IDE
Learn how to easily integrate live Quickbase in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Shortcut Data Replication to SAP HANA
Use CData Sync to customize and automate Shortcut replication to SAP HANA.
-
Integrate ElevenLabs Data in Pentaho Data Integration
Build ETL pipelines based on ElevenLabs in the Pentaho Data Integration tool.
-
Automated Continuous FreeAgent Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable FreeAgent replication to OneLake in Microsoft Fabric.
-
Enable the PolarTeamPro JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with PolarTeamPro.
-
Build Dashboards with Close Data in DBxtra
Create dynamic dashboards and perform analytics based on Close in DBxtra.
-
Replicate Avalara AvaTax Data from PowerShell
Write a quick PowerShell script to query Avalara AvaTax. Use connectivity to the live data to replicate Avalara AvaTax to SQL Server.
-
Import Real-Time Google Spanner Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Google Spanner in ColdFusion.
-
DataBind Controls to Kintone Data in Delphi
DataBind to Kintone in Delphi with standard data access components and controls.
-
Automate Greenhouse Data Replication to Azure Data Lake
Use CData Sync to customize and automate Greenhouse replication to Azure Data Lake.
-
Integrate Cline with Live Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Sybase IQ from within your IDE.
-
How to connect to SAS xpt Data from IntelliJ
Integrate connectivity to SAS XPORT with wizards in IntelliJ.
-
Validate Excel Online Data with QuerySurge
Access and validate Microsoft Excel Online in QuerySurge using the CData JDBC Driver.
-
Build Dashboards with Discourse Data in Dundas BI
Create dynamic dashboards and perform analytics based on Discourse in Dundas BI.
-
Build Confluence-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Confluence to explore live Confluence Data in Gemini Code Assist to assist with building Confluence-powered applications.
-
Connect to SAP Data in NetBeans
Connect to SAP ERP/NetWeaver in NetBeans with the data source configuration wizard.
-
Integrating Codex CLI with Acumatica ERP 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.
-
Connecting Agentforce with LinkedIn Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your LinkedIn for you.
-
Automated Continuous AlloyDB Replication to SingleStore
Use CData Sync for automated, continuous, customizable AlloyDB replication to SingleStore.
-
Integrate with LinkedIn Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LinkedIn to a JSON file on disk.
-
DataBind Anaplan Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Anaplan with the DevExpress Windows Forms and Web controls to provide Anaplan to a chart.
-
How to connect to ZohoSubscriptions Data in DBVisualizer
Integrate ZohoSubscriptions with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Outreach.io Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Outreach.io Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to Apollo Data from a Connection Pool in Jetty
The Apollo JDBC Driver supports connection pooling: This article shows how to connect faster to Apollo from Web apps in Jetty.
-
Migrating data from PabblySubscriptions to Snowflake using CData SSIS Components.
Easily push PabblySubscriptions to Snowflake using the CData SSIS Tasks for PabblySubscriptions and Snowflake.
-
Query Salesforce Data 360 Data in ColdFusion
Write standard ColdFusion data access code to connect to Salesforce Data 360.
-
Use Biml to Build SSIS Tasks to Replicate Opsgenie Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Opsgenie to SQL Server.
-
Access Live MailerSend Data in AWS Lambda (with IntelliJ IDEA)
Connect to live MailerSend in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Establish a Live Connection with Pinterest Data using Tableau Bridge
The CData ODBC Driver for Pinterest enables you to integrate live Pinterest into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Automated Oracle-Connected Workflows in Zapier
Use CData Connect AI to connect to live Oracle Database and build automated workflows in Zapier.
-
Prepare, Blend, and Analyze Oracle SCM Data in Alteryx Designer (ODBC)
Build workflows to access live Oracle SCM for self-service data analytics.
-
Query Live Salesforce 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 Salesforce & Force.com directly from the development environment.
-
Automated Continuous Snapchat Ads Replication to SQLite
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to SQLite.
-
Connect to OData Services in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to Work with PDFMonkey Data in AWS Glue Jobs Using JDBC
Connect to PDFMonkey from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Build Charts with Mailgun Data in Clear Analytics
Create dynamic charts and perform analytics based on Mailgun in Clear Analytics.
-
Configure the CData JDBC Driver for Spark in a Connection Pool in Tomcat
Connect to Apache Spark SQL from a connection pool in Tomcat.
-
How to connect Amazon QuickSight to Azure Synapse Data
Create a connection to Azure Synapse in CData Connect AI and insert Azure Synapse into Amazon QuickSight SPICE to build interactive dashboards.
-
Back Up CapsuleCRM 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 CapsuleCRM data.
-
Enable the Calendly JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Calendly.
-
Visualize Sybase Data in TIBCO Spotfire through ADO.NET
Integrate Sybase into dashboards in TIBCO Spotfire.
-
Automated Continuous Raisers Edge NXT Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Azure SQL Database.
-
How to connect to PingOne Data in DBVisualizer
Integrate PingOne with visual data analysis tools and data connection wizards in DBVisualizer
-
Create Data Visualizations in Cognos BI with REST Data
Access REST as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Query Salesforce CRM Analytics Data in MySQL Workbench
Execute MySQL queries against live Salesforce CRM Analytics from MySQL Workbench.