CData Software - Knowledge Base
Recent Articles
-
Build Authorize.Net Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Authorize.Net and build visualizations in Tableau Cloud.
-
Automated Continuous ZohoDesk Replication to Vertica
Use CData Sync for automated, continuous, customizable ZohoDesk replication to Vertica.
-
Automated Continuous TaxJar Replication to SQL Server
Use CData Sync for automated, continuous, customizable TaxJar replication to SQL Server.
-
Visualize SAP Netweaver Gateway Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to SAP Netweaver Gateway.
-
Trigger Snowflake IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Snowflake with standard wizards in Logic Apps.
-
Build a PostgreSQL Interface for SAS Data Sets Data using the CData JDBC Driver
Use the Remoting features of the SAS Data Sets JDBC Driver to create a PostgreSQL entry-point for data access.
-
Edit and Search Spark External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Apache Spark SQL to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Spark objects that you can access from apps and the dashboard.
-
SAP Netweaver Gateway Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAP Netweaver Gateway facts in real time.
-
Use JayDeBeApi to access Printify Data in Python
Use standard Python scripting and the development environment of your choice to access live Printify.
-
Easily Integrate Intercom Data in Lazarus Pascal IDE
Learn how to easily integrate live Intercom in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
How to Connect to & Open Optimizely Data in Microsoft Excel
This article uses the CData ODBC driver for Optimizely to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Load Freshdesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Freshdesk to a database.
-
Choosing the Best Method to Connect MariaDB to SQL Server: 5 Options Explained
Discover multiple ways to connect and use MariaDB from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
How to Build an ETL App for Exa Data in Python with CData
Create ETL applications and real-time data pipelines for Exa in Python with petl.
-
Build Dashboards with Microsoft OneDrive Data in DBxtra
Create dynamic dashboards and perform analytics based on Microsoft OneDrive in DBxtra.
-
Process & Analyze Coda Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Coda Data.
-
Connect to EnterpriseDB Data from a Connection Pool in JBoss
Integrate EnterpriseDB into Java servlets: Use the Management Console in JBoss to install the EnterpriseDB JDBC Driver.
-
How to Seamlessly Import Shippo Data into IBM SPSS Modeler
Integrate Shippo data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Analyze Oracle Sales Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Oracle Sales in Microsoft R Open.
-
Build Toggl-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Toggl.
-
Connect to Adobe Commerce Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Adobe Commerce in the Denodo Virtual DataPort Administrator.
-
Integrating Dataiku with Google Spanner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Google Spanner.
-
Build Data Flows from SQL Server to CockroachDB through SSIS
Easily push SQL Server data to CockroachDB using the CData SSIS Tasks for CockroachDB.
-
ETL Instantly in Oracle Data Integrator
This article shows how to transfer Instantly into a data warehouse using Oracle Data Integrator.
-
Prepare, Blend, and Analyze Excel Online Data in Alteryx Designer (ODBC)
Build workflows to access live Microsoft Excel Online for self-service data analytics.
-
Use the CData ODBC Driver for Zendesk in Microsoft Power Query
You can use the CData Zendesk ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Zendesk into Microsoft Power Query.
-
Access Phoenix Data from MySQL in Amazon QuickSight
Connect to Phoenix and build visualizations of Apache Phoenix using a MySQL Connection in Amazon QuickSight.
-
Moving Data from Yelp to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Yelp data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Integrate LibreChat with Live MariaDB Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live MariaDB from within the chat interface.
-
How to connect to Mixpanel Data from Spring Boot
Connect to Mixpanel in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Real-Time Sage Cloud Accounting Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Sage Cloud Accounting and Dataflow to import and use Sage Business Cloud Accounting in Power Apps.
-
Connecting Agentforce with WooCommerce 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 WooCommerce for you.
-
Create SSAS Tabular Models from Microsoft Teams Data
How to build a SQL Server Analysis Service Tabular Model from Microsoft Teams using CData drivers.
-
Connect to Zendesk Data in ACL Analytics
Connect to Zendesk via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Zendesk.
-
Query Copper Data in DataGrip
Create a Data Source for Copper in DataGrip and use SQL to query live Copper.
-
Getting Started with the CData Power BI Connector for Certinia
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Certinia.
-
Automated Humanity Data Replication to Teradata
Use CData Sync to Customize and automate Humanity replication to Teradata.
-
Integrating Kiro CLI with Power BI XMLA 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.
-
Getting Started with the CData ODBC Driver for QuickBooks Online
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for QuickBooks Online.
-
Extend Google Sheets with CouchDB Data
Make calls to CouchDB from Google Apps Script via the API Server.
-
Manage Deel Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Deel.
-
Build a PostgreSQL Interface for Reply.io Data using the CData JDBC Driver
Use the Remoting features of the Reply.io JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Google Contacts Data from PowerBuilder via JDBC
This article demonstrates how to access Google Contacts from PowerBuilder using the Google Contacts JDBC Driver.
-
Build a Simple VCL Application for Dynamics 365 Business Central Data
How to build a simple VCL Application to view Dynamics 365 Business Central in RAD Studio using the CData ODBC Driver for Dynamics 365 Business Central.
-
Integrate Theia IDE with Live Workday Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
How to Connect to Live Dynamics 365 Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Microsoft Dynamics 365 securely in real time.
-
Connect to JotForm Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for JotForm and the SQL Gateway to access JotForm from Google Apps Script.
-
How to Query Live MongoDB Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live MongoDB data in natural language using Python.
-
Build Automated Workflows with Live Couchbase Data in Workato
Use CData Connect AI to connect to live Couchbase and build automated workflows in Workato.
-
Automate Sage Cloud Accounting Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Sage Business Cloud Accounting and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Explore Geographical Relationships in Ontraport Data with Power Map
Create data visualizations with Ontraport in Power Map.
-
Create SAP ByDesign-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to SAP ByDesign Data from OutSystems and build custom enterprise apps using live SAP Business ByDesign.
-
Automated Continuous SparkPost Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable SparkPost replication to Apache Cassandra.
-
Connect to Jodoo Data from a Connection Pool in Jetty
The Jodoo JDBC Driver supports connection pooling: This article shows how to connect faster to Jodoo from Web apps in Jetty.
-
Operational Reporting on Trello Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Trello.
-
Access Live Azure Data Lake Storage Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Azure Data Lake Storage from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
OneNote Reporting in OBIEE with the OneNote JDBC Driver
Deploy the OneNote JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to Oracle Sales in SpagoBI
Create reports featuring live Oracle Sales in SpagoBI Studio. Host Oracle Sales reports on SpagoBI Server.
-
How to Query ConvertAPI Data in MySQL Workbench
Execute MySQL queries against live ConvertAPI from MySQL Workbench.
-
LaunchDarkly Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LaunchDarkly facts in real time.
-
How to publish and share MYOB AccountRight Data dashboards with Tableau Server
The CData ODBC driver for MYOB AccountRight enables you integrate MYOB AccountRight into Tableau dashboards.
-
Connect to Marketo Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Build Semantic Layer Views for RabbitMQ Data in APOS Live Data Gateway
Use the CData Connector for RabbitMQ in APOS Live Data Gateway to build Semantic Layer Views for RabbitMQ.
-
How to Design Zoho Creator Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Zoho Creator from mobile and tablet Power Apps.
-
Use JayDeBeApi to access ChartMogul Data in Python
Use standard Python scripting and the development environment of your choice to access live ChartMogul.
-
Query Basecamp Data in ColdFusion
Write standard ColdFusion data access code to connect to Basecamp.
-
Integrate with Twitter Ads Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Twitter Ads in SnapLogic.
-
Visualize Live Square Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Square into custom reports in Power BI.
-
Use Databricks Agent Bricks to Talk to Your CSV Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your CSV/TSV Files for you.
-
Automated Continuous FHIR Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable FHIR replication to PostgreSQL.
-
Use the CData Software ODBC Driver for Humanity in MicroStrategy Web
Connect to Humanity in MicroStrategy Web using the CData Software ODBC Driver for Humanity.
-
How to connect and process Apache CouchDB from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Apache CouchDB.
-
Explore Geographical Relationships in ZohoExpense Data with Power Map
Create data visualizations with ZohoExpense in Power Map.
-
How to Query Live Salesforce CRM Analytics Data in Perplexity MacOS Desktop
Connect to and query live Salesforce CRM Analytics Data in Perplexity Desktop using CData MCP Server.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Billsby
Provide connectivity to Billsby through an SAP BusinessObjects universe.
-
Build Sybase-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Sybase Data and create custom apps in Bubble.
-
Create Autopilot Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Autopilot data access from reports, embedded analytics, and more.
-
Access Live ShipStation Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live ShipStation from your Google Sheets.
-
Create Accelo Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Accelo from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to JotForm Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for JotForm in the Denodo Virtual DataPort Administrator.
-
Import and Visualize Zoho Projects Data in Power View
Create data visualizations based on Zoho Projects in Excel.
-
Manage ZohoMarketingHub Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for ZohoMarketingHub.
-
Build MVC Applications with Connectivity to ScrapingBee Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access ScrapingBee from an ASP.NET MVC application.
-
Replicate Keap Data to Multiple Databases via the CData Sync CLI
Replicate Keap to disparate databases with a single configuration.
-
Easily Integrate LightSpeedRetail Data in Lazarus Pascal IDE
Learn how to easily integrate live LightSpeedRetail in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Automate Impala Data Replication to SAP HANA
Use CData Sync to customize and automate Apache Impala replication to SAP HANA.
-
DataBind Charts to Outlook Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Outlook 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.
-
A PostgreSQL Interface for Mistral AI Data (MySQL Remoting via JDBC)
Use the Remoting features of the Mistral AI JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Dynamics 365 Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Dynamics 365 entities in PHP by modeling them as objects.
-
Write a Simple Go Application to work with CapsuleCRM Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to CapsuleCRM.
-
Microsoft Teams Reporting in OBIEE with the Microsoft Teams JDBC Driver
Deploy the Microsoft Teams JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Work with Bullhorn CRM Data in AWS Glue Jobs Using JDBC
Connect to Bullhorn CRM from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create Power BI Reports on Real-Time LDAP Objects
Use the CData ODBC Driver for LDAP to visualize LDAP in Power BI Desktop.
-
Build Automated SAP ByDesign-Connected Workflows in Zapier
Use CData Connect AI to connect to live SAP Business ByDesign and build automated workflows in Zapier.
-
Build Semantic Layer Views for SAP Ariba Procurement Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Procurement.
-
Integrate Live Stripe Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Stripe from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Stripe.
-
Integrate Mode with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Mode with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Mode.
-
Moving Data from Zoho Books to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Zoho Books data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Viewing Mocean Data in RAD Studio Data Explorer
How to view Mocean in RAD Studio Data Explorer using the CData ODBC Driver for Mocean.
-
Connect to Amazon Athena Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Amazon Athena using standard SQL.