CData Software - Knowledge Base
Recent Articles
-
Query Pipeline CRM Data as a MySQL Database in Node.js
Execute MySQL queries against Pipeline CRM from Node.js.
-
Visualize ConvertKit Data in TIBCO Spotfire through ADO.NET
Integrate ConvertKit into dashboards in TIBCO Spotfire.
-
Query Google Analytics Data as a SQL Server Database in Node.js
Execute SQL Server queries against Google Analytics from Node.js.
-
Access Live Oracle Financials Cloud Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Oracle Financials Cloud in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build a Singer.io Tap for SendGrid With the CData Python Connector
Learn how to easily build a Singer.io Tap for live SendGrid data using
-
Connect to SingleStore Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live SingleStore.
-
Perform Batch Operations with Reckon Accounts Hosted Data in Apache NiFi
Connect to Reckon Accounts Hosted and perform batch operations in Apache NiFi using the CData Software JDBC Driver.
-
Build MVC Applications with Connectivity to Zoho CRM Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Zoho CRM from an ASP.NET MVC application.
-
Visualize SAP Ariba Source Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Ariba Source.
-
Connect to Oracle SCM Data from a Connection Pool in Jetty
The Oracle SCM JDBC Driver supports connection pooling: This article shows how to connect faster to Oracle SCM from Web apps in Jetty.
-
Query Redshift Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Redshift entities in PHP by modeling them as objects.
-
Connect to Box Data from a Connection Pool in Jetty
The Box JDBC Driver supports connection pooling: This article shows how to connect faster to Box from Web apps in Jetty.
-
Operational Reporting on Productboard Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Productboard.
-
Connect to Simplesat Data in JRuby
Create a simple JRuby app with access to live Simplesat.
-
Automated Continuous Flowlu Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Flowlu replication to IBM DB2.
-
Integrate Auth0 Data in Pentaho Data Integration
Build ETL pipelines based on Auth0 in the Pentaho Data Integration tool.
-
Import Exact Online Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Exact Online Data and provide access to live Exact Online for custom reports in the Power BI Service.
-
How to Connect Flowise AI Agents to Live Tally 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 Tally ERP without replication.
-
Integrating LlamaIndex with SAP Fieldglass Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on SAP Fieldglass in real time.
-
How to connect to Telegram Data with Squirrel SQL client
Connect to Telegram and execute queries in the Squirrel SQL Client.
-
DataBind Controls to HubSpot Data in Delphi
DataBind to HubSpot in Delphi with standard data access components and controls.
-
Use the CData Software ODBC Driver for Paylocity in MicroStrategy
Connect to Paylocity in MicroStrategy Developer using the CData Software ODBC Driver for Paylocity.
-
Connect to SAS xpt Data from HeidiSQL
Use CData Connect AI to connect to and query live SAS XPORT from HeidiSQL.
-
Natively Connect to Greenhouse Data in PHP
The CData ODBC driver for Greenhouse enables you to create PHP applications with connectivity to Greenhouse. Leverage the native support for ODBC in PHP.
-
How to connect to MailChimp Data from IntelliJ
Integrate connectivity to MailChimp with wizards in IntelliJ.
-
How to Visualize Customer.io Data in Python with pandas
Use pandas and other modules to analyze and visualize live Customer.io in Python.
-
Replicate Teradata Data from PowerShell
Write a quick PowerShell script to query Teradata. Use connectivity to the live data to replicate Teradata to SQL Server.
-
Automated Continuous Shopify Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Shopify replication to AlloyDB.
-
Automate Tasks in Power Automate Using the CData API Server
Automate Facebook Ads actions in Microsoft Flow — sending emails, posting to social media, or syncing CRM and ERP.
-
Import WordPress Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to WordPress Data and provide access to live WordPress for custom reports in the Power BI Service.
-
Create SAP ByDesign-Connected Nintex Workflows
Use CData Connect AI to connect to SAP ByDesign Data from Nintex Workflow Cloud and build custom workflows using live SAP Business ByDesign.
-
Automate eBay Analytics Integration Tasks from PowerShell
Are you in search of a quick and easy way to access eBay Analytics from PowerShell? This article demonstrates how to utilize the eBay Analytics Cmdlets for tasks like connecting to eBay Analytics, automating operations, downloading data, and more.
-
Create Data Visualizations in Cognos BI with Templated Data
Access Templated as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software JDBC Driver for Scrapfly in MicroStrategy Desktop
Connect to Scrapfly in MicroStrategy Desktop using the CData Software JDBC Driver for Scrapfly.
-
Analyze SAP ByDesign Data in Cognos Analytics
Use CData Connect AI to connect to SAP ByDesign Data from Cognos Analytics and analyze live SAP Business ByDesign.
-
Edit and Search External IBM Cloud Object Storage Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of IBM Cloud Object Storage to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create IBM Cloud Object Storage Data objects that you can access from apps and the dashboard.
-
Query Google Contacts Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Contacts from Node.js.
-
Import Sybase IQ Data Using Azure Data Factory
Use CData Connect AI to connect to Sybase IQ Data from Azure Data Factory and import live Sybase IQ.
-
Connecting Agentforce with BigQuery Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Google BigQuery for you.
-
How to Connect the Power BI Service to Raisers Edge NXT: Complete Guide
Connect to the CData Software Power BI Connector for Raisers Edge NXT from PowerBI.com to provide real-time Raisers Edge NXT across the organization.
-
Visualize Discourse Data in TIBCO Spotfire through OData
Integrate Discourse into dashboards in TIBCO Spotfire.
-
How to Use a Microsoft Access Database to Update Amazon DynamoDB Data in Real Time
Update Amazon DynamoDB data by creating a linked table in Microsoft Access with the CData Amazon DynamoDB ODBC Driver.
-
Connect to Helpscout Data in RazorSQL
Connect to Helpscout from wizards and query Helpscout from the GUI in the RazorSQL database management tool.
-
How to integrate Tanda with Apache Airflow
Access and process Tanda in Apache Airflow using the CData JDBC Driver.
-
DataBind AdRoll Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide AdRoll to a chart.
-
Access MailerSend Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access MailerSend from your Oracle system.
-
Build Apps with Live Azure Table Storage in Adalo using CData Connect AI
Use CData Connect AI to integrate live Azure Table Storage into the Adalo platform and build custom mobile and web applications with real-time Azure Table Storage.
-
Integrate with MarkLogic Data in SnapLogic
Use CData Connect AI to connect to and integrate with live MarkLogic in SnapLogic.
-
Connect to ElevenLabs Data in DBArtisan
Use wizards in DBArtisan to configure ElevenLabs as a data source.
-
Automate ConvertKit Data Replication to Azure Synapse
Use CData Sync to customize and automate ConvertKit replication to Azure Synapse.
-
How to Query Live Amplitude Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Amplitude data in natural language using Python.
-
Access Paylocity Data from MySQL in PHP
Connect to Paylocity through the standard MySQL libraries in PHP.
-
Automated Continuous Clio Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Clio replication to Azure SQL Database.
-
Visualize Live TigerGraph Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live TigerGraph using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create Datasets from Clockify in Domo Workbench and Build Visualizations of Clockify Data in Domo
Use the CData Software ODBC Driver for Clockify to create datasets from Clockify in Domo Workbench and then build visualizations in the Domo service.
-
Connect ZeroBounce to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ZeroBounce using the CData Python MCP Server.
-
Import Redshift Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Redshift Data and provide access to live Amazon Redshift for custom reports in the Power BI Service.
-
Add Omnisend Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Omnisend with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to SAP HANA XS Advanced in SpagoBI
Create reports featuring live SAP HANA XS Advanced in SpagoBI Studio. Host SAP HANA XS Advanced reports on SpagoBI Server.
-
How to Create Power BI Visual Reports with Real-Time SparkPost Data
Use CData Power BI Connectors to visualize SparkPost in Power BI.
-
How to Connect Microsoft Exchange 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 Microsoft Exchange data in real time using natural language.
-
Feed Dynamics CRM Data into FineReport
How to set Microsoft Dynamics CRM as a JDBC data source in FineReport.
-
Publish Deel-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Deel.
-
Integrate Elorus Data in the Pentaho Report Designer
Publish reports based on Elorus in the Pentaho BI tool.
-
Bind Live SAP HANA Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live SAP HANA data
-
How to create Copper federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Copper in MySQL .
-
Visualize iContact Data in Sisense
Create an ElastiCube in Sisense app with access to iContact.
-
Connect to ServiceNow Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ServiceNow and the SQL Gateway to access ServiceNow from Google Apps Script.
-
Moving Data from Moosend to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Moosend data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Replicate Access Data to Multiple Databases
Replicate Microsoft Access to disparate databases with a point-and-click configuration.
-
Automate Codat Data Replication to Azure Data Lake
Use CData Sync to customize and automate Codat replication to Azure Data Lake.
-
Automate Square Data Replication to Azure Synapse
Use CData Sync to customize and automate Square replication to Azure Synapse.
-
Visualize Mouseflow Data in TIBCO Spotfire through OData
Integrate Mouseflow into dashboards in TIBCO Spotfire.
-
Create Apps from Cloudant Data in Qlik Sense Cloud
Use CData Connect AI to connect to Cloudant Data and build apps from live IBM Cloudant in Qlik Sense Cloud.
-
How to Query Live Authorize.Net Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Authorize.Net data in natural language using Python.
-
Connect Mocean to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Mocean with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software ODBC Driver for Google Ad Manager in MicroStrategy Web
Connect to Google Ad Manager in MicroStrategy Web using the CData Software ODBC Driver for Google Ad Manager.
-
Migrating data from OneNote to Snowflake using CData SSIS Components.
Easily push Microsoft OneNote to Snowflake using the CData SSIS Tasks for OneNote and Snowflake.
-
Automated Continuous Vault CRM Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Vault CRM replication to PostgreSQL.
-
Create SSAS Tabular Models from Opsgenie Data
How to build a SQL Server Analysis Service Tabular Model from Opsgenie using CData drivers.
-
Smartsheet Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Smartsheet through CData Connect AI using different applications and tools.
-
Connect and Visualize Live Facebook Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Facebook into the Databricks platform and create visualization dashboards with real-time Facebook.
-
Connect to OData from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from OData, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Connect to Kafka Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Apache Kafka using standard SQL.
-
Access Live Active Directory Data in Coginiti Pro
Connect to and query live Active Directory from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Configure the CData JDBC Driver for Drift in a Connection Pool in Tomcat
Connect to Drift from a connection pool in Tomcat.
-
Analyze BigCommerce Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of BigCommerce and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrating Cursor CLI with Contentful 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 MVC Applications with Connectivity to Outreach.io Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Outreach.io from an ASP.NET MVC application.
-
Connect to ZarMoney Data in NetBeans
Connect to ZarMoney in NetBeans with the data source configuration wizard.
-
How to Access Helpscout Data Using Entity Framework
This article shows how to access Helpscout using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Access Live EmailOctopus Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate EmailOctopus into the statistical analysis tools available in SAS JMP. This article shows how to use EmailOctopus in the Graph Builder and Query Builder.
-
Load HCL Domino Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load HCL Domino to a database.
-
Replicate Multiple Printful Accounts via the CData Sync CLI
Replicate multiple Printful accounts to one or many databases.
-
Create a Data Access Object for eBay Data using JDBI
A brief overview of creating a SQL Object API for eBay in JDBI.
-
Publish Monday.com-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Monday.com.
-
Edit and Search NetSuite External Objects in Salesforce
Consume NetSuite objects in Salesforce filter lists.
-
Establish a Live Connection with Short.io Data using Tableau Bridge
The CData ODBC Driver for Short.io enables you to integrate live Short.io into Tableau Cloud dashboards using the Tableau Bridge.
-
Automated Continuous LinkedIn Ads Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable LinkedIn Ads replication to OneLake in Microsoft Fabric.
-
Use the CData Software JDBC Driver for Twilio in MicroStrategy
Connect to Twilio in MicroStrategy Developer using the CData Software JDBC Driver for Twilio.