CData Software - Knowledge Base
Recent Articles
-
Connect to Real-Time OpenWeatherMap Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use OpenWeatherMap data in Power Apps.
-
Use JayDeBeApi to access Zoho Creator Data in Python
Use standard Python scripting and the development environment of your choice to access live Zoho Creator data.
-
Deploy the ADO.NET Provider for OData on an SSRS Report Server
Connect to OData services 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.
-
How to Visualize Klaviyo Data in Python with pandas
Use pandas and other modules to analyze and visualize live Klaviyo data in Python.
-
Use the CData ODBC Driver for GitHub from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for GitHub to connect to GitHub data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring GitHub data in Excel.
-
Analyze Sage Cloud Accounting Data in Looker
Use CData Connect AI to connect to Sage Cloud Accounting Data from Looker and build custom apps using live Sage Cloud Accounting data.
-
Integrate Real-Time Access to Amazon Marketplace in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon Marketplace data in real time.
-
Visualize Jumpseller Data in TIBCO Spotfire through ADO.NET
Integrate Jumpseller data into dashboards in TIBCO Spotfire.
-
Connect to IBM Cloud Object Storage Data from HeidiSQL
Use CData Connect AI to connect to and query live IBM Cloud Object Storage data from HeidiSQL.
-
Use ChatGPT to Talk to Your Facebook 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 Facebook data for you.
-
Excel Spreadsheet Automation on Timely Data with the QUERY Formula
Pull data from Timely, automate spreadsheets, and more with the QUERY formula.
-
Build Presto-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live Presto data.
-
Easily Integrate PagerDuty Data in Lazarus Pascal IDE
Learn how to easily integrate live PagerDuty data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Adobe Analytics Data in DBArtisan
Use wizards in DBArtisan to configure Adobe Analytics data as a data source.
-
Integrating OpenCode with Customer.io 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.
-
Object-Relational Mapping (ORM) with Pushbullet Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pushbullet data into a Java-based ORM framework, Hibernate.
-
LINQ to SAP ByDesign 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 SAP ByDesign Data Provider.
-
Create a Data Access Object for Avalara AvaTax Data using JDBI
A brief overview of creating a SQL Object API for Avalara AvaTax data in JDBI.
-
Integrate Google Analytics Data into Power Automate Desktop using CData Connect
CData Connect for Google Analytics Data enables you to integrate Google Analytics data into workflows built using Microsoft Power Automate Desktop.
-
Create Databricks-Connected Business Apps in AppSheet
Connect to Databricks Data via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Databricks data.
-
Connect to Facebook Ads Data in Ruby
Connect to Facebook Ads data in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build NetSuite SuiteAnalytics-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live NetSuite SuiteAnalytics data and build NetSuite SuiteAnalytics-connected web apps with Axios.
-
Connect to SAP HANA XS Advanced Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time SAP HANA XS Advanced data using standard SQL.
-
Connect to Discord Data from PowerBuilder via JDBC
This article demonstrates how to access Discord data from PowerBuilder using the Discord JDBC Driver.
-
How to Visualize Procore Data in Python with pandas
Use pandas and other modules to analyze and visualize live Procore data in Python.
-
Connect to Browserless 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 Browserless and work with Browserless data in your FileMaker application.
-
Integrate with Beeminder Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Beeminder data to a JSON file on disk.
-
Connect to Real-Time Sage 300 Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage 300 and Dataflow to import and use Sage 300 data in Power Apps.
-
Prepare, Blend, and Analyze Trello Data in Alteryx Designer (ODBC)
Build workflows to access live Trello data for self-service data analytics.
-
Establish a Live Connection with Billsby Data using Tableau Bridge
The CData ODBC Driver for Billsby enables you to integrate live Billsby data into Tableau Cloud dashboards using the Tableau Bridge.
-
Build Impala-Connected Apps in Choreo
Use CData Connect AI to connect to Impala Data from Choreo and build custom apps using live Impala data.
-
How to Connect to & Open Pipeliner CRM Data in Microsoft Excel
This article uses the CData ODBC driver for Pipeliner CRM to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect Shortcut to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Shortcut with IBM WebSphere for seamless data integration and connectivity.
-
How to Query Live Excel Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Excel data data in natural language using Python.
-
Consume Google Directory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Google Directory feeds that reflect any changes in SAP Lumira.
-
Easily Integrate GraphQL Data in Lazarus Pascal IDE
Learn how to easily integrate live GraphQL data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Live Attio Data in AWS Lambda
Connect to live Attio data in AWS Lambda using the CData JDBC Driver.
-
Automated Continuous Intercom Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Intercom replication to Apache Cassandra.
-
Replicate Oracle SCM Data from PowerShell
Write a quick PowerShell script to query Oracle SCM data. Use connectivity to the live data to replicate Oracle SCM data to SQL Server.
-
Connect to Oracle HCM Cloud Data in DBArtisan
Use wizards in DBArtisan to configure Oracle HCM Cloud data as a data source.
-
Integrate with Workable Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Workable data to a JSON file on disk.
-
Create Adobe Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to Adobe Analytics Data from Nintex Workflow Cloud and build custom workflows using live Adobe Analytics data.
-
Use the CData Software JDBC Driver for HBase in MicroStrategy Web
Connect to HBase data in MicroStrategy Web using the CData Software JDBC Driver for HBase.
-
Build Salesforce Pardot-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 Salesforce Pardot data without replication.
-
Extract, Transform, and Load Float Data in Informatica PowerCenter
Create a simple Workflow for Float data in Informatica PowerCenter.
-
Connect to Live Google Spanner Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Google Spanner in CData Connect AI and connect to your Google Spanner data from PostgreSQL.
-
Integrating Claude Code CLI with Salesloft 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.
-
How to Build an ETL App for EnterpriseDB Data in Python with CData Connect AI
Build ETL pipelines that read and write live EnterpriseDB data in Python with petl and the CData Connect AI Python SDK.
-
Connect to Front Data from a Connection Pool in JBoss
Integrate Front data into Java servlets: Use the Management Console in JBoss to install the Front JDBC Driver.
-
Use the CData ODBC Driver for Azure DevOps from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure DevOps to connect to Azure DevOps data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure DevOps data in Excel.
-
Integrate with live Typeform Data in Jitterbit
Use CData Connect AI to connect to and integrate live Typeform data in Jitterbit.
-
Use Grok to Talk to Your SparkPost 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 SparkPost data for you.
-
Connect to Google Ad Manager Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google Ad Manager data in Google Apps Script.
-
Moving Data from Salesforce CRM Analytics to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Salesforce CRM Analytics data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Search External PingOne Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of PingOne data to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create PingOne Data objects that you can access from apps and the dashboard.
-
API Server Cloud Tunneling Capabilities
Configure the Cloud Gateway on the API Server to create a reverse SSH tunnel to a publicly accessible SSH host.
-
Automated Continuous Google Ad Manager Replication to Oracle
Use CData Sync for automated, continuous, customizable Google Ad Manager replication to Oracle.
-
Visualize Teradata Data in Tableau
The CData ODBC driver for Teradata enables you integrate Teradata data into Tableau dashboards.
-
Integrating LangGraph with JSON Services via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on JSON services within automated workflows.
-
Use the CData Software JDBC Driver for Dynamics NAV in MicroStrategy Desktop
Connect to Dynamics NAV data in MicroStrategy Desktop using the CData Software JDBC Driver for Dynamics NAV.
-
Integrating OpenCode with Google Drive 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.
-
Build Cohere-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Cohere data.
-
Integrating OpenCode with CircleCI 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.
-
Object-Relational Mapping (ORM) with Apollo Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Apollo data into a Java-based ORM framework, Hibernate.
-
Automate OneNote Data Replication to Azure Synapse
Use CData Sync to customize and automate OneNote data replication to Azure Synapse.
-
Integrate Live Splunk Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf's Cascade agent to securely access and query live Splunk data from within the IDE.
-
Integrate Cline with Live Google Forms Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Google Forms data from within your IDE.
-
Build Semantic Layer Views for SAP Netweaver Gateway Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Netweaver Gateway data.
-
Use the CData Software JDBC Driver for Snowflake in MicroStrategy Web
Connect to Snowflake data in MicroStrategy Web using the CData Software JDBC Driver for Snowflake.
-
Integrate Real-Time Access to Zoho Inventory in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Zoho Inventory data in real time.
-
Connect to Oracle Eloqua Reporting Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Oracle Eloqua Reporting data in the Denodo Virtual DataPort Administrator.
-
Create Datasets from Zuora in Domo Workbench and Build Visualizations of Zuora Data in Domo
Use the CData Software ODBC Driver for Zuora to create datasets from Zuora data in Domo Workbench and then build visualizations in the Domo service.
-
Integrate with FHIR Data in SnapLogic
Use CData Connect AI to connect to and integrate with live FHIR data in SnapLogic.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Highrise
Provide connectivity to Highrise data through an SAP BusinessObjects universe.
-
Connecting GenSpark with Phoenix Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Phoenix data without any replication or custom integration required.
-
DataBind Adobe Target Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Adobe Target with the DevExpress Windows Forms and Web controls to provide Adobe Target data to a chart.
-
Use the CData Software JDBC Driver for Beeminder in MicroStrategy
Connect to Beeminder data in MicroStrategy Developer using the CData Software JDBC Driver for Beeminder.
-
Procore Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Procore data through CData Connect AI using different applications and tools.
-
Use the CData Software JDBC Driver for Retently in MicroStrategy
Connect to Retently data in MicroStrategy Developer using the CData Software JDBC Driver for Retently.
-
Publish Raisers Edge NXT-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Raisers Edge NXT data.
-
Integrating Kiro with Adobe Analytics 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.
-
Publish Reports with SAP Business One Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SAP Business One data.
-
How to Build an ETL App for QuickBooks Online Data in Python with CData
Create ETL applications and real-time data pipelines for QuickBooks Online data in Python with petl.
-
Enable the ZendeskSell JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZendeskSell data.
-
Automated Continuous Avalara AvaTax Replication to SQL Server
Use CData Sync for automated, continuous, customizable Avalara AvaTax replication to SQL Server.
-
Connecting GenSpark with SFTP Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SFTP data without any replication or custom integration required.
-
Back Up SAP Netweaver Gateway data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for SAP Netweaver Gateway. In this article, we will employ an SSIS workflow to populate a database with SAP Netweaver Gateway data data.
-
Integrate Close Data in the Pentaho Report Designer
Publish reports based on Close data in the Pentaho BI tool.
-
Create Dynamic Neo4J Grids Using the Infragistics XamDataGrid
Learn how you can connect Neo4J to Infragistics XamDataGrid to build dynamic grids.
-
Build Dashboards with Printful Data in Dundas BI
Create dynamic dashboards and perform analytics based on Printful data in Dundas BI.
-
Rapidly Develop YouTube Analytics-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 YouTube Analytics.
-
Build Dashboards with Box Data in Dundas BI
Create dynamic dashboards and perform analytics based on Box data in Dundas BI.
-
Use the CData Software JDBC Driver for Humanity in MicroStrategy Web
Connect to Humanity data in MicroStrategy Web using the CData Software JDBC Driver for Humanity.
-
Visualize Live ShipEngine Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live ShipEngine data into custom reports in Power BI.
-
Automated Continuous Gong Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Gong replication to Apache Kafka.
-
Operational Reporting on SharePoint Excel Services Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SharePoint Excel Services data.
-
Connect to Browserless Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Browserless.
-
Replicate Multiple Bitbucket Accounts
Replicate multiple Bitbucket accounts to one or many databases.
-
Use the CData Software JDBC Driver for Azure Data Catalog in MicroStrategy Desktop
Connect to Azure Data Catalog data in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Data Catalog.
-
Build Zoho Inventory-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 Zoho Inventory data without replication.