CData Software - Knowledge Base
Recent Articles
-
Connect to and Visualize Live LightSpeedRetail Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LightSpeedRetail data.
-
Access Live SAP Netweaver Gateway Data in AWS Lambda
Connect to live SAP Netweaver Gateway data in AWS Lambda using the CData JDBC Driver.
-
Connect to Act CRM Data in Aqua Data Studio
Access Act CRM data from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Salesforce Marketing Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Salesforce Marketing data using standard SQL.
-
Mode Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Mode facts in real time.
-
Connect to CSV from a Connection Pool in WebLogic
Use the CData JDBC Driver for CSV to connect to CSV data from Web applications running on WebLogic.
-
Getting Started with the CData Connect AI Python SDK for Optimizely
Install the CData Connect AI Python SDK to read live Optimizely data with standard DB-API 2.0 Python code.
-
How to Create Power BI Visual Reports with Real-Time MarkLogic Data
Use CData Power BI Connectors to visualize MarkLogic data in Power BI.
-
Explore Geographical Relationships in Google Campaign Manager 360 Data with Power Map
Create data visualizations with Google Campaign Manager 360 data in Power Map.
-
How to Connect to Live Figshare 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 Figshare data for you.
-
Build SAP Ariba Procurement-Connected Applications in Kiro with CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live SAP Ariba Procurement data without replication.
-
Build Automated Workflows with Live Neo4J Data in Workato
Use CData Connect AI to connect to live Neo4J data and build automated workflows in Workato.
-
Create Dynamic SAP Fieldglass Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP Fieldglass to Infragistics XamDataGrid to build dynamic grids.
-
Publish Reports with Stripe Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Stripe data.
-
Access Live Onfleet Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Onfleet data into the statistical analysis tools available in SAS JMP. This article shows how to use Onfleet data in the Graph Builder and Query Builder.
-
Automated Continuous Azure Data Lake Storage Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Azure Data Lake Storage replication to AlloyDB.
-
Getting Started with the CData SSIS Components for Dynamics CRM
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Dynamics CRM.
-
Build Semantic Layer Views for WooCommerce Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for WooCommerce data.
-
Using DirectQuery in Power BI with CData Power BI Connectors
CData Power BI Connectors support the DirectQuery connection mode in Power BI, allowing users to query large datasets in real-time without having to import the data locally.
-
How to connect SharePoint with BigCommerce Data through external lists
Provide BigCommerce data to SharePoint users as an external list.
-
Automated Continuous Oracle SCM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Oracle SCM replication to delimited files (CSV/TSV).
-
How to Use a Microsoft Access Database to Update Salesforce Data in Real Time
Update Salesforce data by creating a linked table in Microsoft Access with the CData Salesforce ODBC Driver.
-
Integrate Salesforce Data 360 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Salesforce Data 360 data from Informatica Cloud.
-
Automate Oracle Financials Cloud Data Replication to Azure Synapse
Use CData Sync to customize and automate Oracle Financials Cloud data replication to Azure Synapse.
-
Automated Continuous Toggl Replication to SingleStore
Use CData Sync for automated, continuous, customizable Toggl replication to SingleStore.
-
Trigger DB2 IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for DB2 with standard wizards in Logic Apps.
-
Create Azure Data Catalog-Connected Business Apps in AppSheet
Connect to Azure Data Catalog Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Azure Data Catalog data.
-
Connect to ZohoInvoice Data in RapidMiner
Integrate ZohoInvoice data with standard components and data source configuration wizards in RapidMiner Studio.
-
Automated Continuous OData Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable OData replication to Apache Cassandra.
-
How to Seamlessly Import Azure Analysis Services Data into IBM SPSS Modeler
Integrate Azure Analysis Services data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automate Notion Data Replication to SAP HANA
Use CData Sync to customize and automate Notion data replication to SAP HANA.
-
Extract, Transform, and Load Square Data in Informatica PowerCenter
Create a simple Workflow for Square data in Informatica PowerCenter.
-
Connect to Real-Time Salesforce Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Salesforce and Dataflow to import and use Salesforce data in Power Apps.
-
Visualize Live Spark Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Spark data.
-
Create Datasets from PhantomBuster in Domo Workbench and Build Visualizations of PhantomBuster Data in Domo
Use the CData Software ODBC Driver for PhantomBuster to create datasets from PhantomBuster data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to MongoDB Data from HeidiSQL
Use CData Connect AI to connect to and query live MongoDB data from HeidiSQL.
-
Query Trello Data in ColdFusion
Write standard ColdFusion data access code to connect to Trello data.
-
Integrate Open WebUI with Live EnterpriseDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live EnterpriseDB data from within the chat interface.
-
Build AI/ML Models with Live PingOne Data using Dataiku
Connect PingOne Data with Dataiku using the CData JDBC Driver for PingOne.
-
Create Reports with Klipfolio Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Klipfolio data.
-
Use Databricks Agent Bricks to Talk to Your Microsoft Teams Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Microsoft Teams data for you.
-
Integrating Kiro with Snapchat Ads 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.
-
Access Live ZarMoney Data in Coginiti Pro
Connect to and query live ZarMoney data from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to Bitly Data in DBeaver
Use the CData ODBC Driver to connect to Bitly data in DBeaver.
-
Getting Started with the CData Connect AI Python SDK for FHIR
Install the CData Connect AI Python SDK to read live FHIR data with standard DB-API 2.0 Python code.
-
Access ServiceDesk Plus Data from MySQL in Amazon QuickSight
Connect to ServiceDesk Plus and build visualizations of ServiceDesk Plus data using a MySQL Connection in Amazon QuickSight.
-
Publish Foursquare-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Foursquare data.
-
Access Live LDAP Objects in AWS Lambda (with IntelliJ IDEA)
Connect to live LDAP objects in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Getting Started with the CData JDBC Driver for Microsoft Teams
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Microsoft Teams.
-
Model, Search, and Visualize Live GitHub Data in ThoughtSpot
Use CData Connect AI to connect to live GitHub data for modeling, searching, and visualizing.
-
Connect to Certinia Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Certinia.
-
Use Dash to Build to Web Apps on SAP Business Warehouse Data
Create Python applications that use pandas and Dash to build SAP Business Warehouse-connected web apps.
-
Prepare, Blend, and Analyze Everhour Data in Alteryx Designer (ODBC)
Build workflows to access live Everhour data for self-service data analytics.
-
Choosing the Best Method to Connect Clio to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Clio data from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Natively Connect to Nethunt Data in PHP
The CData ODBC driver for Nethunt enables you to create PHP applications with connectivity to Nethunt data. Leverage the native support for ODBC in PHP.
-
Excel Spreadsheet Automation on Landbot Data with the QUERY Formula
Pull data from Landbot, automate spreadsheets, and more with the QUERY formula.
-
Build Voice Agents in ElevenLabs with access to Live GraphQL Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live GraphQL data.
-
DataBind Charts to Oracle Service Cloud Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Oracle Service Cloud data 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.
-
Connect to Todoist Data from PowerBuilder via JDBC
This article demonstrates how to access Todoist data from PowerBuilder using the Todoist JDBC Driver.
-
Create Power BI Reports on Real-Time Harvest Data
Use the CData ODBC Driver for Harvest to visualize Harvest data in Power BI Desktop.
-
Extract, Transform, and Load Highrise Data in Informatica PowerCenter
Create a simple Workflow for Highrise data in Informatica PowerCenter.
-
Visualize Live Reckon Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Reckon data.
-
Use Grok to Talk to Your Zoom 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 Zoom data for you.
-
How to Connect to Live Vault CRM 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 Vault CRM data without replication.
-
How to Seamlessly Import Tanda Data into IBM SPSS Modeler
Integrate Tanda data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Getting Started with the CData Excel Add-In for Hacker News
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Hacker News.
-
Build Voice Agents in ElevenLabs with access to Live SAP Netweaver Gateway Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SAP Netweaver Gateway data.
-
Use ChatGPT to Talk to Your ConstantContact Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your ConstantContact data for you.
-
Access Quickbase Data from MySQL in Amazon QuickSight
Connect to Quickbase and build visualizations of Quickbase data using a MySQL Connection in Amazon QuickSight.
-
Import and Visualize Salesforce Data 360 Data in Power View
Create data visualizations based on Salesforce Data 360 data in Excel.
-
Getting Started with the CData Excel Add-In for SAP Hybris C4C
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for SAP Hybris C4C.
-
Integrate with LaunchDarkly Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy LaunchDarkly data to a JSON file on disk.
-
Use Agno to Talk to Your Testmonitor 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 Testmonitor data for you.
-
Analyze CSV Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of CSV data and visualize live CSV data in Infragistics Reveal.
-
Connect to eBay Data in DBArtisan
Use wizards in DBArtisan to configure eBay data as a data source.
-
Work with Jira Data in FoxPro
Load Jira data into a FoxPro database. This article includes full code and a walk-through of the process.
-
Automate Box Data Replication to Couchbase
Use CData Sync to Customize and automate Box data replication to Couchbase.
-
Build a PostgreSQL Interface for LinkedIn Ads Data using the CData JDBC Driver
Use the Remoting features of the LinkedIn Ads JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connecting Mastra with Moosend Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time Moosend data, no replication required.
-
Connect to and Query ShipEngine Data in QlikView over ODBC
Create data visualizations with ShipEngine data in QlikView.
-
Prepare, Blend, and Analyze Power BI XMLA Data in Alteryx Designer (ODBC)
Build workflows to access live Power BI XMLA data for self-service data analytics.
-
Use Manus AI to Talk to Your Certinia Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Manus AI agents to securely answer questions and take actions on Certinia data.
-
Query Xero Data in DataGrip
Create a Data Source for Xero in DataGrip and use SQL to query live Xero data.
-
Query Splunk Data as a SQL Server Database in Node.js
Execute SQL Server queries against Splunk data from Node.js.
-
How to Easily Query Oracle HCM Cloud Data in OpenOffice Base
Connect to Oracle HCM Cloud data in OpenOffice Base using the CData ODBC Driver for Oracle HCM Cloud and generate reports with live data insights.
-
Integrating OpenCode with Cohere 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.
-
DataBind Controls to Bullhorn CRM Data in Delphi
DataBind to Bullhorn CRM data in Delphi with standard data access components and controls.
-
Explore Geographical Relationships in Kintone Data with Power Map
Create data visualizations with Kintone data in Power Map.
-
Automated Continuous HubSpot Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable HubSpot replication to Amazon Redshift.
-
Getting Started with the CData Tableau Connector for NASA
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Explore Geographical Relationships in Sentry Data with Power Map
Create data visualizations with Sentry data in Power Map.
-
Use Claude to Talk to Your NetSuite Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your NetSuite data for you.
-
Integrating GitHub Copilot with Yelp 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.
-
Connect to EmailOctopus Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to EmailOctopus and work with EmailOctopus data in your FileMaker applications.
-
Integrating Zuora Data in Talend Cloud Data Management Platform
Connect Zuora Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Zuora.
-
Back Up QuickBooks Time data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for QuickBooks Time. In this article, we will employ an SSIS workflow to populate a database with QuickBooks Time data data.
-
Integrating GitHub Copilot with FormSite 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.
-
Automated Continuous Salesforce CRM Analytics Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Salesforce CRM Analytics replication to Amazon Redshift.
-
Visualize Live Figshare Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Figshare data.
-
Connect to JSON Services from a Connection Pool in Jetty
The JSON JDBC Driver supports connection pooling: This article shows how to connect faster to JSON services from Web apps in Jetty.