CData Software - Knowledge Base
Recent Articles
-
Configure the CData JDBC Driver for Chargebee in a Connection Pool in Tomcat
Connect to Chargebee data from a connection pool in Tomcat.
-
How to Connect to & Open Bugsnag Data in Microsoft Excel
This article uses the CData ODBC driver for Bugsnag to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create WordPress Dataflows on PowerBI.com
Connect to the CData Power BI Connector for WordPress from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automate FormSite Data Replication to SAP HANA
Use CData Sync to customize and automate FormSite data replication to SAP HANA.
-
Link ServiceNow with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ServiceNow data in Filemaker Pro for Mac or Windows.
-
Build Clio-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Clio data.
-
Access Live Lakebase Data in TIBCO Data Virtualization
Use the Lakebase Tibco DV Adapter to create a Lakebase data data source in TIBCO Data Virtualization Studio and gain access to live Lakebase data from your TDV Server.
-
Create Informatica Mappings From/To an ODBC Data Source for Vimeo
Create an ODBC connection to Vimeo in Informatica and browse and transfer Vimeo data.
-
Creating YouTube Analytics-Connected Applications in Unqork
You can use CData Connect AI to feed YouTube Analytics data to Unqork and build custom business apps.
-
Migrating data from Campaigner to Google BigQuery using CData SSIS Components.
Easily push Campaigner data to Google BigQuery using the CData SSIS Tasks for Campaigner and Google BigQuery.
-
Connect to Moosend from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Moosend data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Access CloudConvert Data from MySQL in PHP
Connect to CloudConvert through the standard MySQL libraries in PHP.
-
Publish Clockify-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Clockify data.
-
Connect to Bitly Data from HeidiSQL
Use CData Connect AI to connect to and query live Bitly data from HeidiSQL.
-
Automated Continuous JobNimbus Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable JobNimbus replication to Google BigQuery.
-
Build Campaigner Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Campaigner data and build visualizations in Tableau Cloud.
-
Add Samanage Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Samanage with the Informatica Enterprise Data Catalog to classify and organize data.
-
Query Live Phoenix Data in Perplexity Desktop via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Perplexity Desktop to securely access and query live Phoenix data through a conversational interface.
-
Visualize Oracle SCM 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 Oracle SCM data into TIBCO Spotfire.
-
Connect to ShipEngine Data from a Connection Pool in JBoss
Integrate ShipEngine data into Java servlets: Use the Management Console in JBoss to install the ShipEngine JDBC Driver.
-
Connect and Visualize Live Adobe Experience Manager Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Adobe Experience Manager data into the Databricks platform and create visualization dashboards with real-time Adobe Experience Manager data.
-
Connect to HCL Domino from Asprova with CData Software ODBC Driver for HCL Domino
This article shows how to connect faster to HCL Domino data from Asprova.
-
Use the CData Software JDBC Driver for Greenplum in MicroStrategy Desktop
Connect to Greenplum data in MicroStrategy Desktop using the CData Software JDBC Driver for Greenplum.
-
Replicate Multiple ClickUp Accounts via the CData Sync CLI
Replicate multiple ClickUp accounts to one or many databases.
-
Use the CData ODBC Driver for SageHR in Microsoft Power Query
You can use the CData SageHR ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import SageHR data into Microsoft Power Query.
-
How to Connect to Live Adobe Commerce 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 Adobe Commerce data for you.
-
Automated Continuous NASA Replication to IBM DB2
Use CData Sync for automated, continuous, customizable NASA replication to IBM DB2.
-
Connect to CouchDB Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to CouchDB.
-
Create SSAS Tabular Models from JobNimbus Data
How to build a SQL Server Analysis Service Tabular Model from JobNimbus data using CData drivers.
-
Connect to Okta Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Okta data.
-
Getting Started with the CData JDBC Driver for BigCommerce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for BigCommerce.
-
Connect to Live MailerLite Data in PostGresSQL Interface through CData Connect AI
Create a live connection to MailerLite in CData Connect AI and connect to your MailerLite data from PostgreSQL.
-
Publish Crystal Reports on Mailgun Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Mailgun data.
-
Build Bugsnag-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Bugsnag data.
-
Getting Started with the CData SSIS Components for JSON
Complete guide to installing, licensing, and connecting with the CData SSIS Components for JSON.
-
Access Live FreeAgent Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate FreeAgent data into the statistical analysis tools available in SAS JMP. This article shows how to use FreeAgent data in the Graph Builder and Query Builder.
-
Automate Procore Data Replication to Azure Synapse
Use CData Sync to customize and automate Procore data replication to Azure Synapse.
-
DataBind Controls to Monday.com Data in Delphi
DataBind to Monday.com data in Delphi with standard data access components and controls.
-
How to work with Azure DevOps Data in Apache Spark using SQL
Access and process Azure DevOps Data in Apache Spark using the CData Software JDBC Driver.
-
Access Live SAP SuccessFactors Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live SAP SuccessFactors data from your Excel spreadsheets.
-
Access Live QuickBooks Time Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate QuickBooks Time data into the statistical analysis tools available in SAS JMP. This article shows how to use QuickBooks Time data in the Graph Builder and Query Builder.
-
Getting Started with the CData SSIS Components for ZarMoney
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ZarMoney.
-
Enable the Oracle SCM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle SCM data.
-
Automated Continuous ChargeOver Replication to AlloyDB
Use CData Sync for automated, continuous, customizable ChargeOver replication to AlloyDB.
-
Establish a Live Connection with PDFMonkey Data using Tableau Bridge
The CData ODBC Driver for PDFMonkey enables you to integrate live PDFMonkey data into Tableau Cloud dashboards using the Tableau Bridge.
-
Manage Jira Assets Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Jira Assets.
-
Automated Amazon Marketplace Data Replication to Teradata
Use CData Sync to Customize and automate Amazon Marketplace data replication to Teradata.
-
Build Pipelines with Live IBM Informix Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to IBM Informix from Google Cloud Data Fusion, enabling the integration of live IBM Informix data into the building and management of effective data pipelines.
-
Build DB2-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live DB2 data and build DB2-connected web apps with Axios.
-
Use Dash to Build to Web Apps on Supabase Data
Create Python applications that use pandas and Dash to build Supabase-connected web apps.
-
A PostgreSQL Interface for Zoho CRM Data using the CData ODBC Driver
Use the SQL Gateway and Zoho CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Moosend in MicroStrategy Web
Connect to Moosend data in MicroStrategy Web using the CData Software ODBC Driver for Moosend.
-
Access Live Paylocity Data in Coginiti Pro
Connect to and query live Paylocity data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData ODBC Driver for Amplitude in Microsoft Power Query
You can use the CData Amplitude ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Amplitude data into Microsoft Power Query.
-
Consume SAP HANA OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP HANA feeds that reflect any changes in SAP Lumira.
-
Create Teamwork Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Teamwork data access from reports, embedded analytics, and more.
-
Prepare, Blend, and Analyze Sage 300 Data in Alteryx Designer (Connect AI)
Build workflows to access live Sage 300 data for self-service data analytics.
-
Visualize EmailOctopus 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 EmailOctopus data into TIBCO Spotfire.
-
Query, Visualize, and Share live Microsoft Ads Data in Redash
Use CData Connect AI to connect to live Microsoft Ads data in Redash for querying, visualizing, and sharing.
-
Connect to Postmark Data in RapidMiner
Integrate Postmark data with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData Excel Add-In for Pingdom
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Pingdom.
-
How to Connect to Live Microsoft Entra ID Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Entra ID data securely in real time.
-
Analyze Gong Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Gong data and visualize Gong data in SAP Analytics Cloud.
-
Seamlessly Bring TaxJar Data into Retool Using CData Connect AI
Integrate TaxJar data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Integrating Reckon Accounts Hosted Data in Talend Cloud Data Management Platform
Connect Reckon Accounts Hosted Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Reckon Accounts Hosted.
-
Stream Oracle Data into Apache Kafka Topics
Access and stream Oracle data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Import and Visualize Testmonitor Data in Power View
Create data visualizations based on Testmonitor data in Excel.
-
Use the CData ODBC Driver for OneNote from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for OneNote to connect to OneNote data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring OneNote data in Excel.
-
Query Freshteam Data as a MySQL Database in Node.js
Execute MySQL queries against Freshteam data from Node.js.
-
How to Connect Flowise AI Agents to Live Google Search Results via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Google Search results without replication.
-
Use Microsoft Copilot Studio to talk to your Databricks 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 Databricks data for you.
-
Automated Continuous LaunchDarkly Replication to Oracle
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to Oracle.
-
Use JayDeBeApi to access Oracle SCM Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle SCM data.
-
Build Agents in Relevance AI with Access to Live Office 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Office 365 data within intelligent agent workflows.
-
Getting Started with the CData SSIS Components for Omnisend
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Omnisend.
-
Connecting Pipedream with EnterpriseDB Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on EnterpriseDB data in real time.
-
Build Google Forms Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Google Forms data and build visualizations in Tableau Cloud.
-
Connect to Miro from Asprova with CData Software ODBC Driver for Miro
This article shows how to connect faster to Miro data from Asprova.
-
Visualize Live Greenhouse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Greenhouse data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Informatica Mappings From/To an ODBC Data Source for Square
Create an ODBC connection to Square in Informatica and browse and transfer Square data.
-
How to create Visio diagrams from Twilio Data
Automatically update Twilio data with the changes you make to Visio master shapes.
-
Migrating data from Google Sheets to Databricks using CData SSIS Components.
Easily push Google Sheets data to Databricks using the CData SSIS Tasks for Google Sheets and Databricks.
-
Access Live Salesforce Data 360 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Salesforce Data 360 data into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Data 360 data in the Graph Builder and Query Builder.
-
Build PostgreSQL-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live PostgreSQL data.
-
How to connect and process ConvertAPI data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live ConvertAPI data.
-
Replicate Pushbullet Data from PowerShell
Write a quick PowerShell script to query Pushbullet data. Use connectivity to the live data to replicate Pushbullet data to SQL Server.
-
Query ConvertAPI Data through ODBC in Node.js
Use node-odbc to execute SQL queries against ConvertAPI data from Node.js.
-
Rapidly Develop Neo4J-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 Neo4J.
-
Use Dash to Build to Web Apps on Active Directory Data
Create Python applications that use pandas and Dash to build Active Directory-connected web apps.
-
Automated Continuous Front Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Front replication to Apache Kafka.
-
Integrate with DB2 Data in JReport Designer
Create charts and reports based on DB2 data in JReport Designer.
-
Build NetSuite-Connected Apps in Choreo
Use CData Connect AI to connect to NetSuite Data from Choreo and build custom apps using live NetSuite data.
-
Connect to Real-Time Splunk Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Splunk and Dataflow to import and use Splunk data in Power Apps.
-
Integrate Google's Vertex AI Agent with Live MongoDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MongoDB data within intelligent workflows.
-
Build a Singer.io Tap for Outreach.io With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Outreach.io data using the CData Python Connector.
-
Connect to Pinterest from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Pinterest data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
How to load SAP SuccessFactors LMS data into Elasticsearch via Logstash
Introducing a simple method to load SAP SuccessFactors LMS data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Automated Continuous Google Cloud Storage Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Google Cloud Storage replication to Google BigQuery.
-
Build Dashboards with Zoho Recruit Data in DBxtra
Create dynamic dashboards and perform analytics based on Zoho Recruit data in DBxtra.
-
Access Live Procore Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Procore data from Excel 365 Online (Excel for the web) with Connect Spreadsheets.