CData Software - Knowledge Base
Recent Articles
-
DataBind Missive Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Missive to a chart.
-
Model Oracle HCM Cloud Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Oracle HCM Cloud, enabling the direct import of real-time Oracle HCM Cloud.
-
Import Real-Time LinkedIn Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LinkedIn in ColdFusion.
-
Build CSV-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for CSV to explore live CSV Data in Cursor to assist with building CSV-powered applications.
-
LINQ to Raisers Edge NXT 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 Raisers Edge NXT Data Provider.
-
How to connect PolyBase to Bugsnag
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Bugsnag.
-
Use the CData ODBC Driver for Instagram from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Instagram to connect to Instagram from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Instagram in Excel.
-
Analyze Front Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Front from Power Pivot. You will use the Table Import Wizard to load Front. You can visually build the import query or use any SQL supported by the driver.
-
Connect to and Query Slack Data in QlikView over ODBC
Create data visualizations with Slack in QlikView.
-
Visualize Live Toggl Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Toggl.
-
Design BIRT Reports on Printify Data
Provide current Printify to your embedded analytics.
-
Create Data Visualizations in Cognos BI with RabbitMQ Data
Access RabbitMQ as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Connect to ConvertAPI Data in Jaspersoft Studio
Execute SQL to remote ConvertAPI in Jaspersoft Studio.
-
Query Exact Online Data as a SQL Server Database in Node.js
Execute SQL Server queries against Exact Online from Node.js.
-
Create Salesforce Marketing-Connected Dashboards in Grafana
Connect to Salesforce Marketing Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Salesforce Marketing Cloud.
-
How to Work with Flowlu Data in ETL Validator JDBC
Connect to Flowlu from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect to SharePoint Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Microsoft SharePoint. Leverage the pyodbc module for ODBC in Python.
-
Connect to ConvertAPI Data in JRuby
Create a simple JRuby app with access to live ConvertAPI.
-
Natively Connect to Aircall Data in PHP
The CData ODBC driver for Aircall enables you to create PHP applications with connectivity to Aircall. Leverage the native support for ODBC in PHP.
-
Connect to Landbot Data in Jaspersoft Studio
Execute SQL to remote Landbot in Jaspersoft Studio.
-
How to Connect to Live Lakebase Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Lakebase for you.
-
How to Connect Cvent Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Cvent data in real time using natural language.
-
Use the CData Software JDBC Driver for Datadog in MicroStrategy Web
Connect to Datadog in MicroStrategy Web using the CData Software JDBC Driver for Datadog.
-
Natively Connect to Rootly Data in PHP
The CData ODBC driver for Rootly enables you to create PHP applications with connectivity to Rootly. Leverage the native support for ODBC in PHP.
-
Work with SAP Business Warehouse Data in FoxPro
Load SAP Business Warehouse into a FoxPro database. This article includes full code and a walk-through of the process.
-
Query, Visualize, and Share live Microsoft Ads Data in Redash
Use CData Connect AI to connect to live Microsoft Ads in Redash for querying, visualizing, and sharing.
-
How to Query PolarTeamPro Data in MySQL Workbench
Execute MySQL queries against live PolarTeamPro from MySQL Workbench.
-
Explore Geographical Relationships in Google Contacts Data with Power Map
Create data visualizations with Google Contacts in Power Map.
-
Build Cvent-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Cvent Data from Zoho Analytics and import live Cvent.
-
Replicate Sage 200 Data in Heroku for Use in Salesforce Connect
Replicate Sage 200 to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to publish and share Aweber Data dashboards with Tableau Server
The CData ODBC driver for Aweber enables you integrate Aweber into Tableau dashboards.
-
How to create Google Sheets federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Sheets in MySQL .
-
Connect to Cvent Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Cvent as an External Source in Dremio.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Mode
Provide connectivity to Mode through an SAP BusinessObjects universe.
-
Automate Perigon Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Perigon from PowerShell? This article demonstrates how to utilize the Perigon Cmdlets for tasks like connecting to Perigon, automating operations, downloading data, and more.
-
Automated Continuous Outreach.io Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Outreach.io replication to Apache Kafka.
-
Build Zoho Creator-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Zoho Creator and build web apps with connectivity to live Zoho Creator.
-
How to Seamlessly Import Planio Data into IBM SPSS Modeler
Integrate Planio data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Access Excel Data from MySQL in Amazon QuickSight
Connect to Excel and build visualizations of Microsoft Excel using a MySQL Connection in Amazon QuickSight.
-
Integrate with Epicor Kinetic Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Epicor Kinetic in SnapLogic.
-
Connect Act-On to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Act-On using the CData Python MCP Server.
-
Access Oracle Data from MySQL in Amazon QuickSight
Connect to Oracle and build visualizations of Oracle Database using a MySQL Connection in Amazon QuickSight.
-
How to connect to Google Search Results from IntelliJ
Integrate connectivity to Google Search with wizards in IntelliJ.
-
Add Oracle Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Oracle with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Query Live LinkedIn Ads Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live LinkedIn Ads into Databricks
-
Connect to ZohoExpense Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoExpense in the Denodo Virtual DataPort Administrator.
-
Integrating Dataiku with Sage Intacct Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Sage Intacct.
-
Create Workday-Connected Applications in Appsmith
Connect to Workday Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Workday.
-
Visualize SparkPost Data in Tableau
The CData ODBC driver for SparkPost enables you integrate SparkPost into Tableau dashboards.
-
Connect to HDFS Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Cursor with Live Microsoft Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Microsoft Ads from within the editor.
-
Connect to EnterpriseDB Data from PowerBuilder via JDBC
This article demonstrates how to access EnterpriseDB from PowerBuilder using the EnterpriseDB JDBC Driver.
-
DataBind Vercel Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Vercel to a chart.
-
Publish ElevenLabs-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live ElevenLabs.
-
Automate Trello Data Replication to Couchbase
Use CData Sync to Customize and automate Trello replication to Couchbase.
-
Connect to CloudConvert Data in Jaspersoft Studio
Execute SQL to remote CloudConvert in Jaspersoft Studio.
-
Natively Connect to Discord Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Discord. Leverage the native support for ODBC in PHP.
-
Integrate Goose with Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live SQL Analysis Services from within the local AI agent.
-
Connect to Tickspot Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Tickspot using standard SQL.
-
Integrate Live Amazon S3 Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Amazon S3 and integrate live Amazon S3 into apps built in Microsoft Power Apps.
-
How to import Tally Data into Apache Solr
Use the CData Software JDBC Driver for Tally in Data Import Handler and create an automated import of Tally ERP to Apache Solr Enterprise Search platform.
-
Import SQL Server Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Microsoft SQL Server. In this article, you will use the OData format to import Microsoft SQL Server into Microsoft Power Query.
-
How to Build an ETL App for Basecamp Data in Python with CData
Create ETL applications and real-time data pipelines for Basecamp in Python with petl.
-
How to connect SharePoint with SAP HANA Data through external lists
Provide SAP HANA to SharePoint users as an external list.
-
Prepare, Blend, and Analyze MariaDB Data in Alteryx Designer (ODBC)
Build workflows to access live MariaDB for self-service data analytics.
-
HCL Domino REST API Part 3: Use the REST API from Postman
Part 3 of the HCL Domino REST API series. Import the OpenAPI spec into Postman, set variables, and exercise CRUD operations against the REST API.
-
Access Live Azure DevOps 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 Azure DevOps through MCP integration.
-
Automate ZohoPeople Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoPeople from PowerShell? This article demonstrates how to utilize the ZohoPeople Cmdlets for tasks like connecting to ZohoPeople, automating operations, downloading data, and more.
-
Use the CData ODBC Driver for TigerGraph from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for TigerGraph to connect to TigerGraph from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring TigerGraph in Excel.
-
Connect to FreeAgent Data in DBeaver
Use the CData ODBC Driver to connect to FreeAgent in DBeaver.
-
Automated Continuous Copper Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Copper replication to PostgreSQL.
-
Integrating LlamaIndex with Acumatica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Acumatica ERP in real time.
-
Work with Live Freshservice Data in Power Query
Use CData Connect AI to connect to Freshservice and work with live Freshservice in Microsoft Power Query.
-
Automate Billsby Data Replication to Azure Synapse
Use CData Sync to customize and automate Billsby replication to Azure Synapse.
-
Access Microsoft Exchange Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Exchange from your Oracle system.
-
Connect to Coinbase Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Coinbase and the SQL Gateway to access Coinbase from Google Apps Script.
-
Connect to Freshsales Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Freshsales as an External Source in Dremio.
-
Automated TaxJar Data Replication to Teradata
Use CData Sync to Customize and automate TaxJar replication to Teradata.
-
How to update Stripe from Excel
This article explains how to transfer data from Excel to Stripe using the Excel Add-In for Stripe.
-
Use the CData Software ODBC Driver for Google Spanner in SAS for Real-Time Reporting and Analytics
Connect to real-time Google Spanner in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Google Spanner.
-
How to Access Live AlloyDB Data in Visual Studio Code via Cline
Run CData MCP Server for AlloyDB on Windows Subsytem for Linux (WSL) and connect to live Google AlloyDB from the Cline extension in Visual Studio Code.
-
Integrate with ElevenLabs Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy ElevenLabs to a JSON file on disk.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Parquet
Provide connectivity to Apache Parquet through an SAP BusinessObjects universe.
-
DataBind Charts to Reckon Accounts Hosted Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Reckon Accounts Hosted from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Publish Reports with Onfleet Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Onfleet.
-
Use Dash to Build to Web Apps on Raisers Edge NXT Data
Create Python applications that use pandas and Dash to build Raisers Edge NXT-connected web apps.
-
Using the CData Software ODBC Driver for PhantomBuster in PyCharm
Connect to PhantomBuster as an ODBC data source in PyCharm using the CData Software ODBC Driver for PhantomBuster.
-
Create Power BI Reports on Real-Time Amplitude Data
Use the CData ODBC Driver for Amplitude to visualize Amplitude in Power BI Desktop.
-
Enable the Dynamics CRM JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Microsoft Dynamics CRM.
-
How to Import Data from Redis into Google Sheets
Import Redis into a Google spreadsheet that is automatically refreshed.
-
LINQ to Datadog 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 Datadog Data Provider.
-
Import Real-Time Databricks Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Databricks in ColdFusion.
-
Publish Reports with Microsoft Teams Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft Teams.
-
How to connect to HCL Domino Data in DBVisualizer
Integrate HCL Domino with visual data analysis tools and data connection wizards in DBVisualizer
-
Automated Continuous Google Search Replication to MongoDB
Use CData Sync for automated, continuous, customizable Google Search replication to MongoDB.
-
Consume FTP OData Feeds in SAP Lumira
Use the API Server to create data visualizations on FTP feeds that reflect any changes in SAP Lumira.
-
Connect to Outreach.io in SpagoBI
Create reports featuring live Outreach.io in SpagoBI Studio. Host Outreach.io reports on SpagoBI Server.
-
Working with Apify Data in LINQPad
Execute LINQ queries to Apify in LINQPad.
-
Connect Teamwork to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Teamwork using the CData Python MCP Server.
-
Create Data Visualizations Based On SharePoint Data in Mode
Use CData Connect AI to connect to SharePoint Data from Mode and build visualizations using live