CData Software - Knowledge Base
Recent Articles
-
Publish Reports with Clari Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Clari.
-
Integrate Live Odoo Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Integrating Claude Code CLI with Oracle SCM 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 Import Data from Google Calendar into Google Sheets
Import Google Calendar into a Google spreadsheet that is automatically refreshed.
-
Create Power BI Reports on Real-Time SharePoint Excel Services Data
Use the CData ODBC Driver for SharePoint Excel Services to visualize SharePoint Excel Services in Power BI Desktop.
-
SageHR Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SageHR facts in real time.
-
Create Data Visualizations in Cognos BI with Bullhorn CRM Data
Access Bullhorn CRM as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Easily Query Email Data in OpenOffice Base
Connect to Email data in OpenOffice Base using the CData ODBC Driver for Email and generate reports with live data insights.
-
Connect to Oracle Service Cloud Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Oracle Service Cloud Data and connect to Oracle Service Cloud in Akorbi Digital RunMyProcess.
-
Integrating Gumloop with Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Neo4J within automated workflows.
-
View Reports on Real-Time Hugging Face Data in Power BI Report Server
Use the CData ODBC Driver for Hugging Face to visualize Hugging Face in Power BI Desktop and then publish them to Power BI Report Server.
-
Moving Data from Recurly to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Recurly data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Azure Cosmos DB using the Model Context Protocol.
-
Visualize Eventbrite Data in TIBCO Spotfire through ADO.NET
Integrate Eventbrite into dashboards in TIBCO Spotfire.
-
Connect to LaunchDarkly Data in HULFT Integrate
Connect to LaunchDarkly as a JDBC data source in HULFT Integrate
-
Replicate Multiple SAP Ariba Procurement Accounts
Replicate multiple SAP Ariba Procurement accounts to one or many databases.
-
How to connect to Shortcut Data from IntelliJ
Integrate connectivity to Shortcut with wizards in IntelliJ.
-
Create SSAS Tabular Models from SAP SuccessFactors LMS Data
How to build a SQL Server Analysis Service Tabular Model from SAP SuccessFactors LMS using CData drivers.
-
Build Charts with Bitly Data in Clear Analytics
Create dynamic charts and perform analytics based on Bitly in Clear Analytics.
-
Build Data Flows from Delighted to SQL Server using SSIS
Easily back up Delighted to SQL Server using the SSIS components for Delighted.
-
Twilio Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Twilio through CData Connect AI using different applications and tools.
-
Extend Google Sheets with CSV Data
Make calls to CSV from Google Apps Script via the API Server.
-
Connect to Amazon Marketplace Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Import and Visualize SAP HANA XS Advanced Data in Power View
Create data visualizations based on SAP HANA XS Advanced in Excel.
-
Replicate Multiple HubDB Accounts
Replicate multiple HubDB accounts to one or many databases.
-
Import and Visualize Asana Data in Power View
Create data visualizations based on Asana in Excel.
-
Use the CData Software ODBC Driver for Missive in SAS for Real-Time Reporting and Analytics
Connect to real-time Missive in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Missive.
-
Connect to Confluence Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Confluence and the Script function in FileMaker Pro to connect to Confluence and work with Atlassian Confluence in your FileMaker application.
-
Automate Typeform Data Replication to SAP HANA
Use CData Sync to customize and automate Typeform replication to SAP HANA.
-
Connect to Amazon Marketplace Data in ACL Analytics
Connect to Amazon Marketplace via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon Marketplace.
-
Use the CData Software JDBC Driver for IBM Informix in MicroStrategy Desktop
Connect to IBM Informix in MicroStrategy Desktop using the CData Software JDBC Driver for IBM Informix.
-
How to Connect the Power BI Service to JobNimbus: Complete Guide
Connect to the CData Software Power BI Connector for JobNimbus from PowerBI.com to provide real-time JobNimbus across the organization.
-
Connect to Tanda Data in HULFT Integrate
Connect to Tanda as a JDBC data source in HULFT Integrate
-
How to Connect DBeaver to Rootly via a JDBC Driver
Manage Rootly with visual tools in DBeaver like the query browser.
-
Connect to Discord from a Connection Pool in WebLogic
Use the CData JDBC Driver for Discord to connect to Discord from Web applications running on WebLogic.
-
Getting Started with the CData ODBC Driver for Webflow
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Webflow.
-
Getting Started with the CData Python Connector for Slack
Learn to install and license the CData Python Connector
-
Automated Continuous Tanda Replication to SQL Server
Use CData Sync for automated, continuous, customizable Tanda replication to SQL Server.
-
Work with Kintone Data in FoxPro
Load Kintone into a FoxPro database. This article includes full code and a walk-through of the process.
-
Build Voice Agents in ElevenLabs with access to Live Stripe Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Stripe.
-
Automated Continuous SuiteCRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SuiteCRM replication to delimited files (CSV/TSV).
-
Automated Continuous Lakebase Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Lakebase replication to Amazon S3.
-
Integrate Goose with Live Cvent Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Cvent from within the local AI agent.
-
Connect to Grafana Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Grafana in the Denodo Virtual DataPort Administrator.
-
How to Connect to Live Outreach.io 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 Outreach.io for you.
-
Visualize Live Bright Data Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Bright Data.
-
Prepare, Blend, and Analyze Xero Data in Alteryx Designer (Connect AI)
Build workflows to access live Xero Accounting for self-service data analytics.
-
Automated Continuous Microsoft Dataverse Replication to Databricks
Use CData Sync for automated, continuous, customizable Microsoft Dataverse replication to Databricks.
-
Getting Started with the CData SSIS Components for HubDB
Complete guide to installing, licensing, and connecting with the CData SSIS Components for HubDB.
-
Automated Continuous Spark Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Spark replication to Amazon S3.
-
How to Import Data from Instagram into Google Sheets
Import Instagram into a Google spreadsheet that is automatically refreshed.
-
How to Visualize SAP Hybris C4C 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 SAP Hybris C4C in Python.
-
Access Live SQL Analysis Services Data in AWS Lambda
Connect to live SQL Analysis Services in AWS Lambda using the CData JDBC Driver.
-
Connect HubDB to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect HubDB with IBM WebSphere for seamless data integration and connectivity.
-
Integrate with live Slack Data in Jitterbit
Use CData Connect AI to connect to and integrate live Slack in Jitterbit.
-
Connect to Amazon Athena Data from PowerBuilder via JDBC
This article demonstrates how to access Amazon Athena from PowerBuilder using the Amazon Athena JDBC Driver.
-
How to Query Live Google Analytics Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Analytics data in natural language using Python.
-
Natively Connect to JotForm Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to JotForm. Leverage the native support for ODBC in PHP.
-
Integrate Parquet Data in the Pentaho Report Designer
Publish reports based on Apache Parquet in the Pentaho BI tool.
-
Validate SAS Data Sets Data with QuerySurge
Access and validate SAS Data Sets in QuerySurge using the CData JDBC Driver.
-
Manage Templated Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Templated.
-
Integrate Goose with Live Active Directory Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Active Directory from within the local AI agent.
-
Build Dashboards with Odoo Data in DBxtra
Create dynamic dashboards and perform analytics based on Odoo ERP in DBxtra.
-
Access Live Monday.com Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Monday.com into the statistical analysis tools available in SAS JMP. This article shows how to use Monday.com in the Graph Builder and Query Builder.
-
How to Query ChartMogul Data in MySQL Workbench
Execute MySQL queries against live ChartMogul from MySQL Workbench.
-
View Reports on Real-Time Cohere Data in Power BI Report Server
Use the CData ODBC Driver for Cohere to visualize Cohere in Power BI Desktop and then publish them to Power BI Report Server.
-
Excel Spreadsheet Automation on Highrise Data with the QUERY Formula
Pull data from Highrise, automate spreadsheets, and more with the QUERY formula.
-
How to Work with Epicor Kinetic Data in ETL Validator JDBC
Connect to Epicor Kinetic from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to Live Sybase IQ 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 Sybase IQ through natural language.
-
Create Datasets from Stack Exchange in Domo Workbench and Build Visualizations of Stack Exchange Data in Domo
Use the CData Software ODBC Driver for Stack Exchange to create datasets from Stack Exchange in Domo Workbench and then build visualizations in the Domo service.
-
Integrate Zoho CRM with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Zoho CRM with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Zoho CRM.
-
Viewing Snowflake Data in RAD Studio Data Explorer
How to view Snowflake in RAD Studio Data Explorer using the CData ODBC Driver for Snowflake.
-
Create Data Visualizations in Cognos BI with Hacker News Data
Access Hacker News as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Work with Tanda Data in ETL Validator JDBC
Connect to Tanda from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Visualize Elorus Data in Python with pandas
Use pandas and other modules to analyze and visualize live Elorus in Python.
-
Integrate Facebook Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Facebook Ads and integrate live Facebook Ads into your Power Automate tasks.
-
Build Apps with Live BambooHR in Adalo using CData Connect AI
Use CData Connect AI to integrate live BambooHR into the Adalo platform and build custom mobile and web applications with real-time BambooHR.
-
Query Apollo Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Apollo from Node.js.
-
Getting Started with the CData ODBC Driver for SendInBlue
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for SendInBlue.
-
Access Live NetSuite SuiteAnalytics Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live NetSuite SuiteAnalytics through MCP integration.
-
Excel Spreadsheet Automation on Oracle SCM Data with the QUERY Formula
Pull data from Oracle SCM, automate spreadsheets, and more with the QUERY formula.
-
Connect to Clockify Data in Jaspersoft Studio
Execute SQL to remote Clockify in Jaspersoft Studio.
-
Connect Spreadsheets Getting Started Guide
A basic guide to setting up and connecting to data through Connect Spreadsheets by CData
-
Integrating Gumloop with Oracle HCM Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Oracle HCM Cloud within automated workflows.
-
Automated Continuous AgileCRM Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable AgileCRM replication to Amazon Redshift.
-
Object-Relational Mapping (ORM) with MYOB AccountRight Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to MYOB AccountRight into a Java-based ORM framework, Hibernate.
-
Connect to Auth0 Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Auth0 and work with Auth0 in your FileMaker applications.
-
How to integrate Mocean with Apache Airflow
Access and process Mocean in Apache Airflow using the CData JDBC Driver.
-
Connect to Mocean Data in DBeaver
Use the CData ODBC Driver to connect to Mocean in DBeaver.
-
Visualize Live FHIR Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live FHIR into custom reports in Power BI.
-
How to Connect to & Open BigCommerce Data in Microsoft Excel
This article uses the CData ODBC driver for BigCommerce to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automate Tanda Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Tanda from PowerShell? This article demonstrates how to utilize the Tanda Cmdlets for tasks like connecting to Tanda, automating operations, downloading data, and more.
-
Integrate with PhantomBuster Data in JReport Designer
Create charts and reports based on PhantomBuster in JReport Designer.
-
Validate JDBC-ODBC Bridge Data with QuerySurge
Access and validate JDBC-ODBC Bridge in QuerySurge using the CData JDBC Driver.
-
How to integrate xBase with Apache Airflow
Access and process xBase in Apache Airflow using the CData JDBC Driver.
-
Create Reports with Twilio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Twilio.
-
How to Seamlessly Import Mailjet Data into IBM SPSS Modeler
Integrate Mailjet data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to Query Live Placid Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Placid data in natural language using Python.
-
Create Office 365 Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Office 365 data access from reports, embedded analytics, and more.
-
How to Connect DBeaver to Sybase via a JDBC Driver
Manage Sybase with visual tools in DBeaver like the query browser.