CData Software - Knowledge Base
Recent Articles
-
Load Helpscout Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Helpscout to a database.
-
Connect to CapsuleCRM Data in NetBeans
Connect to CapsuleCRM in NetBeans with the data source configuration wizard.
-
Analyze Spark Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Apache Spark SQL and visualize Apache Spark SQL in SAP Analytics Cloud.
-
Build Voice Agents in ElevenLabs with access to Live JSON Services
Use the CData Connect AI Remote MCP Server to enable ElevenLabs agents to securely access live JSON.
-
Replicate Multiple Zoho CRM Accounts via the CData Sync CLI
Replicate multiple Zoho CRM accounts to one or many databases.
-
Query Campaigner Data as a MySQL Database in Node.js
Execute MySQL queries against Campaigner from Node.js.
-
Use the CData Software JDBC Driver for Productboard in MicroStrategy Web
Connect to Productboard in MicroStrategy Web using the CData Software JDBC Driver for Productboard.
-
Build Charts with Highrise Data in Clear Analytics
Create dynamic charts and perform analytics based on Highrise CRM in Clear Analytics.
-
How to Create Power BI Visual Reports with Real-Time Highrise Data
Use CData Power BI Connectors to visualize Highrise CRM in Power BI.
-
Create Data Visualizations in Cognos BI with Pinecone Data
Access Pinecone as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Query RSS Feeds using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume RSS entities in PHP by modeling them as objects.
-
Connect to Kintone Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Kintone in the Denodo Virtual DataPort Administrator.
-
Query Redshift Data as a SQL Server Database in Node.js
Execute SQL Server queries against Amazon Redshift from Node.js.
-
Analyze FormSite Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for FormSite from Power Pivot. You will use the Table Import Wizard to load FormSite. You can visually build the import query or use any SQL supported by the driver.
-
How to Query Sendwithus Data in MySQL Workbench
Execute MySQL queries against live Sendwithus from MySQL Workbench.
-
Integrate AfterShip with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate AfterShip with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to AfterShip.
-
Visualize Live REST Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live REST using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Create a Data Access Object for Nuclia Data using JDBI
A brief overview of creating a SQL Object API for Nuclia in JDBI.
-
Integrating Codex CLI with Tally ERP 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 BigCommerce Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live BigCommerce.
-
Use the CData SSIS Components to Insert New or Update Existing Odoo Records from SQL Server
Easily push SQL Server data to Odoo using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Odoo or update existing records with data from a SQL Server database.
-
Connect to SAS xpt Data in Aqua Data Studio
Access SAS XPORT from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Couchbase Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your Couchbase for you.
-
Working with Omnisend Data in LINQPad
Execute LINQ queries to Omnisend in LINQPad.
-
Design BIRT Reports on Flowlu Data
Provide current Flowlu to your embedded analytics.
-
Integrate Typeform Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Typeform from Informatica Cloud.
-
Build Twilio-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for Twilio Data and create custom apps in Bubble.
-
Replicate Teamgate Data in Heroku for Use in Salesforce Connect
Replicate Teamgate to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Viewing MariaDB Data in RAD Studio Data Explorer
How to view MariaDB in RAD Studio Data Explorer using the CData ODBC Driver for MariaDB.
-
Visualize Live Azure Data Lake Storage Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Azure Data Lake Storage using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Access Live Moosend Data in AWS Lambda
Connect to live Moosend in AWS Lambda using the CData JDBC Driver.
-
Connect to Hive Data from HeidiSQL
Use CData Connect AI to connect to and query live Apache Hive from HeidiSQL.
-
Automated Continuous Zoho Inventory Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Zoho Inventory replication to delimited files (CSV/TSV).
-
How to Connect to Live Gong Data in Mistral AI Workflows
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Gong without replication.
-
Configure the CData JDBC Driver for FreshBooks in a Connection Pool in Tomcat
Connect to FreshBooks from a connection pool in Tomcat.
-
Automated Continuous Quaderno Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Quaderno replication to Google Cloud SQL.
-
Import and Visualize SAP HANA Data in Power View
Create data visualizations based on SAP HANA in Excel.
-
Build GitHub-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live GitHub.
-
Visualize Live ZendeskSell Data in Tableau
Use CData Tableau Connectors and Tableau Desktop to visualize live ZendeskSell.
-
How to import Instagram Data into Apache Solr
Use the CData Software JDBC Driver for Instagram in Data Import Handler and create an automated import of Instagram to Apache Solr Enterprise Search platform.
-
How to Access Live EmailOctopus Data in Power Automate Desktop via ODBC
The CData ODBC Driver for EmailOctopus enables you to integrate EmailOctopus into workflows built using Microsoft Power Automate Desktop.
-
How to connect and process Microsoft Planner from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Microsoft Planner.
-
Connect to Sage Cloud Accounting Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Sage Business Cloud Accounting in the Denodo Virtual DataPort Administrator.
-
How to Seamlessly Import Oracle Sales Data into IBM SPSS Modeler
Integrate Oracle Sales data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Publish Reports with SurveyMonkey Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date SurveyMonkey.
-
How to connect SharePoint with Greenplum Data through external lists
Provide Pivotal GreenPlum to SharePoint users as an external list.
-
Access Zoho Inventory Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Zoho Inventory from your Oracle system.
-
Getting Started with the CData ADO.NET Provider for Jira Assets
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Jira Assets.
-
Getting Started with the CData SSIS Components for Twitter Ads
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Twitter Ads.
-
How to Work with Pinecone Data in AWS Glue Jobs Using JDBC
Connect to Pinecone from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
A PostgreSQL Interface for Vault CRM Data using the CData ODBC Driver
Use the SQL Gateway and Vault CRM ODBC Driver to create a PostgreSQL entry-point for data access.
-
Using the CData Software ODBC Driver for LightSpeedRetail in PyCharm
Connect to LightSpeedRetail as an ODBC data source in PyCharm using the CData Software ODBC Driver for LightSpeedRetail.
-
How to create Visio diagrams from Salesforce Marketing Data
Automatically update Salesforce Marketing Cloud with the changes you make to Visio master shapes.
-
Access Discourse Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Discourse from HeidiSQL.
-
Analyze Live Shopify Data in SAS Viya
Use CData Connect AI to connect to Shopify from SAS Viya and deploy self-service analytics using live Shopify.
-
Manage Avaza Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Avaza.
-
Query Excel Online Data in ColdFusion
Write standard ColdFusion data access code to connect to Microsoft Excel Online.
-
Integrating Kiro CLI with SAP HANA 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.
-
Create a Data Access Object for FormSite Data using JDBI
A brief overview of creating a SQL Object API for FormSite in JDBI.
-
Connect to Microsoft Dataverse Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Microsoft Dataverse Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Explore Geographical Relationships in Autopilot Data with Power Map
Create data visualizations with Autopilot in Power Map.
-
Write a Simple Go Application to work with Amazon Athena Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Amazon Athena.
-
Automated Continuous SAP Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP replication to Snowflake.
-
Build Semantic Layer Views for SAP Ariba Procurement Data in APOS Live Data Gateway
Use the CData Connector for SAP Ariba Procurement in APOS Live Data Gateway to build Semantic Layer Views for SAP Ariba Procurement.
-
Use the CData ODBC Driver for Sage Cloud Accounting from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Sage Cloud Accounting to connect to Sage Business Cloud Accounting from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Sage Business Cloud Accounting in Excel.
-
Natively Connect to Pingdom Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Pingdom. Leverage the native support for ODBC in PHP.
-
Using the CData Software ODBC Driver for Mailgun in PyCharm
Connect to Mailgun as an ODBC data source in PyCharm using the CData Software ODBC Driver for Mailgun.
-
Connect to Lakebase Data in CloverDX (formerly CloverETL)
Transfer Lakebase using the visual workflow in the CloverDX data integration tool.
-
Automate Dynamics 365 Business Central Data Replication to SAP HANA
Use CData Sync to customize and automate Dynamics 365 Business Central replication to SAP HANA.
-
Migrating data from Oracle Sales to Snowflake using CData SSIS Components.
Easily push Oracle Sales to Snowflake using the CData SSIS Tasks for Oracle Sales and Snowflake.
-
Explore Geographical Relationships in Hacker News Data with Power Map
Create data visualizations with Hacker News in Power Map.
-
Connect to Freshservice Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Freshservice in Airbyte.
-
Getting Started with the CData SSIS Components for Samanage
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Samanage.
-
How to Easily Query Printful Data in OpenOffice Base
Connect to Printful data in OpenOffice Base using the CData API Driver for ODBC and generate reports with live data insights.
-
Automated Continuous Nethunt Replication to SQL Server
Use CData Sync for automated, continuous, customizable Nethunt replication to SQL Server.
-
Connect to Live Airtable Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Airtable in CData Connect AI and connect to your Airtable from PostgreSQL.
-
Getting Started with the CData JDBC Driver for PhantomBuster
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for PhantomBuster.
-
Integrate Theia IDE with Live Zoho CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Theia IDE
-
Extract, Transform, and Load SharePoint Excel Services Data in Informatica PowerCenter
Create a simple Workflow for SharePoint Excel Services in Informatica PowerCenter.
-
Connect to ZarMoney Data in DBArtisan
Use wizards in DBArtisan to configure ZarMoney as a data source.
-
Automated Azure Blob Storage Data Replication to Teradata
Use CData Sync to Customize and automate Azure Blob Storage replication to Teradata.
-
Access Live Apollo Data 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 Apollo through MCP integration.
-
Build PayPal-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for PayPal Data and create custom apps in Mendix.
-
Query WordPress Data in DataGrip
Create a Data Source for WordPress in DataGrip and use SQL to query live WordPress.
-
How to Connect the Power BI Service to Authorize.Net: Complete Guide
Connect to the CData Software Power BI Connector for Authorize.Net from PowerBI.com to provide real-time Authorize.Net across the organization.
-
Integrating GitHub Copilot CLI with MailerLite 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.
-
Migrating data from Copper to Databricks using CData SSIS Components.
Easily push Copper to Databricks using the CData SSIS Tasks for Copper and Databricks.
-
Import Pipedrive Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to Pipedrive Data and provide access to live Pipedrive for custom reports in the Power BI Service.
-
Connect to Freshdesk Data in Aqua Data Studio
Access Freshdesk from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
How to Connect to Live Oracle SCM Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Oracle SCM for you.
-
Build an OLAP Cube in SSAS from SpaceX Data
Establish a connection to SpaceX data from SQL Server Analysis Services, and use the SpaceX Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Okta Data in TIBCO Spotfire through OData
Integrate Okta into dashboards in TIBCO Spotfire.
-
Access Live TigerGraph Data in Coginiti Pro
Connect to and query live TigerGraph from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Automated Continuous Teamgate Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Teamgate replication to OneLake in Microsoft Fabric.
-
Viewing ZohoExpense Data in RAD Studio Data Explorer
How to view ZohoExpense in RAD Studio Data Explorer using the CData ODBC Driver for ZohoExpense.
-
How to connect Amazon QuickSight to Office 365 Data
Create a connection to Microsoft Office 365 in CData Connect AI and insert Microsoft Office 365 into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Microsoft Copilot Studio to talk to your SAP Netweaver Gateway Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Microsoft Copilot Studio to securely answer questions and take actions on your SAP Netweaver Gateway for you.
-
Process & Analyze Azure Table Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Azure Table Data.
-
Integrate Elasticsearch Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Elasticsearch and integrate live Elasticsearch into your Power Automate tasks.
-
Build WordPress-Connected Apps in Choreo
Use CData Connect AI to connect to WordPress Data from Choreo and build custom apps using live WordPress.