CData Software - Knowledge Base
Recent Articles
-
Moving Data from Shippo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Shippo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Create Flowlu Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Flowlu data access from reports, embedded analytics, and more.
-
How to connect to Yelp Data with Squirrel SQL client
Connect to Yelp data and execute queries in the Squirrel SQL Client.
-
Build Semantic Layer Views for PingOne Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for PingOne data.
-
DataBind Certinia Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Certinia with the DevExpress Windows Forms and Web controls to provide Certinia data to a chart.
-
Publish Oracle Eloqua Reporting-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Oracle Eloqua Reporting data.
-
Automated Continuous Webflow Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Webflow replication to Apache Cassandra.
-
Integrate Open WebUI with Live Redshift Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Redshift data from within the chat interface.
-
Build Semantic Layer Views for Shortcut Data in APOS Live Data Gateway
Use the CData Connector for Shortcut in APOS Live Data Gateway to build Semantic Layer Views for Shortcut data.
-
Publish Crystal Reports on Dynamics NAV Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Dynamics NAV data.
-
Build a Singer.io Tap for SAS xpt With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SAS xpt data using the CData Python Connector.
-
How to connect Amazon QuickSight to Airtable Data
Create a connection to Airtable data in CData Connect AI and insert Airtable data into Amazon QuickSight SPICE to build interactive dashboards.
-
View Reports on Real-Time QuickBooks Online Data in Power BI Report Server
Use the CData ODBC Driver for QuickBooks Online to visualize QuickBooks Online data in Power BI Desktop and then publish them to Power BI Report Server.
-
Access Live Intercom Data in AWS Lambda
Connect to live Intercom data in AWS Lambda using the CData JDBC Driver.
-
Visualize SAP ByDesign Data in TIBCO Spotfire through ADO.NET
Integrate SAP ByDesign data into dashboards in TIBCO Spotfire.
-
Create Datasets from Mocean in Domo Workbench and Build Visualizations of Mocean Data in Domo
Use the CData Software ODBC Driver for Mocean to create datasets from Mocean data in Domo Workbench and then build visualizations in the Domo service.
-
Build AI/ML Models with Live Sybase Data using Dataiku
Connect Sybase Data with Dataiku using the CData JDBC Driver for Sybase.
-
Automated Continuous Jira Assets Replication to MongoDB
Use CData Sync for automated, continuous, customizable Jira Assets replication to MongoDB.
-
Publish Reports with PayPal Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date PayPal data.
-
Access Live MariaDB Data in TIBCO Data Virtualization
Use the MariaDB Tibco DV Adapter to create a MariaDB data data source in TIBCO Data Virtualization Studio and gain access to live MariaDB data from your TDV Server.
-
Connecting GenSpark with MYOB AccountRight Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to MYOB AccountRight data without any replication or custom integration required.
-
How to Seamlessly Import Email Data into IBM SPSS Modeler
Integrate Email data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrating Claude Code CLI with Insightly 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.
-
Design BIRT Reports on Hive Data
Provide current Hive data to your embedded analytics.
-
Back Up eBay Analytics data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for eBay Analytics. In this article, we will employ an SSIS workflow to populate a database with eBay Analytics data data.
-
Connect to Zoho Projects Data in JRuby
Create a simple JRuby app with access to live Zoho Projects data.
-
View Reports on Real-Time PostgreSQL Data in Power BI Report Server
Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL data in Power BI Desktop and then publish them to Power BI Report Server.
-
Replicate FreeAgent Data to Multiple Databases
Replicate FreeAgent data to disparate databases with a point-and-click configuration.
-
Connect to Bullhorn CRM Data in Ruby
Connect to Bullhorn CRM data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Live LinkedIn Ads Data in SAS Viya
Use CData Connect AI to connect to LinkedIn Ads data from SAS Viya and deploy self-service analytics using live LinkedIn Ads data.
-
How to integrate Workday with Apache Airflow
Access and process Workday data in Apache Airflow using the CData JDBC Driver.
-
Connect to Jira Assets Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Jira Assets.
-
Connect to Oracle Eloqua Data in DBArtisan
Use wizards in DBArtisan to configure Oracle Eloqua data as a data source.
-
Access Simplesat Data from MySQL in PHP
Connect to Simplesat through the standard MySQL libraries in PHP.
-
Build AI Agents with Zoho Creator 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 Zoho Creator data through CData Connect AI.
-
Use Claude to Talk to Your Greenhouse 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 Greenhouse data for you.
-
Integrating Claude Code with Authorize.Net Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Authorize.Net data within assisted coding and automated development workflows.
-
Access Live Vercel Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Vercel data into the statistical analysis tools available in SAS JMP. This article shows how to use Vercel data in the Graph Builder and Query Builder.
-
Build QuickBooks Time Visualizations in Tableau Desktop
Use CData Connect AI to connect to live QuickBooks Time data and build visualizations in Tableau.
-
Replicate Freshservice Data from PowerShell
Write a quick PowerShell script to query Freshservice data. Use connectivity to the live data to replicate Freshservice data to SQL Server.
-
How to Connect to Live Oracle Service Cloud Data from OpenAI Python Applications (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable OpenAI-powered Python applications to securely read and take actions on your Oracle Service Cloud data through natural language.
-
Publish Dropbox-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Dropbox data.
-
Manage FHIR Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FHIR.
-
Connect to Shopify Data from Crystal Reports
Use CData Connect AI to connect to and report on live Shopify data from Crystal Reports.
-
Access Exa Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Exa data from your Oracle system.
-
ETL Sentry in Oracle Data Integrator
This article shows how to transfer Sentry data into a data warehouse using Oracle Data Integrator.
-
How to integrate Metabase with Shortcut Data
Use CData Connect AI to connect to live Shortcut data and create an interactive dashboard in Metabase from Shortcut data.
-
Visualize Amazon S3 Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Amazon S3 data.
-
Connect to Planio in SpagoBI
Create reports featuring live Planio data in SpagoBI Studio. Host Planio reports on SpagoBI Server.
-
Use CData Connect AI to Access AgileCRM Data in Microsoft Power Pivot
Use CData Connect AI to connect to live AgileCRM data in the Power Pivot business intelligence tool.
-
Connect to ClickUp Data in DBArtisan
Use wizards in DBArtisan to configure ClickUp data as a data source.
-
Use the CData ODBC Driver for Splunk from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Splunk to connect to Splunk data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Splunk data in Excel.
-
Connecting Agentforce with SFTP 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 SFTP data for you.
-
Build an OLAP Cube in SSAS from MongoDB Data
Establish a connection to MongoDB data data from SQL Server Analysis Services, and use the MongoDB Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous SharePoint Excel Services Replication to Amazon S3
Use CData Sync for automated, continuous, customizable SharePoint Excel Services replication to Amazon S3.
-
Automated Continuous Templated Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Templated replication to Google Cloud SQL.
-
Automated Continuous MailerLite Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable MailerLite replication to Amazon Redshift.
-
Integrating OpenCode with Zoho Recruit 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.
-
Integrate with Placid Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Placid data to a JSON file on disk.
-
Connect to Azure Analysis Services Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Azure Analysis Services data from Filemaker Pro on Mac.
-
Access Live Active Directory Data in TIBCO Data Virtualization
Use the Active Directory Tibco DV Adapter to create a Active Directory data data source in TIBCO Data Virtualization Studio and gain access to live Active Directory data from your TDV Server.
-
Integrating GitHub Copilot with SAS xpt 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.
-
Automated Continuous BambooHR Replication to Amazon S3
Use CData Sync for automated, continuous, customizable BambooHR replication to Amazon S3.
-
Stream LaunchDarkly Data into Apache Kafka Topics
Access and stream LaunchDarkly data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Integrating Gumloop with Teradata Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Teradata data within automated workflows.
-
Choosing the Best Method to Connect Pipedrive to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Pipedrive data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Write a Simple Go Application to work with Snowflake Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Snowflake data.
-
Analyze Zoho Creator Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Zoho Creator data and visualize live Zoho Creator data in Infragistics Reveal.
-
Connecting Mastra with GitLab 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 GitLab data, no replication required.
-
Connect Parquet Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Parquet data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Replicate SAS xpt Data from PowerShell
Write a quick PowerShell script to query SAS xpt data. Use connectivity to the live data to replicate SAS xpt data to SQL Server.
-
Create Data Visualizations in Cognos BI with Clio Data
Access Clio data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrate Brex Data in Pentaho Data Integration
Build ETL pipelines based on Brex data in the Pentaho Data Integration tool.
-
Integrating OpenCode with PayPal 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.
-
Integrate Live Workday Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Workday data to Blue Prism using the CData ODBC Driver for Workday to create automated workflows for repetitive business tasks.
-
Connect to SurveyMonkey Data in DBeaver
Use the CData ODBC Driver to connect to SurveyMonkey data in DBeaver.
-
Feed Flowlu Data into FineReport
How to set Flowlu data as a JDBC data source in FineReport.
-
Build Visualizations of Greenplum Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Greenplum data in Birst.
-
Operational Reporting on ClickUp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote ClickUp data.
-
Visualize MongoDB Data in TIBCO Spotfire through OData
Integrate MongoDB data into dashboards in TIBCO Spotfire.
-
Natively Connect to Billsby Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Billsby data. Leverage the native support for ODBC in PHP.
-
Enable the IBM Informix JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with IBM Informix data.
-
Moving Data from Freshsales to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Freshsales data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Real-Time Slack Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Slack data in ColdFusion.
-
Connect to Onfleet Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Onfleet.
-
How to publish and share Sybase Data dashboards with Tableau Server
The CData ODBC driver for Sybase enables you integrate Sybase data into Tableau dashboards.
-
DataBind Controls to Humanity Data in Delphi
DataBind to Humanity data in Delphi with standard data access components and controls.
-
How to Connect LinkedIn Ads 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 LinkedIn Ads data in real time using natural language.
-
Attio Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Attio facts in real time.
-
Connect to YouTube Analytics Data from Crystal Reports
Use CData Connect AI to connect to and report on live YouTube Analytics data from Crystal Reports.
-
Google Cloud Storage Reporting in OBIEE with the Google Cloud Storage JDBC Driver
Deploy the Google Cloud Storage JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Visualize SingleStore Data in Sisense
Create an ElastiCube in Sisense app with access to SingleStore data.
-
How to Visualize Couchbase Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Couchbase data in Python.
-
Integrating Gumloop with ZohoExpense Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on ZohoExpense data within automated workflows.
-
Consume SQL Analysis Services OData Feeds in PowerBuilder
This article demonstrates how to consume SQL Analysis Services data as OData feeds from PowerBuilder using the API Server.
-
Integrate Cursor with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Google Spanner data from within the editor.
-
Integrating Dataiku with SAP SuccessFactors Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SAP SuccessFactors data.
-
Connect to WooCommerce Data in Google Apps Script via Connect AI
Use CData Connect AI to access WooCommerce data in Google Apps Script.
-
Analyze Oracle Financials Cloud Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Financials Cloud data in Microsoft R Open.
-
Integrate ADP Data into Power Automate Desktop using CData Connect
CData Connect for ADP Data enables you to integrate ADP data into workflows built using Microsoft Power Automate Desktop.