CData Software - Knowledge Base
Recent Articles
-
Use the CData ODBC Driver for Adobe Analytics in Microsoft Power Query
You can use the CData Adobe Analytics ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Adobe Analytics data into Microsoft Power Query.
-
How to Connect to & Open Power BI XMLA Data in Microsoft Excel
This article uses the CData ODBC driver for Power BI XMLA to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Feed Harvest Data into FineReport
How to set Harvest data as a JDBC data source in FineReport.
-
How to Easily Query Freshsales Data in OpenOffice Base
Connect to Freshsales data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Using the CData Software ODBC Driver for ChargeOver in PyCharm
Connect to ChargeOver as an ODBC data source in PyCharm using the CData Software ODBC Driver for ChargeOver.
-
Automate Lakebase Data Replication to Couchbase
Use CData Sync to Customize and automate Lakebase data replication to Couchbase.
-
Use the CData Software ODBC Driver for Xero in MicroStrategy Web
Connect to Xero data in MicroStrategy Web using the CData Software ODBC Driver for Xero.
-
Connect to SuiteCRM Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SuiteCRM Data and connect to SuiteCRM data in Akorbi Digital RunMyProcess.
-
Integrating Antigravity CLI with LaunchDarkly data via CData CLI
Connect LaunchDarkly data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to Use a Microsoft Access Database to Update XML Data in Real Time
Update XML data by creating a linked table in Microsoft Access with the CData XML ODBC Driver.
-
Publish NetSuite-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live NetSuite data.
-
Integrate with Microsoft Dataverse Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Microsoft Dataverse data in SnapLogic.
-
How to connect SharePoint with ShipStation Data through external lists
Provide ShipStation data to SharePoint users as an external list.
-
Integrate with Anaplan Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Anaplan data to a JSON file on disk.
-
Back Up Avro data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Avro. In this article, we will employ an SSIS workflow to populate a database with Avro data data.
-
Connect to Jira Data in DBArtisan
Use wizards in DBArtisan to configure Jira data as a data source.
-
Use Grok to Talk to Your Dynamics NAV 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 Dynamics NAV data for you.
-
Build Visualizations of Zoho Creator Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Zoho Creator data in Birst.
-
Analyze Azure Table Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Azure Table data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Rebilly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Rebilly facts in real time.
-
Create LDAP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time LDAP data access from reports, embedded analytics, and more.
-
Connect to ServiceDesk Plus Data in Jaspersoft Studio
Execute SQL to remote ServiceDesk Plus data in Jaspersoft Studio.
-
Automate Google Spanner Data Replication to Couchbase
Use CData Sync to Customize and automate Google Spanner data replication to Couchbase.
-
Integrate xBase Data in Pentaho Data Integration
Build ETL pipelines based on xBase data in the Pentaho Data Integration tool.
-
Build Databricks-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Databricks Data and create custom apps in Bubble.
-
Automated Continuous Pipedrive Replication to Oracle
Use CData Sync for automated, continuous, customizable Pipedrive replication to Oracle.
-
Integrating Antigravity CLI with Auth0 data via CData CLI
Connect Auth0 data to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Integrate Real-Time Access to Phoenix in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Phoenix data in real time.
-
Integrate Snowflake Data into Power Automate Desktop using CData Connect
CData Connect for Snowflake Data enables you to integrate Snowflake data into workflows built using Microsoft Power Automate Desktop.
-
Build AI Agents with Phoenix Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can securely access and act on live Phoenix data through CData Connect AI.
-
How to connect SharePoint with Cassandra Data through external lists
Provide Cassandra data to SharePoint users as an external list.
-
Connect to CouchDB Data in CloverDX (formerly CloverETL)
Transfer CouchDB data using the visual workflow in the CloverDX data integration tool.
-
How to Connect to Live Sybase IQ Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Sybase IQ data without replication.
-
Connecting Moonlit Workflow with Blackbaud FE NXT 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 Blackbaud FE NXT data in real time.
-
Visualize Live CampaignMonitor Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live CampaignMonitor data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Reports with FormSite Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FormSite data.
-
Import Act CRM Data Using Azure Data Factory
Use CData Connect AI to connect to Act CRM Data from Azure Data Factory and import live Act CRM data.
-
How to integrate Oracle SCM with Apache Airflow
Access and process Oracle SCM data in Apache Airflow using the CData JDBC Driver.
-
Build an OLAP Cube in SSAS from SAP Fieldglass Data
Establish a connection to SAP Fieldglass data data from SQL Server Analysis Services, and use the SAP Fieldglass Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Qualaroo Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Qualaroo replication to IBM DB2.
-
How to connect to Airtable Data from IntelliJ
Integrate connectivity to Airtable data with wizards in IntelliJ.
-
Extract, Transform, and Load Factorial Data in Informatica PowerCenter
Create a simple Workflow for Factorial data in Informatica PowerCenter.
-
Analyze Splunk Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Splunk data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Creating Redis-Connected Applications in Unqork
You can use CData Connect AI to feed Redis data to Unqork and build custom business apps.
-
Automated Continuous Mouseflow Replication to SQL Server
Use CData Sync for automated, continuous, customizable Mouseflow replication to SQL Server.
-
How to Build an ETL App for Avro Data in Python with CData
Create ETL applications and real-time data pipelines for Avro data in Python with petl.
-
Automated Continuous MYOB AccountRight Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable MYOB AccountRight replication to Google BigQuery.
-
Model Zoom Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zoom, enabling the direct import of real-time Zoom data.
-
Create SSAS Tabular Models from SAP Ariba Source Data
How to build a SQL Server Analysis Service Tabular Model from SAP Ariba Source data using CData drivers.
-
Access Live Paymo Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Paymo data from your Excel spreadsheets.
-
How to connect to RSS Feeds in DBVisualizer
Integrate RSS feeds with visual data analysis tools and data connection wizards in DBVisualizer
-
Use the CData ODBC Driver for Excel Online from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Excel Online to connect to Excel Online data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Excel Online data in Excel.
-
Create Data Visualizations in Cognos BI with Toggl Data
Access Toggl data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Stream Blackbaud FE NXT Data into Apache Kafka Topics
Access and stream Blackbaud FE NXT data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Access Live SAP Ariba Procurement Data in AWS Lambda (with IntelliJ IDEA)
Connect to live SAP Ariba Procurement data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
How to connect to Zoho Projects Data with Squirrel SQL client
Connect to Zoho Projects data and execute queries in the Squirrel SQL Client.
-
Connect to Salesforce Data 360 Data in Jaspersoft Studio
Execute SQL to remote Salesforce Data 360 data in Jaspersoft Studio.
-
Query Power BI XMLA Data as a MySQL Database in Node.js
Execute MySQL queries against Power BI XMLA data from Node.js.
-
Connect and Query Live NetSuite SuiteAnalytics Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live NetSuite SuiteAnalytics data into Databricks and enable direct, live querying and analysis without replication.
-
Use the CData Software ODBC Driver for Square in MicroStrategy Desktop
Connect to Square data in MicroStrategy Desktop using the CData Software ODBC Driver for Square.
-
Automated Excel Data Replication to Teradata
Use CData Sync to Customize and automate Excel data replication to Teradata.
-
How to Visualize ConvertKit Data in Python with pandas
Use pandas and other modules to analyze and visualize live ConvertKit data in Python.
-
Integrate Live SAP Concur Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live SAP Concur data from within the IDE.
-
Visualize Facebook Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Facebook Ads data.
-
Build Data Flows from CircleCI to SQL Server using SSIS
Easily back up CircleCI data to SQL Server using the SSIS components for CircleCI.
-
How to Connect to Live HDFS 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 HDFS data through natural language.
-
Automated Continuous ClickUp Replication to SQLite
Use CData Sync for automated, continuous, customizable ClickUp replication to SQLite.
-
Build an OLAP Cube in SSAS from Typeform Data
Establish a connection to Typeform data data from SQL Server Analysis Services, and use the Typeform Data Provider to build OLAP cubes for use in analytics and reporting.
-
Automated Continuous Factorial Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Factorial replication to Google Cloud SQL.
-
Automated Continuous Timely Replication to Vertica
Use CData Sync for automated, continuous, customizable Timely replication to Vertica.
-
Getting Started with the CData JDBC Driver for CloudConvert
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for CloudConvert.
-
Connect to EnterpriseDB Data in Aqua Data Studio
Access EnterpriseDB data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create Reports with Couchbase Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Couchbase data.
-
Build AI/ML Models with Live Pipeline CRM Data using Dataiku
Connect Pipeline CRM Data with Dataiku using the CData API Driver for JDBC.
-
Automated Continuous LDAP Replication to IBM DB2
Use CData Sync for automated, continuous, customizable LDAP replication to IBM DB2.
-
Connect to AlloyDB Data in CloverDX (formerly CloverETL)
Transfer AlloyDB data using the visual workflow in the CloverDX data integration tool.
-
How to connect to OneNote Data from Spring Boot
Connect to OneNote in a Spring Boot Application using the CData JDBC Driver for OneNote
-
Visualize Vault CRM Data in TIBCO Spotfire through OData
Integrate Vault CRM data into dashboards in TIBCO Spotfire.
-
Integrating Boomi Agentstudio with Procore Data via CData Connect AI
Use CData Connect AI to provide Boomi Agentstudio with secure, governed access to Procore data, enabling AI agents to act on live enterprise data within your integration and automation workflows.
-
Build Dashboards with IBM Cloud Object Storage Data in Dundas BI
Create dynamic dashboards and perform analytics based on IBM Cloud Object Storage data in Dundas BI.
-
Use the CData Software ODBC Driver for Sendwithus in MicroStrategy
Connect to Sendwithus data in MicroStrategy Developer using the CData Software ODBC Driver for Sendwithus.
-
Build MailChimp Visualizations in Tableau Desktop
Use CData Connect AI to connect to live MailChimp data and build visualizations in Tableau.
-
DataBind Hugging Face Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Hugging Face data to a chart.
-
Connect to and Query SAP Business Warehouse Data in QlikView over ODBC
Create data visualizations with SAP Business Warehouse data in QlikView.
-
Access Codat Data from MySQL in Amazon QuickSight
Connect to Codat and build visualizations of Codat data using a MySQL Connection in Amazon QuickSight.
-
Create xBase-Connected Business Apps in AppSheet
Connect to xBase Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to xBase data.
-
Visualize Tally Data in Tableau
The CData ODBC driver for Tally enables you integrate Tally data into Tableau dashboards.
-
Connect to Zuora Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Zuora data.
-
Connect to Cohere Data in Aqua Data Studio
Access Cohere data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous ChartMogul Replication to SingleStore
Use CData Sync for automated, continuous, customizable ChartMogul replication to SingleStore.
-
Build Agents in Relevance AI with Access to Live Freshteam Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Freshteam data within intelligent agent workflows.
-
Access Live Tavily Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Tavily data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software ODBC Driver for IBM Informix in MicroStrategy
Connect to IBM Informix data in MicroStrategy Developer using the CData Software ODBC Driver for IBM Informix.
-
Publish Crystal Reports on Slack Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Slack data.
-
Integrating GitHub Copilot with Salesforce Marketing 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.
-
Explore Geographical Relationships in ScrapingBee Data with Power Map
Create data visualizations with ScrapingBee data in Power Map.
-
Automated Continuous Tanda Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Tanda data replication to OneLake in Microsoft Fabric.
-
LINQ to Microsoft Planner 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 Microsoft Planner Data Provider.
-
Connect to Microsoft Dataverse Data in NetBeans
Connect to Microsoft Dataverse data in NetBeans with the data source configuration wizard.
-
A PostgreSQL Interface for Close Data (MySQL Remoting via JDBC)
Use the Remoting features of the Close JDBC Driver to create a PostgreSQL entry-point for data access.