CData Software - Knowledge Base
Recent Articles
-
Connect to SQL Analysis Services in Ruby
Connect to SQL Analysis Services in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Build Dashboards with Reckon in Dundas BI
Create dynamic dashboards and perform analytics based on Reckon in Dundas BI.
-
Process & Analyze SAP Fieldglass in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Fieldglass .
-
How to work with Klipfolio in Apache Spark using SQL
Access and process Klipfolio in Apache Spark using the CData Software JDBC Driver.
-
Natively Connect to Sybase IQ in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Sybase IQ. Leverage the native support for ODBC in PHP.
-
Access Live Airtable in Roo Code via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Roo Code agents to securely access and build applications with live Airtable through MCP integration.
-
Connect to Azure Data Catalog in RapidMiner
Integrate Azure Data Catalog with standard components and data source configuration wizards in RapidMiner Studio.
-
Build AI Agents with Greenplum Data in IBM watsonx Orchestrate using CData Connect AI
Learn how to build intelligent agents in IBM watsonx Orchestrate that can
-
Extract, Transform, and Load Act CRM in Informatica PowerCenter
Create a simple Workflow for Act CRM in Informatica PowerCenter.
-
Build Data Flows from SQL Server to Email through SSIS
Easily push SQL Server data to Email using the CData SSIS Tasks for Email.
-
How to Connect to Live Lakebase 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 Lakebase for you.
-
Bind Live Office 365 Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Office 365 data
-
Access Live Azure Analysis Services in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Analysis Services in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Building Dynamic Web Pages with LinkedIn Ads Using AngularJS
Create single-page applications with live connectivity to LinkedIn Ads using the CData API Server.
-
Build a PostgreSQL Interface for Kintone using the CData JDBC Driver
Use the Remoting features of the Kintone JDBC Driver to create a PostgreSQL entry-point for data access.
-
Integrating Gumloop with SAP Hybris C4C via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on SAP Hybris C4C within automated workflows.
-
How to Connect to & Open Shopify in Microsoft Excel
This article uses the CData ODBC driver for Shopify to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Getting Started with the CData SSIS Components for ConstantContact
Complete guide to installing, licensing, and connecting with the CData SSIS Components for ConstantContact.
-
Integrate Tableau CRM Analytics in the Pentaho Report Designer
Publish reports based on Tableau CRM Analytics in the Pentaho BI tool.
-
Automated Continuous Couchbase Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Couchbase replication to PostgreSQL.
-
Create a Data Access Object for HubSpot using JDBI
A brief overview of creating a SQL Object API for HubSpot in JDBI.
-
Import Kintone into the Power BI Service for Visualizations
Use CData Connect AI to connect to Kintone and provide access to live Kintone for custom reports in the Power BI Service.
-
Analyze SurveyMonkey in R via JDBC
Use standard R functions and the development environment of your choice to analyze SurveyMonkey with the CData JDBC Driver for SurveyMonkey.
-
View Reports on Real-Time Outreach.io in Power BI Report Server
Use the CData ODBC Driver for Outreach.io to visualize Outreach.io in Power BI Desktop and then publish them to Power BI Report Server.
-
DB2 Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on DB2 facts in real time.
-
Replicate Amazon Marketplace to Multiple Databases via the CData Sync CLI
Replicate Amazon Marketplace to disparate databases with a single configuration.
-
Import Eventbrite into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Eventbrite. In this article, you will use the OData format to import Eventbrite into Microsoft Power Query.
-
How to Visualize Google Cloud Storage Data in Python with pandas
Use pandas and other modules to analyze and visualize live Google Cloud Storage in Python.
-
Load Presto to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Presto to a database.
-
Connect SAP HANA XS Advanced to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your SAP HANA XS Advanced using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Integrate Theia IDE with Live Amazon Athena Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Connect to Google Directory in Aqua Data Studio
Access Google Directory from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Getting Started with the CData Excel Add-In for Reckon
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Reckon.
-
Connect to Presto in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Use ChatGPT to Talk to Your Bullhorn CRM via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Bullhorn CRM for you.
-
How to connect to Salesforce Marketing from Spring Boot
Connect to Salesforce Marketing in a Spring Boot Application using CData JDBC Salesforce Marketing Driver
-
Use Biml to Build SSIS Tasks to Replicate Adobe Commerce to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Adobe Commerce to SQL Server.
-
Connect to Real-Time SAP Data in Power Apps Using Dataflows to Build Custom Applications
-