CData Software - Knowledge Base
Recent Articles
-
How to Visualize Microsoft Teams Data in Python with pandas
Use pandas and other modules to analyze and visualize live Microsoft Teams data in Python.
-
How to Connect to & Open Clockify Data in Microsoft Excel
This article uses the CData ODBC driver for Clockify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to ServiceDesk Plus Data in DBArtisan
Use wizards in DBArtisan to configure ServiceDesk Plus data as a data source.
-
How to connect to SAP HANA XS Advanced Data in DBVisualizer
Integrate SAP HANA XS Advanced data with visual data analysis tools and data connection wizards in DBVisualizer
-
Build CouchDB-Connected Apps in Choreo
Use CData Connect AI to connect to CouchDB Data from Choreo and build custom apps using live CouchDB data.
-
Working with Marketo Data in LINQPad
Execute LINQ queries to Marketo data in LINQPad.
-
Automated Continuous Trello Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Trello replication to delimited files (CSV/TSV).
-
Connect to Perplexity Data in DBeaver
Use the CData ODBC Driver to connect to Perplexity data in DBeaver.
-
Connect to Gmail Data in Google Apps Script via Connect AI
Use CData Connect AI to access Gmail data in Google Apps Script.
-
Build Agents in Relevance AI with Access to Live Azure Data Lake Storage Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Azure Data Lake Storage data within intelligent agent workflows.
-
Consume Azure Data Catalog OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Data Catalog data as OData feeds from PowerBuilder using the API Server.
-
Build Automated Workflows with Live DB2 Data in Workato
Use CData Connect AI to connect to live DB2 data and build automated workflows in Workato.
-
FHIR Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to FHIR data through CData Connect AI using different applications and tools.
-
Build an OLAP Cube in SSAS from Invoiced Data
Establish a connection to Invoiced data data from SQL Server Analysis Services, and use the Invoiced Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to create Visio diagrams from Zoho CRM Data
Automatically update Zoho CRM data with the changes you make to Visio master shapes.
-
Connecting Moonlit Workflow with GitLab Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your GitLab data in real time.
-
Easily Integrate ZohoSubscriptions Data in Lazarus Pascal IDE
Learn how to easily integrate live ZohoSubscriptions data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use Grok to Talk to Your Google Contacts Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Google Contacts data for you.
-
Oracle Sales Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Oracle Sales facts in real time.
-
Integrate Live Aha! Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Aha! data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Use the CData SSIS Components to Insert New or Update Existing Oracle Service Cloud Records from SQL Server
Easily push SQL Server data to Oracle Service Cloud using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Oracle Service Cloud or update existing records with data from a SQL Server database.
-
Integrate Theia IDE with Live HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE's built-in AI agents to securely access and query live HCL Domino data from within the development environment.
-
Integrating OpenCode with Epicor Kinetic 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 Informatica Mappings From/To an ODBC Data Source for Splunk
Create an ODBC connection to Splunk in Informatica and browse and transfer Splunk data.
-
Excel Spreadsheet Automation on SAP Business One Data with the QUERY Formula
Pull data from SAP Business One, automate spreadsheets, and more with the QUERY formula.
-
Validate Brex Data with QuerySurge
Access and validate Brex data in QuerySurge using the CData JDBC Driver.
-
Getting Started with the CData Power BI Connector for OneNote
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for OneNote.
-
DataBind Controls to Sybase IQ Data in C++Builder
DataBind to Sybase IQ data in C++Builder with standard components and controls.
-
Access Live SendPulse Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live SendPulse data from your Excel spreadsheets.
-
Automated Continuous Sybase IQ Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Sybase IQ replication to Google BigQuery.
-
Connect to ServiceDesk Plus 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 ServiceDesk Plus and work with ServiceDesk Plus data in your FileMaker application.
-
Visualize Live Anaplan Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Anaplan data into custom reports in Power BI.
-
How to Connect SAP HANA Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live SAP HANA data in real time using natural language.
-
Connect to Exact Online Data in RapidMiner
Integrate Exact Online data with standard components and data source configuration wizards in RapidMiner Studio.
-
Add Parquet Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Parquet with the Informatica Enterprise Data Catalog to classify and organize data.
-
Object-Relational Mapping (ORM) with Amazon Athena 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 Amazon Athena data into a Java-based ORM framework, Hibernate.
-
Use the CData ODBC Driver for HDFS in Microsoft Power Query
You can use the CData HDFS ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import HDFS data into Microsoft Power Query.
-
Build a Simple VCL Application for Notion Data
How to build a simple VCL Application to view Notion data in RAD Studio using the CData ODBC Driver for Notion.
-
Automated Continuous MessageBird Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable MessageBird data replication to OneLake in Microsoft Fabric.
-
Integrate MariaDB Data in the Pentaho Report Designer
Publish reports based on MariaDB data in the Pentaho BI tool.
-
How to create QuickBooks Online federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for QuickBooks Online data in MySQL .
-
Automated Continuous Azure Synapse Replication to Oracle
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Oracle.
-
Getting Started with the CData ODBC Driver for Asana
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Asana.
-
Connect to Sybase Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Sybase and the Script function in FileMaker Pro to connect to Sybase and work with Sybase data in your FileMaker application.
-
Connect to Freshdesk Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Freshdesk data.
-
How to connect PolyBase to Zoho Projects
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Projects data.
-
How to Access Live Pipedrive Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Pipedrive enables you to integrate Pipedrive data into workflows built using Microsoft Power Automate Desktop.
-
Visualize SAP HANA XS Advanced Data in Sisense
Create an ElastiCube in Sisense app with access to SAP HANA XS Advanced data.
-
Integrating Kiro with Telegram 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.
-
LinkedIn Reporting in OBIEE with the LinkedIn JDBC Driver
Deploy the LinkedIn JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Zoho Projects Data from AWS Glue
Use CData Connect AI to gain access to live Zoho Projects data from your AWS Glue jobs.
-
Connect to Splunk Data from HeidiSQL
Use CData Connect AI to connect to and query live Splunk data from HeidiSQL.
-
Establish a Live Connection with SAP HANA XS Advanced Data using Tableau Bridge
The CData ODBC Driver for SAP HANA XS Advanced enables you to integrate live SAP HANA XS Advanced data into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to ClickUp Data from IntelliJ
Integrate connectivity to ClickUp data with wizards in IntelliJ.
-
Integrating OpenCode with XML 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.
-
Integrate Live RSS Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live RSS feeds from within the IDE.
-
How to create Visio diagrams from Teradata Data
Automatically update Teradata data with the changes you make to Visio master shapes.
-
Connect to OData Services 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 OData services.
-
Connecting Agentforce with SharePoint 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 SharePoint data for you.
-
Connecting GenSpark with Vault CRM Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Vault CRM data without any replication or custom integration required.
-
How to Connect to & Open Keap Data in Microsoft Excel
This article uses the CData ODBC driver for Keap to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Create HelloSign Dataflows on PowerBI.com
Connect to the CData Power BI Connector for HelloSign from PowerBI.com to create Power BI Dataflows with real-time data.
-
Getting Started with the CData JDBC Driver for RSS
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for RSS.
-
Migrating data from ZarMoney to Databricks using CData SSIS Components.
Easily push ZarMoney data to Databricks using the CData SSIS Tasks for ZarMoney and Databricks.
-
Query RSS Feeds through ODBC in Node.js
Use node-odbc to execute SQL queries against RSS feeds from Node.js.
-
Getting Started with the CData Python Connector for QuickBooks Time
Learn to install and license the CData Python Connector and configure a connection to live QuickBooks Time data.
-
How to load Miro data into Elasticsearch via Logstash
Introducing a simple method to load Miro data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
LINQ to Trello 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 Trello Data Provider.
-
Automated Continuous GitLab Replication to MySQL
Use CData Sync for automated, continuous, customizable GitLab replication to MySQL.
-
Connect Printify to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Printify with IBM WebSphere for seamless data integration and connectivity.
-
Visualize Toggl Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Toggl data.
-
How to Connect to Live Redis 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 Redis data through natural language.
-
Analyze YouTube Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of YouTube Analytics data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate with Acumatica Data in JReport Designer
Create charts and reports based on Acumatica data in JReport Designer.
-
Connect to Salesforce Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Salesforce.
-
How to Work with PDFMonkey Data in ETL Validator JDBC
Connect to PDFMonkey from ETL Validator jobs using the CData Software JDBC Driver.
-
How to connect to Vercel Data in DBVisualizer
Integrate Vercel data with visual data analysis tools and data connection wizards in DBVisualizer
-
Visualize SAP Hybris C4C Data in TIBCO Spotfire through OData
Integrate SAP Hybris C4C data into dashboards in TIBCO Spotfire.
-
Integrating GitHub Copilot with Vimeo 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 Live Shortcut Data in MicroStrategy through CData Connect AI
Create a live connection to Shortcut Data in CData Connect AI and connect to your Shortcut data from MicroStrategy.
-
How to Create Power BI Visual Reports with Real-Time QuickBooks Online Data
Use CData Power BI Connectors to visualize QuickBooks Online data in Power BI.
-
Connecting Agentforce with Microsoft Entra ID 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 Microsoft Entra ID data for you.
-
How to Connect to Live Tavily Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Tavily data securely in real time.
-
Analyze Active Directory Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Active Directory from Power Pivot. You will use the Table Import Wizard to load Active Directory data. You can visually build the import query or use any SQL supported by the driver.
-
Query Live ServiceNow Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live ServiceNow data directly from the development environment.
-
Stream Jodoo Data into Apache Kafka Topics
Access and stream Jodoo data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData ODBC Driver for Snapchat Ads from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Snapchat Ads to connect to Snapchat Ads data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Snapchat Ads data in Excel.
-
How to Access Live Productboard Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Productboard enables you to integrate Productboard data into workflows built using Microsoft Power Automate Desktop.
-
Use Microsoft Copilot Studio to talk to your Snapchat Ads 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 Snapchat Ads data for you.
-
Migrating data from Zoho Inventory to Snowflake using CData SSIS Components.
Easily push Zoho Inventory data to Snowflake using the CData SSIS Tasks for Zoho Inventory and Snowflake.
-
Use the CData Software ODBC Driver for GetResponse in MicroStrategy Desktop
Connect to GetResponse data in MicroStrategy Desktop using the CData Software ODBC Driver for GetResponse.
-
Getting Started with the CData Excel Add-In for GitLab
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for GitLab.
-
Query AdRoll Data in ColdFusion
Write standard ColdFusion data access code to connect to AdRoll data.
-
Automate VWO Integration Tasks from PowerShell
Are you in search of a quick and easy way to access VWO data from PowerShell? This article demonstrates how to utilize the VWO Cmdlets for tasks like connecting to VWO data, automating operations, downloading data, and more.
-
Connect to SendInBlue Data in Jaspersoft Studio
Execute SQL to remote SendInBlue data in Jaspersoft Studio.
-
Integrate Cline with Live Snowflake Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Snowflake data from within your IDE.
-
Create Active Directory-Connected Business Apps in AppSheet
Connect to Active Directory Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Active Directory data.
-
Integrating Antigravity CLI with JotForm data via CData CLI
Connect JotForm data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Create Power BI Visual Reports with Real-Time Exa Data
Use CData Power BI Connectors to visualize Exa data in Power BI.
-
Using the CData Software ODBC Driver for Figshare in PyCharm
Connect to Figshare as an ODBC data source in PyCharm using the CData Software ODBC Driver for Figshare.