CData Software - Knowledge Base
Recent Articles
-
How to Connect to & Open Datadog Data in Microsoft Excel
This article uses the CData ODBC driver for Datadog to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Marketo Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Marketo from Filemaker Pro on Mac.
-
Viewing Webflow Data in RAD Studio Data Explorer
How to view Webflow in RAD Studio Data Explorer using the CData ODBC Driver for Webflow.
-
Build a Simple VCL Application for Microsoft Entra ID Data
How to build a simple VCL Application to view Microsoft Entra ID in RAD Studio using the CData ODBC Driver for Microsoft Entra ID.
-
How to Create Power BI Visual Reports with Real-Time Email Data
Use CData Power BI Connectors to visualize Email in Power BI.
-
Deploy the ADO.NET Provider for Salesloft on an SSRS Report Server
Connect to Salesloft 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.
-
How to Connect DBeaver to ZohoDesk via a JDBC Driver
Manage ZohoDesk with visual tools in DBeaver like the query browser.
-
Connect to CSV Data in Claris FileMaker Pro
Use the CData ODBC Driver for CSV in FileMaker Pro to connect to CSV and work with CSV/TSV Files in your FileMaker applications.
-
Rapidly Develop Pipedrive-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 Pipedrive.
-
Connect to and Query SharePoint Data in QlikView over ODBC
Create data visualizations with Microsoft SharePoint in QlikView.
-
Automated Continuous MongoDB Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MongoDB replication to Azure SQL Database.
-
Automated Continuous Avaza Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Avaza replication to Amazon Redshift.
-
Import and Visualize NASA Data in Power View
Create data visualizations based on NASA in Excel.
-
Create Helpscout Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Helpscout data access from reports, embedded analytics, and more.
-
Automate Float Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Float from PowerShell? This article demonstrates how to utilize the Float Cmdlets for tasks like connecting to Float, automating operations, downloading data, and more.
-
Getting Started with the CData ADO.NET Provider for ConvertKit
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData SSIS Components for JSON
Complete guide to installing, licensing, and connecting with the CData SSIS Components for JSON.
-
Object-Relational Mapping (ORM) with Vercel 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 Vercel into a Java-based ORM framework, Hibernate.
-
Integrate Open WebUI with Live Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Google Spanner from within the chat interface.
-
Feed Zoho CRM Data into FineReport
How to set Zoho CRM as a JDBC data source in FineReport.
-
Establish a Live Connection with HCL Domino Data using Tableau Bridge
The CData ODBC Driver for HCL Domino enables you to integrate live HCL Domino into Tableau Cloud dashboards using the Tableau Bridge.
-
Excel Spreadsheet Automation on Mixpanel Data with the QUERY Formula
Pull data from Mixpanel, automate spreadsheets, and more with the QUERY formula.
-
Integrate Live CircleCI Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live CircleCI to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Getting Started with the CData SSIS Components for ConvertAPI
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ConvertAPI.
-
Access Live SharePoint Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live SharePoint data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Create Power BI Reports on Real-Time QuickBooks Data
Use the CData ODBC Driver for QuickBooks to visualize QuickBooks Desktop in Power BI Desktop.
-
Automate PagerDuty Data Replication to Azure Data Lake
Use CData Sync to customize and automate PagerDuty replication to Azure Data Lake.
-
Automated Continuous Tickspot Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Tickspot replication to Google Cloud SQL.
-
How to Query Live Facebook Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Facebook Ads data in natural language using Python.
-
Natively Connect to Demio Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Demio. Leverage the native support for ODBC in PHP.
-
Rapidly Develop Freshdesk-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 Freshdesk.
-
Integrate Real-Time Access to SQL Analysis Services in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SQL Analysis Services in real time.
-
Build DB2-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live IBM DB2 and build DB2-connected web apps with Axios.
-
Connect to Sage Intacct Data in RapidMiner
Integrate Sage Intacct with standard components and data source configuration wizards in RapidMiner Studio.
-
Analyze Opsgenie Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Opsgenie in Microsoft R Open.
-
Build Zoho Creator-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoho Creator Data from Zoho Analytics and import live Zoho Creator.
-
Access Live Paylocity Data in Coginiti Pro
Connect to and query live Paylocity from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Jira Data in Aqua Data Studio
Access Atlassian Jira from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrating Gumloop with Odoo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Odoo ERP within automated workflows.
-
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.
-
Connect to and Query JobNimbus Data in QlikView over ODBC
Create data visualizations with JobNimbus in QlikView.
-
Create Workday Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Workday data access from reports, embedded analytics, and more.
-
How to Connect to & Open Pushbullet Data in Microsoft Excel
This article uses the CData ODBC driver for Pushbullet to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Stream Front Data into Apache Kafka Topics
Access and stream Front in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Freshsales Data in Sisense
Create an ElastiCube in Sisense app with access to Freshsales.
-
Connect to Productboard Data in JRuby
Create a simple JRuby app with access to live Productboard.
-
Automated Continuous OData Replication to MySQL
Use CData Sync for automated, continuous, customizable OData replication to MySQL.
-
Integrate with Planio Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Planio to a JSON file on disk.
-
Connect to Postmark Data in RapidMiner
Integrate Postmark with standard components and data source configuration wizards in RapidMiner Studio.
-
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 securely in real time.
-
How to Seamlessly Import Aircall Data into IBM SPSS Modeler
Integrate Aircall data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Connect to Perplexity Data in CloverDX (formerly CloverETL)
Transfer Perplexity using the visual workflow in the CloverDX data integration tool.
-
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 Microsoft OneNote from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft OneNote in Excel.
-
Connect to CapsuleCRM Data in RazorSQL
Connect to CapsuleCRM from wizards and query CapsuleCRM from the GUI in the RazorSQL database management tool.
-
Build a Singer.io Tap for Avaza With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Avaza data using
-
How to create an RPA flow for Webflow Data in UiPath Studio
Use the Webflow ODBC Driver to create workflows that access real-time Webflow without any coding.
-
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 for you.
-
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 Microsoft Office 365 within intelligent agent workflows.
-
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.
-
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 Google Cloud Storage Data in TIBCO Spotfire through OData
Integrate Google Cloud Storage into dashboards in TIBCO Spotfire.
-
Automated Continuous YouTube Analytics Replication to SingleStore
Use CData Sync for automated, continuous, customizable YouTube Analytics replication to SingleStore.
-
Visualize Live Greenhouse Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Greenhouse using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Codat Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Codat and work with Codat in your FileMaker application.
-
Migrating data from Google Sheets to Databricks using CData SSIS Components.
Easily push Google Sheets 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 into the statistical analysis tools available in SAS JMP. This article shows how to use Salesforce Data 360 in the Graph Builder and Query Builder.
-
Automated Continuous JotForm Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable JotForm replication to Google Cloud SQL.
-
Replicate Pushbullet Data from PowerShell
Write a quick PowerShell script to query Pushbullet. Use connectivity to the live data to replicate Pushbullet to SQL Server.
-
Manage Gong Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Gong.
-
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.
-
How to Connect to TaxJar Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to TaxJar. Leverage the pyodbc module for ODBC in Python.
-
Create Datasets from Harvest in Domo Workbench and Build Visualizations of Harvest Data in Domo
Use the CData Software ODBC Driver for Harvest to create datasets from Harvest in Domo Workbench and then build visualizations in the Domo service.
-
Query JDBC-ODBC Bridge Data in ColdFusion
Write standard ColdFusion data access code to connect to JDBC-ODBC Bridge.
-
Moving Data from LDAP to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live LDAP data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate with DB2 Data in JReport Designer
Create charts and reports based on IBM DB2 in JReport Designer.
-
Replicate Multiple Oracle HCM Cloud Accounts
Replicate multiple Oracle HCM Cloud accounts to one or many databases.
-
Automate Workday Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Workday and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automated Continuous Sage Cloud Accounting Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Sage Business Cloud Accounting replication to OneLake in Microsoft Fabric.
-
How to connect to Dynamics 365 Business Central Data in DBVisualizer
Integrate Dynamics 365 Business Central with visual data analysis tools and data connection wizards in DBVisualizer
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live MongoDB 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
-
Visualize ZohoPeople Data in TIBCO Spotfire through ADO.NET
Integrate ZohoPeople into dashboards in TIBCO Spotfire.
-
Build Visualizations of SAP Business One Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Business One in Birst.
-
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.
-
Query Impala Data as a MySQL Database in Node.js
Execute MySQL queries against Apache Impala from Node.js.
-
Build Agents in Relevance AI with Access to Live CSV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on CSV/TSV Files within intelligent agent workflows.
-
Establish a Live Connection with Flowlu Data using Tableau Bridge
The CData ODBC Driver for Flowlu enables you to integrate live Flowlu into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Confluence Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Atlassian Confluence and build visualizations in Tableau.
-
Build AI/ML Models with Live Opsgenie Data using Dataiku
Connect Opsgenie Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To an ODBC Data Source for ShipStation
Create an ODBC connection to ShipStation in Informatica and browse and transfer ShipStation.
-
Automated Continuous ZohoMarketingHub Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ZohoMarketingHub replication to OneLake in Microsoft Fabric.
-
How to publish and share Oracle SCM Data dashboards with Tableau Server
The CData ODBC driver for Oracle SCM enables you integrate Oracle SCM into Tableau dashboards.
-
Connect to Sage 200 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sage 200 in the Denodo Virtual DataPort Administrator.
-
Stream Timely Data into Apache Kafka Topics
Access and stream Timely in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
How to load Elasticsearch data into Elasticsearch via Logstash
Introducing a simple method to load Elasticsearch data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Natively Connect to SAP Business One Data in PHP
The CData ODBC driver for SAP Business One enables you to create PHP applications with connectivity to SAP Business One. Leverage the native support for ODBC in PHP.
-
Easily Integrate Hacker News Data in Lazarus Pascal IDE
Learn how to easily integrate live Hacker News in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Build Visualizations of Browserless Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Browserless in Birst.
-
Connect to Cvent Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Cvent using standard SQL.
-
Replicate AlloyDB Data to Multiple Databases
Replicate Google AlloyDB to disparate databases with a point-and-click configuration.