CData Software - Knowledge Base
Recent Articles
-
Edit and Search SAP Business Warehouse External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of SAP Business Warehouse to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create SAP Business Warehouse objects that you can access from apps and the dashboard.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live PostgreSQL using the Model Context Protocol.
-
Automated Continuous ConvertKit Replication to MongoDB
Use CData Sync for automated, continuous, customizable ConvertKit replication to MongoDB.
-
Automated Continuous Couchbase Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Couchbase replication to Amazon Redshift.
-
Automated Continuous Exa Replication to Snowflake
Use CData Sync for automated, continuous, customizable Exa replication to Snowflake.
-
Automated Continuous MessageBird Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable MessageBird replication to Azure SQL Database.
-
Integrate Paylocity Data into Power Automate Desktop using CData Connect
CData Connect for Paylocity Data enables you to integrate Paylocity into workflows built using Microsoft Power Automate Desktop.
-
Connect to Hive Data from a Connection Pool in JBoss
Integrate Apache Hive into Java servlets: Use the Management Console in JBoss to install the Hive JDBC Driver.
-
How to load Oracle Sales data into Elasticsearch via Logstash
Introducing a simple method to load Oracle Sales data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Integrate ZeroBounce with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ZeroBounce with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ZeroBounce.
-
Automated Continuous BambooHR Replication to SQL Server
Use CData Sync for automated, continuous, customizable BambooHR replication to SQL Server.
-
Getting Started with the CData JDBC Driver for OData
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for OData.
-
Access Sage Intacct Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Sage Intacct from your Oracle system.
-
DataBind Charts to Google Spanner Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Google Spanner 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.
-
Query Google Cloud Storage Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Cloud Storage from Node.js.
-
Connect to Eventbrite Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Eventbrite as an External Source in Dremio.
-
Process & Analyze FreshBooks Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live FreshBooks Data.
-
Connect to QuickBooks Data in DBeaver
Use the CData ODBC Driver to connect to QuickBooks Desktop in DBeaver.
-
Integrate Real-Time Access to Teradata in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Teradata in real time.
-
Integrate Cursor with Live Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cursor to securely access and act on live Stripe from within the editor.
-
How to connect Amazon QuickSight to Zuora Data
Create a connection to Zuora in CData Connect AI and insert Zuora into Amazon QuickSight SPICE to build interactive dashboards.
-
Automated Continuous Bannerbear Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Bannerbear replication to OneLake in Microsoft Fabric.
-
Integrate Live Dynamics 365 Business Central Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Dynamics 365 Business Central to Blue Prism using the CData ODBC Driver for Dynamics 365 Business Central to create automated workflows for repetitive business tasks.
-
Viewing Reckon Data in RAD Studio Data Explorer
How to view Reckon in RAD Studio Data Explorer using the CData ODBC Driver for Reckon.
-
Create Google Analytics-Connected Nintex Workflows
Use CData Connect AI to connect to Google Analytics Data from Nintex Workflow Cloud and build custom workflows using live Google Analytics.
-
Bidirectional Access to Zoho Inventory Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Zoho Inventory in Filemaker Pro for Mac or Windows.
-
Import Real-Time Zuora Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Zuora in ColdFusion.
-
Access Close Data from MySQL in PHP
Connect to Close through the standard MySQL libraries in PHP.
-
Connect to and Query Google Spanner Data in QlikView over ODBC
Create data visualizations with Google Spanner in QlikView.
-
Use Microsoft Copilot Studio to talk to your Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your Zendesk for you.
-
Connect to Samanage Data in RapidMiner
Integrate Samanage with standard components and data source configuration wizards in RapidMiner Studio.
-
Add Amplitude Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Amplitude with the Informatica Enterprise Data Catalog to classify and organize data.
-
Building Dynamic Web Pages with IBM Cloud Object Storage Data Using AngularJS
Create single-page applications with live connectivity to IBM Cloud Object Storage using the CData API Server.
-
Import Cosmos DB Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Azure Cosmos DB. In this article, you will use the OData format to import Azure Cosmos DB into Microsoft Power Query.
-
Connect to Bitbucket in SpagoBI
Create reports featuring live Bitbucket in SpagoBI Studio. Host Bitbucket reports on SpagoBI Server.
-
Parquet Reporting in OBIEE with the Parquet JDBC Driver
Deploy the Parquet JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Query SingleStore Data as a MySQL Database in Node.js
Execute MySQL queries against SingleStore from Node.js.
-
Migrating data from Dotmailer to Snowflake using CData SSIS Components.
Easily push Dotmailer to Snowflake using the CData SSIS Tasks for Dotmailer and Snowflake.
-
Natively Connect to Autopilot Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Autopilot. Leverage the native support for ODBC in PHP.
-
Use the CData Software JDBC Driver for Blackbaud FE NXT in MicroStrategy Web
Connect to Blackbaud FE NXT in MicroStrategy Web using the CData Software JDBC Driver for Blackbaud FE NXT.
-
Use ChatGPT to Talk to Your Procore 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 Procore for you.
-
Visualize Redis Data in TIBCO Spotfire through OData
Integrate Redis into dashboards in TIBCO Spotfire.
-
Query Redshift Data in ColdFusion
Write standard ColdFusion data access code to connect to Amazon Redshift.
-
Automated Hubstaff Data Replication to Teradata
Use CData Sync to Customize and automate Hubstaff replication to Teradata.
-
How to connect to QuickBooks Online Data in DBVisualizer
Integrate QuickBooks Online with visual data analysis tools and data connection wizards in DBVisualizer
-
Sugar CRM Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sugar CRM facts in real time.
-
Visualize Keap Data in Sisense
Create an ElastiCube in Sisense app with access to Keap.
-
Use JayDeBeApi to access Aweber Data in Python
Use standard Python scripting and the development environment of your choice to access live Aweber.
-
Integrate Open WebUI with Live Zendesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Zendesk from within the chat interface.
-
Publish Azure Analysis Services-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Azure Analysis Services.
-
Access Live Paymo Data in Coginiti Pro
Connect to and query live Paymo from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Use the CData Software ODBC Driver for XML in MicroStrategy
Connect to XML Files in MicroStrategy Developer using the CData Software ODBC Driver for XML.
-
LINQ to ConvertAPI 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 ConvertAPI Data Provider.
-
Connecting GenSpark with SurveyMonkey Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to SurveyMonkey without any replication or custom integration required.
-
Consume Jira Assets OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Jira Assets feeds that reflect any changes in SAP Lumira.
-
How to connect SharePoint with Azure Synapse Data through external lists
Provide Azure Synapse to SharePoint users as an external list.
-
Build an OLAP Cube in SSAS from Quaderno Data
Establish a connection to Quaderno data from SQL Server Analysis Services, and use the Quaderno Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software ODBC Driver for Webex in MicroStrategy
Connect to Webex in MicroStrategy Developer using the CData Software ODBC Driver for Webex.
-
Integrate Live Couchbase Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Couchbase and integrate live Couchbase into apps built in Microsoft Power Apps.
-
Consume GraphQL OData Feeds in SAP Lumira
Use the API Server to create data visualizations on GraphQL feeds that reflect any changes in SAP Lumira.
-
Rapidly Develop CockroachDB-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 CockroachDB.
-
DataBind Controls to Sendwithus Data in C++Builder
DataBind to Sendwithus in C++Builder with standard components and controls.
-
Connect to Dropbox Data in DBeaver
Use the CData ODBC Driver to connect to Dropbox in DBeaver.
-
Natively Connect to FormSite Data in PHP
The CData ODBC driver for FormSite enables you to create PHP applications with connectivity to FormSite. Leverage the native support for ODBC in PHP.
-
Migrating data from Vault CRM to Databricks using CData SSIS Components.
Easily push Veeva Vault & Vault CRM to Databricks using the CData SSIS Tasks for Vault CRM and Databricks.
-
Configure the CData JDBC Driver for IBM Cloud Object Storage in a Connection Pool in Tomcat
Connect to IBM Cloud Object Storage from a connection pool in Tomcat.
-
Build Mistral AI-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Mistral AI and build web apps with connectivity to live Mistral AI.
-
Connect Zoho Recruit to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live Zoho Recruit using the CData Python MCP Server.
-
Integrate Live Microsoft OneDrive Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Connect to Insightly Data in JRuby
Create a simple JRuby app with access to live Insightly.
-
Build Sugar CRM-Connected Apps in Choreo
Use CData Connect AI to connect to Sugar CRM Data from Choreo and build custom apps using live Sugar CRM.
-
How to connect to PingOne Data from Spring Boot
Connect to PingOne in a Spring Boot Application using the CData JDBC Driver for PingOne
-
Access Live Amazon S3 Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live Amazon S3 data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
How to Build an ETL App for Google Campaign Manager 360 Data in Python with CData Connect AI
Build ETL pipelines that read and write live Google Campaign Manager 360 in Python with petl and the CData Connect AI Python SDK.
-
Integrate Microsoft OneDrive Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Microsoft OneDrive and integrate live Microsoft OneDrive into your Power Automate tasks.
-
Add Shopify Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Shopify with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate Zoho Projects Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Zoho Projects from PowerShell? This article demonstrates how to utilize the Zoho Projects Cmdlets for tasks like connecting to Zoho Projects, automating operations, downloading data, and more.
-
Connect to QuickBooks Online Data from Crystal Reports
Use CData Connect AI to connect to and report on live QuickBooks Online from Crystal Reports.
-
How to Connect DBeaver to Box via a JDBC Driver
Manage Box with visual tools in DBeaver like the query browser.
-
Visualize Live BigQuery Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Google BigQuery.
-
Create Informatica Mappings From/To a JDBC Data Source for Basecamp
Create Basecamp data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Build SQL Server-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Microsoft SQL Server.
-
Analyze Live Elasticsearch Data in SAS Viya
Use CData Connect AI to connect to Elasticsearch from SAS Viya and deploy self-service analytics using live Elasticsearch.
-
Build Blackbaud FE NXT Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Blackbaud FE NXT and build visualizations in Tableau Cloud.
-
Use the CData Software ODBC Driver for Front in SAS for Real-Time Reporting and Analytics
Connect to real-time Front in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Front.
-
Access Strava Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Strava from your Oracle system.
-
Connect to Wrike Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Wrike and work with Wrike in your FileMaker applications.
-
Migrating data from Perplexity to Snowflake using CData SSIS Components.
Easily push Perplexity to Snowflake using the CData SSIS Tasks for Perplexity and Snowflake.
-
How to create an RPA flow for Cohere Data in UiPath Studio
Use the Cohere ODBC Driver to create workflows that access real-time Cohere without any coding.
-
Integrating Antigravity CLI with MailerLite via CData CLI
Connect MailerLite to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
How to connect to Sugar CRM Data from IntelliJ
Integrate connectivity to Sugar CRM with wizards in IntelliJ.
-
Use the CData Software ODBC Driver for SAP BusinessObjects BI in MicroStrategy Desktop
Connect to SAP BusinessObjects BI in MicroStrategy Desktop using the CData Software ODBC Driver for SAP BusinessObjects BI.
-
How to Query Live Demio Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Demio data in natural language using Python.
-
Build Visualizations of Yelp Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Yelp in Birst.
-
Integrate Gong Data in Pentaho Data Integration
Build ETL pipelines based on Gong in the Pentaho Data Integration tool.
-
How to create Oracle Eloqua federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Oracle Eloqua in MySQL .
-
Connect to Printful Data in Aqua Data Studio
Access Printful from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
CSV Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on CSV facts in real time.
-
DataBind Controls to Greenplum Data in Delphi
DataBind to Pivotal GreenPlum in Delphi with standard data access components and controls.
-
Connect to OneNote Data from PowerBuilder via ADO.NET
This article demonstrates how to access Microsoft OneNote from Appeon PowerBuilder using the CData ADO.NET Provider for OneNote.