CData Software - Knowledge Base
Recent Articles
-
Automated Continuous MailChimp Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable MailChimp replication to delimited files (CSV/TSV).
-
Create Snapchat Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Snapchat Ads data access from reports, embedded analytics, and more.
-
Build Visualizations of Toggl Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Toggl data in Birst.
-
Prepare, Blend, and Analyze Dotmailer Data in Alteryx Designer (ODBC)
Build workflows to access live Dotmailer data for self-service data analytics.
-
How to Use a Microsoft Access Database to Update Marketo Data in Real Time
Update Marketo data by creating a linked table in Microsoft Access with the CData Marketo ODBC Driver.
-
Create DB2-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to DB2 Data from Klipfolio and build custom visualizations using live DB2 data.
-
Bridge Blackbaud FE NXT Connectivity with Apache NiFi
Access and process Blackbaud FE NXT data in Apache NiFi using the CData JDBC Driver.
-
Integrate Live LinkedIn Ads Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to LinkedIn Ads from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live LinkedIn Ads data.
-
Getting Started with the CData Excel Add-In for SAP Ariba Source
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Ariba Source.
-
Model Azure Synapse Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Synapse, enabling the direct import of real-time Azure Synapse data.
-
Build a Singer.io Tap for Sage 300 With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Sage 300 data using the CData Python Connector.
-
Visualize Tally Data in TIBCO Spotfire through ADO.NET
Integrate Tally data into dashboards in TIBCO Spotfire.
-
Create Data Visualizations in Cognos BI with Figshare Data
Access Figshare data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze MarkLogic Data in Cognos Analytics
Use CData Connect AI to connect to MarkLogic Data from Cognos Analytics and analyze live MarkLogic data.
-
How to Work with JSON Services in ETL Validator JDBC
Connect to JSON from ETL Validator jobs using the CData Software JDBC Driver.
-
Getting Started with the CData Python Connector for BambooHR
Learn to install and license the CData Python Connector and configure a connection to live BambooHR data.
-
Visualize Factorial Data in TIBCO Spotfire through ADO.NET
Integrate Factorial data into dashboards in TIBCO Spotfire.
-
Connect to Workday Data in Aqua Data Studio
Access Workday data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use Grok to Talk to Your Azure Data Catalog 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 Azure Data Catalog data for you.
-
Automated Continuous Flowlu Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Flowlu replication to Apache Kafka.
-
Visualize Amazon Athena Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Amazon Athena data into TIBCO Spotfire.
-
Connect to iContact Data in Ruby
Connect to iContact data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Query SAP Hybris C4C Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Hybris C4C data.
-
Build Apps with Live Parquet Data Using the Low-Code Development Platform of Mendix
Connect Parquet data with Mendix to build apps using the CData JDBC Driver for Parquet.
-
Integrate Optimizely with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Optimizely with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Optimizely data.
-
Integrate Coda Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Coda data and integrate live Coda data into your Power Automate tasks.
-
Use the CData ODBC Driver for Freshservice from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Freshservice to connect to Freshservice data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Freshservice data in Excel.
-
Using the CData Software ODBC Driver for Datadog in PyCharm
Connect to Datadog as an ODBC data source in PyCharm using the CData Software ODBC Driver for Datadog.
-
How to Create Power BI Visual Reports with Real-Time Act CRM Data
Use CData Power BI Connectors to visualize Act CRM data in Power BI.
-
Use the CData Software ODBC Driver for ZohoPeople in MicroStrategy
Connect to ZohoPeople data in MicroStrategy Developer using the CData Software ODBC Driver for ZohoPeople.
-
Operational Reporting on Salesforce Data 360 Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Salesforce Data 360 data.
-
Working with Oracle SCM Data in LINQPad
Execute LINQ queries to Oracle SCM data in LINQPad.
-
Edit and Search External SAS Data Sets Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of SAS Data Sets data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create SAS Data Sets Data objects that you can access from apps and the dashboard.
-
Getting Started with the CData Tableau Connector for Tavily
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automate OpenWeatherMap Data Replication to Couchbase
Use CData Sync to Customize and automate OpenWeatherMap data replication to Couchbase.
-
Connect to Salesforce in SpagoBI
Create reports featuring live Salesforce data in SpagoBI Studio. Host Salesforce reports on SpagoBI Server.
-
Integrate NetSuite Data in the Pentaho Report Designer
Publish reports based on NetSuite data in the Pentaho BI tool.
-
Build Oracle Service Cloud Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Oracle Service Cloud data and build visualizations in Tableau.
-
Connect to Real-Time Miro Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Miro data in Power Apps.
-
Build Automated Exact Online-Connected Workflows in Zapier
Use CData Connect AI to connect to live Exact Online data and build automated workflows in Zapier.
-
Connect to Act CRM Data from AWS Glue
Use CData Connect AI to gain access to live Act CRM data from your AWS Glue jobs.
-
Visualize Brex Data in Sisense
Create an ElastiCube in Sisense app with access to Brex data.
-
Integrating Kiro with Clari 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 Semantic Layer Views for SAS Data Sets Data in APOS Live Data Gateway
Use the CData Connector for SAS Data Sets in APOS Live Data Gateway to build Semantic Layer Views for SAS Data Sets data.
-
Use the CData ODBC Driver for QuickBooks from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for QuickBooks to connect to QuickBooks data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring QuickBooks data in Excel.
-
Connect to ShipStation Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to ShipStation.
-
Build Apps with Live Hive Data Using the Low-Code Development Platform of Mendix
Connect Hive data with Mendix to build apps using the CData JDBC Driver for Hive.
-
Validate Pinecone Data with QuerySurge
Access and validate Pinecone data in QuerySurge using the CData JDBC Driver.
-
Connect to Okta Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Okta and the SQL Gateway to access Okta data from Google Apps Script.
-
Build Facebook Ads-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Facebook Ads Data and create custom apps in Mendix.
-
Using the CData Software ODBC Driver for Strava in PyCharm
Connect to Strava as an ODBC data source in PyCharm using the CData Software ODBC Driver for Strava.
-
Create SSAS Tabular Models from Adobe Target Data
How to build a SQL Server Analysis Service Tabular Model from Adobe Target data using CData drivers.
-
Deploy the ADO.NET Provider for Everhour on an SSRS Report Server
Connect to Everhour 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.
-
Build IBM Cloud Object Storage-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live IBM Cloud Object Storage data.
-
Automate Jira Assets Data Replication to Couchbase
Use CData Sync to Customize and automate Jira Assets data replication to Couchbase.
-
How to create Microsoft Exchange federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Exchange data in MySQL .
-
Replicate Jumpseller Data to Multiple Databases
Replicate Jumpseller data to disparate databases with a point-and-click configuration.
-
Bidirectional Access to Smartsheet Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Smartsheet data in Filemaker Pro for Mac or Windows.
-
Rapidly Develop SAP Hybris C4C-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 SAP Hybris C4C.
-
Integrating xBase Data in Talend Cloud Data Management Platform
Connect xBase Data with Talend Cloud Data Management Platform using the CData JDBC Driver for xBase.
-
Use the CData ODBC Driver for xBase in Microsoft Power Query
You can use the CData xBase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import xBase data into Microsoft Power Query.
-
Integrating Claude Code CLI with Excel Online 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 Confluence Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Confluence replication to Google BigQuery.
-
Extract, Transform, and Load Strava Data in Informatica PowerCenter
Create a simple Workflow for Strava data in Informatica PowerCenter.
-
Connect to PolarTeamPro Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for PolarTeamPro data.
-
Analyze Apify Data in Cognos Analytics
Use CData Connect AI to connect to Apify Data from Cognos Analytics and analyze live Apify data.
-
Integrating Gumloop with MYOB AccountRight Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on MYOB AccountRight data within automated workflows.
-
LINQ to Shippo 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 Shippo Data Provider.
-
Build Charts with Intercom Data in Clear Analytics
Create dynamic charts and perform analytics based on Intercom data in Clear Analytics.
-
Integrate Live Blackbaud FE NXT Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Blackbaud FE NXT data to Blue Prism using the CData ODBC Driver for Blackbaud FE NXT to create automated workflows for repetitive business tasks.
-
Connecting Moonlit Workflow with QuickBooks Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your QuickBooks data in real time.
-
Automated Continuous SAP Fieldglass Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to SingleStore.
-
Confluence Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Confluence facts in real time.
-
Use the CData ODBC Driver for Sybase in Microsoft Power Query
You can use the CData Sybase ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sybase data into Microsoft Power Query.
-
Use JayDeBeApi to access Highrise Data in Python
Use standard Python scripting and the development environment of your choice to access live Highrise data.
-
Automated Continuous xBase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable xBase replication to PostgreSQL.
-
Replicate Multiple Cosmos DB Accounts via the CData Sync CLI
Replicate multiple Cosmos DB accounts to one or many databases.
-
Build a Singer.io Tap for Facebook Ads With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Facebook Ads data using the CData Python Connector.
-
Query Live Databricks 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 Databricks data directly from the development environment.
-
How to Connect to Live Azure Data Lake Storage 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 Azure Data Lake Storage data through natural language.
-
Integrating MySQL Data in Talend Cloud Data Management Platform
Connect MySQL Data with Talend Cloud Data Management Platform using the CData JDBC Driver for MySQL.
-
Feed Printful Data into FineReport
How to set Printful data as a JDBC data source in FineReport.
-
Working with Helpscout Data in LINQPad
Execute LINQ queries to Helpscout data in LINQPad.
-
Deploy the ADO.NET Provider for Databricks on an SSRS Report Server
Connect to Databricks 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.
-
Build GitHub-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to GitHub Data from Zoho Analytics and import live GitHub data.
-
Integrate Devin with Live Printify Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Printify data.
-
How to Connect DBeaver to ActiveCampaign via a JDBC Driver
Manage ActiveCampaign data with visual tools in DBeaver like the query browser.
-
Connect to Azure Data Lake Storage Data in DBArtisan
Use wizards in DBArtisan to configure Azure Data Lake Storage data as a data source.
-
How to load GitLab data into Elasticsearch via Logstash
Introducing a simple method to load GitLab data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate Cursor with Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Freshteam data from within the editor.
-
Analyze Facebook Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Facebook from Power Pivot. You will use the Table Import Wizard to load Facebook data. You can visually build the import query or use any SQL supported by the driver.
-
Build Pipelines with Live Paymo Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Paymo from Google Cloud Data Fusion, enabling the integration of live Paymo data into the building and management of effective data pipelines.
-
Connect SharePoint Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SharePoint data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to and Query Omnisend Data in QlikView over ODBC
Create data visualizations with Omnisend data in QlikView.
-
Automated Continuous Zoom Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Zoom replication to IBM DB2.
-
How to create BenchmarkEmail federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for BenchmarkEmail data in MySQL .
-
Integrate Live Adobe Commerce Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Adobe Commerce from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Adobe Commerce data.
-
Connect to SuiteCRM Data in RazorSQL
Connect to SuiteCRM from wizards and query SuiteCRM data from the GUI in the RazorSQL database management tool.
-
Integrate with live Act-On Data in Jitterbit
Use CData Connect AI to connect to and integrate live Act-On data in Jitterbit.
-
Getting Started with the CData Connect AI Python SDK for Zuora
Install the CData Connect AI Python SDK to read live Zuora data with standard DB-API 2.0 Python code.