CData Software - Knowledge Base
Recent Articles
-
Connect to Zoho Creator Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Zoho Creator data in the Denodo Virtual DataPort Administrator.
-
Integrate Trae with Live ZohoDesk Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Trae to securely access and query live ZohoDesk data from within the AI-powered IDE.
-
Connect Productboard Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Productboard data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Configure the CData JDBC Driver for Facebook in a Connection Pool in Tomcat
Connect to Facebook data from a connection pool in Tomcat.
-
Use Dash to Build to Web Apps on Paddle Data
Create Python applications that use pandas and Dash to build Paddle-connected web apps.
-
How to Easily Query Quickbase Data in OpenOffice Base
Connect to Quickbase data in OpenOffice Base using the CData ODBC Driver for Quickbase and generate reports with live data insights.
-
Build Landbot-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Landbot data and build web apps with connectivity to live Landbot data.
-
Stream Foursquare Data into Apache Kafka Topics
Access and stream Foursquare data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Query, Visualize, and Share live Zoho Inventory Data in Redash
Use CData Connect AI to connect to live Zoho Inventory data in Redash for querying, visualizing, and sharing.
-
How to integrate Flowlu with Apache Airflow
Access and process Flowlu data in Apache Airflow using the CData JDBC Driver.
-
Integrate Cline with Live Microsoft Exchange Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Exchange data from within your IDE.
-
How to import Flowlu Data into Apache Solr
Use the CData Software JDBC Driver for Flowlu in Data Import Handler and create an automated import of Flowlu data to Apache Solr Enterprise Search platform.
-
Explore Geographical Relationships in Eventbrite Data with Power Map
Create data visualizations with Eventbrite data in Power Map.
-
Integrate Live Sybase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Sybase data and integrate live Sybase data into apps built in Microsoft Power Apps.
-
Integrate with Humanity Data in JReport Designer
Create charts and reports based on Humanity data in JReport Designer.
-
Access Live Power BI XMLA Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Power BI XMLA data from your Google Sheets.
-
Use Dash to Build Web Apps on Cosmos DB Data via CData Connect AI
Build interactive Dash web apps on live Cosmos DB data using pandas and the CData Connect AI Python SDK.
-
Link Jira with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Jira data in Filemaker Pro for Mac or Windows.
-
Back Up CSV data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for CSV. In this article, we will employ an SSIS workflow to populate a database with CSV data data.
-
How to connect PolyBase to Zoho Inventory
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Zoho Inventory data.
-
Build MVC Applications with Connectivity to Blackbaud FE NXT Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Blackbaud FE NXT from an ASP.NET MVC application.
-
How to Access Live TigerGraph Data in Power Automate Desktop via ODBC
The CData ODBC Driver for TigerGraph enables you to integrate TigerGraph data into workflows built using Microsoft Power Automate Desktop.
-
DataBind Controls to Jira Assets Data in C++Builder
DataBind to Jira Assets data in C++Builder with standard components and controls.
-
Link Miro with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Miro data in Filemaker Pro for Mac or Windows.
-
Access Exact Online Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Exact Online data from HeidiSQL.
-
Consume SAP HANA OData Feeds in PowerBuilder
This article demonstrates how to consume SAP HANA data as OData feeds from PowerBuilder using the API Server.
-
Getting Started with the CData JDBC Driver for Simplesat
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Simplesat.
-
Automated Continuous eBay Analytics Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable eBay Analytics replication to PostgreSQL.
-
Getting Started with the CData Excel Add-In for Dynamics 365
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Dynamics 365.
-
Shopify Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Shopify facts in real time.
-
Integrate Sage Intacct Data in Pentaho Data Integration
Build ETL pipelines based on Sage Intacct data in the Pentaho Data Integration tool.
-
How to Visualize xBase Data in Python with pandas
Use pandas and other modules to analyze and visualize live xBase data in Python.
-
How to Connect to Xero Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Xero data. Leverage the pyodbc module for ODBC in Python.
-
Process & Analyze Retently Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Retently Data.
-
LINQ to SAS Data Sets 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 SAS Data Sets Data Provider.
-
How to Access Amazon Marketplace Data Using Entity Framework
This article shows how to access Amazon Marketplace data using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Automated Continuous Discord Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Discord replication to Google BigQuery.
-
Integrate Cline with Live Microsoft Teams Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Microsoft Teams data from within your IDE.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Teradata
Provide connectivity to Teradata data through an SAP BusinessObjects universe.
-
How to Query Live Google Ads Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Google Ads data data in natural language using Python.
-
Access Live DocuSign Data in Coginiti Pro
Connect to and query live DocuSign data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Build an ETL App for Tavily Data in Python with CData
Create ETL applications and real-time data pipelines for Tavily data in Python with petl.
-
View Reports on Real-Time Greenplum Data in Power BI Report Server
Use the CData ODBC Driver for Greenplum to visualize Greenplum data in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Azure Analysis Services Data into Power Automate Desktop using CData Connect
CData Connect for Azure Analysis Services Data enables you to integrate Azure Analysis Services data into workflows built using Microsoft Power Automate Desktop.
-
Integrating GitHub Copilot with Salesforce Data 360 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 Build an ETL App for Greenhouse Data in Python with CData Connect AI
Extract and transform live Greenhouse data in Python with petl and the CData Connect AI Python SDK.
-
Integrate Open WebUI with Live Toggl Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Toggl data from within the chat interface.
-
Natively Connect to Teradata Data in PHP
The CData ODBC driver for Teradata enables you to create PHP applications with connectivity to Teradata data. Leverage the native support for ODBC in PHP.
-
Add Aha! Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Aha! with the Informatica Enterprise Data Catalog to classify and organize data.
-
Use the CData Software ODBC Driver for Pipeliner CRM in MicroStrategy Desktop
Connect to Pipeliner CRM data in MicroStrategy Desktop using the CData Software ODBC Driver for Pipeliner CRM.
-
DataBind Controls to Hugging Face Data in C++Builder
DataBind to Hugging Face data in C++Builder with standard components and controls.
-
Create Power BI Reports on Real-Time Calendly Data
Use the CData ODBC Driver for Calendly to visualize Calendly data in Power BI Desktop.
-
Automate SendInBlue Data Replication to Azure Data Lake
Use CData Sync to customize and automate SendInBlue data replication to Azure Data Lake.
-
Natively Connect to Wrike Data in PHP
The CData ODBC driver for Wrike enables you to create PHP applications with connectivity to Wrike data. Leverage the native support for ODBC in PHP.
-
Process & Analyze HDFS Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live HDFS Data.
-
Publish Opsgenie-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Opsgenie data.
-
Automated Continuous Bitly Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Bitly replication to Apache Kafka.
-
Publish Crystal Reports on ShipEngine Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date ShipEngine data.
-
How to Connect to Live Act CRM 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 Act CRM data for you.
-
Replicate Multiple Salesforce CRM Analytics Accounts via the CData Sync CLI
Replicate multiple Salesforce CRM Analytics accounts to one or many databases.
-
How to Connect to Stack Exchange Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Stack Exchange data. Leverage the pyodbc module for ODBC in Python.
-
Integrate Cline with Live Lakebase Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Lakebase data from within your IDE.
-
Connect to Front in SpagoBI
Create reports featuring live Front data in SpagoBI Studio. Host Front reports on SpagoBI Server.
-
Explore Geographical Relationships in Mistral AI Data with Power Map
Create data visualizations with Mistral AI data in Power Map.
-
Connect to xBase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for xBase and the SQL Gateway to access xBase data from Google Apps Script.
-
Prepare, Blend, and Analyze Perplexity Data in Alteryx Designer (Connect AI)
Build workflows to access live Perplexity data for self-service data analytics.
-
LINQ to Salesforce Pardot 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 Salesforce Pardot Data Provider.
-
Visualize Superchat Data in Sisense
Create an ElastiCube in Sisense app with access to Superchat data.
-
How to Query Highrise Data in MySQL Workbench
Execute MySQL queries against live Highrise data from MySQL Workbench.
-
Automated Continuous API Replication to SQLite
Use CData Sync for automated, continuous, customizable API replication to SQLite.
-
Analyze Live Jira Data in SAS Viya
Use CData Connect AI to connect to Jira data from SAS Viya and deploy self-service analytics using live Jira data.
-
Integrate Omnisend with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Omnisend with External Services.
-
Automated Continuous Cloudant Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Cloudant data replication to OneLake in Microsoft Fabric.
-
Visualize Live Testmonitor Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Testmonitor data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Import and Visualize Brex Data in Power View
Create data visualizations based on Brex data in Excel.
-
Connect to Adobe Commerce Data in RazorSQL
Connect to Adobe Commerce from wizards and query Adobe Commerce data from the GUI in the RazorSQL database management tool.
-
Visualize Live Slack Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Slack data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Connect to Bannerbear Data in CloverDX (formerly CloverETL)
Transfer Bannerbear data using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous Moosend Replication to Snowflake
Use CData Sync for automated, continuous, customizable Moosend replication to Snowflake.
-
Model Vertica Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Vertica, enabling the direct import of real-time Vertica data.
-
Query Hubstaff Data as a MySQL Database in Node.js
Execute MySQL queries against Hubstaff data from Node.js.
-
Create Dropbox Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Dropbox from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query Snowflake Data in ColdFusion
Write standard ColdFusion data access code to connect to Snowflake data.
-
Integrate Live RSS Feeds into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live RSS feeds to Blue Prism using the CData ODBC Driver for RSS to create automated workflows for repetitive business tasks.
-
How to Easily Query MariaDB Data in OpenOffice Base
Connect to MariaDB data in OpenOffice Base using the CData ODBC Driver for MariaDB and generate reports with live data insights.
-
Moving Data from Zoho Inventory to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Inventory data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Contentful Data from a Connection Pool in JBoss
Integrate Contentful data into Java servlets: Use the Management Console in JBoss to install the Contentful JDBC Driver.
-
Connect to and Visualize Live GetResponse Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live GetResponse data.
-
Visualize Azure Analysis Services Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Azure Analysis Services data.
-
Access Live Discord Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Discord data into the statistical analysis tools available in SAS JMP. This article shows how to use Discord data in the Graph Builder and Query Builder.
-
Integrating LangGraph with YouTube Analytics Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on YouTube Analytics data within automated workflows.
-
Integrate Slack Data in Pentaho Data Integration
Build ETL pipelines based on Slack data in the Pentaho Data Integration tool.
-
Integrating LangGraph with ADP Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on ADP data within automated workflows.
-
Automate Jodoo Data Replication to Azure Synapse
Use CData Sync to customize and automate Jodoo data replication to Azure Synapse.
-
OneNote Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to OneNote data through CData Connect AI using different applications and tools.
-
Work with Flowlu Data in FoxPro
Load Flowlu data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Integrate Goose with Live Elasticsearch Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Elasticsearch data from within the local AI agent.
-
How to Connect to Live Adobe Target Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Adobe Target data for you.
-
Replicate Google Directory Data in Heroku for Use in Salesforce Connect
Replicate Google Directory data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Salesloft Data in Google Apps Script via Connect AI
Use CData Connect AI to access Salesloft data in Google Apps Script.