CData Software - Knowledge Base
Recent Articles
-
Access Snapchat Ads Data from MySQL in Amazon QuickSight
Connect to Snapchat Ads and build visualizations of Snapchat Ads using a MySQL Connection in Amazon QuickSight.
-
Publish Reports with Amazon DynamoDB Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Amazon DynamoDB.
-
Connect to LightSpeedRetail Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time LightSpeedRetail using standard SQL.
-
Model, Search, and Visualize Live Shopify Data in ThoughtSpot
Use CData Connect AI to connect to live Shopify for modeling, searching, and visualizing.
-
Moving Data from Intercom to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Intercom data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Import Azure Data Lake Storage Data Using Azure Data Factory
Use CData Connect AI to connect to Azure Data Lake Storage Data from Azure Data Factory and import live Azure Data Lake Storage.
-
Build MVC Applications with Connectivity to CircleCI Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access CircleCI from an ASP.NET MVC application.
-
Consume Facebook OData Feeds in PowerBuilder
This article demonstrates how to consume Facebook as OData feeds from PowerBuilder using the API Server.
-
Bitbucket Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Bitbucket facts in real time.
-
Query Act CRM Data in DataGrip
Create a Data Source for Act CRM in DataGrip and use SQL to query live Act CRM.
-
Create Datasets from ShipEngine in Domo Workbench and Build Visualizations of ShipEngine Data in Domo
Use the CData Software ODBC Driver for ShipEngine to create datasets from ShipEngine in Domo Workbench and then build visualizations in the Domo service.
-
Build ShipStation-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ShipStation Data and create custom apps in Bubble.
-
Build Charts with Sage 200 Data in Clear Analytics
Create dynamic charts and perform analytics based on Sage 200 in Clear Analytics.
-
Build Charts with Greenplum Data in Clear Analytics
Create dynamic charts and perform analytics based on Pivotal GreenPlum in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time PostgreSQL Data
Use CData Power BI Connectors to visualize PostgreSQL in Power BI.
-
Access ConvertAPI 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 ConvertAPI.
-
Create Dynamic GraphQL Grids Using the Infragistics XamDataGrid
Learn how you can connect GraphQL to Infragistics XamDataGrid to build dynamic grids.
-
Connecting Mastra with JSON Services 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 JSON, no replication required.
-
How to connect PolyBase to Datadog
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Datadog.
-
How to connect to ZendeskSell Data in DBVisualizer
Integrate ZendeskSell with visual data analysis tools and data connection wizards in DBVisualizer
-
How to create Visio diagrams from Salesloft Data
Automatically update Salesloft with the changes you make to Visio master shapes.
-
Operational Reporting on SharePoint Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft SharePoint.
-
Query Pushbullet Data in ColdFusion
Write standard ColdFusion data access code to connect to Pushbullet.
-
Create QuickBooks Online-Connected Applications in Appsmith
Connect to QuickBooks Online Data via CData Connect AI in Appsmith and create custom business applications with real-time access to QuickBooks Online.
-
Replicate Multiple Google Campaign Manager 360 Accounts via the CData Sync CLI
Replicate multiple Google Campaign Manager 360 accounts to one or many databases.
-
How to Query Live OnePageCrm Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live OnePageCrm data in natural language using Python.
-
Integrate Rootly with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Rootly with External Services.
-
Publish Reports with Auth0 Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Auth0.
-
Build Data Flows from Excel Online to SQL Server using SSIS
Easily back up Microsoft Excel Online to SQL Server using the SSIS components for Excel Online.
-
Connect to Azure DevOps Data in JRuby
Create a simple JRuby app with access to live Azure DevOps.
-
Build Shopify-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Shopify to explore live Shopify Data in Gemini Code Assist to assist with building Shopify-powered applications.
-
Analyze NetSuite SuiteAnalytics Data in Cognos Analytics
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Cognos Analytics and analyze live NetSuite SuiteAnalytics.
-
Connect to Google Ad Manager Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Google Ad Manager.
-
Deploy the ADO.NET Provider for ShipEngine on an SSRS Report Server
Connect to ShipEngine 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.
-
SendGrid Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SendGrid facts in real time.
-
Build MVC Applications with Connectivity to Tickspot Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Tickspot from an ASP.NET MVC application.
-
Connect to and Query Confluence Data in QlikView over ODBC
Create data visualizations with Atlassian Confluence in QlikView.
-
Create Dynamic Phoenix Grids Using the Infragistics XamDataGrid
Learn how you can connect Phoenix to Infragistics XamDataGrid to build dynamic grids.
-
Use Grok to Talk to Your Amazon S3 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 Amazon S3 for you.
-
Create a Data Access Object for Nethunt Data using JDBI
A brief overview of creating a SQL Object API for Nethunt in JDBI.
-
Analyze Oracle Eloqua Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Oracle Eloqua from Power Pivot. You will use the Table Import Wizard to load Oracle Eloqua. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Okta Data in Sisense
Create an ElastiCube in Sisense app with access to Okta.
-
Automated Continuous SAP BusinessObjects BI Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable SAP BusinessObjects BI replication to delimited files (CSV/TSV).
-
Excel Spreadsheet Automation on ZarMoney Data with the QUERY Formula
Pull data from ZarMoney, automate spreadsheets, and more with the QUERY formula.
-
How to Connect Flowise AI Agents to Live WooCommerce Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live WooCommerce without replication.
-
Enable the SAP Ariba Procurement JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Ariba Procurement.
-
How to Create Power BI Visual Reports with Real-Time PabblySubscriptions Data
Use CData Power BI Connectors to visualize PabblySubscriptions in Power BI.
-
How to Build an ETL App for ChargeOver Data in Python with CData
Create ETL applications and real-time data pipelines for ChargeOver in Python with petl.
-
Choosing the Best Method to Connect OData to SQL Server: 5 Options Explained
Discover multiple ways to connect and use OData from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Visualize Sybase IQ Data in TIBCO Spotfire through OData
Integrate Sybase IQ into dashboards in TIBCO Spotfire.
-
Automated Parquet Data Replication to Teradata
Use CData Sync to Customize and automate Apache Parquet replication to Teradata.
-
Feed Hubstaff Data into FineReport
How to set Hubstaff as a JDBC data source in FineReport.
-
Connect to Greenhouse Data in DBArtisan
Use wizards in DBArtisan to configure Greenhouse as a data source.
-
Build Semantic Layer Views for GitLab Data in APOS Live Data Gateway
Use the CData Connector for GitLab in APOS Live Data Gateway to build Semantic Layer Views for GitLab.
-
Automated Continuous Toggl Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Toggl replication to Google Cloud SQL.
-
Build Semantic Layer Views for FreeAgent Data in APOS Live Data Gateway
Use the CData Connector for FreeAgent in APOS Live Data Gateway to build Semantic Layer Views for FreeAgent.
-
Build Azure Table-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Azure Table Data from Zoho Analytics and import live Azure Table Storage.
-
Access Live SQL Server Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft SQL Server into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft SQL Server in the Graph Builder and Query Builder.
-
Connect to SAP BusinessObjects BI Data in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for SAP BusinessObjects BI Data and connect to SAP BusinessObjects BI in Akorbi Digital RunMyProcess.
-
Query Oracle SCM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Oracle SCM from Node.js.
-
Build Vercel-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Vercel and build web apps with connectivity to live Vercel.
-
Integrating Sage Intacct Data in Talend Cloud Data Management Platform
Connect Sage Intacct Data with Talend Cloud Data Management Platform using the CData JDBC Driver for Sage Intacct.
-
Automate Acumatica Data Replication to Azure Synapse
Use CData Sync to customize and automate Acumatica ERP replication to Azure Synapse.
-
Using the CData Software ODBC Driver for GetResponse in PyCharm
Connect to GetResponse as an ODBC data source in PyCharm using the CData Software ODBC Driver for GetResponse.
-
Integrate with Sage 200 Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Sage 200 in SnapLogic.
-
How to Work with Supabase Data in ETL Validator JDBC
Connect to Supabase from ETL Validator jobs using the CData Software JDBC Driver.
-
Automated Continuous EnterpriseDB Replication to MySQL
Use CData Sync for automated, continuous, customizable EnterpriseDB replication to MySQL.
-
Integrating GitHub Copilot CLI with Accelo 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 Query Live Sybase Data in Claude Desktop
Connect to and query live Sybase Data in Claude Desktop using CData MCP Server.
-
Build Visualizations of BambooHR Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of BambooHR in Birst.
-
Build Raisers Edge NXT-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Raisers Edge NXT and build web apps with connectivity to live Raisers Edge NXT.
-
Create Informatica Mappings From/To a JDBC Data Source for Amazon Athena
Create Amazon Athena data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Analyze MailerSend Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze MailerSend with the CData JDBC Driver for MailerSend.
-
Use the CData Software JDBC Driver for Bannerbear in MicroStrategy Desktop
Connect to Bannerbear in MicroStrategy Desktop using the CData Software JDBC Driver for Bannerbear.
-
Automate SendPulse Data Replication to Azure Data Lake
Use CData Sync to customize and automate SendPulse replication to Azure Data Lake.
-
Visualize Live SAS Data Sets Data in the Power BI Service
Use CData Connect AI to connect to live SAS Data Sets and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate DB2 Data Replication to SAP HANA
Use CData Sync to customize and automate IBM DB2 replication to SAP HANA.
-
Replicate Google Forms Data from PowerShell
Write a quick PowerShell script to query Google Forms. Use connectivity to the live data to replicate Google Forms to SQL Server.
-
Replicate Multiple Smartsheet Accounts via the CData Sync CLI
Replicate multiple Smartsheet accounts to one or many databases.
-
Connecting Mastra with Amazon S3 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 Amazon S3, no replication required.
-
Manage Pingdom Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Pingdom.
-
Build SharePoint Excel Services-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for SharePoint Excel Services to explore live SharePoint Excel Services Data in Gemini Code Assist to assist with building SharePoint Excel Services-powered applications.
-
Integrate Real-Time Access to SendGrid in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to SendGrid in real time.
-
Create CockroachDB-Connected Nintex Workflows
Use CData Connect AI to connect to CockroachDB Data from Nintex Workflow Cloud and build custom workflows using live CockroachDB.
-
Create Power BI Reports on Real-Time YouTube Analytics Data
Use the CData ODBC Driver for YouTube Analytics to visualize YouTube Analytics in Power BI Desktop.
-
Build AI Agents with Azure DevOps 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 Azure DevOps through CData Connect AI.
-
Add Vimeo Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Vimeo with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Visualizations of PDFMonkey Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of PDFMonkey in Birst.
-
Create Lakebase-Connected Dashboards in Grafana
Connect to Lakebase Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Lakebase.
-
Connect to Real-Time MYOB AccountRight Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for MYOB AccountRight and Dataflow to import and use MYOB AccountRight in Power Apps.
-
How to connect Amazon QuickSight to Dynamics 365 Business Central Data
Create a connection to Dynamics 365 Business Central in CData Connect AI and insert Dynamics 365 Business Central into Amazon QuickSight SPICE to build interactive dashboards.
-
Integrating Claude Code CLI with Snowflake 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.
-
Explore Geographical Relationships in IBM Cloud Object Storage Data with Power Map
Create data visualizations with IBM Cloud Object Storage in Power Map.
-
Deploy the ADO.NET Provider for Zoho Creator on an SSRS Report Server
Connect to Zoho Creator 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.
-
Create Azure DevOps Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Azure DevOps data access from reports, embedded analytics, and more.
-
Migrating data from Foursquare to Google BigQuery using CData SSIS Components.
Easily push Foursquare to Google BigQuery using the CData SSIS Tasks for Foursquare and Google BigQuery.
-
Create Sentry Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Sentry from PowerBI.com to create Power BI Dataflows with real-time data.
-
Query SuiteCRM Data from Node.js
Use the OData endpoint of the CData API Server to connect to your SuiteCRM and perform CRUD operations on SuiteCRM from Node.js.
-
Access Live Zoom Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Zoom from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Manage Coinbase Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Coinbase.