CData Software - Knowledge Base
Recent Articles
-
Create Reports from SAP HANA Data in Looker Studio
Use CData Connect AI to gain access to live SAP HANA data and create custom reports in Looker Studio.
-
Automated Continuous Sentry Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Sentry replication to Amazon Redshift.
-
Create Dashboards and Visualize Live Slack Data in Geckoboard
Use CData Connect AI to connect to live Slack data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Natively Connect to Sage 300 Data in PHP
The CData ODBC driver for Sage 300 enables you to create PHP applications with connectivity to Sage 300 data. Leverage the native support for ODBC in PHP.
-
Integrate Splunk with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Splunk with External Services.
-
LINQ to Campaigner 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 Campaigner Data Provider.
-
Integrating Kiro with Avalara AvaTax 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 Cloudant-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Cloudant data.
-
Connect to and Visualize Live Stack Exchange Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Stack Exchange data.
-
Analyze ZohoExpense Data in Looker
Use CData Connect AI to connect to ZohoExpense Data from Looker and build custom apps using live ZohoExpense data.
-
Use Microsoft Copilot Studio to talk to your Azure Synapse 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 Azure Synapse data for you.
-
Getting Started with the CData SSIS Components for Zoho Inventory
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Zoho Inventory.
-
Automated Continuous Amplitude Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amplitude replication to Apache Cassandra.
-
Migrating data from Oracle Sales to Databricks using CData SSIS Components.
Easily push Oracle Sales data to Databricks using the CData SSIS Tasks for Oracle Sales and Databricks.
-
Automated Continuous PolarTeamPro Replication to MySQL
Use CData Sync for automated, continuous, customizable PolarTeamPro replication to MySQL.
-
Getting Started with the CData Python Connector for Vercel
Learn to install and license the CData Python Connector and configure a connection to live Vercel data.
-
Connect to PDFMonkey Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to PDFMonkey.
-
Connect to and Visualize Live ZohoInvoice Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live ZohoInvoice data.
-
Integrate with Gmail Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Gmail data to a JSON file on disk.
-
Getting Started with the CData Power BI Connector for Google Spanner
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Spanner.
-
Build Apps with Live Oracle Financials Cloud data in Adalo using CData Connect AI
Use CData Connect AI to integrate live Oracle Financials Cloud data into the Adalo platform and build custom mobile and web applications with real-time Oracle Financials Cloud data.
-
Getting Started with the CData Tableau Connector for Gorgias
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Perform Batch Operations with QuickBooks Data in Apache NiFi
Connect to QuickBooks data and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Integrating Dataiku with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live YouTube Analytics data.
-
Connect to Snapchat Ads Data in RapidMiner
Integrate Snapchat Ads data with standard components and data source configuration wizards in RapidMiner Studio.
-
Operational Reporting on Vault CRM Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Vault CRM data.
-
Import Real-Time Pinterest Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Pinterest data in ColdFusion.
-
How to Easily Query PolarTeamPro Data in OpenOffice Base
Connect to PolarTeamPro data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Query Adobe Analytics Data in DataGrip
Create a Data Source for Adobe Analytics in DataGrip and use SQL to query live Adobe Analytics data.
-
Access Live Azure Analysis Services Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Analysis Services data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Publish ZendeskSell-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ZendeskSell data.
-
Connect to Clio Data in Jaspersoft Studio
Execute SQL to remote Clio data in Jaspersoft Studio.
-
Use Biml to Build SSIS Tasks to Replicate Vercel Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Vercel data to SQL Server.
-
Replicate Azure Table Data from PowerShell
Write a quick PowerShell script to query Azure Table data. Use connectivity to the live data to replicate Azure Table data to SQL Server.
-
Getting Started with the CData ADO.NET Provider for SageHR
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Connect to Google Forms Data in Ruby
Connect to Google Forms data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Semantic Layer Views for Clari Data in APOS Live Data Gateway
Use the CData Connector for Clari in APOS Live Data Gateway to build Semantic Layer Views for Clari data.
-
Integrate WordPress with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate WordPress with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to WordPress data.
-
Automated Continuous ChargeOver Replication to SQL Server
Use CData Sync for automated, continuous, customizable ChargeOver replication to SQL Server.
-
Migrating data from RabbitMQ to Snowflake using CData SSIS Components.
Easily push RabbitMQ data to Snowflake using the CData SSIS Tasks for RabbitMQ and Snowflake.
-
Integrate Real-Time Access to Lakebase in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Lakebase data in real time.
-
Add Bright Data Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Bright Data with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to integrate Metabase with Cvent Data
Use CData Connect AI to connect to live Cvent data and create an interactive dashboard in Metabase from Cvent data.
-
Using the CData Software ODBC Driver for EnterpriseDB in PyCharm
Connect to EnterpriseDB as an ODBC data source in PyCharm using the CData Software ODBC Driver for EnterpriseDB.
-
Create Certinia-Connected Dashboards in Grafana
Connect to Certinia Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Certinia data.
-
Access Humanity Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Humanity data from HeidiSQL.
-
Link eBay Analytics with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate eBay Analytics data in Filemaker Pro for Mac or Windows.
-
Connect to OneNote from Asprova with CData Software ODBC Driver for OneNote
This article shows how to connect faster to OneNote data from Asprova.
-
Integrate Live EnterpriseDB Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to EnterpriseDB data and integrate live EnterpriseDB data into apps built in Microsoft Power Apps.
-
Create HCL Domino-Connected Dashboards in Grafana
Connect to HCL Domino Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to HCL Domino data.
-
Build Voice Agents in ElevenLabs with access to Live Monday.com Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Monday.com data.
-
Build AI Agents with OneNote 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 OneNote data through CData Connect AI.
-
Query Greenplum Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Greenplum entities in PHP by modeling them as objects.
-
Use Claude to Talk to Your SQL Server 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 SQL Server data for you.
-
Interact with Live Google Calendar Data in Meta Muse via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Muse to securely interact with live Google Calendar data.
-
Automated Continuous Workable Replication to MongoDB
Use CData Sync for automated, continuous, customizable Workable replication to MongoDB.
-
Publish Discourse-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Discourse data.
-
Build SAP HANA-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SAP HANA data.
-
Connect to Paylocity Data in Claris FileMaker Pro
Use the CData ODBC Driver for Paylocity in FileMaker Pro to connect to Paylocity and work with Paylocity data in your FileMaker applications.
-
Connect to Yelp 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 Yelp data.
-
Add Amazon S3 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amazon S3 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Feed Parallel Data into FineReport
How to set Parallel data as a JDBC data source in FineReport.
-
Integrate Nuclia with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Nuclia with External Services.
-
Automate Dynamics NAV Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Dynamics NAV data from PowerShell? This article demonstrates how to utilize the Dynamics NAV Cmdlets for tasks like connecting to Dynamics NAV data, automating operations, downloading data, and more.
-
Migrating data from JobNimbus to Databricks using CData SSIS Components.
Easily push JobNimbus data to Databricks using the CData SSIS Tasks for JobNimbus and Databricks.
-
Access Live Bannerbear 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 Bannerbear data through MCP integration.
-
DataBind Controls to ZohoPeople Data in C++Builder
DataBind to ZohoPeople data in C++Builder with standard components and controls.
-
View Reports on Real-Time Dynamics CRM Data in Power BI Report Server
Use the CData ODBC Driver for Dynamics CRM to visualize Dynamics CRM data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to work with Cloudflare Data in Apache Spark using SQL
Access and process Cloudflare Data in Apache Spark using the CData Software JDBC Driver.
-
Build AI/ML Models with Live Calendly Data using Dataiku
Connect Calendly Data with Dataiku using the CData API Driver for JDBC.
-
Build Pipelines with Live Certinia Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Certinia from Google Cloud Data Fusion, enabling the integration of live Certinia data into the building and management of effective data pipelines.
-
How to Query Live ScrapingBee Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live ScrapingBee data data in natural language using Python.
-
Publish Reports with ServiceNow Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date ServiceNow data.
-
Import Real-Time Adobe Analytics Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Adobe Analytics data in ColdFusion.
-
Create Google Drive-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Google Drive Data from Klipfolio and build custom visualizations using live Google Drive data.
-
Build Monday.com-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Monday.com data and build web apps with connectivity to live Monday.com data.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for LaunchDarkly
Provide connectivity to LaunchDarkly data through an SAP BusinessObjects universe.
-
Access Close Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Close data from HeidiSQL.
-
Import Real-Time Brex Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Brex data in ColdFusion.
-
Use the CData ODBC Driver for Notion from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Notion to connect to Notion data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Notion data in Excel.
-
Create Microsoft OneDrive-Connected Nintex Workflows
Use CData Connect AI to connect to Microsoft OneDrive Data from Nintex Workflow Cloud and build custom workflows using live Microsoft OneDrive data.
-
Import Real-Time Bannerbear Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Bannerbear data in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for MailerSend
Provide connectivity to MailerSend data through an SAP BusinessObjects universe.
-
Integrating LlamaIndex with Jira Assets Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Jira Assets data in real time.
-
How to load Mixpanel data into Elasticsearch via Logstash
Introducing a simple method to load Mixpanel data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access FreshBooks Data from MySQL in PHP
Connect to FreshBooks through the standard MySQL libraries in PHP.
-
Connect to MariaDB Data in ACL Analytics
Connect to MariaDB data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to MariaDB data.
-
Build Slack-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Slack data.
-
Integrate with SAP HANA XS Advanced Data in SnapLogic
Use CData Connect AI to connect to and integrate with live SAP HANA XS Advanced data in SnapLogic.
-
Use the CData ODBC Driver for AdRoll from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for AdRoll to connect to AdRoll data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring AdRoll data in Excel.
-
Connect to Supabase Data in RapidMiner
Integrate Supabase data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Impala Data in DBeaver
Use the CData ODBC Driver to connect to Impala data in DBeaver.
-
A PostgreSQL Interface for Wave Financial Data using the CData ODBC Driver
Use the SQL Gateway and Wave Financial ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData Software ODBC Driver for Superchat in SAS for Real-Time Reporting and Analytics
Connect to real-time Superchat data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Superchat.
-
Connect to Shortcut from Asprova with CData Software ODBC Driver for Shortcut
This article shows how to connect faster to Shortcut data from Asprova.
-
Build Apps with Live Opsgenie Data Using the Low-Code Development Platform of Mendix
Connect Opsgenie data with Mendix to build apps using the CData API Driver for JDBC.
-
Create Dynamics NAV-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Dynamics NAV Data from Klipfolio and build custom visualizations using live Dynamics NAV data.
-
Query, Visualize, and Share live Zoho CRM Data in Redash
Use CData Connect AI to connect to live Zoho CRM data in Redash for querying, visualizing, and sharing.
-
Natively Connect to Cassandra Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Cassandra data. Leverage the native support for ODBC in PHP.
-
Connect to Snapchat Ads Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Snapchat Ads data from Filemaker Pro on Mac.