CData Software - Knowledge Base
Recent Articles
-
Connect to Samanage from Asprova with CData Software ODBC Driver for Samanage
This article shows how to connect faster to Samanage data from Asprova.
-
Build a Simple VCL Application for Amazon S3 Data
How to build a simple VCL Application to view Amazon S3 in RAD Studio using the CData ODBC Driver for Amazon S3.
-
Visualize PolarTeamPro Data in Sisense
Create an ElastiCube in Sisense app with access to PolarTeamPro.
-
Connect to Exact Online Data in JRuby
Create a simple JRuby app with access to live Exact Online.
-
Use Agno to Talk to Your Google Cloud Storage 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 Google Cloud Storage for you.
-
How to Work with Workday Data in AWS Glue Jobs Using JDBC
Connect to Workday from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
How to Access Live Parallel Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Parallel enables you to integrate Parallel into workflows built using Microsoft Power Automate Desktop.
-
Automate ConvertKit Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live ConvertKit and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Connect Adobe Experience Manager to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Adobe Experience Manager with IBM WebSphere for seamless data integration and connectivity.
-
Load Tavily Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Tavily to a database.
-
Use the CData Software JDBC Driver for ShipStation in MicroStrategy
Connect to ShipStation in MicroStrategy Developer using the CData Software JDBC Driver for ShipStation.
-
Create Informatica Mappings From/To an ODBC Data Source for Jumpseller
Create an ODBC connection to Jumpseller in Informatica and browse and transfer Jumpseller.
-
How to Connect to Rebilly Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Rebilly. Leverage the pyodbc module for ODBC in Python.
-
Access Jumpseller Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Jumpseller from HeidiSQL.
-
Choosing the Best Method to Connect QuickBooks to SQL Server: 5 Options Explained
Discover multiple ways to connect and use QuickBooks Desktop from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Connect to IBM Informix Data in Jaspersoft Studio
Execute SQL to remote IBM Informix in Jaspersoft Studio.
-
Analyze Salesforce Marketing Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Salesforce Marketing Cloud and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connecting Moonlit Workflow with OneNote Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Microsoft OneNote in real time.
-
Automated Continuous Oracle HCM Cloud Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Oracle HCM Cloud replication to Google Cloud SQL.
-
Automated Continuous TaxJar Replication to IBM DB2
Use CData Sync for automated, continuous, customizable TaxJar replication to IBM DB2.
-
Build Voice Agents in ElevenLabs with access to Live SQL Analysis Services Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live SQL Analysis Services.
-
Build an OLAP Cube in SSAS from Azure Table Data
Establish a connection to Azure Table Storage data from SQL Server Analysis Services, and use the Azure Table Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate Salesforce Data in Pentaho Data Integration
Build ETL pipelines based on Salesforce & Force.com in the Pentaho Data Integration tool.
-
Connect to HCL Domino Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use the CData Software ODBC Driver for MarkLogic in MicroStrategy
Connect to MarkLogic in MicroStrategy Developer using the CData Software ODBC Driver for MarkLogic.
-
Build a Simple VCL Application for ZohoMarketingHub Data
How to build a simple VCL Application to view ZohoMarketingHub in RAD Studio using the CData ODBC Driver for ZohoMarketingHub.
-
Consume Facebook Ads OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Facebook Ads feeds that reflect any changes in SAP Lumira.
-
Import Real-Time Anaplan Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Anaplan in ColdFusion.
-
How to Build an ETL App for Azure Data Catalog Data in Python with CData
Create ETL applications and real-time data pipelines for Azure Data Catalog in Python with petl.
-
Dynamics CRM Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Microsoft Dynamics CRM through CData Connect AI using different applications and tools.
-
Build a PostgreSQL Interface for AfterShip Data using the CData JDBC Driver
Use the Remoting features of the AfterShip JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to ZohoDesk in SpagoBI
Create reports featuring live ZohoDesk in SpagoBI Studio. Host ZohoDesk reports on SpagoBI Server.
-
Automate Moosend Data Replication to Couchbase
Use CData Sync to Customize and automate Moosend replication to Couchbase.
-
Choosing the Best Method to Connect SendPulse to SQL Server: 5 Options Explained
Discover multiple ways to connect and use SendPulse from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Query Pinecone Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Pinecone entities in PHP by modeling them as objects.
-
Build Dashboards with Chargebee Data in DBxtra
Create dynamic dashboards and perform analytics based on Chargebee in DBxtra.
-
Access Live Email Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Email from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Import and Visualize Presto Data in Power View
Create data visualizations based on Presto in Excel.
-
Access Live Splunk Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Splunk data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Connect to Sentry Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Sentry and work with Sentry in your FileMaker applications.
-
Connect to Gmail Data in DBeaver
Use the CData ODBC Driver to connect to Gmail in DBeaver.
-
Access Live Dynamics 365 Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Microsoft Dynamics 365 into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Dynamics 365 in the Graph Builder and Query Builder.
-
Using the CData Software ODBC Driver for Attio in PyCharm
Connect to Attio as an ODBC data source in PyCharm using the CData Software ODBC Driver for Attio.
-
Visualize Vimeo Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Vimeo.
-
How to Access Live Azure Data Lake Storage Data in Visual Studio Code via Cline
Run CData MCP Server for Azure Data Lake Storage on Windows Subsytem for Linux (WSL) and connect to live Azure Data Lake Storage from the Cline extension in Visual Studio Code.
-
Bridge Act-On Connectivity with Apache NiFi
Access and process Act-On in Apache NiFi using the CData JDBC Driver.
-
Work with Live Azure Data Lake Storage Data in Power Query
Use CData Connect AI to connect to Azure Data Lake Storage and work with live Azure Data Lake Storage in Microsoft Power Query.
-
How to connect to ZohoPeople Data from Spring Boot
Connect to ZohoPeople in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Short.io Data from a Connection Pool in Jetty
The Short.io JDBC Driver supports connection pooling: This article shows how to connect faster to Short.io from Web apps in Jetty.
-
Explore Geographical Relationships in Browserless Data with Power Map
Create data visualizations with Browserless in Power Map.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live BambooHR using the Model Context Protocol.
-
Create Redis-Connected Dashboards in Grafana
Connect to Redis Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Redis.
-
How to Connect Flowise AI Agents to Live Microsoft Teams 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 Microsoft Teams without replication.
-
How to work with Adobe Experience Manager Data in Apache Spark using SQL
Access and process Adobe Experience Manager Data in Apache Spark using the CData Software JDBC Driver.
-
Bridge Jumpseller Connectivity with Apache NiFi
Access and process Jumpseller in Apache NiFi using the CData JDBC Driver.
-
Access Live LinkedIn Data in AWS Lambda
Connect to live LinkedIn in AWS Lambda using the CData JDBC Driver.
-
Connecting Mastra with CouchDB 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 Apache CouchDB, no replication required.
-
Connect to Wave Financial Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Wave Financial in the Denodo Virtual DataPort Administrator.
-
Automate Productboard Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Productboard from PowerShell? This article demonstrates how to utilize the Productboard Cmdlets for tasks like connecting to Productboard, automating operations, downloading data, and more.
-
Connect to BigQuery Data in Claris FileMaker Pro
Use the CData ODBC Driver for Google BigQuery in FileMaker Pro to connect to BigQuery and work with Google BigQuery in your FileMaker applications.
-
LINQ to NASA 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 NASA Data Provider.
-
Automated Continuous Monday.com Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Monday.com replication to Google Cloud SQL.
-
Build Voice Agents in ElevenLabs with access to Live Slack Data
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live Slack.
-
Connect to Egnyte from a Connection Pool in WebLogic
Use the CData JDBC Driver for Egnyte to connect to Egnyte from Web applications running on WebLogic.
-
Integrating Kiro CLI with SendPulse 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 connect to Google Campaign Manager 360 Data in DBVisualizer
Integrate Google Campaign Manager 360 with visual data analysis tools and data connection wizards in DBVisualizer
-
Publish Crystal Reports on Retently Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Retently.
-
Analyze AlloyDB Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for AlloyDB from Power Pivot. You will use the Table Import Wizard to load Google AlloyDB. You can visually build the import query or use any SQL supported by the driver.
-
Visualize Wistia Data in TIBCO Spotfire through ADO.NET
Integrate Wistia into dashboards in TIBCO Spotfire.
-
Query Adobe Analytics Data as a MySQL Database in Node.js
Execute MySQL queries against Adobe Analytics from Node.js.
-
Build Dashboards with SAP BusinessObjects BI Data in Dundas BI
Create dynamic dashboards and perform analytics based on SAP BusinessObjects BI in Dundas BI.
-
Create Informatica Mappings From/To an ODBC Data Source for Bannerbear
Create an ODBC connection to Bannerbear in Informatica and browse and transfer Bannerbear.
-
Getting Started with the CData JDBC Driver for Phoenix
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Phoenix.
-
How to Access Google Spanner Data Using Entity Framework
This article shows how to access Google Spanner using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Replicate PabblySubscriptions Data from PowerShell
Write a quick PowerShell script to query PabblySubscriptions. Use connectivity to the live data to replicate PabblySubscriptions to SQL Server.
-
Automated Continuous Neo4J Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Neo4J replication to Amazon S3.
-
ETL Drip in Oracle Data Integrator
This article shows how to transfer Drip into a data warehouse using Oracle Data Integrator.
-
Create Data Visualizations Based On PostgreSQL Data in Mode
Use CData Connect AI to connect to PostgreSQL Data from Mode and build visualizations using live
-
Automated Vault CRM Data Replication to Teradata
Use CData Sync to Customize and automate Veeva Vault & Vault CRM replication to Teradata.
-
How to Easily Query Auth0 Data in OpenOffice Base
Connect to Auth0 data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Create Data Visualizations in Cognos BI with Printful Data
Access Printful as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
How to Connect DBeaver to Amazon DynamoDB via a JDBC Driver
Manage Amazon DynamoDB with visual tools in DBeaver like the query browser.
-
Automated Continuous Microsoft Planner Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Microsoft Planner replication to OneLake in Microsoft Fabric.
-
Getting Started with the CData ADO.NET Provider for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData API Driver for ADO.NET.
-
How to Seamlessly Import Acumatica Data into IBM SPSS Modeler
Integrate Acumatica data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Automated Continuous FormSite Replication to AlloyDB
Use CData Sync for automated, continuous, customizable FormSite replication to AlloyDB.
-
Connect to and Visualize Live Mixpanel Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Mixpanel.
-
Connect to Elasticsearch Data in RazorSQL
Connect to Elasticsearch from wizards and query Elasticsearch from the GUI in the RazorSQL database management tool.
-
Integrate Sage 200 with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Sage 200 with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Sage 200.
-
Query JDBC-ODBC Bridge Data in DataGrip
Create a Data Source for JDBC-ODBC Bridge in DataGrip and use SQL to query live JDBC-ODBC Bridge.
-
Connecting Pipedream with LinkedIn Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on LinkedIn Ads data in real time.
-
How to Visualize Monday.com Data in Python with pandas
Use pandas and other modules to analyze and visualize live Monday.com in Python.
-
Use Manus AI to Talk to Your SAP Business One 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 SAP Business One.
-
Connect to Pinterest Data in Aqua Data Studio
Access Pinterest from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Use the CData Software ODBC Driver for Act CRM in MicroStrategy Web
Connect to Act CRM in MicroStrategy Web using the CData Software ODBC Driver for Act CRM.
-
Trigger Act-On IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Act-On with standard wizards in Logic Apps.
-
Import Hugging Face Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Hugging Face. In this article, you will use the OData format to import Hugging Face into Microsoft Power Query.
-
Replicate Multiple Azure DevOps Accounts via the CData Sync CLI
Replicate multiple Azure DevOps accounts to one or many databases.
-
LINQ to DocuSign 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 DocuSign Data Provider.
-
Connect to Ontraport Data in RazorSQL
Connect to Ontraport from wizards and query Ontraport from the GUI in the RazorSQL database management tool.