CData Software - Knowledge Base
Recent Articles
-
Connect to EventBrite from Asprova with CData Software ODBC Driver for EventBrite
This article shows how to connect faster to EventBrite data from Asprova.
-
Integrate Snapchat Ads with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Snapchat Ads with External Services.
-
Connect to Redshift in SpagoBI
Create reports featuring live Amazon Redshift in SpagoBI Studio. Host Redshift reports on SpagoBI Server.
-
Connect to Dynamics 365 Business Central from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Dynamics 365 Business Central to connect to Dynamics 365 Business Central and execute queries in PowerBuilder.
-
Automated Continuous ShipStation Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable ShipStation replication to OneLake in Microsoft Fabric.
-
Connect to Zendesk in Aqua Data Studio
Access Zendesk from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect and Query Live Google Calendar Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Google Calendar into Databricks
-
How to Query Live Presto Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Presto data in natural language using Python.
-
How to connect to Cvent from IntelliJ
Integrate connectivity to Cvent with wizards in IntelliJ.
-
How to connect to SharePoint from Spring Boot
Connect to SharePoint in a Spring Boot Application using CData JDBC SharePoint Driver
-
Connect to Kafka from a Connection Pool in JBoss
Integrate Apache Kafka into Java servlets: Use the Management Console in JBoss to install the Kafka JDBC Driver.
-
Visualize Live Greenhouse in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live Greenhouse.
-
Visualize Facebook Ads in TIBCO Spotfire through ADO.NET
Integrate Facebook Ads into dashboards in TIBCO Spotfire.
-
How to connect Amazon QuickSight to Bullhorn CRM
Create a connection to Bullhorn CRM in CData Connect AI and insert Bullhorn CRM into Amazon QuickSight SPICE to build interactive dashboards.
-
Connect and Query Live Vault CRM Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Veeva Vault & Vault CRM into Databricks
-
Edit and Search Stripe External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Stripe to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Stripe objects that you can access from apps and the dashboard.
-
Access Live Google Sheets in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google Sheets from your Google Sheets.
-
Integrate SAP ByDesign with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate SAP ByDesign with External Services.
-
Visualize Impala from Tableau
Use the Tableau Desktop business intelligence tool to connect to Apache Impala.
-
How to integrate Metabase with Microsoft Dataverse
Use CData Connect AI to connect to live Microsoft Dataverse (CDS) and create an interactive dashboard in Metabase from Microsoft Dataverse (CDS).
-
Extract, Transform, and Load Outreach.io in Informatica PowerCenter
Create a simple Workflow for Outreach.io in Informatica PowerCenter.
-
Automate Microsoft Project Replication to Azure Data Lake
Use CData Sync to customize and automate Microsoft Project replication to Azure Data Lake.
-
Parquet Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Parquet facts in real time.
-
Connect to Google Sheets in DBeaver
Use the CData ODBC Driver to connect to Google Sheets in DBeaver.
-
How to import Wave Financial into Apache Solr
Use the CData Software JDBC Driver for Wave Financial in Data Import Handler and create an automated import of Wave Financial to Apache Solr Enterprise Search platform.
-
Automated Continuous Stripe Replication to SQLite
Use CData Sync for automated, continuous, customizable Stripe replication to SQLite.
-
Automated Continuous OData Replication to MongoDB
Use CData Sync for automated, continuous, customizable OData replication to MongoDB.
-
Migrating data from QuickBooks to Google BigQuery using CData SSIS Components.
Easily push QuickBooks Desktop to Google BigQuery using the CData SSIS Tasks for QuickBooks and Google BigQuery.
-
How to connect and process Oracle Eloqua from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Oracle Eloqua.
-
Build Jira-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Atlassian Jira.
-
Create ShipStation-Connected Applications in Appsmith
Connect to ShipStation via CData Connect AI in Appsmith and create custom business applications with real-time access to ShipStation.
-
Excel Spreadsheet Automation on Zoom with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
Access Live Sage 50 UK in AWS Lambda (with IntelliJ IDEA)
Connect to live Sage 50 UK in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Use the CData Software JDBC Driver for SuiteCRM in MicroStrategy Web
Connect to SuiteCRM in MicroStrategy Web using the CData Software JDBC Driver for SuiteCRM.
-
Connect to Snapchat Ads from a Connection Pool in WebLogic
Use the CData JDBC Driver for Snapchat Ads to connect to Snapchat Ads from Web applications running on WebLogic.
-
Query BigCommerce using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume BigCommerce entities in PHP by modeling them as objects.
-
Use the CData Software ODBC Driver for Workday in MicroStrategy
Connect to Workday in MicroStrategy Developer using the CData Software ODBC Driver for Workday.
-
Access Salesforce from MySQL in PHP
Connect to Salesforce through the standard MySQL libraries in PHP.
-
Feed JDBC-ODBC Bridge into FineReport
How to set JDBC-ODBC Bridge as a JDBC data source in FineReport.
-
Replicate Microsoft OneDrive from PowerShell
Write a quick PowerShell script to query Microsoft OneDrive. Use connectivity to the live data to replicate Microsoft OneDrive to SQL Server.
-
Replicate BigCommerce to Multiple Databases
Replicate BigCommerce to disparate databases with a point-and-click configuration.
-
Use the CData Software ODBC Driver for Coinbase in SAS for Real-Time Reporting and Analytics
Connect to real-time Coinbase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Coinbase.
-
Operational Reporting on CSV from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote CSV/TSV Files.
-
How to load Salesforce Data Cloud data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Data Cloud data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Access Live Hive in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Apache Hive from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Automated Continuous Coinbase Replication to SingleStore
Use CData Sync for automated, continuous, customizable Coinbase replication to SingleStore.
-
How to import RSS Feeds into Apache Solr
Use the CData Software JDBC Driver for RSS in Data Import Handler and create an automated import of RSS Feeds to Apache Solr Enterprise Search platform.
-
Integrate Zendesk into Automated Tasks with Power Automate
Use CData Connect AI to connect to Zendesk and integrate live Zendesk into your Power Automate tasks.
-
Integrate with Jira Service Management in SnapLogic
Use CData Connect AI to connect to and integrate with live Atlassian Jira Service Management in SnapLogic.
-
Create Reports from Vault CRM in Looker Studio
Use CData Connect AI to gain access to live Veeva Vault & Vault CRM and create custom reports in Looker Studio.
-
Analyze API in Cognos Analytics
Use CData Connect AI to connect to API from Cognos Analytics and analyze live API.
-
How to create SQL Analysis Services federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SQL Analysis Services in MySQL .
-
Getting Started with the CData Python Connector for Tally
Learn to install and license the CData Python Connector
-
Use the CData Software ODBC Driver for Dynamics 365 in MicroStrategy
Connect to Microsoft Dynamics 365 in MicroStrategy Developer using the CData Software ODBC Driver for Dynamics 365.
-
Create a Data Access Object for HubSpot using JDBI
A brief overview of creating a SQL Object API for HubSpot in JDBI.
-
How to Easily Query Microsoft Dataverse in OpenOffice Base
-