CData Software - Knowledge Base
Recent Articles
-
Build Snapchat Ads Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Snapchat Ads data and build visualizations in Tableau.
-
How to connect to ConvertKit Data from IntelliJ
Integrate connectivity to ConvertKit data with wizards in IntelliJ.
-
Connect to JobNimbus in SpagoBI
Create reports featuring live JobNimbus data in SpagoBI Studio. Host JobNimbus reports on SpagoBI Server.
-
How to Access Live AdRoll Data in Power Automate Desktop via ODBC
The CData ODBC Driver for AdRoll enables you to integrate AdRoll data into workflows built using Microsoft Power Automate Desktop.
-
How to connect PolyBase to HDFS
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live HDFS data.
-
Operational Reporting on Basecamp Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Basecamp data.
-
How to Query Live iContact Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live iContact data data in natural language using Python.
-
Connect and Query Live Sage Intacct Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Sage Intacct data into Databricks and enable direct, live querying and analysis without replication.
-
Connect to Insightly Data in Ruby
Connect to Insightly data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build AI/ML Models with Live Notion Data using Dataiku
Connect Notion Data with Dataiku using the CData API Driver for JDBC.
-
Access Live Teradata Data in Excel 365 Online (Excel for the web)
Connect to Teradata data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Access Factorial Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Factorial data.
-
Explore Geographical Relationships in FormSite Data with Power Map
Create data visualizations with FormSite data in Power Map.
-
Build HubSpot-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live HubSpot data.
-
Feed MailerSend Data into FineReport
How to set MailerSend data as a JDBC data source in FineReport.
-
How to publish and share Amazon S3 Data dashboards with Tableau Server
The CData ODBC driver for Amazon S3 enables you integrate Amazon S3 data into Tableau dashboards.
-
How to Connect to & Open Moosend Data in Microsoft Excel
This article uses the CData ODBC driver for Moosend to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Build Basecamp-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Basecamp Data from Zoho Analytics and import live Basecamp data.
-
Create Dashboards and Visualize Live BambooHR Data in Geckoboard
Use CData Connect AI to connect to live BambooHR data and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Easily Integrate Databricks Data in Lazarus Pascal IDE
Learn how to easily integrate live Databricks data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create a Data Access Object for Perplexity Data using JDBI
A brief overview of creating a SQL Object API for Perplexity data in JDBI.
-
How to Visualize Adobe Commerce Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Adobe Commerce data in Python.
-
Automated Continuous Certinia Replication to Databricks
Use CData Sync for automated, continuous, customizable Certinia replication to Databricks.
-
Access Keap Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Keap data from your Oracle system.
-
Create Salesforce CRM Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Salesforce CRM Analytics Data from OutSystems and build custom enterprise apps using live Salesforce CRM Analytics data.
-
Visualize Live Factorial Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Factorial data.
-
Access Reckon Accounts Hosted Data from MySQL in PHP
Connect to Reckon Accounts Hosted through the standard MySQL libraries in PHP.
-
Replicate ConvertKit Data to Multiple Databases
Replicate ConvertKit data to disparate databases with a point-and-click configuration.
-
Connect and Visualize Live RSS Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live RSS feeds into the Databricks platform and create visualization dashboards with real-time RSS feeds.
-
How to connect SharePoint with Oracle Service Cloud Data through external lists
Provide Oracle Service Cloud data to SharePoint users as an external list.
-
Integrating Codex with Mixpanel 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 Microsoft OneDrive-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Microsoft OneDrive Data from OutSystems and build custom enterprise apps using live Microsoft OneDrive data.
-
Create Reports from Cvent Data in Looker Studio
Use CData Connect AI to gain access to live Cvent data and create custom reports in Looker Studio.
-
How to Connect to Live Basecamp 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 Basecamp data for you.
-
Validate Adobe Commerce Data with QuerySurge
Access and validate Adobe Commerce data in QuerySurge using the CData JDBC Driver.
-
Connecting Moonlit Workflow with Power BI XMLA 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 Power BI XMLA data in real time.
-
Connect to Apify from Asprova with CData Software ODBC Driver for Apify
This article shows how to connect faster to Apify data from Asprova.
-
Connect to Dynamics 365 Business Central Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Dynamics 365 Business Central as an External Source in Dremio.
-
Easily Integrate Zoho Books Data in Lazarus Pascal IDE
Learn how to easily integrate live Zoho Books data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Azure Data Catalog
Provide connectivity to Azure Data Catalog data through an SAP BusinessObjects universe.
-
Automated Continuous Exact Online Replication to SQL Server
Use CData Sync for automated, continuous, customizable Exact Online replication to SQL Server.
-
Create Datasets from Deel in Domo Workbench and Build Visualizations of Deel Data in Domo
Use the CData Software ODBC Driver for Deel to create datasets from Deel data in Domo Workbench and then build visualizations in the Domo service.
-
Create Highrise-Connected Applications in Appsmith
Connect to Highrise Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Highrise data.
-
Bind Live Smartsheet Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Smartsheet data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Access Live Guru Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Guru data from your Excel spreadsheets.
-
Connect to Float Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Float data.
-
DataBind Controls to Reply.io Data in C++Builder
DataBind to Reply.io data in C++Builder with standard components and controls.
-
Enable the Oracle JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Oracle data.
-
Integrate with Facebook Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Facebook data in SnapLogic.
-
How to connect Amazon QuickSight to Bright Data Data
Create a connection to Bright Data data in CData Connect AI and insert Bright Data data into Amazon QuickSight SPICE to build interactive dashboards.
-
Query Discourse Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Discourse data from Node.js.
-
Integrate with Live Freshdesk Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Freshdesk from the MuleSoft Anypoint Platform to integrate live Freshdesk data into custom reports and dashboards.
-
How to use SQLAlchemy ORM to access Deel Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Deel data.
-
Automated Continuous Excel Replication to Databricks
Use CData Sync for automated, continuous, customizable Excel replication to Databricks.
-
Use the CData Software JDBC Driver for Google Contacts in MicroStrategy Desktop
Connect to Google Contacts data in MicroStrategy Desktop using the CData Software JDBC Driver for Google Contacts.
-
Use the CData Software JDBC Driver for SAP HANA in MicroStrategy Web
Connect to SAP HANA data in MicroStrategy Web using the CData Software JDBC Driver for SAP HANA.
-
Connect to ADP from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from ADP data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Query Onfleet Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Onfleet data from Node.js.
-
Build Data Flows from Pipeline CRM to SQL Server using SSIS
Easily back up Pipeline CRM data to SQL Server using the SSIS components for Pipeline CRM.
-
Connect to Landbot 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 Landbot and work with Landbot data in your FileMaker application.
-
Automated Continuous PDFMonkey Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable PDFMonkey replication to Azure SQL Database.
-
Build SAP HANA-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for SAP HANA Data and create custom apps in Bubble.
-
Connect to Onfleet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Onfleet as an External Source in Dremio.
-
MYOB AccountRight Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to MYOB AccountRight data through CData Connect AI using different applications and tools.
-
Manage GraphQL Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for GraphQL.
-
How to Build an ETL App for PagerDuty Data in Python with CData
Create ETL applications and real-time data pipelines for PagerDuty data in Python with petl.
-
Automated Continuous SAP SuccessFactors Replication to SingleStore
Use CData Sync for automated, continuous, customizable SAP SuccessFactors replication to SingleStore.
-
How to Connect to Live CockroachDB Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your CockroachDB data for you.
-
Create Dynamic Oracle Sales Grids Using the Infragistics XamDataGrid
Learn how you can connect Oracle Sales to Infragistics XamDataGrid to build dynamic grids.
-
Use Azure AI Foundry to Talk to Your Google Directory 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 Google Directory data for you.
-
Use the CData Software JDBC Driver for Autopilot in MicroStrategy Desktop
Connect to Autopilot data in MicroStrategy Desktop using the CData Software JDBC Driver for Autopilot.
-
Build an OLAP Cube in SSAS from Splunk Data
Establish a connection to Splunk data data from SQL Server Analysis Services, and use the Splunk Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Live PostgreSQL Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to PostgreSQL from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live PostgreSQL data.
-
Integrate Google's Vertex AI Agent with Live Kintone Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Kintone data within intelligent workflows.
-
DataBind ZeroBounce Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide ZeroBounce data to a chart.
-
Replicate Multiple YouTube Analytics Accounts
Replicate multiple YouTube Analytics accounts to one or many databases.
-
Automated Continuous Apify Replication to SQL Server
Use CData Sync for automated, continuous, customizable Apify replication to SQL Server.
-
Connect to Avalara AvaTax Data from PowerBuilder via ADO.NET
This article demonstrates how to access Avalara AvaTax data from Appeon PowerBuilder using the CData ADO.NET Provider for Avalara AvaTax.
-
View Reports on Real-Time Oracle HCM Cloud Data in Power BI Report Server
Use the CData ODBC Driver for Oracle HCM Cloud to visualize Oracle HCM Cloud data in Power BI Desktop and then publish them to Power BI Report Server.
-
Connect to Nethunt from Asprova with CData Software ODBC Driver for Nethunt
This article shows how to connect faster to Nethunt data from Asprova.
-
Connect to Opsgenie Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Opsgenie.
-
Design BIRT Reports on Monday.com Data
Provide current Monday.com data to your embedded analytics.
-
Automated Continuous AgileCRM Replication to AlloyDB
Use CData Sync for automated, continuous, customizable AgileCRM replication to AlloyDB.
-
Connect Parallel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Parallel data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Import Real-Time MailerSend Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use MailerSend data in ColdFusion.
-
Search External Google Forms Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Google Forms data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Forms Data objects that you can access from apps and the dashboard.
-
Query Superchat Data as a MySQL Database in Node.js
Execute MySQL queries against Superchat data from Node.js.
-
Integrating Codex with Copper 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.
-
How to Seamlessly Import Asana Data into IBM SPSS Modeler
Integrate Asana data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous Procore Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Procore replication to Apache Cassandra.
-
How to connect to ConvertAPI Data from Spring Boot
Connect to ConvertAPI in a Spring Boot Application using the CData API Driver for JDBC
-
Load Moosend Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Moosend data to a database.
-
Access Browserless Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Browserless data from HeidiSQL.
-
Use Biml to Build SSIS Tasks to Replicate Teamwork Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Teamwork data to SQL Server.
-
Prepare, Blend, and Analyze GitHub Data in Alteryx Designer (ODBC)
Build workflows to access live GitHub data for self-service data analytics.
-
Getting Started with the CData Python Connector for MariaDB
Learn to install and license the CData Python Connector and configure a connection to live MariaDB data.
-
Automated Continuous Mistral AI Replication to SingleStore
Use CData Sync for automated, continuous, customizable Mistral AI replication to SingleStore.
-
Manage Apify Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Apify.
-
Migrating data from Planio to Databricks using CData SSIS Components.
Easily push Planio data to Databricks using the CData SSIS Tasks for Planio and Databricks.
-
Bridge FreeAgent Connectivity with Apache NiFi
Access and process FreeAgent data in Apache NiFi using the CData JDBC Driver.