CData Software - Knowledge Base
Recent Articles
-
Visualize Elasticsearch in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Elasticsearch into TIBCO Spotfire.
-
Getting Started with the CData ODBC Driver for Azure Synapse
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Azure Synapse.
-
Connect to Todoist in Ruby
Connect to Todoist in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Connect and Visualize Live Gmail Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Gmail into the Databricks platform and create visualization dashboards with real-time Gmail.
-
Connect to Marketo in CloverDX (formerly CloverETL)
Transfer Marketo using the visual workflow in the CloverDX data integration tool.
-
Automated Continuous MariaDB Replication to AlloyDB
Use CData Sync for automated, continuous, customizable MariaDB replication to AlloyDB.
-
Import FTP into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access FTP Servers. In this article, you will use the OData format to import FTP Servers into Microsoft Power Query.
-
Automated Continuous QuickBooks Time Replication to IBM DB2
Use CData Sync for automated, continuous, customizable QuickBooks Time replication to IBM DB2.
-
Integrate SAP SuccessFactors into Automated Tasks with Power Automate
Use CData Connect AI to connect to SAP SuccessFactors and integrate live SAP SuccessFactors into your Power Automate tasks.
-
Integrating Dataiku with Zendesk via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Zendesk.
-
Connect to Email in Ruby
Connect to Email in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Data Flows from Calendly to SQL Server using SSIS
Easily back up Calendly to SQL Server using the SSIS components for Calendly.
-
How to create an RPA flow for Act-On in UiPath Studio
Use the Act-On ODBC Driver to create workflows that access real-time Act-On without any coding.
-
Connect to Bing Ads in HULFT Integrate
Connect to Bing Ads as a JDBC data source in HULFT Integrate
-
Query Sage Cloud Accounting using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Sage Cloud Accounting entities in PHP by modeling them as objects.
-
Hive Reporting in OBIEE with the Hive JDBC Driver
Deploy the Hive JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Connect to Live CockroachDB from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your CockroachDB for you.
-
Extend Google Sheets with Google Cloud Storage
Make calls to the API Server from Google Apps Script.
-
Create Reports with SQL Server in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Microsoft SQL Server.
-
Connect Procore to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Procore with IBM WebSphere for seamless data integration and connectivity.
-
Connect to SAP ByDesign in SpagoBI
Create reports featuring live SAP Business ByDesign in SpagoBI Studio. Host SAP ByDesign reports on SpagoBI Server.
-
How to import Amazon DynamoDB into Apache Solr
Use the CData Software JDBC Driver for Amazon DynamoDB in Data Import Handler and create an automated import of Amazon DynamoDB to Apache Solr Enterprise Search platform.
-
Access Amazon Marketplace in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Amazon Marketplace.
-
How to Import Data from Jira into Google Sheets
Import Atlassian Jira into a Google spreadsheet that is automatically refreshed.
-
How to Import Data from Certinia into Google Sheets
Import Certinia into a Google spreadsheet that is automatically refreshed.
-
Analyze Quickbase in Looker
Use CData Connect AI to connect to Quickbase from Looker and build custom apps using live Quickbase.
-
Build AI/ML Models with Live DB2 Data using Dataiku
-