CData Software - Knowledge Base
Recent Articles
-
Use Dash to Build to Web Apps on Simplesat Data
Create Python applications that use pandas and Dash to build Simplesat-connected web apps.
-
Visualize Outreach.io Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Outreach.io.
-
How to Query Live Auth0 Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Auth0 data in natural language using Python.
-
Query SendInBlue Data as a MySQL Database in Node.js
Execute MySQL queries against SendInBlue from Node.js.
-
How to use SQLAlchemy ORM to access Cohere Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Cohere.
-
How to Query Live Zoho Inventory Data in Claude Desktop
Connect to and query live Zoho Inventory Data in Claude Desktop using CData MCP Server.
-
Working with Unbounce Data in LINQPad
Execute LINQ queries to Unbounce in LINQPad.
-
Create Power BI Reports on Real-Time Mocean Data
Use the CData ODBC Driver for Mocean to visualize Mocean in Power BI Desktop.
-
Access Codat Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Codat from HeidiSQL.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for YouTube Analytics
Provide connectivity to YouTube Analytics through an SAP BusinessObjects universe.
-
Connect ShipStation to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ShipStation using the CData Python MCP Server.
-
Connect Clari to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Clari with IBM WebSphere for seamless data integration and connectivity.
-
Access Live Confluence Data in Coginiti Pro
Connect to and query live Atlassian Confluence from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Creating SAP SuccessFactors LMS-Connected Applications in Unqork
You can use CData Connect AI to feed SAP SuccessFactors LMS to Unqork and build custom business apps.
-
Bind Live Amazon Marketplace Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Amazon Marketplace data
-
Build Pipedrive-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Pipedrive and build web apps with connectivity to live Pipedrive.
-
Build an OLAP Cube in SSAS from Helpscout Data
Establish a connection to Helpscout data from SQL Server Analysis Services, and use the Helpscout Data Provider to build OLAP cubes for use in analytics and reporting.
-
Build CouchDB-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to CouchDB Data from Zoho Analytics and import live Apache CouchDB.
-
Create a Data Access Object for GitLab Data using JDBI
A brief overview of creating a SQL Object API for GitLab in JDBI.
-
Query PayPal Data in DataGrip
Create a Data Source for PayPal in DataGrip and use SQL to query live PayPal.
-
How to create SuiteCRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SuiteCRM in MySQL .
-
DataBind Controls to Instagram Data in C++Builder
DataBind to Instagram in C++Builder with standard components and controls.
-
Build a Simple VCL Application for Outreach.io Data
How to build a simple VCL Application to view Outreach.io in RAD Studio using the CData ODBC Driver for Outreach.io.
-
Access Sybase Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Sybase from HeidiSQL.
-
Use the CData SSIS Components to Insert New or Update Existing Sybase Records from SQL Server
Easily push SQL Server data to Sybase using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Sybase or update existing records with data from a SQL Server database.
-
Manage Instantly Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Instantly.
-
Connect to Planio Data from a Connection Pool in JBoss
Integrate Planio into Java servlets: Use the Management Console in JBoss to install the Planio JDBC Driver.
-
How to load AdRoll data into Elasticsearch via Logstash
Introducing a simple method to load AdRoll data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData JDBC Driver for SAP BusinessObjects BI
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for SAP BusinessObjects BI.
-
Build Apps with Live Bullhorn CRM in Adalo using CData Connect AI
Use CData Connect AI to integrate live Bullhorn CRM into the Adalo platform and build custom mobile and web applications with real-time Bullhorn CRM.
-
How to Design GitHub Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to GitHub from mobile and tablet Power Apps.
-
How to Access Cloudant Data Using Entity Framework
This article shows how to access IBM Cloudant using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Working with Azure Data Catalog Data in LINQPad
Execute LINQ queries to Azure Data Catalog in LINQPad.
-
Seamlessly Bring Google Search Results into Retool Using CData Connect AI
Integrate Google Search data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Query Avro Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Apache Avro and perform CRUD operations on Avro from Node.js.
-
Integrate Quickbase Data in the Pentaho Report Designer
Publish reports based on Quickbase in the Pentaho BI tool.
-
Connect to ZeroBounce Data from PowerBuilder via ADO.NET
This article demonstrates how to access ZeroBounce from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
How to connect to Salesloft Data in DBVisualizer
Integrate Salesloft with visual data analysis tools and data connection wizards in DBVisualizer
-
Connect to QuickBooks Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time QuickBooks Desktop using standard SQL.
-
Consume SendGrid OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SendGrid feeds that reflect any changes in SAP Lumira.
-
Stream Webex Data into Apache Kafka Topics
Access and stream Webex in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Use the CData ODBC Driver for MariaDB from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for MariaDB to connect to MariaDB from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring MariaDB in Excel.
-
Connect to Oracle HCM Cloud Data from AWS Glue
Use CData Connect AI to gain access to live Oracle HCM Cloud from your AWS Glue jobs.
-
Build PayPal Visualizations in Tableau Cloud
Use CData Connect AI to connect to live PayPal and build visualizations in Tableau Cloud.
-
How to Connect to Live QuickBooks Online 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 QuickBooks Online for you.
-
Create Data Visualizations in Cognos BI with HelloSign Data
Access HelloSign as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to create Dropbox federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Dropbox in MySQL .
-
Analyze Blackbaud FE NXT Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Blackbaud FE NXT from Power Pivot. You will use the Table Import Wizard to load Blackbaud FE NXT. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Tableau Connector for Snowflake
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Snowflake.
-
Import Microsoft OneDrive Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Microsoft OneDrive Data and provide access to live Microsoft OneDrive for custom reports in the Power BI Service.
-
Build eBay-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live eBay.
-
ETL Foursquare in Oracle Data Integrator
This article shows how to transfer Foursquare into a data warehouse using Oracle Data Integrator.
-
Integrate Hive with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Hive with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Apache Hive.
-
Publish Reports with RabbitMQ Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date RabbitMQ.
-
Integrate Parallel with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Parallel with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Parallel.
-
Manage Pinterest Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pinterest.
-
Automated Continuous Chargebee Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Chargebee replication to AlloyDB.
-
How to Seamlessly Import FHIR Data into IBM SPSS Modeler
Integrate FHIR data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Manage Adobe Commerce Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Adobe Commerce.
-
Connect to ZendeskSell from a Connection Pool in WebLogic
Use the CData JDBC Driver for ZendeskSell to connect to ZendeskSell from Web applications running on WebLogic.
-
How to Access Live ZohoExpense Data in Power Automate Desktop via ODBC
The CData ODBC Driver for ZohoExpense enables you to integrate ZohoExpense into workflows built using Microsoft Power Automate Desktop.
-
Connect to ActiveCampaign in SpagoBI
Create reports featuring live ActiveCampaign in SpagoBI Studio. Host ActiveCampaign reports on SpagoBI Server.
-
Bidirectional Access to Outlook Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Outlook in Filemaker Pro for Mac or Windows.
-
Work with Coda Data in FoxPro
Load Coda into a FoxPro database. This article includes full code and a walk-through of the process.
-
Access Live Azure Data Lake Storage Data in Coginiti Pro
Connect to and query live Azure Data Lake Storage from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to use SQLAlchemy ORM to access Box Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Box.
-
Access Live Blackbaud FE NXT Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Blackbaud FE NXT from your Excel spreadsheets.
-
Automated Continuous Wistia Replication to SQLite
Use CData Sync for automated, continuous, customizable Wistia replication to SQLite.
-
Access Live SQL Analysis Services 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 SQL Analysis Services through MCP integration.
-
Analyze SuiteCRM Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SuiteCRM and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create a Data Access Object for FreshBooks Data using JDBI
A brief overview of creating a SQL Object API for FreshBooks in JDBI.
-
Load Placid Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Placid to a database.
-
Write a Simple Go Application to work with Google Forms Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Google Forms.
-
Access LinkedIn 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 LinkedIn.
-
Automated Continuous Delighted Replication to SQL Server
Use CData Sync for automated, continuous, customizable Delighted replication to SQL Server.
-
Replicate ZendeskSell Data in Heroku for Use in Salesforce Connect
Replicate ZendeskSell to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Query SAP Business One Data in MySQL Workbench
Execute MySQL queries against live SAP Business One from MySQL Workbench.
-
How to Connect to Live Neo4J 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 Neo4J for you.
-
Integrating LangChain with Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Monday.com within automated workflows.
-
Build Semantic Layer Views for Workable Data in APOS Live Data Gateway
Use the CData Connector for Workable in APOS Live Data Gateway to build Semantic Layer Views for Workable.
-
Create Power BI Reports on Real-Time Apollo Data
Use the CData ODBC Driver for Apollo to visualize Apollo in Power BI Desktop.
-
Query Klipfolio Data as a MySQL Database in Node.js
Execute MySQL queries against Klipfolio from Node.js.
-
Visualize HubSpot Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load HubSpot into TIBCO Spotfire.
-
Connect to and Query Trello Data in QlikView over ODBC
Create data visualizations with Trello in QlikView.
-
Getting Started with the CData ADO.NET Provider for Microsoft Dataverse
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Microsoft Dataverse.
-
Use JayDeBeApi to access SAP HANA XS Advanced Data in Python
Use standard Python scripting and the development environment of your choice to access live SAP HANA XS Advanced.
-
DataBind PabblySubscriptions Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide PabblySubscriptions to a chart.
-
Connect to and Visualize Live Contentful Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Contentful.
-
Integrating LangChain with SQL Server Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Microsoft SQL Server within automated workflows.
-
Stream CouchDB Data into Apache Kafka Topics
Access and stream Apache CouchDB in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Visualize Greenhouse Data in TIBCO Spotfire through OData
Integrate Greenhouse into dashboards in TIBCO Spotfire.
-
Bind Live SharePoint Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SharePoint data
-
How to Connect to Live Microsoft Exchange Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your Microsoft Exchange for you.
-
Prepare, Blend, and Analyze Cloudant Data in Alteryx Designer (Connect AI)
Build workflows to access live IBM Cloudant for self-service data analytics.
-
Migrating data from Reply.io to Google BigQuery using CData SSIS Components.
Easily push Reply.io to Google BigQuery using the CData SSIS Tasks for Reply.io and Google BigQuery.
-
Work with Google Analytics Data in FoxPro
Load Google Analytics into a FoxPro database. This article includes full code and a walk-through of the process.
-
Use the CData Software ODBC Driver for SAP Hybris C4C in MicroStrategy
Connect to SAP Hybris C4C in MicroStrategy Developer using the CData Software ODBC Driver for SAP Hybris C4C.
-
How to connect PolyBase to Microsoft Ads
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Ads.
-
Deploy the ADO.NET Provider for Gmail on an SSRS Report Server
Connect to Gmail from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Analyze PayPal Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PayPal with the CData JDBC Driver for PayPal.