CData Software - Knowledge Base
Recent Articles
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Access
Provide connectivity to Access data through an SAP BusinessObjects universe.
-
Connect to SpaceX Data in JRuby
Create a simple JRuby app with access to live SpaceX data.
-
DataBind Charts to SAP HANA Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to SAP HANA data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to OnePageCrm Data in HULFT Integrate
Connect to OnePageCrm as a JDBC data source in HULFT Integrate
-
Integrating Dataiku with Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Cvent data.
-
Build a PostgreSQL Interface for BigQuery Data using the CData JDBC Driver
Use the Remoting features of the BigQuery JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to create ShipEngine federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for ShipEngine data in MySQL .
-
Using the CData Software ODBC Driver for Google Ad Manager in PyCharm
Connect to Google Ad Manager as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Ad Manager.
-
Connect to Tally Data from AWS Glue
Use CData Connect AI to gain access to live Tally data from your AWS Glue jobs.
-
Use Manus AI to Talk to Your Testmonitor Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Testmonitor data.
-
How to Connect the Power BI Service to Microsoft Ads: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Ads from PowerBI.com to provide real-time Microsoft Ads data across the organization.
-
Connect to Float Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Float as an External Source in Dremio.
-
Use the CData Software ODBC Driver for ZohoSubscriptions in MicroStrategy Web
Connect to ZohoSubscriptions data in MicroStrategy Web using the CData Software ODBC Driver for ZohoSubscriptions.
-
Automated Continuous Clari Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Clari replication to AlloyDB.
-
Create Reports from Bannerbear Data in Looker Studio
Use CData Connect AI to gain access to live Bannerbear data and create custom reports in Looker Studio.
-
Access Live Azure Data Catalog Data in Coginiti Pro
Connect to and query live Azure Data Catalog data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrate Jumpseller Data in Pentaho Data Integration
Build ETL pipelines based on Jumpseller data in the Pentaho Data Integration tool.
-
Connect to Google Campaign Manager 360 from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Campaign Manager 360 data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Enable the Freshsales JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Freshsales data.
-
Connect to and Visualize Live SageHR Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SageHR data.
-
Connect and Query Live Exact Online Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Exact Online data into Databricks and enable direct, live querying and analysis without replication.
-
How to Access Live SQL Analysis Services Data in Power Automate Desktop via ODBC
The CData ODBC Driver for SQL Analysis Services enables you to integrate SQL Analysis Services data into workflows built using Microsoft Power Automate Desktop.
-
ChargeOver Reporting in OBIEE with the ChargeOver JDBC Driver
Deploy the ChargeOver JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Automated Continuous Greenhouse Replication to SingleStore
Use CData Sync for automated, continuous, customizable Greenhouse replication to SingleStore.
-
How to Access Live Google Cloud Storage Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Google Cloud Storage enables you to integrate Google Cloud Storage data into workflows built using Microsoft Power Automate Desktop.
-
Natively Connect to Microsoft Planner Data in PHP
The CData ODBC driver for Microsoft Planner enables you to create PHP applications with connectivity to Microsoft Planner data. Leverage the native support for ODBC in PHP.
-
Automated Continuous CouchDB Replication to IBM DB2
Use CData Sync for automated, continuous, customizable CouchDB replication to IBM DB2.
-
Access Nethunt Data from MySQL in Amazon QuickSight
Connect to Nethunt and build visualizations of Nethunt data using a MySQL Connection in Amazon QuickSight.
-
Visualize Wrike 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 Wrike data into TIBCO Spotfire.
-
Connect to Sybase IQ Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Sybase IQ.
-
Create ZohoInvoice-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to ZohoInvoice Data from Klipfolio and build custom visualizations using live ZohoInvoice data.
-
Create Reports from Adobe Experience Manager Data in Looker Studio
Use CData Connect AI to gain access to live Adobe Experience Manager data and create custom reports in Looker Studio.
-
Integrate Foursquare Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Foursquare data from Informatica Cloud.
-
Connecting Agentforce with Cloudflare 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 Cloudflare data for you.
-
Create Apps from Facebook Data in Qlik Sense Cloud
Use CData Connect AI to connect to Facebook Data and build apps from live Facebook data in Qlik Sense Cloud.
-
Build AI/ML Models with Live Access Data using Dataiku
Connect Access Data with Dataiku using the CData JDBC Driver for Access.
-
Use JayDeBeApi to access Kintone Data in Python
Use standard Python scripting and the development environment of your choice to access live Kintone data.
-
Create SSAS Tabular Models from LinkedIn Data
How to build a SQL Server Analysis Service Tabular Model from LinkedIn data using CData drivers.
-
Migrating data from Strava to Snowflake using CData SSIS Components.
Easily push Strava data to Snowflake using the CData SSIS Tasks for Strava and Snowflake.
-
Using the CData Software ODBC Driver for Amazon DynamoDB in PyCharm
Connect to Amazon DynamoDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for Amazon DynamoDB.
-
Visualize Pushbullet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Pushbullet data.
-
Integrating Claude Code CLI with Beeminder 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 Salesforce Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Salesforce and the SQL Gateway to access Salesforce data from Google Apps Script.
-
Build Pipelines with Live Workday Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Workday from Google Cloud Data Fusion, enabling the integration of live Workday data into the building and management of effective data pipelines.
-
Connect to WooCommerce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to WooCommerce.
-
Stream Strava Data into Apache Kafka Topics
Access and stream Strava data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Live JSON Services in MicroStrategy through CData Connect AI
Create a live connection to JSON Services in CData Connect AI and connect to your JSON services from MicroStrategy.
-
Use the CData ODBC Driver for HCL Domino from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for HCL Domino to connect to HCL Domino data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring HCL Domino data in Excel.
-
Automate Sentry Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Sentry data from PowerShell? This article demonstrates how to utilize the Sentry Cmdlets for tasks like connecting to Sentry data, automating operations, downloading data, and more.
-
Extract, Transform, and Load MailChimp Data in Informatica PowerCenter
Create a simple Workflow for MailChimp data in Informatica PowerCenter.
-
Publish OpenWeatherMap-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live OpenWeatherMap data.
-
How to Easily Query Google Contacts Data in OpenOffice Base
Connect to Google Contacts data in OpenOffice Base using the CData ODBC Driver for Google Contacts and generate reports with live data insights.
-
Automated Continuous GetResponse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable GetResponse replication to delimited files (CSV/TSV).
-
Getting Started with the CData Excel Add-In for Paylocity
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Paylocity.
-
How to Build an ETL App for Aha! Data in Python with CData
Create ETL applications and real-time data pipelines for Aha! data in Python with petl.
-
Publish CampaignMonitor-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live CampaignMonitor data.
-
Prepare, Blend, and Analyze BigQuery Data in Alteryx Designer (ODBC)
Build workflows to access live BigQuery data for self-service data analytics.
-
Query, Visualize, and Share live Freshteam Data in Redash
Use CData Connect AI to connect to live Freshteam data in Redash for querying, visualizing, and sharing.
-
Managing Snowflake TIMESTAMP discrepancies with CData Drivers
TIMESTAMP columns can be difficult thing to manage when insert data into Snowflake. This article explains what you need to know about Snowflake TIMESTAMP types and how to manage them with CData Drivers.
-
How to Access Live Couchbase Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Couchbase enables you to integrate Couchbase data into workflows built using Microsoft Power Automate Desktop.
-
Automated Continuous PayPal Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PayPal replication to Azure SQL Database.
-
Build Pipelines with Live GraphQL Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to GraphQL from Google Cloud Data Fusion, enabling the integration of live GraphQL data into the building and management of effective data pipelines.
-
Validate Google Ads Data with QuerySurge
Access and validate Google Ads data in QuerySurge using the CData JDBC Driver.
-
Visualize Live Kafka Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Kafka data into custom reports in Power BI.
-
Build Visualizations of Google Campaign Manager 360 Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Campaign Manager 360 data in Birst.
-
Use Dash to Build to Web Apps on Azure Data Catalog Data
Create Python applications that use pandas and Dash to build Azure Data Catalog-connected web apps.
-
How to Connect to SageHR Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to SageHR data. Leverage the pyodbc module for ODBC in Python.
-
Design BIRT Reports on PDFMonkey Data
Provide current PDFMonkey data to your embedded analytics.
-
Connect to Live Kintone Data in MicroStrategy through CData Connect AI
Create a live connection to Kintone Data in CData Connect AI and connect to your Kintone data from MicroStrategy.
-
Create Reports with ChartMogul Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ChartMogul data.
-
Use Claude to Talk to Your Discord 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 Discord data for you.
-
Integrate with Miro Data in JReport Designer
Create charts and reports based on Miro data in JReport Designer.
-
Create Datasets from AgileCRM in Domo Workbench and Build Visualizations of AgileCRM Data in Domo
Use the CData Software ODBC Driver for AgileCRM to create datasets from AgileCRM data in Domo Workbench and then build visualizations in the Domo service.
-
A PostgreSQL Interface for Drip Data (MySQL Remoting via JDBC)
Use the Remoting features of the Drip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Dashboards with Presto Data in Dundas BI
Create dynamic dashboards and perform analytics based on Presto data in Dundas BI.
-
Automated Continuous MailChimp Replication to Databricks
Use CData Sync for automated, continuous, customizable MailChimp replication to Databricks.
-
How to connect to Customer.io Data in DBVisualizer
Integrate Customer.io data with visual data analysis tools and data connection wizards in DBVisualizer
-
Replicate Multiple GraphQL Accounts via the CData Sync CLI
Replicate multiple GraphQL accounts to one or many databases.
-
Integrating GitHub Copilot with Productboard 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 Work with SAP Hybris C4C Data in AWS Glue Jobs Using JDBC
Connect to SAP Hybris C4C from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Use the CData ODBC Driver for iContact in Microsoft Power Query
You can use the CData iContact ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import iContact data into Microsoft Power Query.
-
Integrating Kiro 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.
-
Create Datasets from Zoho CRM in Domo Workbench and Build Visualizations of Zoho CRM Data in Domo
Use the CData Software ODBC Driver for Zoho CRM to create datasets from Zoho CRM data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to and Query Egnyte Data in QlikView over ODBC
Create data visualizations with Egnyte data in QlikView.
-
Connect to Opsgenie from a Connection Pool in WebLogic
Use the CData JDBC Driver for Opsgenie to connect to Opsgenie data from Web applications running on WebLogic.
-
Build Voice Agents in ElevenLabs with access to Live Oracle Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Oracle data.
-
Connect to Notion Data in Aqua Data Studio
Access Notion data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to create an RPA flow for Campaigner Data in UiPath Studio
Use the Campaigner ODBC Driver to create workflows that access real-time Campaigner data without any coding.
-
Create a Data Access Object for Snapchat Ads Data using JDBI
A brief overview of creating a SQL Object API for Snapchat Ads data in JDBI.
-
Access Live Amazon Marketplace Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Amazon Marketplace data through MCP integration.
-
Getting Started with the CData SSIS Components for Google Calendar
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Google Calendar.
-
Connect to Rebilly from Asprova with CData Software ODBC Driver for Rebilly
This article shows how to connect faster to Rebilly data from Asprova.
-
Visualize SAP SuccessFactors LMS 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 SAP SuccessFactors LMS data into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SAP Hybris C4C.
-
Automated Continuous SAP Concur Replication to Vertica
Use CData Sync for automated, continuous, customizable SAP Concur replication to Vertica.
-
Integrate Monday.com Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Monday.com data and integrate live Monday.com data into your Power Automate tasks.
-
Import Real-Time Salesforce Data 360 Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Salesforce Data 360 data in ColdFusion.
-
Automated Continuous Discourse Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Discourse replication to delimited files (CSV/TSV).
-
Connect to Facebook Ads 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 Facebook Ads data.
-
Getting Started with the CData ADO.NET Provider for Avalara AvaTax
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Avalara AvaTax.