CData Software - Knowledge Base
Recent Articles
-
Bind Live Adobe Analytics Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Adobe Analytics data and seamlessly connect and bind them to Wijmo's FlexGrid for real-time, interactive data access without manual data movement.
-
Create Data Visualizations in Cognos BI with Mode Data
Access Mode data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Access Google Ad Manager 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 Google Ad Manager data.
-
Excel Spreadsheet Automation on SQLite Data with the QUERY Formula
Pull data from SQLite, automate spreadsheets, and more with the QUERY formula.
-
How to Access XML Data Using Entity Framework
This article shows how to access XML data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Certinia Reporting in OBIEE with the Certinia JDBC Driver
Deploy the Certinia JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Publish Azure DevOps-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Azure DevOps data.
-
Using the CData Software ODBC Driver for Mocean in PyCharm
Connect to Mocean as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mocean.
-
Connect to Demio Data in JRuby
Create a simple JRuby app with access to live Demio data.
-
Connect to Discourse Data from a Connection Pool in Jetty
The Discourse JDBC Driver supports connection pooling: This article shows how to connect faster to Discourse data from Web apps in Jetty.
-
How to Connect to & Open Couchbase Data in Microsoft Excel
This article uses the CData ODBC driver for Couchbase to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Automated Continuous Coinbase Replication to SQL Server
Use CData Sync for automated, continuous, customizable Coinbase replication to SQL Server.
-
Automated Continuous Avro Replication to SingleStore
Use CData Sync for automated, continuous, customizable Avro replication to SingleStore.
-
Create Sage Intacct-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Sage Intacct Data from OutSystems and build custom enterprise apps using live Sage Intacct data.
-
Visualize Live Freshteam Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Freshteam data into custom reports in Power BI.
-
Use Databricks Agent Bricks to Talk to Your Workday Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Workday data for you.
-
Create a Data Access Object for MYOB AccountRight Data using JDBI
A brief overview of creating a SQL Object API for MYOB AccountRight data in JDBI.
-
Integrating OpenCode 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.
-
Automated Continuous Avaza Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Avaza replication to Apache Cassandra.
-
Create Datasets from Dynamics 365 in Domo Workbench and Build Visualizations of Dynamics 365 Data in Domo
Use the CData Software ODBC Driver for Dynamics 365 to create datasets from Dynamics 365 data in Domo Workbench and then build visualizations in the Domo service.
-
Getting Started with the CData Connect AI Python SDK for PostgreSQL
Install the CData Connect AI Python SDK to read and write live PostgreSQL data with standard DB-API 2.0 Python code.
-
Integrating LangChain with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Sybase IQ data within automated workflows.
-
Use the CData Software JDBC Driver for Pinterest in MicroStrategy
Connect to Pinterest data in MicroStrategy Developer using the CData Software JDBC Driver for Pinterest.
-
Use the CData ODBC Driver for Webflow from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Webflow to connect to Webflow data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Webflow data in Excel.
-
Analyze Dynamics 365 Data in Cognos Analytics
Use CData Connect AI to connect to Dynamics 365 Data from Cognos Analytics and analyze live Dynamics 365 data.
-
Build AI/ML Models with Live Landbot Data using Dataiku
Connect Landbot Data with Dataiku using the CData API Driver for JDBC.
-
Getting Started with the CData JDBC Driver for SharePoint
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SharePoint.
-
Connecting GenSpark with LDAP Objects via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to LDAP objects without any replication or custom integration required.
-
Integrate Google's Antigravity Agent with Live Authorize.Net Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live Authorize.Net data using the Model Context Protocol.
-
Integrate with Gorgias Data in JReport Designer
Create charts and reports based on Gorgias data in JReport Designer.
-
Automated Continuous Mixpanel Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Mixpanel replication to Azure SQL Database.
-
Extract, Transform, and Load Yelp Data in Informatica PowerCenter
Create a simple Workflow for Yelp data in Informatica PowerCenter.
-
Integrating Boomi Agentstudio with Quickbase Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Quickbase data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
How to Work with Qualaroo Data in AWS Glue Jobs Using JDBC
Connect to Qualaroo from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData JDBC Driver for Salesforce
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Salesforce.
-
Natively Connect to Excel Online Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Excel Online data. Leverage the native support for ODBC in PHP.
-
Connect to Mouseflow Data in CloverDX (formerly CloverETL)
Transfer Mouseflow data using the visual workflow in the CloverDX data integration tool.
-
Build Data Flows from Miro to SQL Server using SSIS
Easily back up Miro data to SQL Server using the SSIS components for Miro.
-
Connect to and Query Copper Data in QlikView over ODBC
Create data visualizations with Copper data in QlikView.
-
Integrate Devin with Live Adobe Target Data Using CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Devin, the AI software engineer, to securely access and query live Adobe Target data.
-
Access Live MYOB AccountRight Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live MYOB AccountRight data through MCP integration.
-
How to Query Live Accelo Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Accelo data data in natural language using Python.
-
Import and Visualize Strava Data in Power View
Create data visualizations based on Strava data in Excel.
-
Build Apps with Live Chargebee Data Using the Low-Code Development Platform of Mendix
Connect Chargebee data with Mendix to build apps using the CData API Driver for JDBC.
-
How to Easily Query QuickBooks Data in OpenOffice Base
Connect to QuickBooks data in OpenOffice Base using the CData ODBC Driver for QuickBooks and generate reports with live data insights.
-
Build a Simple VCL Application for Aircall Data
How to build a simple VCL Application to view Aircall data in RAD Studio using the CData ODBC Driver for Aircall.
-
Connect to Printful Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Printful data.
-
Build Charts with FTP Data in Clear Analytics
Create dynamic charts and perform analytics based on FTP data in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time Helpscout Data
Use CData Power BI Connectors to visualize Helpscout data in Power BI.
-
Use Grok to Talk to Your Excel Online 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 Excel Online data for you.
-
Create SSAS Tabular Models from Hacker News Data
How to build a SQL Server Analysis Service Tabular Model from Hacker News data using CData drivers.
-
Query SAP Ariba Procurement Data in ColdFusion
Write standard ColdFusion data access code to connect to SAP Ariba Procurement data.
-
Import Real-Time Kafka Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Kafka data in ColdFusion.
-
Automated Continuous BigCommerce Replication to Databricks
Use CData Sync for automated, continuous, customizable BigCommerce replication to Databricks.
-
Query Oracle SCM Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Oracle SCM data from Node.js.
-
Connect to Freshteam Data in RazorSQL
Connect to Freshteam from wizards and query Freshteam data from the GUI in the RazorSQL database management tool.
-
Model SuiteCRM Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SuiteCRM, enabling the direct import of real-time SuiteCRM data.
-
Use the CData Software ODBC Driver for Bullhorn CRM in MicroStrategy
Connect to Bullhorn CRM data in MicroStrategy Developer using the CData Software ODBC Driver for Bullhorn CRM.
-
Connect to OnePageCrm Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for OnePageCrm and the SQL Gateway to access OnePageCrm data from Google Apps Script.
-
How to connect to LeadDesk Data from IntelliJ
Integrate connectivity to LeadDesk data with wizards in IntelliJ.
-
Replicate Asana Data in Heroku for Use in Salesforce Connect
Replicate Asana data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Blackbaud FE NXT Data from PowerBuilder via ADO.NET
This article demonstrates how to access Blackbaud FE NXT data from Appeon PowerBuilder using the CData ADO.NET Provider for Blackbaud FE NXT.
-
How to Connect to Live Sybase IQ 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 Sybase IQ data for you.
-
Connect to Qualaroo Data in Jaspersoft Studio
Execute SQL to remote Qualaroo data in Jaspersoft Studio.
-
How to Connect to Mailgun Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Mailgun data. Leverage the pyodbc module for ODBC in Python.
-
Connect to Toggl Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Toggl and work with Toggl data in your FileMaker applications.
-
How to connect to SAP Business Warehouse Data from Spring Boot
Connect to SAP Business Warehouse in a Spring Boot Application using the CData JDBC Driver for SAP Business Warehouse
-
Prepare, Blend, and Analyze Amplitude Data in Alteryx Designer (ODBC)
Build workflows to access live Amplitude data for self-service data analytics.
-
Build Apps with Live SendPulse Data Using the Low-Code Development Platform of Mendix
Connect SendPulse data with Mendix to build apps using the CData API Driver for JDBC.
-
How to use SQLAlchemy ORM to access Hubstaff Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Hubstaff data.
-
Use Dash to Build Web Apps on ZohoMarketingHub Data via CData Connect AI
Build interactive Dash web apps on live ZohoMarketingHub data using pandas and the CData Connect AI Python SDK.
-
Visualize Live Neo4J Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Neo4J data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Replicate Demio Data from PowerShell
Write a quick PowerShell script to query Demio data. Use connectivity to the live data to replicate Demio data to SQL Server.
-
Build Pipelines with Live Bright Data Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to Bright Data from Google Cloud Data Fusion, enabling the integration of live Bright Data data into the building and management of effective data pipelines.
-
Getting Started with the CData Tableau Connector for SAP Ariba Procurement
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SAP Ariba Procurement.
-
Use the CData Software JDBC Driver for Printful in MicroStrategy
Connect to Printful data in MicroStrategy Developer using the CData Software JDBC Driver for Printful.
-
Connecting Moonlit Workflow with EnterpriseDB 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 EnterpriseDB data in real time.
-
Connect to Power BI XMLA Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Power BI XMLA to connect to Power BI XMLA data and execute queries in PowerBuilder.
-
View Reports on Real-Time Trello Data in Power BI Report Server
Use the CData ODBC Driver for Trello to visualize Trello data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrating Dataiku with Oracle Eloqua Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Oracle Eloqua data.
-
Okta Reporting in OBIEE with the Okta JDBC Driver
Deploy the Okta JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query Zoho Creator Data as a SQL Server Database in Node.js
Execute SQL Server queries against Zoho Creator data from Node.js.
-
Choosing the Best Method to Connect LinkedIn to SQL Server: 5 Options Explained
Discover multiple ways to connect and use LinkedIn data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Trae with Live Shortcut Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live Shortcut data from within the AI-powered IDE.
-
Create TaxJar-Connected Applications in Appsmith
Connect to TaxJar Data via CData Connect AI in Appsmith and create custom business applications with real-time access to TaxJar data.
-
Integrate Google Sheets with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Sheets with External Services.
-
Connect to Lakebase Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Lakebase Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to SQL Server Data in HULFT Integrate
Connect to SQL Server as a JDBC data source in HULFT Integrate
-
Connect to SQL Analysis Services Data in Aqua Data Studio
Access SQL Analysis Services data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Viewing OpenWeatherMap Data in RAD Studio Data Explorer
How to view OpenWeatherMap data in RAD Studio Data Explorer using the CData ODBC Driver for OpenWeatherMap.
-
How to Connect to Live MongoDB Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live MongoDB data securely in real time.
-
Connect to Auth0 Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Auth0 data in the Denodo Virtual DataPort Administrator.
-
Access Live SparkPost Data in Coginiti Pro
Connect to and query live SparkPost data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for Exact Online in MicroStrategy Web
Connect to Exact Online data in MicroStrategy Web using the CData Software ODBC Driver for Exact Online.
-
Publish Crystal Reports on Azure Data Lake Storage Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure Data Lake Storage data.
-
Connect to Email Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Email and the Script function in FileMaker Pro to connect to Email and work with Email data in your FileMaker application.
-
Choosing the Best Method to Connect Perigon to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Perigon data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use Databricks Agent Bricks to Talk to Your SAP Hybris C4C Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your SAP Hybris C4C data for you.
-
Connect to Nethunt Data in JRuby
Create a simple JRuby app with access to live Nethunt data.
-
Integrate with Live Authorize.Net Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Authorize.Net from the MuleSoft Anypoint Platform to integrate live Authorize.Net data into custom reports and dashboards.