CData Software - Knowledge Base
Recent Articles
-
Connect to SAP SuccessFactors Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live SAP SuccessFactors data from Filemaker Pro on Mac.
-
Connect to Adobe Analytics Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Adobe Analytics and the SQL Gateway to access Adobe Analytics data from Google Apps Script.
-
How to Connect the Power BI Service to Procore: Complete Guide
Connect to the CData Software Power BI Connector for Procore from PowerBI.com to provide real-time Procore data across the organization.
-
How to Work with Snapchat Ads Data in AWS Glue Jobs Using JDBC
Connect to Snapchat Ads from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Google Search Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Google Search from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connecting Pipedream with Azure Data Catalog 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 Azure Data Catalog data in real time.
-
Visualize Snowflake Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Snowflake data.
-
Getting Started with the CData Tableau Connector for Neo4J
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Neo4J.
-
Integrate with Authorize.Net Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Authorize.Net data to a JSON file on disk.
-
Connect to Gong Data in RapidMiner
Integrate Gong data with standard components and data source configuration wizards in RapidMiner Studio.
-
Design BIRT Reports on MySQL Data
Provide current MySQL data to your embedded analytics.
-
Extract, Transform, and Load SFTP Data in Informatica PowerCenter
Create a simple Workflow for SFTP data in Informatica PowerCenter.
-
Natively Connect to EnterpriseDB Data in PHP
The CData ODBC driver for EnterpriseDB enables you to create PHP applications with connectivity to EnterpriseDB data. Leverage the native support for ODBC in PHP.
-
Build Adobe Target-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Adobe Target data and build Adobe Target-connected web apps with Axios.
-
Use Agno to Talk to Your Notion Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Notion data for you.
-
Access Live Google Forms Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Google Forms data into the statistical analysis tools available in SAS JMP. This article shows how to use Google Forms data in the Graph Builder and Query Builder.
-
Analyze Confluence Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Confluence data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Use JayDeBeApi to access PagerDuty Data in Python
Use standard Python scripting and the development environment of your choice to access live PagerDuty data.
-
Create Power BI Reports on Real-Time ZarMoney Data
Use the CData ODBC Driver for ZarMoney to visualize ZarMoney data in Power BI Desktop.
-
Getting Started with the CData Excel Add-In for Vault CRM
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Vault CRM.
-
How to Connect Cvent 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 Cvent data in real time using natural language.
-
Automated Continuous Instagram Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Instagram replication to Google Cloud SQL.
-
How to connect to Telegram Data from IntelliJ
Integrate connectivity to Telegram data with wizards in IntelliJ.
-
Automated Continuous Helpscout Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Helpscout replication to Amazon S3.
-
Automated Continuous JSON Replication to Oracle
Use CData Sync for automated, continuous, customizable JSON replication to Oracle.
-
Using the CData Software ODBC Driver for ClickUp in PyCharm
Connect to ClickUp as an ODBC data source in PyCharm using the CData Software ODBC Driver for ClickUp.
-
Choosing the Best Method to Connect Oracle HCM Cloud to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Oracle HCM Cloud data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Getting Started with the CData ODBC Driver for Intercom
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Intercom.
-
Use the CData ODBC Driver for Instantly from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Instantly to connect to Instantly data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Instantly data in Excel.
-
Connect to ZohoDesk Data in RazorSQL
Connect to ZohoDesk from wizards and query ZohoDesk data from the GUI in the RazorSQL database management tool.
-
Integrate Open WebUI with Live SageHR Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live SageHR data from within the chat interface.
-
DataBind Charts to Zoho CRM Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Zoho CRM data from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Create Figshare-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Figshare Data from OutSystems and build custom enterprise apps using live Figshare data.
-
Import Real-Time Mistral AI Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Mistral AI data in ColdFusion.
-
How to Connect DBeaver to Coinbase via a JDBC Driver
Manage Coinbase data with visual tools in DBeaver like the query browser.
-
Migrating data from Clockify to Snowflake using CData SSIS Components.
Easily push Clockify data to Snowflake using the CData SSIS Tasks for Clockify and Snowflake.
-
Connect to EnterpriseDB Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for EnterpriseDB Data and connect to EnterpriseDB data in Akorbi Digital RunMyProcess.
-
Integrating Kiro with Oracle HCM Cloud 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 Adobe Target Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Adobe Target data.
-
How to Create Power BI Visual Reports with Real-Time Cohere Data
Use CData Power BI Connectors to visualize Cohere data in Power BI.
-
Getting Started with the CData ODBC Driver for ZeroBounce
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for ZeroBounce.
-
Connect to SQL Server Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with SQL Server Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to Connect to Bullhorn CRM Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Bullhorn CRM data. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous SAP Ariba Source Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP Ariba Source replication to SingleStore.
-
How to Connect to LinkedIn Ads Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to LinkedIn Ads data. Leverage the pyodbc module for ODBC in Python.
-
Automate Zoom Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoom data from PowerShell? This article demonstrates how to utilize the Zoom Cmdlets for tasks like connecting to Zoom data, automating operations, downloading data, and more.
-
Query Avalara AvaTax Data in DataGrip
Create a Data Source for Avalara AvaTax in DataGrip and use SQL to query live Avalara AvaTax data.
-
How to Access Live Zoho Recruit Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Zoho Recruit enables you to integrate Zoho Recruit data into workflows built using Microsoft Power Automate Desktop.
-
Visualize Bitbucket Data in Sisense
Create an ElastiCube in Sisense app with access to Bitbucket data.
-
Query Live Google Calendar 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 Google Calendar data directly from the development environment.
-
Connect to HDFS Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to HDFS.
-
Access Cassandra Data from MySQL in PHP
Connect to Cassandra through the standard MySQL libraries in PHP.
-
Integrate with Live Bitly Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Bitly from the MuleSoft Anypoint Platform to integrate live Bitly data into custom reports and dashboards.
-
Automate Amazon Athena Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon Athena data from PowerShell? This article demonstrates how to utilize the Amazon Athena Cmdlets for tasks like connecting to Amazon Athena data, automating operations, downloading data, and more.
-
Integrate Live Amazon S3 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon S3 data and integrate live Amazon S3 data into apps built in Microsoft Power Apps.
-
Connect to Square Data from HeidiSQL
Use CData Connect AI to connect to and query live Square data from HeidiSQL.
-
Connecting Pipedream with FHIR 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 FHIR data in real time.
-
Connect to Azure Data Catalog Data in ACL Analytics
Connect to Azure Data Catalog data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Azure Data Catalog data.
-
Integrate Live Zoom Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Zoom data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
Visualize Live NetSuite Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live NetSuite data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Build Visualizations of Jira Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Jira data in Birst.
-
Easily Integrate Dropbox Data in Lazarus Pascal IDE
Learn how to easily integrate live Dropbox data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect Flowise AI Agents to Live MarkLogic Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live MarkLogic data without replication.
-
Migrating data from Coda to Snowflake using CData SSIS Components.
Easily push Coda data to Snowflake using the CData SSIS Tasks for Coda and Snowflake.
-
Work with Qualaroo Data in FoxPro
Load Qualaroo data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData ODBC Driver for TigerGraph from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for TigerGraph to connect to TigerGraph data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring TigerGraph data in Excel.
-
Connect to FreeAgent Data in DBeaver
Use the CData ODBC Driver to connect to FreeAgent data in DBeaver.
-
Connect to Google Spanner Data in CloverDX (formerly CloverETL)
Transfer Google Spanner data using the visual workflow in the CloverDX data integration tool.
-
Integrating LlamaIndex with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Acumatica data in real time.
-
Work with Live Freshservice Data in Power Query
Use CData Connect AI to connect to Freshservice data and work with live Freshservice data in Microsoft Power Query.
-
Connect to Zoho Inventory Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Zoho Inventory data using standard SQL.
-
How to integrate Metabase with Stripe Data
Use CData Connect AI to connect to live Stripe data and create an interactive dashboard in Metabase from Stripe data.
-
Visualize GetResponse Data in TIBCO Spotfire through ADO.NET
Integrate GetResponse data into dashboards in TIBCO Spotfire.
-
Integrate Google's Antigravity Agent with Live ZohoMarketingHub Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live ZohoMarketingHub data using the Model Context Protocol.
-
How to Seamlessly Import Google Translate Data into IBM SPSS Modeler
Integrate Google Translate data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Create Salesforce-Connected Applications in Appsmith
Connect to Salesforce Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Salesforce data.
-
View Reports on Real-Time SendInBlue Data in Power BI Report Server
Use the CData ODBC Driver for SendInBlue to visualize SendInBlue data in Power BI Desktop and then publish them to Power BI Report Server.
-
Automated Continuous Discord Replication to Databricks
Use CData Sync for automated, continuous, customizable Discord replication to Databricks.
-
Integrate LibreChat with Live Sage 200 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Sage 200 data from within the chat interface.
-
Use Agno to Talk to Your Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Timely data for you.
-
How to use SQLAlchemy ORM to access Clari Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Clari data.
-
Integrate Kintone with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Kintone with External Services.
-
Excel Spreadsheet Automation on FreeAgent Data with the QUERY Formula
Pull data from FreeAgent, automate spreadsheets, and more with the QUERY formula.
-
Automate Copper Data Replication to Azure Data Lake
Use CData Sync to customize and automate Copper data replication to Azure Data Lake.
-
How to Visualize Insightly Data in Python with pandas
Use pandas and other modules to analyze and visualize live Insightly data in Python.
-
Connect to SAP ByDesign Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for SAP ByDesign data.
-
Visualize Cloudant Data in TIBCO Spotfire through OData
Integrate Cloudant data into dashboards in TIBCO Spotfire.
-
Visualize Live Azure Table Data in the Power BI Service
Use CData Connect AI to connect to live Azure Table data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Use Azure AI Foundry to Talk to Your SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your SQL Server data for you.
-
Getting Started with the CData JDBC Driver for LinkedIn Ads
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for LinkedIn Ads.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Freshservice
Provide connectivity to Freshservice data through an SAP BusinessObjects universe.
-
Use the CData ODBC Driver for Hugging Face from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Hugging Face to connect to Hugging Face data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Hugging Face data in Excel.
-
Publish Supabase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Supabase data.
-
Create Power BI Reports on Real-Time Amplitude Data
Use the CData ODBC Driver for Amplitude to visualize Amplitude data in Power BI Desktop.
-
Connect to SAP Ariba Procurement Data in DBArtisan
Use wizards in DBArtisan to configure SAP Ariba Procurement data as a data source.
-
Connecting Agentforce with Spark 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 Spark data for you.
-
Create Notion-Connected Nintex Workflows
Use CData Connect AI to connect to Notion Data from Nintex Workflow Cloud and build custom workflows using live Notion data.
-
Automated Continuous Google Search Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Search replication to MongoDB.
-
Integrating LangGraph with Cloudflare Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Cloudflare data within automated workflows.
-
Connect to and Visualize Live JSON Services in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live JSON services.