CData Software - Knowledge Base
Recent Articles
-
Access Live Twilio 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 Twilio through MCP integration.
-
How to Query Live Monday.com Data in Claude Desktop
Connect to and query live Monday.com Data in Claude Desktop using CData MCP Server.
-
Deploy the ADO.NET Provider for LeadDesk on an SSRS Report Server
Connect to LeadDesk 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.
-
Access Live Dynamics 365 Business Central Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Dynamics 365 Business Central into the statistical analysis tools available in SAS JMP. This article shows how to use Dynamics 365 Business Central in the Graph Builder and Query Builder.
-
Use JayDeBeApi to access Sage Intacct Data in Python
Use standard Python scripting and the development environment of your choice to access live Sage Intacct.
-
Automated Continuous SAP Concur Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Concur replication to Snowflake.
-
Use ChatGPT to Talk to Your Power BI XMLA Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Power BI XMLA for you.
-
Integrating Kiro CLI with AgileCRM 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.
-
A PostgreSQL Interface for Impala Data (MySQL Remoting via JDBC)
Use the Remoting features of the Impala JDBC Driver to create a PostgreSQL entry-point for data access.
-
Build Presto-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Presto and build web apps with connectivity to live Presto.
-
Automated Continuous CouchDB Replication to SQL Server
Use CData Sync for automated, continuous, customizable CouchDB replication to SQL Server.
-
Build Oracle Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Oracle Database and build visualizations in Tableau Cloud.
-
Build Data Flows from Jira to SQL Server using SSIS
Easily back up Atlassian Jira to SQL Server using the SSIS components for Jira.
-
Access Live SAP BusinessObjects BI Data in Coginiti Pro
Connect to and query live SAP BusinessObjects BI from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Excel Spreadsheet Automation on Parallel Data with the QUERY Formula
Pull data from Parallel, automate spreadsheets, and more with the QUERY formula.
-
Connect to BambooHR Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for BambooHR Data and connect to BambooHR in Akorbi Digital RunMyProcess.
-
Replicate Multiple Oracle Sales Accounts
Replicate multiple Oracle Sales accounts to one or many databases.
-
Automate Microsoft OneDrive Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft OneDrive and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect to Gumroad Data in DBVisualizer
Integrate Gumroad with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Semantic Layer Views for Nuclia Data in APOS Live Data Gateway
Use the CData Connector for Nuclia in APOS Live Data Gateway to build Semantic Layer Views for Nuclia.
-
How to Connect to Live EnterpriseDB 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 EnterpriseDB through natural language.
-
Integrate LibreChat with Live Slack Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Slack from within the chat interface.
-
Getting Started with the CData Connect AI Python SDK for Zoho Books
Install the CData Connect AI Python SDK to read and write live Zoho Books with standard DB-API 2.0 Python code.
-
Integrate Goose with Live SAP Business One Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SAP Business One from within the local AI agent.
-
How to connect to Google Tasks Data from Spring Boot
Connect to Google Tasks in a Spring Boot Application using the CData API Driver for JDBC
-
How to work with Close Data in Apache Spark using SQL
Access and process Close Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData SSIS Components for Sage 300
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Sage 300.
-
How to create Visio diagrams from ActiveCampaign Data
Automatically update ActiveCampaign with the changes you make to Visio master shapes.
-
Use the CData API Server to Access OneNote Data in Microsoft PowerPivot
Use the CData API Server to connect to live Microsoft OneNote in the Power Pivot business intelligence tool.
-
Visualize Suadeo 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 Suadeo into TIBCO Spotfire.
-
Build Voice Agents in ElevenLabs with access to Live Sybase IQ Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Sybase IQ.
-
Integrate with ServiceNow Data in SnapLogic
Use CData Connect AI to connect to and integrate with live ServiceNow in SnapLogic.
-
How to create an RPA flow for Xero Data in UiPath Studio
Use the Xero ODBC Driver to create workflows that access real-time Xero Accounting without any coding.
-
Process & Analyze Close Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Close Data.
-
Use the CData ODBC Driver for Phoenix from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Phoenix to connect to Apache Phoenix from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Phoenix in Excel.
-
Connect to Asana Data in RazorSQL
Connect to Asana from wizards and query Asana from the GUI in the RazorSQL database management tool.
-
Create Datasets from Pipeline CRM in Domo Workbench and Build Visualizations of Pipeline CRM Data in Domo
Use the CData Software ODBC Driver for Pipeline CRM to create datasets from Pipeline CRM in Domo Workbench and then build visualizations in the Domo service.
-
How to Work with LDAP Objects in ETL Validator JDBC
Connect to LDAP from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Seamlessly Import ZohoInvoice Data into IBM SPSS Modeler
Integrate ZohoInvoice data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Write a Simple Go Application to work with SAP Ariba Source Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Ariba Source.
-
Integrate Cline with Live Smartsheet Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Smartsheet from within your IDE.
-
Getting Started with the CData JDBC Driver for Autopilot
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Autopilot.
-
Connect to Figshare Data in RapidMiner
Integrate Figshare with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Mouseflow Data in DBArtisan
Use wizards in DBArtisan to configure Mouseflow as a data source.
-
How to import SAP BusinessObjects BI Data into Apache Solr
Use the CData Software JDBC Driver for SAP BusinessObjects BI in Data Import Handler and create an automated import of SAP BusinessObjects BI to Apache Solr Enterprise Search platform.
-
Connect to SAP Ariba Procurement Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP Ariba Procurement using standard SQL.
-
Visualize Live Neo4J Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Neo4J into custom reports in Power BI.
-
How to Connect to Live Email Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Email without replication.
-
Visualize Greenplum Data in Sisense
Create an ElastiCube in Sisense app with access to Pivotal GreenPlum.
-
Automated Continuous Bugsnag Replication to Databricks
Use CData Sync for automated, continuous, customizable Bugsnag replication to Databricks.
-
Use the CData Software JDBC Driver for Azure Data Lake Storage in MicroStrategy Web
Connect to Azure Data Lake Storage in MicroStrategy Web using the CData Software JDBC Driver for Azure Data Lake Storage.
-
How to connect to HBase Data in DBVisualizer
Integrate Apache HBase with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData Software JDBC Driver for Dynamics 365 in MicroStrategy Web
Connect to Microsoft Dynamics 365 in MicroStrategy Web using the CData Software JDBC Driver for Dynamics 365.
-
Model, Search, and Visualize Live GitLab Data in ThoughtSpot
Use CData Connect AI to connect to live GitLab for modeling, searching, and visualizing.
-
Analyze PostgreSQL Data in Looker
Use CData Connect AI to connect to PostgreSQL Data from Looker and build custom apps using live PostgreSQL.
-
Automated Continuous Shippo Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Shippo replication to delimited files (CSV/TSV).
-
Create Power BI Reports on Real-Time Elorus Data
Use the CData ODBC Driver for Elorus to visualize Elorus in Power BI Desktop.
-
Create Informatica Mappings From/To a JDBC Data Source for Authorize.Net
Create Authorize.Net data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Asana Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Asana through CData Connect AI using different applications and tools.
-
Automated Continuous Exa Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Exa replication to IBM DB2.
-
Visualize Zoho Recruit Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Zoho Recruit.
-
Connect to OneNote Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Microsoft OneNote.
-
Automated Continuous SAP HANA XS Advanced Replication to Databricks
Use CData Sync for automated, continuous, customizable SAP HANA XS Advanced replication to Databricks.
-
Access Oracle Eloqua Data from MySQL in PHP
Connect to Oracle Eloqua through the standard MySQL libraries in PHP.
-
How to Connect the Power BI Service to HCL Domino: Complete Guide
Connect to the CData Software Power BI Connector for HCL Domino from PowerBI.com to provide real-time HCL Domino across the organization.
-
Build a PostgreSQL Interface for Aha! Data using the CData JDBC Driver
Use the Remoting features of the Aha! JDBC Driver to create a PostgreSQL entry-point for data access.
-
How to Connect the Power BI Service to Aha!: Complete Guide
Connect to the CData Software Power BI Connector for Aha! from PowerBI.com to provide real-time Aha! across the organization.
-
How to Connect Avalara AvaTax 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 Avalara AvaTax data in real time using natural language.
-
LINQ to FTP 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 FTP Data Provider.
-
Moving Data from EmailOctopus to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live EmailOctopus data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Getting Started with the CData ADO.NET Provider for Perplexity
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
Getting Started with the CData JDBC Driver for Bitbucket
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Bitbucket.
-
Explore Geographical Relationships in Nethunt Data with Power Map
Create data visualizations with Nethunt in Power Map.
-
Operational Reporting on eBay Analytics Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote eBay Analytics.
-
Create Datasets from CouchDB in Domo Workbench and Build Visualizations of CouchDB Data in Domo
Use the CData Software ODBC Driver for CouchDB to create datasets from Apache CouchDB in Domo Workbench and then build visualizations in the Domo service.
-
Visualize Oracle HCM Cloud Data in TIBCO Spotfire through OData
Integrate Oracle HCM Cloud into dashboards in TIBCO Spotfire.
-
Connect Perplexity Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Perplexity using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Live Google Contacts Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Google Contacts and integrate live Google Contacts into apps built in Microsoft Power Apps.
-
Create Dynamics NAV Data Visualizations in Power BI
The CData ODBC Driver for Dynamics NAV provides straightforward connectivity to live data for self-service business intelligence tools like Power BI: Create Power BI dashboards that you can refresh on demand.
-
Create Klipfolio Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Klipfolio data access from reports, embedded analytics, and more.
-
Connect to Real-Time Vercel Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use Vercel in Power Apps.
-
Use the CData Software JDBC Driver for Teradata in MicroStrategy Desktop
Connect to Teradata in MicroStrategy Desktop using the CData Software JDBC Driver for Teradata.
-
Visualize Zoho Projects Data in Sisense
Create an ElastiCube in Sisense app with access to Zoho Projects.
-
Explore Geographical Relationships in HubSpot Data with Power Map
Create data visualizations with HubSpot in Power Map.
-
Connect Hive to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Hive with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Google Forms Data in DBArtisan
Use wizards in DBArtisan to configure Google Forms as a data source.
-
Build AI/ML Models with Live Gumroad Data using Dataiku
Connect Gumroad Data with Dataiku using the CData API Driver for JDBC.
-
Build Automated Workflows with Live Microsoft Entra ID Data in Workato
Use CData Connect AI to connect to live Microsoft Entra ID and build automated workflows in Workato.
-
Getting Started with the CData Excel Add-In for Dynamics 365 Business Central
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics 365 Business Central.
-
Connect to xBase Data as an External Source in Dremio
Use the CData JDBC Driver to connect to xBase as an External Source in Dremio.
-
Getting Started with the CData ODBC Driver for Helpscout
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Helpscout.
-
Connect to Live SAP BusinessObjects BI Data in PostGresSQL Interface through CData Connect AI
Create a live connection to SAP BusinessObjects BI in CData Connect AI and connect to your SAP BusinessObjects BI from PostgreSQL.
-
Deploy the ADO.NET Provider for ChartMogul on an SSRS Report Server
Connect to ChartMogul 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.
-
Configure the CData JDBC Driver for GitLab in a Connection Pool in Tomcat
Connect to GitLab from a connection pool in Tomcat.
-
Design BIRT Reports on ADP Data
Provide current ADP to your embedded analytics.
-
Use Dash to Build Web Apps on Reckon Accounts Hosted Data via CData Connect AI
Build interactive Dash web apps on live Reckon Accounts Hosted using pandas and the CData Connect AI Python SDK.
-
Use the CData Software JDBC Driver for SAP Business Warehouse in MicroStrategy
Connect to SAP Business Warehouse in MicroStrategy Developer using the CData Software JDBC Driver for SAP Business Warehouse.
-
Process & Analyze Missive Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Missive Data.
-
Use Dash to Build to Web Apps on SAS xpt Data
Create Python applications that use pandas and Dash to build SAS xpt-connected web apps.
-
Connecting Pipedream with SAP HANA 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 SAP HANA data in real time.