CData Software - Knowledge Base
Recent Articles
-
Integrating Kiro with Oracle Eloqua Reporting 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.
-
Automate CockroachDB Integration Tasks from PowerShell
Are you in search of a quick and easy way to access CockroachDB data from PowerShell? This article demonstrates how to utilize the CockroachDB Cmdlets for tasks like connecting to CockroachDB data, automating operations, downloading data, and more.
-
Create Bright Data-Connected Nintex Workflows
Use CData Connect AI to connect to Bright Data Data from Nintex Workflow Cloud and build custom workflows using live Bright Data data.
-
Visualize MarkLogic Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to MarkLogic data.
-
How to connect PolyBase to GitLab
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live GitLab data.
-
Connect to NetSuite Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for NetSuite data in Airbyte.
-
How to connect to CockroachDB Data with Squirrel SQL client
Connect to CockroachDB data and execute queries in the Squirrel SQL Client.
-
Query Rebilly Data as a MySQL Database in Node.js
Execute MySQL queries against Rebilly data from Node.js.
-
Access Live Oracle Service Cloud Data in AWS Lambda
Connect to live Oracle Service Cloud data in AWS Lambda using the CData JDBC Driver.
-
Getting Started with the CData Tableau Connector for Oracle Eloqua Reporting
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Oracle Eloqua Reporting.
-
Use the CData Software JDBC Driver for SAP Netweaver Gateway in MicroStrategy
Connect to SAP Netweaver Gateway data in MicroStrategy Developer using the CData Software JDBC Driver for SAP Netweaver Gateway.
-
A PostgreSQL Interface for Shippo Data using the CData ODBC Driver
Use the SQL Gateway and Shippo ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to use SQLAlchemy ORM to access PagerDuty Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of PagerDuty data.
-
Visualize JSON Services in Tableau
The CData ODBC driver for JSON enables you integrate JSON services into Tableau dashboards.
-
Getting Started with the CData SSIS Components for Mailjet
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Mailjet.
-
Create a Data Access Object for Azure Table Data using JDBI
A brief overview of creating a SQL Object API for Azure Table data in JDBI.
-
Integrating LlamaIndex with Oracle Sales Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Oracle Sales data in real time.
-
Automated Continuous Dynamics 365 Business Central Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Dynamics 365 Business Central replication to Apache Cassandra.
-
Getting Started with the CData ADO.NET Provider for SFTP
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for SFTP.
-
Back Up Amazon S3 data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Amazon S3. In this article, we will employ an SSIS workflow to populate a database with Amazon S3 data data.
-
Integrate Hive with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Hive with External Services.
-
Access Live Dynamics NAV Data in TIBCO Data Virtualization
Use the Dynamics NAV Tibco DV Adapter to create a Dynamics NAV data data source in TIBCO Data Virtualization Studio and gain access to live Dynamics NAV data from your TDV Server.
-
Connect to ZohoExpense Data in RapidMiner
Integrate ZohoExpense data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect to Live WordPress 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 WordPress data without replication.
-
Connect to Xero Data in Ruby
Connect to Xero data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Establish a Live Connection with Timely Data using Tableau Bridge
The CData ODBC Driver for Timely enables you to integrate live Timely data into Tableau Cloud dashboards using the Tableau Bridge.
-
Visualize Live ADP Data in the Power BI Service
Use CData Connect AI to connect to live ADP data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData ODBC Driver for NetSuite
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for NetSuite.
-
Create SSAS Tabular Models from Float Data
How to build a SQL Server Analysis Service Tabular Model from Float data using CData drivers.
-
Connect to NASA Data in Aqua Data Studio
Access NASA data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create IBM Informix-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to IBM Informix Data from Klipfolio and build custom visualizations using live IBM Informix data.
-
Create Power BI Reports on Real-Time ZohoMarketingHub Data
Use the CData ODBC Driver for ZohoMarketingHub to visualize ZohoMarketingHub data in Power BI Desktop.
-
Use Agno to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Microsoft Teams data for you.
-
How to connect to Chargebee Data in DBVisualizer
Integrate Chargebee data with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to Epicor Kinetic Data from AWS Glue
Use CData Connect AI to gain access to live Epicor Kinetic data from your AWS Glue jobs.
-
Visualize Live Microsoft Dataverse Data in the Power BI Service
Use CData Connect AI to connect to live Microsoft Dataverse data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating LangChain with GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on GraphQL data within automated workflows.
-
Load Microsoft Ads Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Ads data to a database.
-
How to Connect to & Open Parquet Data in Microsoft Excel
This article uses the CData ODBC driver for Parquet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Zoho Inventory Data in DBArtisan
Use wizards in DBArtisan to configure Zoho Inventory data as a data source.
-
Integrating Antigravity CLI with SpaceX data via CData CLI
Connect SpaceX data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Connect to Redshift Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Redshift data.
-
Use the CData Software ODBC Driver for Drip in MicroStrategy Desktop
Connect to Drip data in MicroStrategy Desktop using the CData Software ODBC Driver for Drip.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Okta
Provide connectivity to Okta data through an SAP BusinessObjects universe.
-
Build Dashboards with GetResponse Data in DBxtra
Create dynamic dashboards and perform analytics based on GetResponse data in DBxtra.
-
Create Dynamic Azure Analysis Services Grids Using the Infragistics XamDataGrid
Learn how you can connect Azure Analysis Services to Infragistics XamDataGrid to build dynamic grids.
-
How to publish and share LaunchDarkly Data dashboards with Tableau Server
The CData ODBC driver for LaunchDarkly enables you integrate LaunchDarkly data into Tableau dashboards.
-
Integrate Oracle Eloqua with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Oracle Eloqua with External Services.
-
DataBind BenchmarkEmail Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide BenchmarkEmail data to a chart.
-
Create SSAS Tabular Models from Salesforce Pardot Data
How to build a SQL Server Analysis Service Tabular Model from Salesforce Pardot data using CData drivers.
-
Getting Started with the CData Excel Add-In for Landbot
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Landbot.
-
Connect to Act-On Data from PowerBuilder via JDBC
This article demonstrates how to access Act-On data from PowerBuilder using the Act-On JDBC Driver.
-
Build Greenhouse-Connected Apps in Choreo
Use CData Connect AI to connect to Greenhouse Data from Choreo and build custom apps using live Greenhouse data.
-
Visualize Live Moosend Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Moosend data.
-
Integrating Codex with Google Campaign Manager 360 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.
-
Microsoft OneDrive Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft OneDrive data through CData Connect AI using different applications and tools.
-
Build Semantic Layer Views for Bannerbear Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Bannerbear data.
-
Replicate Multiple Zoho Projects Accounts
Replicate multiple Zoho Projects accounts to one or many databases.
-
Easily Integrate FormSite Data in Lazarus Pascal IDE
Learn how to easily integrate live FormSite data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Integrate with Adobe Target Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Adobe Target data to a JSON file on disk.
-
Search External Google Search Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Search results to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Search Results objects that you can access from apps and the dashboard.
-
EmailOctopus Reporting in OBIEE with the EmailOctopus JDBC Driver
Deploy the EmailOctopus JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrate Google's Antigravity Agent with Live Apollo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Apollo data using the Model Context Protocol.
-
Trigger Google Ad Manager IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Google Ad Manager with standard wizards in Logic Apps.
-
Natively Connect to Omnisend Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Omnisend data. Leverage the native support for ODBC in PHP.
-
How to integrate CockroachDB with Apache Airflow
Access and process CockroachDB data in Apache Airflow using the CData JDBC Driver.
-
How to Connect to Live Redshift Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Redshift data for you.
-
Connect to SAP Business One Data from a Connection Pool in JBoss
Integrate SAP Business One data into Java servlets: Use the Management Console in JBoss to install the SAP Business One JDBC Driver.
-
Prepare, Blend, and Analyze Blackbaud FE NXT Data in Alteryx Designer (ODBC)
Build workflows to access live Blackbaud FE NXT data for self-service data analytics.
-
How to update Workday from Excel
This article explains how to transfer data from Excel to Workday using the Excel Add-In for Workday.
-
How to work with Zoho Recruit Data in Apache Spark using SQL
Access and process Zoho Recruit Data in Apache Spark using the CData Software JDBC Driver.
-
Automate Optimizely Data Replication to SAP HANA
Use CData Sync to customize and automate Optimizely data replication to SAP HANA.
-
Build a PostgreSQL Interface for ChartMogul Data using the CData JDBC Driver
Use the Remoting features of the ChartMogul JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use CData Connect AI to Access SingleStore Data in Microsoft Power Pivot
Use CData Connect AI to connect to live SingleStore data in the Power Pivot business intelligence tool.
-
Automated Continuous WordPress Replication to Databricks
Use CData Sync for automated, continuous, customizable WordPress replication to Databricks.
-
Connect to Drip Data from a Connection Pool in JBoss
Integrate Drip data into Java servlets: Use the Management Console in JBoss to install the Drip JDBC Driver.
-
Build Adobe Experience Manager-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Adobe Experience Manager data.
-
Use Microsoft Copilot Studio to talk to your Freshservice Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Freshservice data for you.
-
Analyze Live SparkPost Data in SAS Viya
Use CData Connect AI to connect to SparkPost data from SAS Viya and deploy self-service analytics using live SparkPost data.
-
Publish Reports with Azure DevOps Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Azure DevOps data.
-
DataBind Controls to MySQL Data in Delphi
DataBind to MySQL data in Delphi with standard data access components and controls.
-
Connect to WooCommerce Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time WooCommerce data using standard SQL.
-
Excel Spreadsheet Automation on AgileCRM Data with the QUERY Formula
Pull data from AgileCRM, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Instantly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Instantly data. Leverage the pyodbc module for ODBC in Python.
-
Rapidly Develop Shopify-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Shopify.
-
Analyze SAP BusinessObjects BI Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP BusinessObjects BI data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
How to connect to Sage Intacct Data with Squirrel SQL client
Connect to Sage Intacct data and execute queries in the Squirrel SQL Client.
-
Automated Continuous Adobe Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Adobe Analytics replication to Amazon Redshift.
-
Create Informatica Mappings From/To an ODBC Data Source for Google Analytics
Create an ODBC connection to Google Analytics in Informatica and browse and transfer Google Analytics data.
-
Automated Continuous BenchmarkEmail Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to PostgreSQL.
-
Natively Connect to Cloudant Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cloudant data. Leverage the native support for ODBC in PHP.
-
Connect to JobNimbus Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for JobNimbus and the SQL Gateway to access JobNimbus data from Google Apps Script.
-
Connect to Dynamics 365 Business Central Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Dynamics 365 Business Central data in Airbyte.
-
Automated Continuous Discourse Replication to MySQL
Use CData Sync for automated, continuous, customizable Discourse replication to MySQL.
-
Use Biml to Build SSIS Tasks to Replicate Microsoft Exchange Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Microsoft Exchange data to SQL Server.
-
Connect to SAP HANA XS Advanced Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live SAP HANA XS Advanced data.
-
Connecting Mastra with Jira 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 Jira data, no replication required.
-
How to integrate Metabase with Office 365 Data
Use CData Connect AI to connect to live Office 365 data and create an interactive dashboard in Metabase from Office 365 data.
-
Use Claude to Talk to Your Paylocity Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Paylocity data for you.
-
How to Easily Query Klaviyo Data in OpenOffice Base
Connect to Klaviyo data in OpenOffice Base using the CData ODBC Driver for Klaviyo and generate reports with live data insights.