CData Software - Knowledge Base
Recent Articles
-
Validate Paylocity Data with QuerySurge
Access and validate Paylocity in QuerySurge using the CData JDBC Driver.
-
How to integrate AgileCRM with Apache Airflow
Access and process AgileCRM in Apache Airflow using the CData JDBC Driver.
-
Integrating GitHub Copilot CLI with PolarTeamPro 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.
-
Connect to Oracle HCM Cloud Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Oracle HCM Cloud as an External Source in Dremio.
-
Build Highrise-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Highrise CRM and build web apps with connectivity to live Highrise CRM.
-
Query Auth0 Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Auth0 from Node.js.
-
Publish Perigon-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Perigon.
-
How to load Trello data into Elasticsearch via Logstash
Introducing a simple method to load Trello data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Connect to BigQuery Data in Google Apps Script via Connect AI
Use CData Connect AI to access Google BigQuery in Google Apps Script.
-
How to Work with Foursquare Data in AWS Glue Jobs Using JDBC
Connect to Foursquare from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Getting Started with the CData Excel Add-In for Slack
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for Slack.
-
ETL ShipStation in Oracle Data Integrator
This article shows how to transfer ShipStation into a data warehouse using Oracle Data Integrator.
-
Provide OData Services of Access Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Access by developing a WCF Service Application.
-
Analyze SAP ByDesign Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of SAP Business ByDesign and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate Theia IDE with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Accelo
Provide connectivity to Accelo through an SAP BusinessObjects universe.
-
Connect to GetResponse Data from PowerBuilder via ADO.NET
This article demonstrates how to access GetResponse from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build Marketo Visualizations in Tableau Cloud
Use CData Connect AI to connect to live Marketo and build visualizations in Tableau Cloud.
-
How to connect PolyBase to Cassandra
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Apache Cassandra.
-
Build Semantic Layer Views for CockroachDB Data in APOS Live Data Gateway
Use the CData Connector for CockroachDB in APOS Live Data Gateway to build Semantic Layer Views for CockroachDB.
-
Placid Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Placid facts in real time.
-
How to create Testmonitor federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Testmonitor in MySQL .
-
Connect to Kafka in SpagoBI
Create reports featuring live Apache Kafka in SpagoBI Studio. Host Kafka reports on SpagoBI Server.
-
How to Import Data from PingOne into Google Sheets
Import PingOne into a Google spreadsheet that is automatically refreshed.
-
Integrate Real-Time Access to Access in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Microsoft Access in real time.
-
Access Live SAP SuccessFactors Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to SAP SuccessFactors from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Build Semantic Layer Views for ADP Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ADP.
-
Natively Connect to MailerLite Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to MailerLite. Leverage the native support for ODBC in PHP.
-
Publish Reports with Campaigner Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Campaigner.
-
Create Apps from HubSpot Data in Qlik Sense Cloud
Use CData Connect AI to connect to HubSpot Data and build apps from live HubSpot in Qlik Sense Cloud.
-
Integrate with Odoo Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Odoo ERP to a JSON file on disk.
-
Connect to LinkedIn Data in RapidMiner
Integrate LinkedIn with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Apps from Hive Data in Qlik Sense Cloud
Use CData Connect AI to connect to Hive Data and build apps from live Apache Hive in Qlik Sense Cloud.
-
Integrating Codex CLI with Unbounce 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.
-
Process & Analyze Shopify Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Shopify Data.
-
Connect to Rebilly Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Deploy the ADO.NET Provider for Egnyte on an SSRS Report Server
Connect to Egnyte from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Integrating Dataiku with SurveyMonkey Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SurveyMonkey.
-
dbt Core Transformations with CData Sync
CData Sync supports integration with dbt Core, allowing users to develop, control, and run transformations in a supported destination database.
-
Create Dashboards and Visualize Live SharePoint Data in Geckoboard
Use CData Connect AI to connect to live Microsoft SharePoint and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Automated Continuous OneNote Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable OneNote replication to Apache Kafka.
-
Process & Analyze Reply.io Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Reply.io Data.
-
Connect to Rootly Data in Jaspersoft Studio
Execute SQL to remote Rootly in Jaspersoft Studio.
-
Create Reports from Azure Table Data in Looker Studio
Use CData Connect AI to gain access to live Azure Table Storage and create custom reports in Looker Studio.
-
Automated Continuous Google Campaign Manager 360 Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Campaign Manager 360 replication to Azure SQL Database.
-
Integrate Quickbase with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Quickbase with External Services.
-
How to publish and share ZohoInvoice Data dashboards with Tableau Server
The CData ODBC driver for ZohoInvoice enables you integrate ZohoInvoice into Tableau dashboards.
-
How to create SAP Business Warehouse federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for SAP Business Warehouse in MySQL .
-
Create Dashboards and Visualize Live Google Drive Data in Geckoboard
Use CData Connect AI to connect to live Google Drive and create dashboards for real-time monitoring and visualization in Geckoboard.
-
Use Dash to Build to Web Apps on AdRoll Data
Create Python applications that use pandas and Dash to build AdRoll-connected web apps.
-
How to Access Live CouchDB Data in Visual Studio Code via Cline
Run CData MCP Server for CouchDB on Windows Subsytem for Linux (WSL) and connect to live Apache CouchDB from the Cline extension in Visual Studio Code.
-
Automated Bugsnag Data Replication to Teradata
Use CData Sync to Customize and automate Bugsnag replication to Teradata.
-
Integrate with Amplitude Data in JReport Designer
Create charts and reports based on Amplitude in JReport Designer.
-
Natively Connect to PostgreSQL Data in PHP
The CData ODBC driver for PostgreSQL enables you to create PHP applications with connectivity to PostgreSQL. Leverage the native support for ODBC in PHP.
-
Automate Amazon DynamoDB Data Replication to Azure Data Lake
Use CData Sync to customize and automate Amazon DynamoDB replication to Azure Data Lake.
-
Build MVC Applications with Connectivity to Flowlu Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Flowlu from an ASP.NET MVC application.
-
Connect to Optimizely Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Optimizely using standard SQL.
-
Build a PostgreSQL Interface for Airtable Data using the CData JDBC Driver
Use the Remoting features of the Airtable JDBC Driver to create a PostgreSQL entry-point for data access.
-
Create Apps from Gmail Data in Qlik Sense Cloud
Use CData Connect AI to connect to Gmail Data and build apps from live Gmail in Qlik Sense Cloud.
-
Add Sage 200 Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Sage 200 with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live Supabase Data in AWS Lambda
Connect to live Supabase in AWS Lambda using the CData JDBC Driver.
-
Visualize Auth0 Data in Sisense
Create an ElastiCube in Sisense app with access to Auth0.
-
Integrate Epicor Kinetic with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Epicor Kinetic with External Services.
-
Work with Mode Data in FoxPro
Load Mode into a FoxPro database. This article includes full code and a walk-through of the process.
-
Connect Salesloft Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Salesloft using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Migrating data from Azure Data Catalog to Databricks using CData SSIS Components.
Easily push Azure Data Catalog to Databricks using the CData SSIS Tasks for Azure Data Catalog and Databricks.
-
Import Real-Time Cvent Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Cvent in ColdFusion.
-
Deploy the ADO.NET Provider for Sybase IQ on an SSRS Report Server
Connect to Sybase IQ from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.
-
Use the CData API Server to Access GraphQL Data in Microsoft PowerPivot
Use the CData API Server to connect to live GraphQL in the Power Pivot business intelligence tool.
-
Integrate Cline with Live Azure Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Azure Analysis Services from within your IDE.
-
Create Informatica Mappings From/To a JDBC Data Source for EnterpriseDB
Create EnterpriseDB data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to ZohoInvoice Data from PowerBuilder via JDBC
This article demonstrates how to access ZohoInvoice from PowerBuilder using the ZohoInvoice JDBC Driver.
-
Connect to Real-Time FreshBooks Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use FreshBooks in Power Apps.
-
Access Tally Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Tally ERP from HeidiSQL.
-
Automated Continuous SAP Netweaver Gateway Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable SAP Netweaver Gateway replication to Azure SQL Database.
-
Use the CData Software ODBC Driver for Drip in MicroStrategy Web
Connect to Drip in MicroStrategy Web using the CData Software ODBC Driver for Drip.
-
Bidirectional Access to ServiceDesk Plus Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate ServiceDesk Plus in Filemaker Pro for Mac or Windows.
-
Publish Beeminder-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Beeminder.
-
Getting Started with the CData JDBC Driver for Everhour
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Everhour.
-
Create Data Visualizations Based On Blackbaud FE NXT Data in Mode
Use CData Connect AI to connect to Blackbaud FE NXT Data from Mode and build visualizations using live
-
How to integrate SharePoint Excel Services with Apache Airflow
Access and process SharePoint Excel Services in Apache Airflow using the CData JDBC Driver.
-
Connect to Redis in SpagoBI
Create reports featuring live Redis in SpagoBI Studio. Host Redis reports on SpagoBI Server.
-
Connect to Nethunt Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Nethunt in the Denodo Virtual DataPort Administrator.
-
Use Claude to Talk to Your Stripe Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Stripe for you.
-
Build Dashboards with Highrise Data in Dundas BI
Create dynamic dashboards and perform analytics based on Highrise CRM in Dundas BI.
-
Import Real-Time ZohoPeople Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZohoPeople in ColdFusion.
-
Create Reports with Outlook Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Outlook.
-
Build Data Flows from QuickBooks to SQL Server using SSIS
Easily back up QuickBooks Desktop to SQL Server using the SSIS components for QuickBooks.
-
How to connect to Wistia Data from Spring Boot
Connect to Wistia in a Spring Boot Application using the CData API Driver for JDBC
-
How to Connect to Oracle Sales Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Oracle Sales. Leverage the pyodbc module for ODBC in Python.
-
Analyze Freshservice Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Freshservice from Power Pivot. You will use the Table Import Wizard to load Freshservice. You can visually build the import query or use any SQL supported by the driver.
-
Getting Started with the CData Python Connector for LaunchDarkly
Learn to install and license the CData Python Connector
-
Working with Pipedrive Data in LINQPad
Execute LINQ queries to Pipedrive in LINQPad.
-
Create Dashboards and Visualize Live Oracle Financials Cloud Data in Geckoboard
Use CData Connect AI to connect to live Oracle Financials Cloud and create dashboards for real-time monitoring and visualization in Geckoboard.
-
A PostgreSQL Interface for SAP Hybris C4C Data (MySQL Remoting via JDBC)
Use the Remoting features of the SAP Hybris C4C JDBC Driver to create a PostgreSQL entry-point for data access.
-
Object-Relational Mapping (ORM) with Bitly Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Bitly into a Java-based ORM framework, Hibernate.
-
Configure the CData JDBC Driver for Shippo in a Connection Pool in Tomcat
Connect to Shippo from a connection pool in Tomcat.
-
Automated Continuous Pinterest Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Pinterest replication to Apache Kafka.
-
Automate ZohoDesk Data Replication to Azure Data Lake
Use CData Sync to customize and automate ZohoDesk replication to Azure Data Lake.
-
Automated Continuous Nethunt Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Nethunt replication to Google Cloud SQL.