CData Software - Knowledge Base
Recent Articles
-
Build Visualizations of Webflow Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Webflow data in Birst.
-
Integrating OpenCode with ChartMogul 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 connect and process Clari data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Clari data.
-
How to Work with Teamwork Data in ETL Validator JDBC
Connect to Teamwork from ETL Validator jobs using the CData Software JDBC Driver.
-
Build a PostgreSQL Interface for SFTP Data using the CData JDBC Driver
Use the Remoting features of the SFTP JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate with live Anaplan Data in Jitterbit
Use CData Connect AI to connect to and integrate live Anaplan data in Jitterbit.
-
Access Live Pinecone Data in Coginiti Pro
Connect to and query live Pinecone data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Analyze Live Bright Data Data in SAS Viya
Use CData Connect AI to connect to Bright Data data from SAS Viya and deploy self-service analytics using live Bright Data data.
-
Automated Continuous Wrike Replication to Vertica
Use CData Sync for automated, continuous, customizable Wrike replication to Vertica.
-
Build Amazon Athena Visualizations in Tableau Desktop
Use CData Connect AI to connect to live Amazon Athena data and build visualizations in Tableau.
-
How to Seamlessly Import Egnyte Data into IBM SPSS Modeler
Integrate Egnyte data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Import and Visualize Accelo Data in Power View
Create data visualizations based on Accelo data in Excel.
-
Connect to Smartsheet Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Smartsheet as an External Source in Dremio.
-
Connecting Moonlit Workflow with Cloudant 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 Cloudant data in real time.
-
Excel Spreadsheet Automation on Microsoft Dataverse Data with the QUERY Formula
Pull data from Microsoft Dataverse, automate spreadsheets, and more with the QUERY formula.
-
Query Amazon DynamoDB Data in DataGrip
Create a Data Source for Amazon DynamoDB in DataGrip and use SQL to query live Amazon DynamoDB data.
-
Visualize Live Google Analytics Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Analytics data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to Connect to Live TaxJar 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 TaxJar data for you.
-
Automated Quickbase Data Replication to Teradata
Use CData Sync to Customize and automate Quickbase data replication to Teradata.
-
Connect to Paylocity Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Paylocity data in the Denodo Virtual DataPort Administrator.
-
Use Azure AI Foundry to Talk to Your LDAP Objects 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 LDAP objects for you.
-
Integrate Theia IDE with Live eBay Analytics 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 eBay Analytics data from within the development environment.
-
Enable the Active Directory JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Active Directory data.
-
How to Seamlessly Import FreeAgent Data into IBM SPSS Modeler
Integrate FreeAgent data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze SAS xpt Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAS xpt data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Build Klipfolio-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Klipfolio Data and create custom apps in Mendix.
-
Analyze Live Apify Data in SAS Viya
Use CData Connect AI to connect to Apify data from SAS Viya and deploy self-service analytics using live Apify data.
-
Integrate Real-Time Access to SAP Ariba Procurement in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SAP Ariba Procurement data in real time.
-
Create Reports from Epicor Kinetic Data in Looker Studio
Use CData Connect AI to gain access to live Epicor Kinetic data and create custom reports in Looker Studio.
-
Excel Spreadsheet Automation on Supabase Data with the QUERY Formula
Pull data from Supabase, automate spreadsheets, and more with the QUERY formula.
-
Connecting Mastra with Phoenix Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Phoenix data, no replication required.
-
Build eBay Analytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live eBay Analytics data.
-
Connect to Samanage Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Samanage.
-
How to Work with Salesforce Data 360 Data in ETL Validator JDBC
Connect to Salesforce Data 360 from ETL Validator jobs using the CData Software JDBC Driver.
-
Extract, Transform, and Load Google Spanner Data in Informatica PowerCenter
Create a simple Workflow for Google Spanner data in Informatica PowerCenter.
-
Build Semantic Layer Views for Adobe Target Data in APOS Live Data Gateway
Use the CData Connector for Adobe Target in APOS Live Data Gateway to build Semantic Layer Views for Adobe Target data.
-
Build SharePoint-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live SharePoint data.
-
Integrate Cline with Live Grafana Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Grafana data from within your IDE.
-
Build Power BI XMLA-Connected Apps in Choreo
Use CData Connect AI to connect to Power BI XMLA Data from Choreo and build custom apps using live Power BI XMLA data.
-
Automated Continuous EmailOctopus Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable EmailOctopus replication to PostgreSQL.
-
Connect to Zoho Books Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Zoho Books and the SQL Gateway to access Zoho Books data from Google Apps Script.
-
Build NetSuite SuiteAnalytics-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live NetSuite SuiteAnalytics data.
-
Connect to Insightly Data from PowerBuilder via ADO.NET
This article demonstrates how to access Insightly data from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to Connect to Live Notion 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 Notion data for you.
-
Build a PostgreSQL Interface for GitLab Data using the CData JDBC Driver
Use the Remoting features of the GitLab JDBC Driver to create a PostgreSQL entry-point for data access.
-
Automated Continuous Raisers Edge NXT Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Raisers Edge NXT replication to Amazon Redshift.
-
Connect to Pinecone Data in Aqua Data Studio
Access Pinecone data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Integrate Trae with Live CockroachDB Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live CockroachDB data from within the AI-powered IDE.
-
Build a Simple VCL Application for LDAP Objects
How to build a simple VCL Application to view LDAP objects in RAD Studio using the CData ODBC Driver for LDAP.
-
Create Oracle Sales-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Oracle Sales Data from OutSystems and build custom enterprise apps using live Oracle Sales data.
-
Automated Continuous Freshservice Replication to Vertica
Use CData Sync for automated, continuous, customizable Freshservice replication to Vertica.
-
Integrate Open WebUI with Live Azure DevOps Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Azure DevOps data from within the chat interface.
-
How to Create Power BI Visual Reports with Real-Time Google Directory Data
Use CData Power BI Connectors to visualize Google Directory data in Power BI.
-
Connecting GenSpark with HCL Domino Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to HCL Domino data without any replication or custom integration required.
-
Natively Connect to Everhour Data in PHP
The CData ODBC driver for Everhour enables you to create PHP applications with connectivity to Everhour data. Leverage the native support for ODBC in PHP.
-
Integrating Boomi Agentstudio with Klipfolio Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Klipfolio data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with Typeform Data in DBxtra
Create dynamic dashboards and perform analytics based on Typeform data in DBxtra.
-
How to publish and share Aircall Data dashboards with Tableau Server
The CData ODBC driver for Aircall enables you integrate Aircall data into Tableau dashboards.
-
How to Query Perigon Data in MySQL Workbench
Execute MySQL queries against live Perigon data from MySQL Workbench.
-
How to import Facebook Ads Data into Apache Solr
Use the CData Software JDBC Driver for Facebook Ads in Data Import Handler and create an automated import of Facebook Ads data to Apache Solr Enterprise Search platform.
-
Automated Continuous Microsoft Planner Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to Amazon S3.
-
Connect to QuickBooks Data in Claris FileMaker Pro
Use the CData ODBC Driver for QuickBooks in FileMaker Pro to connect to QuickBooks and work with QuickBooks data in your FileMaker applications.
-
Connect to Invoiced Data in CloverDX (formerly CloverETL)
Transfer Invoiced data using the visual workflow in the CloverDX data integration tool.
-
Integrating Cursor with Redshift 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 a Data Access Object for Hive Data using JDBI
A brief overview of creating a SQL Object API for Hive data in JDBI.
-
Integrate Theia IDE with Live Airtable 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 Airtable data from within the development environment.
-
Integrating Codex with MailChimp 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.
-
Object-Relational Mapping (ORM) with Reckon Accounts Hosted 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 Reckon Accounts Hosted data into a Java-based ORM framework, Hibernate.
-
Build Dashboards with Billsby Data in Dundas BI
Create dynamic dashboards and perform analytics based on Billsby data in Dundas BI.
-
Access Authorize.Net Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Authorize.Net data from HeidiSQL.
-
Keap Reporting in OBIEE with the Keap JDBC Driver
Deploy the Keap JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Integrating OpenCode with RabbitMQ 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.
-
Replicate Workable Data to Multiple Databases
Replicate Workable data to disparate databases with a point-and-click configuration.
-
Working with Highrise Data in LINQPad
Execute LINQ queries to Highrise data in LINQPad.
-
Consume Elasticsearch OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Elasticsearch feeds that reflect any changes in SAP Lumira.
-
Build Sybase IQ-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Sybase IQ Data and create custom apps in Mendix.
-
How to connect to Shippo Data from IntelliJ
Integrate connectivity to Shippo data with wizards in IntelliJ.
-
Migrating data from CircleCI to Databricks using CData SSIS Components.
Easily push CircleCI data to Databricks using the CData SSIS Tasks for CircleCI and Databricks.
-
Use CData Connect AI to Access Quickbase Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Quickbase data in the Power Pivot business intelligence tool.
-
Connect to Blackbaud FE NXT Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Blackbaud FE NXT.
-
Connect to Notion Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Notion data using standard SQL.
-
Access Live Adobe Commerce Data in TIBCO Data Virtualization
Use the Adobe Commerce Tibco DV Adapter to create a Adobe Commerce data data source in TIBCO Data Virtualization Studio and gain access to live Adobe Commerce data from your TDV Server.
-
Access Factorial Data from MySQL in Amazon QuickSight
Connect to Factorial and build visualizations of Factorial data using a MySQL Connection in Amazon QuickSight.
-
Automate GitLab Integration Tasks from PowerShell
Are you in search of a quick and easy way to access GitLab data from PowerShell? This article demonstrates how to utilize the GitLab Cmdlets for tasks like connecting to GitLab data, automating operations, downloading data, and more.
-
Write a Simple Go Application to work with Jira Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jira data.
-
Use the CData ODBC Driver for ActiveCampaign from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for ActiveCampaign to connect to ActiveCampaign data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring ActiveCampaign data in Excel.
-
Connect to Gong from Asprova with CData Software ODBC Driver for Gong
This article shows how to connect faster to Gong data from Asprova.
-
Publish Reports with Guru Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Guru data.
-
How to Visualize Brex Data in Python with pandas
Use pandas and other modules to analyze and visualize live Brex data in Python.
-
How to use SQLAlchemy ORM to access Shortcut Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Shortcut data.
-
Connect to Stack Exchange Data in RazorSQL
Connect to Stack Exchange from wizards and query Stack Exchange data from the GUI in the RazorSQL database management tool.
-
Access Live Brex Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Brex data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use Grok to Talk to Your Basecamp 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 Basecamp data for you.
-
Use Azure AI Foundry to Talk to Your OData Services 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 OData services for you.
-
How to Connect the Power BI Service to Shippo: Complete Guide
Connect to the CData Software Power BI Connector for Shippo from PowerBI.com to provide real-time Shippo data across the organization.
-
Use the CData ODBC Driver for FreshBooks in Microsoft Power Query
You can use the CData FreshBooks ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import FreshBooks data into Microsoft Power Query.
-
How to Visualize MarkLogic 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 MarkLogic data in Python.
-
Build an OLAP Cube in SSAS from Nethunt Data
Establish a connection to Nethunt data data from SQL Server Analysis Services, and use the Nethunt Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to eBay Analytics Data from PowerBuilder via JDBC
This article demonstrates how to access eBay Analytics data from PowerBuilder using the eBay Analytics JDBC Driver.
-
Import Real-Time GraphQL Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use GraphQL data in ColdFusion.