CData Software - Knowledge Base
Recent Articles
-
Build Charts with LinkedIn Data in Clear Analytics
Create dynamic charts and perform analytics based on LinkedIn data in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time EnterpriseDB Data
Use CData Power BI Connectors to visualize EnterpriseDB data in Power BI.
-
How to connect PolyBase to SQL Analysis Services
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SQL Analysis Services data.
-
Design BIRT Reports on Optimizely Data
Provide current Optimizely data to your embedded analytics.
-
Access Parquet Data from MySQL in Amazon QuickSight
Connect to Parquet and build visualizations of Parquet data using a MySQL Connection in Amazon QuickSight.
-
Connect to Active Directory Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Active Directory and the SQL Gateway to access Active Directory data from Google Apps Script.
-
How to connect and process SendPulse data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live SendPulse data.
-
Establish a Live Connection with Microsoft Teams Data using Tableau Bridge
The CData ODBC Driver for Microsoft Teams enables you to integrate live Microsoft Teams data into Tableau Cloud dashboards using the Tableau Bridge.
-
Use CData Connect AI to Access Oracle Service Cloud Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Oracle Service Cloud data in the Power Pivot business intelligence tool.
-
Integrate ServiceNow with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ServiceNow with External Services.
-
Visualize Live Odoo Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Odoo data.
-
Connect to Google Cloud Storage Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Cloud Storage data.
-
Create Apps from SAP Concur Data in Qlik Sense Cloud
Use CData Connect AI to connect to SAP Concur Data and build apps from live SAP Concur data in Qlik Sense Cloud.
-
How to Connect DBeaver to Act-On via a JDBC Driver
Manage Act-On data with visual tools in DBeaver like the query browser.
-
Create Data Visualizations Based On Sugar CRM Data in Mode
Use CData Connect AI to connect to Sugar CRM Data from Mode and build visualizations using live Sugar CRM data.
-
How to work with TaxJar Data in Apache Spark using SQL
Access and process TaxJar Data in Apache Spark using the CData Software JDBC Driver.
-
Build Dashboards with Tally Data in Dundas BI
Create dynamic dashboards and perform analytics based on Tally data in Dundas BI.
-
Query Planio Data as a MySQL Database in Node.js
Execute MySQL queries against Planio data from Node.js.
-
Integrate with Toggl Data in JReport Designer
Create charts and reports based on Toggl data in JReport Designer.
-
Build Automated Workflows with Live Lakebase Data in Workato
Use CData Connect AI to connect to live Lakebase data and build automated workflows in Workato.
-
Replicate Azure DevOps Data to Multiple Databases
Replicate Azure DevOps data to disparate databases with a point-and-click configuration.
-
Integrate Cline with Live XML Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live XML data from within your IDE.
-
How to load Salesloft data into Elasticsearch via Logstash
Introducing a simple method to load Salesloft data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Build Automated Workflows with Live Zendesk Data in Workato
Use CData Connect AI to connect to live Zendesk data and build automated workflows in Workato.
-
Integrating Claude Code CLI with ZarMoney 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.
-
Create Dashboards and Visualize Live Discord Data in Geckoboard
Use CData Connect AI to connect to live Discord data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
How to Access Live Amazon S3 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Amazon S3 enables you to integrate Amazon S3 data into workflows built using Microsoft Power Automate Desktop.
-
Use the CData Software ODBC Driver for Zuora in MicroStrategy Web
Connect to Zuora data in MicroStrategy Web using the CData Software ODBC Driver for Zuora.
-
Validate Microsoft Planner Data with QuerySurge
Access and validate Microsoft Planner data in QuerySurge using the CData JDBC Driver.
-
Connect to MessageBird Data from a Connection Pool in JBoss
Integrate MessageBird data into Java servlets: Use the Management Console in JBoss to install the MessageBird JDBC Driver.
-
ETL Zoho Recruit in Oracle Data Integrator
This article shows how to transfer Zoho Recruit data into a data warehouse using Oracle Data Integrator.
-
Build Google Contacts-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Google Contacts data without replication.
-
Connect to Quickbase Data in NetBeans
Connect to Quickbase data in NetBeans with the data source configuration wizard.
-
Use the CData Software ODBC Driver for ZohoInvoice in MicroStrategy Desktop
Connect to ZohoInvoice data in MicroStrategy Desktop using the CData Software ODBC Driver for ZohoInvoice.
-
Explore Geographical Relationships in SAP Ariba Source Data with Power Map
Create data visualizations with SAP Ariba Source data in Power Map.
-
Getting Started with the CData ADO.NET Provider for HCL Domino
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for HCL Domino.
-
Connect to Greenplum Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Greenplum data.
-
Load SQL Server Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SQL Server data to a database.
-
Manage Sugar CRM Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Sugar CRM.
-
Build MVC Applications with Connectivity to FHIR Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access FHIR from an ASP.NET MVC application.
-
Integrating LangChain with OneNote Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on OneNote data within automated workflows.
-
Automated Continuous Paylocity Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Paylocity replication to Azure SQL Database.
-
Load SharePoint Excel Services Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load SharePoint Excel Services data to a database.
-
How to Connect the Power BI Service to SharePoint: Complete Guide
Connect to the CData Software Power BI Connector for SharePoint from PowerBI.com to provide real-time SharePoint data across the organization.
-
How to Work with Microsoft Ads Data in AWS Glue Jobs Using JDBC
Connect to Microsoft Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Connect Jumpseller 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 Jumpseller data in real time using natural language.
-
Integrating OpenCode with OData services 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.
-
Creating Amazon Marketplace-Connected Applications in Unqork
You can use CData Connect AI to feed Amazon Marketplace data to Unqork and build custom business apps.
-
How to Access Live Office 365 Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Office 365 enables you to integrate Office 365 data into workflows built using Microsoft Power Automate Desktop.
-
Prepare, Blend, and Analyze Square Data in Alteryx Designer (ODBC)
Build workflows to access live Square data for self-service data analytics.
-
Use Dash to Build to Web Apps on Authorize.Net Data
Create Python applications that use pandas and Dash to build Authorize.Net-connected web apps.
-
How to Connect to & Open Tavily Data in Microsoft Excel
This article uses the CData ODBC driver for Tavily to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create SendGrid-Connected Applications in Appsmith
Connect to SendGrid Data via CData Connect AI in Appsmith and create custom business applications with real-time access to SendGrid data.
-
How to Connect to Live Azure DevOps Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Azure DevOps data for you.
-
Build BigQuery Visualizations in Tableau Desktop
Use CData Connect AI to connect to live BigQuery data and build visualizations in Tableau.
-
Use the CData Software ODBC Driver for Typeform in MicroStrategy Desktop
Connect to Typeform data in MicroStrategy Desktop using the CData Software ODBC Driver for Typeform.
-
Connect to TaxJar Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for TaxJar and the SQL Gateway to access TaxJar data from Google Apps Script.
-
How to Use a Microsoft Access Database to Update Dropbox Data in Real Time
Update Dropbox data by creating a linked table in Microsoft Access with the CData Dropbox ODBC Driver.
-
How to Connect to Live Yelp Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Yelp data for you.
-
Use Biml to Build SSIS Tasks to Replicate Twitter Ads Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Twitter Ads data to SQL Server.
-
How to Connect Zoho Creator 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 Zoho Creator data in real time using natural language.
-
Automated REST Data Replication to Teradata
Use CData Sync to Customize and automate REST data replication to Teradata.
-
How to Seamlessly Import OnePageCrm Data into IBM SPSS Modeler
Integrate OnePageCrm data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Live Spark Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Spark from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Spark data.
-
How to publish and share Reckon Accounts Hosted Data dashboards with Tableau Server
The CData ODBC driver for Reckon Accounts Hosted enables you integrate Reckon Accounts Hosted data into Tableau dashboards.
-
Integrating LangChain with Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Authorize.Net data within automated workflows.
-
Write a Simple Go Application to work with Twitter Ads Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Twitter Ads data.
-
Integrating Claude Code CLI with SparkPost 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.
-
Enable the SAS Data Sets JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAS Data Sets data.
-
Create Dynamic Authorize.Net Grids Using the Infragistics XamDataGrid
Learn how you can connect Authorize.Net to Infragistics XamDataGrid to build dynamic grids.
-
Automated Continuous Bannerbear Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Bannerbear replication to IBM DB2.
-
Create Data Visualizations in Cognos BI with Codat Data
Access Codat data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Create Bullhorn CRM-Connected Business Apps in AppSheet
Connect to Bullhorn CRM Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Bullhorn CRM data.
-
Create Google Ad Manager-Connected Applications in Appsmith
Connect to Google Ad Manager Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Ad Manager data.
-
How to Access Square Data Using Entity Framework
This article shows how to access Square data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Build AI/ML Models with Live Freshsales Data using Dataiku
Connect Freshsales Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous Sybase Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Sybase replication to Google Cloud SQL.
-
Connect to SAS xpt Data in Claris FileMaker Pro
Use the CData ODBC Driver for SAS xpt in FileMaker Pro to connect to SAS xpt and work with SAS xpt data in your FileMaker applications.
-
Natively Connect to Bugsnag Data in PHP
The CData ODBC driver for Bugsnag enables you to create PHP applications with connectivity to Bugsnag data. Leverage the native support for ODBC in PHP.
-
Publish GitLab-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live GitLab data.
-
Use the CData Software ODBC Driver for Azure Data Lake Storage in MicroStrategy
Connect to Azure Data Lake Storage data in MicroStrategy Developer using the CData Software ODBC Driver for Azure Data Lake Storage.
-
How to connect to Nuclia Data from IntelliJ
Integrate connectivity to Nuclia data with wizards in IntelliJ.
-
Automate ShipEngine Data Replication to Azure Data Lake
Use CData Sync to customize and automate ShipEngine data replication to Azure Data Lake.
-
Connect to Redshift Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Redshift and the SQL Gateway to access Redshift data from Google Apps Script.
-
Create Dynamic HBase Grids Using the Infragistics XamDataGrid
Learn how you can connect HBase to Infragistics XamDataGrid to build dynamic grids.
-
Integrate Cursor with Live Couchbase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Couchbase data from within the editor.
-
Configure the CData JDBC Driver for Greenhouse in a Connection Pool in Tomcat
Connect to Greenhouse data from a connection pool in Tomcat.
-
Automated Reply.io Data Replication to Teradata
Use CData Sync to Customize and automate Reply.io data replication to Teradata.
-
PayPal Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to PayPal data through CData Connect AI using different applications and tools.
-
Integrate Adobe Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Adobe Analytics with External Services.
-
ETL Avro in Oracle Data Integrator
This article shows how to transfer Avro data into a data warehouse using Oracle Data Integrator.
-
Publish Basecamp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Basecamp data.
-
Deploy the ADO.NET Provider for Anaplan on an SSRS Report Server
Connect to Anaplan data from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrate Impala Data in the Pentaho Report Designer
Publish reports based on Impala data in the Pentaho BI tool.
-
Build TigerGraph-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live TigerGraph data.
-
Validate Close Data with QuerySurge
Access and validate Close data in QuerySurge using the CData JDBC Driver.
-
Connect to Supabase Data in Ruby
Connect to Supabase data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Prepare, Blend, and Analyze Dynamics CRM Data in Alteryx Designer (ODBC)
Build workflows to access live Dynamics CRM data for self-service data analytics.
-
How to connect to Drip Data in DBVisualizer
Integrate Drip data with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live Smartsheet Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Smartsheet data from your Excel spreadsheets.