CData Software - Knowledge Base
Recent Articles
-
Publish Crystal Reports on Superchat Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Superchat data.
-
Build Apps with Live Jumpseller Data Using the Low-Code Development Platform of Mendix
Connect Jumpseller data with Mendix to build apps using the CData API Driver for JDBC.
-
Getting Started with the CData Python Connector for iContact
Learn to install and license the CData Python Connector and configure a connection to live iContact data.
-
Connect to Salesforce Marketing Data Using the Script Function in Claris FileMaker Pro
Use the CData ODBC Driver for Salesforce Marketing and the Script function in FileMaker Pro to connect to Salesforce Marketing and work with Salesforce Marketing data in your FileMaker application.
-
How to publish and share CampaignMonitor Data dashboards with Tableau Server
The CData ODBC driver for CampaignMonitor enables you integrate CampaignMonitor data into Tableau dashboards.
-
Rapidly Develop Microsoft Exchange-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by Microsoft Exchange.
-
Build an OLAP Cube in SSAS from JSON Services
Establish a connection to JSON services data from SQL Server Analysis Services, and use the JSON Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy
Connect to PingOne data in MicroStrategy Developer using the CData Software JDBC Driver for PingOne.
-
Replicate Browserless Data to Multiple Databases via the CData Sync CLI
Replicate Browserless data to disparate databases with a single configuration.
-
ETL Shortcut in Oracle Data Integrator
This article shows how to transfer Shortcut data into a data warehouse using Oracle Data Integrator.
-
Integrate Cursor with Live Dynamics NAV Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Dynamics NAV data from within the editor.
-
Connect to ZohoPeople Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for ZohoPeople data in the Denodo Virtual DataPort Administrator.
-
Connect to HubSpot Data in ACL Analytics
Connect to HubSpot data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HubSpot data.
-
How to Build an ETL App for FreshBooks Data in Python with CData Connect AI
Extract and transform live FreshBooks data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Close Data from PowerBuilder via JDBC
This article demonstrates how to access Close data from PowerBuilder using the Close JDBC Driver.
-
How to Query Workday Data in MySQL Workbench
Execute MySQL queries against live Workday data from MySQL Workbench.
-
How to connect and process Datadog data from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Datadog data.
-
Build Exa-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Exa Data and create custom apps in Bubble.
-
Integrate Google's Vertex AI Agent with Live Timely Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Vertex AI ADK agents to securely access and act on live Timely data within intelligent workflows.
-
Create SSAS Tabular Models from Printify Data
How to build a SQL Server Analysis Service Tabular Model from Printify data using CData drivers.
-
Use Agno to Talk to Your Kafka Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your Kafka data for you.
-
Analyze NetSuite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze NetSuite data with the CData JDBC Driver for NetSuite.
-
Use Dash to Build to Web Apps on Workday Data
Create Python applications that use pandas and Dash to build Workday-connected web apps.
-
Access Microsoft Exchange Data from MySQL in Amazon QuickSight
Connect to Microsoft Exchange and build visualizations of Microsoft Exchange data using a MySQL Connection in Amazon QuickSight.
-
How to Connect to & Open Apify Data in Microsoft Excel
This article uses the CData ODBC driver for Apify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Elorus Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Elorus to connect to Elorus data and execute queries in PowerBuilder.
-
Connect to Onfleet Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Onfleet and work with Onfleet data in your FileMaker application.
-
Connect to ServiceDesk Plus from a Connection Pool in WebLogic
Use the CData JDBC Driver for ServiceDesk Plus to connect to ServiceDesk Plus data from Web applications running on WebLogic.
-
How to integrate Metabase with QuickBooks Time Data
Use CData Connect AI to connect to live QuickBooks Time data and create an interactive dashboard in Metabase from QuickBooks Time data.
-
Query Attio Data in DataGrip
Create a Data Source for Attio in DataGrip and use SQL to query live Attio data.
-
Connect to Google Ads Data from PowerBuilder via JDBC
This article demonstrates how to access Google Ads data from PowerBuilder using the Google Ads JDBC Driver.
-
Visualize Zoom Data in Tableau
The CData ODBC driver for Zoom enables you integrate Zoom data into Tableau dashboards.
-
Create Dynamic Slack Grids Using the Infragistics XamDataGrid
Learn how you can connect Slack to Infragistics XamDataGrid to build dynamic grids.
-
Integrate JotForm Data in Pentaho Data Integration
Build ETL pipelines based on JotForm data in the Pentaho Data Integration tool.
-
Build MVC Applications with Connectivity to MySQL Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access MySQL from an ASP.NET MVC application.
-
Connect to and Query PhantomBuster Data in QlikView over ODBC
Create data visualizations with PhantomBuster data in QlikView.
-
Model Dynamics 365 Business Central Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Dynamics 365 Business Central, enabling the direct import of real-time Dynamics 365 Business Central data.
-
Access Live Snowflake Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Snowflake data into the statistical analysis tools available in SAS JMP. This article shows how to use Snowflake data in the Graph Builder and Query Builder.
-
Build Semantic Layer Views for HCL Domino Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for HCL Domino data.
-
Integrate with Live Exact Online Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to Exact Online from the MuleSoft Anypoint Platform to integrate live Exact Online data into custom reports and dashboards.
-
Replicate Multiple Exa Accounts
Replicate multiple Exa accounts to one or many databases.
-
Connect Shopify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shopify data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to Connect to Live Monday.com 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 Monday.com data through natural language.
-
Build a PostgreSQL Interface for Google Tasks Data using the CData JDBC Driver
Use the Remoting features of the Google Tasks JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrate SAP Fieldglass with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate SAP Fieldglass with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to SAP Fieldglass data.
-
Create Facebook Ads Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Facebook Ads data access from reports, embedded analytics, and more.
-
Access Helpscout Data from MySQL in PHP
Connect to Helpscout through the standard MySQL libraries in PHP.
-
Build Pipelines with Live SFTP Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to SFTP from Google Cloud Data Fusion, enabling the integration of live SFTP data into the building and management of effective data pipelines.
-
Automated Continuous LDAP Replication to SingleStore
Use CData Sync for automated, continuous, customizable LDAP replication to SingleStore.
-
Use Dash to Build Web Apps on Azure DevOps Data via CData Connect AI
Build interactive Dash web apps on live Azure DevOps data using pandas and the CData Connect AI Python SDK.
-
Link Mailgun with FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Mailgun data in Filemaker Pro for Mac or Windows.
-
Build Automated Odoo-Connected Workflows in Zapier
Use CData Connect AI to connect to live Odoo data and build automated workflows in Zapier.
-
How to connect PolyBase to Simplesat
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Simplesat data.
-
Use Agno to Talk to Your BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your BigCommerce data for you.
-
Automated Continuous Asana Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Asana replication to Google BigQuery.
-
Office 365 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Office 365 facts in real time.
-
Connect to SharePoint Data in NetBeans
Connect to SharePoint data in NetBeans with the data source configuration wizard.
-
How to Connect XML 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 XML data in real time using natural language.
-
Connect to FreeAgent Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for FreeAgent and the SQL Gateway to access FreeAgent data from Google Apps Script.
-
Integrate Discord with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Discord with External Services.
-
How to Visualize Microsoft OneDrive Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Microsoft OneDrive data in Python.
-
Create SSAS Tabular Models from OnePageCrm Data
How to build a SQL Server Analysis Service Tabular Model from OnePageCrm data using CData drivers.
-
Connect to Telegram Data in HULFT Integrate
Connect to Telegram as a JDBC data source in HULFT Integrate
-
Integrate Mocean Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Mocean data from Informatica Cloud.
-
Connect to PagerDuty Data from PowerBuilder via JDBC
This article demonstrates how to access PagerDuty data from PowerBuilder using the PagerDuty JDBC Driver.
-
Create Power BI Reports on Real-Time PostgreSQL Data
Use the CData ODBC Driver for PostgreSQL to visualize PostgreSQL data in Power BI Desktop.
-
Automated Continuous Bitly Replication to SingleStore
Use CData Sync for automated, continuous, customizable Bitly replication to SingleStore.
-
A PostgreSQL Interface for Recurly Data (MySQL Remoting via JDBC)
Use the Remoting features of the Recurly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData Power BI Connector for iContact
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Bidirectional Access to Sage Intacct Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Sage Intacct data in Filemaker Pro for Mac or Windows.
-
Connect to Shippo Data in Ruby
Connect to Shippo data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
How to load OpenWeatherMap data into Elasticsearch via Logstash
Introducing a simple method to load OpenWeatherMap data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
How to Connect to Live FreshBooks 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 FreshBooks data for you.
-
Use Grok to Talk to Your Shortcut 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 Shortcut data for you.
-
Replicate HBase Data in Heroku for Use in Salesforce Connect
Replicate HBase data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Create Power BI Reports on Real-Time ShipStation Data
Use the CData ODBC Driver for ShipStation to visualize ShipStation data in Power BI Desktop.
-
Integrating Codex with Ontraport 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.
-
Search External Anaplan Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Anaplan data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Anaplan Data objects that you can access from apps and the dashboard.
-
Automated Continuous SAP Hybris C4C Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SAP Hybris C4C replication to Apache Cassandra.
-
Build Odoo-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Odoo data.
-
Connect to and Visualize Live Klaviyo Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Klaviyo data.
-
Connect to Elorus Data in Aqua Data Studio
Access Elorus data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Visualize Sendwithus Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Sendwithus data in Python.
-
Access Avalara AvaTax Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Avalara AvaTax data from your Oracle system.
-
How to Connect to Live Google Sheets 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 Google Sheets data without replication.
-
Access Live OData Services in TIBCO Data Virtualization
Use the OData Tibco DV Adapter to create a OData services data source in TIBCO Data Virtualization Studio and gain access to live OData services from your TDV Server.
-
How to Seamlessly Import Paylocity Data into IBM SPSS Modeler
Integrate Paylocity data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Build a Singer.io Tap for SurveyMonkey With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SurveyMonkey data using the CData Python Connector.
-
Create Reports from Google Drive Data in Looker Studio
Use CData Connect AI to gain access to live Google Drive data and create custom reports in Looker Studio.
-
Visualize Live Egnyte Data in the Power BI Service
Use CData Connect AI to connect to live Egnyte data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with live Excel Online Data in Jitterbit
Use CData Connect AI to connect to and integrate live Excel Online data in Jitterbit.
-
Seamlessly Bring Exa Data into Retool Using CData Connect AI
Integrate Exa data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Access Live Printify Data in AWS Lambda
Connect to live Printify data in AWS Lambda using the CData JDBC Driver.
-
How to connect to Parquet Data from Spring Boot
Connect to Parquet in a Spring Boot Application using the CData JDBC Driver for Parquet
-
Build Charts with Coinbase Data in Clear Analytics
Create dynamic charts and perform analytics based on Coinbase data in Clear Analytics.
-
Build AI Agents with SQL Analysis Services 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 SQL Analysis Services data through CData Connect AI.
-
How to connect Amazon QuickSight to Freshteam Data
Create a connection to Freshteam data in CData Connect AI and insert Freshteam data into Amazon QuickSight SPICE to build interactive dashboards.
-
Import Real-Time Zoho Inventory Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zoho Inventory data in ColdFusion.
-
Getting Started with the CData Python Connector for Spotify
Learn to install and license the CData Python Connector and configure a connection to live Spotify data.
-
Use Azure AI Foundry to Talk to Your HCL Domino Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your HCL Domino data for you.