CData Software - Knowledge Base
Recent Articles
-
Access Live ADP Data in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live ADP data through MCP integration.
-
Build Apps with Live Suadeo Data Using the Low-Code Development Platform of Mendix
Connect Suadeo data with Mendix to build apps using the CData JDBC Driver for Suadeo.
-
Build Voice Agents in ElevenLabs with access to Live Epicor Kinetic Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Epicor Kinetic data.
-
Connecting Agentforce with MYOB AccountRight 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 MYOB AccountRight data for you.
-
How to Build an ETL App for Act-On Data in Python with CData Connect AI
Build ETL pipelines that read and write live Act-On data in Python with petl and the CData Connect AI Python SDK.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Parquet
Provide connectivity to Parquet data through an SAP BusinessObjects universe.
-
Create a Data Access Object for Perigon Data using JDBI
A brief overview of creating a SQL Object API for Perigon data in JDBI.
-
Build Data Flows from Authorize.Net to SQL Server using SSIS
Easily back up Authorize.Net data to SQL Server using the SSIS components for Authorize.Net.
-
Connect to Strava Data in JRuby
Create a simple JRuby app with access to live Strava data.
-
How to connect to MYOB AccountRight Data with Squirrel SQL client
Connect to MYOB AccountRight data and execute queries in the Squirrel SQL Client.
-
Integrate Reckon Data in the Pentaho Report Designer
Publish reports based on Reckon data in the Pentaho BI tool.
-
Integrate Shippo Data in Pentaho Data Integration
Build ETL pipelines based on Shippo data in the Pentaho Data Integration tool.
-
How to Easily Query Copper Data in OpenOffice Base
Connect to Copper data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Bridge ClickTime Connectivity with Apache NiFi
Access and process ClickTime data in Apache NiFi using the CData JDBC Driver.
-
Use the CData Software JDBC Driver for SharePoint Excel Services in MicroStrategy Web
Connect to SharePoint Excel Services data in MicroStrategy Web using the CData Software JDBC Driver for SharePoint Excel Services.
-
Deploy the ADO.NET Provider for Sybase on an SSRS Report Server
Connect to Sybase data 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 Work with SpaceX Data in AWS Glue Jobs Using JDBC
Connect to SpaceX from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Work with Azure Data Catalog Data in AWS Glue Jobs Using JDBC
Connect to Azure Data Catalog from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Discord Data in ACL Analytics
Connect to Discord data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Discord data.
-
Visualize Live Azure Analysis Services Data in the Power BI Service
Use CData Connect AI to connect to live Azure Analysis Services data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Build an ETL App for LinkedIn Ads Data in Python with CData
Create ETL applications and real-time data pipelines for LinkedIn Ads data in Python with petl.
-
DataBind Controls to JotForm Data in C++Builder
DataBind to JotForm data in C++Builder with standard components and controls.
-
Automated Continuous Bitly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Bitly replication to IBM DB2.
-
Easily Integrate Superchat Data in Lazarus Pascal IDE
Learn how to easily integrate live Superchat data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Use the CData ODBC Driver for Acumatica from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Acumatica to connect to Acumatica data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Acumatica data in Excel.
-
Manage FreeAgent Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for FreeAgent.
-
Design BIRT Reports on Paddle Data
Provide current Paddle data to your embedded analytics.
-
Build Apps with Live GetResponse data in Adalo using CData Connect AI
Use CData Connect AI to integrate live GetResponse data into the Adalo platform and build custom mobile and web applications with real-time GetResponse data.
-
How to publish and share Supabase Data dashboards with Tableau Server
The CData ODBC driver for Supabase enables you integrate Supabase data into Tableau dashboards.
-
Create Reports with VWO Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date VWO data.
-
View Reports on Real-Time VWO Data in Power BI Report Server
Use the CData ODBC Driver for VWO to visualize VWO data in Power BI Desktop and then publish them to Power BI Report Server.
-
How to Connect to Placid Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Placid data. Leverage the pyodbc module for ODBC in Python.
-
Connect to SingleStore Data in RapidMiner
Integrate SingleStore data with standard components and data source configuration wizards in RapidMiner Studio.
-
How to connect PolyBase to Browserless
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Browserless data.
-
Establish a Live Connection with Freshdesk Data using Tableau Bridge
The CData ODBC Driver for Freshdesk enables you to integrate live Freshdesk data into Tableau Cloud dashboards using the Tableau Bridge.
-
Connect to Hubstaff Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Hubstaff as an External Source in Dremio.
-
Integrate with Bright Data Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Bright Data data to a JSON file on disk.
-
Use the CData ODBC Driver for JotForm in Microsoft Power Query
You can use the CData JotForm ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import JotForm data into Microsoft Power Query.
-
Integrating Cursor with Humanity 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.
-
Connecting Pipedream with LDAP Objects 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 LDAP data in real time.
-
How to Seamlessly Import Dynamics 365 Business Central Data into IBM SPSS Modeler
Integrate Dynamics 365 Business Central data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate Open WebUI with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Microsoft Exchange data from within the chat interface.
-
Add WordPress Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for WordPress with the Informatica Enterprise Data Catalog to classify and organize data.
-
Brex Reporting in OBIEE with the Brex JDBC Driver
Deploy the Brex JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Azure Data Lake Storage Data in DataGrip
Create a Data Source for Azure Data Lake Storage in DataGrip and use SQL to query live Azure Data Lake Storage data.
-
Natively Connect to Cloudant Data in PHP
The CData ODBC driver for Cloudant enables you to create PHP applications with connectivity to Cloudant data. Leverage the native support for ODBC in PHP.
-
Build a PostgreSQL Interface for Auth0 Data using the CData JDBC Driver
Use the Remoting features of the Auth0 JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating LlamaIndex with Salesforce Data 360 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Salesforce Data 360 data in real time.
-
How to Connect to Live Microsoft Planner Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Microsoft Planner data for you.
-
Integrate Goose with Live eBay Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live eBay data from within the local AI agent.
-
Build MVC Applications with Connectivity to ConvertAPI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ConvertAPI from an ASP.NET MVC application.
-
Integrate Azure Data Lake Storage Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Azure Data Lake Storage data and integrate live Azure Data Lake Storage data into your Power Automate tasks.
-
Connect to Dynamics CRM Data in Claris FileMaker Pro
Use the CData ODBC Driver for Dynamics CRM in FileMaker Pro to connect to Dynamics CRM and work with Dynamics CRM data in your FileMaker applications.
-
Getting Started with the CData Tableau Connector for Slack
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Slack.
-
Visualize HCL Domino Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load HCL Domino data into TIBCO Spotfire.
-
Automated Continuous Microsoft Exchange Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to AlloyDB.
-
Connect to and Query Mistral AI Data in QlikView over ODBC
Create data visualizations with Mistral AI data in QlikView.
-
Integrating Antigravity CLI with Presto data via CData CLI
Connect Presto data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous Vimeo Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Vimeo replication to Google BigQuery.
-
Consume HBase OData Feeds in SAP Lumira
Use the API Server to create data visualizations on HBase feeds that reflect any changes in SAP Lumira.
-
Build Salesloft Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Salesloft data and build visualizations in Tableau Cloud.
-
Replicate ChartMogul Data from PowerShell
Write a quick PowerShell script to query ChartMogul data. Use connectivity to the live data to replicate ChartMogul data to SQL Server.
-
Connect to Dynamics 365 Data in HULFT Integrate
Connect to Dynamics 365 as a JDBC data source in HULFT Integrate
-
Access Live Gorgias Data in Coginiti Pro
Connect to and query live Gorgias data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Integrating Cursor with SurveyMonkey 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 Confluence Data in Claris FileMaker Pro
Use the CData ODBC Driver for Confluence in FileMaker Pro to connect to Confluence and work with Confluence data in your FileMaker applications.
-
Analyze SageHR Data in Looker
Use CData Connect AI to connect to SageHR Data from Looker and build custom apps using live SageHR data.
-
Build a Simple VCL Application for Mode Data
How to build a simple VCL Application to view Mode data in RAD Studio using the CData ODBC Driver for Mode.
-
Connect to Avalara AvaTax Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live Avalara AvaTax data from Filemaker Pro on Mac.
-
Getting Started with the CData Python Connector for Teamgate
Learn to install and license the CData Python Connector and configure a connection to live Teamgate data.
-
Design BIRT Reports on PolarTeamPro Data
Provide current PolarTeamPro data to your embedded analytics.
-
Build an OLAP Cube in SSAS from xBase Data
Establish a connection to xBase data data from SQL Server Analysis Services, and use the xBase Data Provider to build OLAP cubes for use in analytics and reporting.
-
Sage 300 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage 300 facts in real time.
-
Getting Started with the CData Power BI Connector for Datadog
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Adobe Experience Manager Reporting in OBIEE with the Adobe Experience Manager JDBC Driver
Deploy the Adobe Experience Manager JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
DataBind Email Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Email with the DevExpress Windows Forms and Web controls to provide Email data to a chart.
-
Connect to HBase Data in JRuby
Create a simple JRuby app with access to live HBase data.
-
Create Reports with Snowflake Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Snowflake data.
-
Analyze Salesforce Marketing Data in Cognos Analytics
Use CData Connect AI to connect to Salesforce Marketing Data from Cognos Analytics and analyze live Salesforce Marketing data.
-
DataBind Charts to Avalara AvaTax Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Avalara AvaTax 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.
-
Consume Bullhorn CRM OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Bullhorn CRM feeds that reflect any changes in SAP Lumira.
-
Integrate Salesforce CRM Analytics with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Salesforce CRM Analytics with External Services.
-
Add Tally Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Tally with the Informatica Enterprise Data Catalog to classify and organize data.
-
Publish eBay Analytics-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live eBay Analytics data.
-
Automated Mocean Data Replication to Teradata
Use CData Sync to Customize and automate Mocean data replication to Teradata.
-
Access Live Opsgenie Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Opsgenie data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate Live MongoDB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to MongoDB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live MongoDB data.
-
Work with Live Zendesk Data in Power Query
Use CData Connect AI to connect to Zendesk data and work with live Zendesk data in Microsoft Power Query.
-
Add LeadDesk Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for LeadDesk with the Informatica Enterprise Data Catalog to classify and organize data.
-
How to Visualize Mailgun Data in Python with pandas
Use pandas and other modules to analyze and visualize live Mailgun data in Python.
-
Build an OLAP Cube in SSAS from Pinterest Data
Establish a connection to Pinterest data data from SQL Server Analysis Services, and use the Pinterest Data Provider to build OLAP cubes for use in analytics and reporting.
-
How to connect PolyBase to SAP HANA XS Advanced
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAP HANA XS Advanced data.
-
Connect to Freshservice Data from a Connection Pool in JBoss
Integrate Freshservice data into Java servlets: Use the Management Console in JBoss to install the Freshservice JDBC Driver.
-
How to Work with Pinecone Data in ETL Validator JDBC
Connect to Pinecone from ETL Validator jobs using the CData Software JDBC Driver.
-
Publish Opsgenie-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Opsgenie data.
-
Use Agno to Talk to Your ShipStation 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 ShipStation data for you.
-
Work with OneNote Data in FoxPro
Load OneNote data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Bridge Freshteam Connectivity with Apache NiFi
Access and process Freshteam data in Apache NiFi using the CData JDBC Driver.
-
Connect to XML Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for XML data.
-
Moving Data from Azure Data Lake Storage to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Azure Data Lake Storage data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.