CData Software - Knowledge Base
Recent Articles
-
Create SSAS Tabular Models from CircleCI Data
How to build a SQL Server Analysis Service Tabular Model from CircleCI using CData drivers.
-
Getting Started with the CData Tableau Connector for Adobe Analytics
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Adobe Analytics.
-
Replicate Redis Data to Multiple Databases via the CData Sync CLI
Replicate Redis to disparate databases with a single configuration.
-
Explore Geographical Relationships in Bitly Data with Power Map
Create data visualizations with Bitly in Power Map.
-
Automate PivotalTracker Data Replication to Azure Data Lake
Use CData Sync to customize and automate PivotalTracker replication to Azure Data Lake.
-
Automated Continuous FreeAgent Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable FreeAgent replication to Amazon Redshift.
-
Connect to Oracle Eloqua Data in RapidMiner
Integrate Oracle Eloqua with standard components and data source configuration wizards in RapidMiner Studio.
-
Viewing Instagram Data in RAD Studio Data Explorer
How to view Instagram in RAD Studio Data Explorer using the CData ODBC Driver for Instagram.
-
Build Jira-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Jira to explore live Jira Data in Cursor to assist with building Jira-powered applications.
-
Create Certinia-Connected Applications in Appsmith
Connect to Certinia Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Certinia.
-
Create NetSuite SuiteAnalytics-Connected Nintex Workflows
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Nintex Workflow Cloud and build custom workflows using live NetSuite SuiteAnalytics.
-
Replicate Multiple JotForm Accounts via the CData Sync CLI
Replicate multiple JotForm accounts to one or many databases.
-
Connect to FreshBooks from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from FreshBooks, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Use the CData Software JDBC Driver for SpaceX in MicroStrategy
Connect to SpaceX in MicroStrategy Developer using the CData Software JDBC Driver for SpaceX.
-
Consume Azure Data Catalog OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Azure Data Catalog feeds that reflect any changes in SAP Lumira.
-
Connect to Cloudant Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live IBM Cloudant from Filemaker Pro on Mac.
-
Create PhantomBuster Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time PhantomBuster data access from reports, embedded analytics, and more.
-
Connect to Procore Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Procore.
-
Use the CData Software JDBC Driver for Zoho Books in MicroStrategy
Connect to Zoho Books in MicroStrategy Developer using the CData Software JDBC Driver for Zoho Books.
-
Build a Singer.io Tap for Bugsnag With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Bugsnag data using
-
Automated Continuous Zuora Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Zuora replication to Amazon Redshift.
-
Integrate RSS Feeds in the Pentaho Report Designer
Publish reports based on RSS Feeds in the Pentaho BI tool.
-
Build Dashboards with MailerSend Data in Dundas BI
Create dynamic dashboards and perform analytics based on MailerSend in Dundas BI.
-
Getting Started with the CData ADO.NET Provider for CouchDB
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for CouchDB.
-
Query Live MailChimp Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live MailChimp directly from the development environment.
-
Query eBay Analytics Data in DataGrip
Create a Data Source for eBay Analytics in DataGrip and use SQL to query live eBay Analytics.
-
Build a Singer.io Tap for Redshift With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Redshift data using
-
Integrating ZohoPeople Data in Talend Cloud Data Management Platform
Connect ZohoPeople Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Integrate Adobe Analytics Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Adobe Analytics and integrate live Adobe Analytics into your Power Automate tasks.
-
Build MVC Applications with Connectivity to SAP SuccessFactors Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access SAP SuccessFactors from an ASP.NET MVC application.
-
Getting Started with the CData ODBC Driver for Oracle HCM Cloud
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Oracle HCM Cloud.
-
Build Microsoft Entra ID-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Microsoft Entra ID to explore live Microsoft Entra ID Data in GitHub Copilot to assist with building Microsoft Entra ID-powered applications.
-
Create Informatica Mappings From/To a JDBC Data Source for Jira
Create Jira data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time Templated Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Templated in ColdFusion.
-
Create ZohoInvoice Dataflows on PowerBI.com
Connect to the CData Power BI Connector for ZohoInvoice from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Pinterest Replication to MySQL
Use CData Sync for automated, continuous, customizable Pinterest replication to MySQL.
-
Extract, Transform, and Load Reckon Accounts Hosted Data in Informatica PowerCenter
Create a simple Workflow for Reckon Accounts Hosted in Informatica PowerCenter.
-
Create FHIR-Connected Applications in Appsmith
Connect to FHIR Data via CData Connect AI in Appsmith and create custom business applications with real-time access to FHIR.
-
Use Agno to Talk to Your GraphQL Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Agno agents to securely answer questions and take actions on your GraphQL for you.
-
Create Data Visualizations in Cognos BI with ShipStation Data
Access ShipStation as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use Dash to Build to Web Apps on Ontraport Data
Create Python applications that use pandas and Dash to build Ontraport-connected web apps.
-
Bridge TigerGraph Connectivity with Apache NiFi
Access and process TigerGraph in Apache NiFi using the CData JDBC Driver.
-
Create SFTP Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SFTP data access from reports, embedded analytics, and more.
-
Choosing the Best Method to Connect Cohere to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Cohere from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Use the CData Software ODBC Driver for YouTube Analytics in MicroStrategy Desktop
Connect to YouTube Analytics in MicroStrategy Desktop using the CData Software ODBC Driver for YouTube Analytics.
-
Access HDFS Data from MySQL in PHP
Connect to HDFS through the standard MySQL libraries in PHP.
-
Integrate with Coinbase Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Coinbase to a JSON file on disk.
-
Connect to Perplexity Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Perplexity in the Denodo Virtual DataPort Administrator.
-
Connect to SAP Fieldglass from Asprova with CData Software ODBC Driver for SAP Fieldglass
This article shows how to connect faster to SAP Fieldglass data from Asprova.
-
How to connect PolyBase to Xero
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Xero Accounting.
-
Visualize Live Phoenix Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Apache Phoenix into custom reports in Power BI.
-
Build ActiveCampaign Visualizations in Tableau Cloud
Use CData Connect AI to connect to live ActiveCampaign and build visualizations in Tableau Cloud.
-
Use the CData ODBC Driver for Dynamics CRM from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Dynamics CRM to connect to Microsoft Dynamics CRM from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Dynamics CRM in Excel.
-
Create a Data Access Object for iContact Data using JDBI
A brief overview of creating a SQL Object API for iContact in JDBI.
-
A PostgreSQL Interface for Copper Data (MySQL Remoting via JDBC)
Use the Remoting features of the Copper JDBC Driver to create a PostgreSQL entry-point for data access.
-
Write a Simple Go Application to work with Jira Assets Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Jira Assets.
-
Enable the SharePoint Excel Services JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SharePoint Excel Services.
-
Automate Google Cloud Storage Data Replication to Azure Synapse
Use CData Sync to customize and automate Google Cloud Storage replication to Azure Synapse.
-
Manage CSV Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for CSV.
-
Getting Started with the CData ODBC Driver for Google Spanner
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Google Spanner.
-
Connect to Sage Cloud Accounting Data from a Connection Pool in JBoss
Integrate Sage Business Cloud Accounting into Java servlets: Use the Management Console in JBoss to install the Sage Cloud Accounting JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Google Calendar Data
Use CData Power BI Connectors to visualize Google Calendar in Power BI.
-
Publish Reports with Pipeline CRM Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Pipeline CRM.
-
How to Access Live Printify Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Printify enables you to integrate Printify into workflows built using Microsoft Power Automate Desktop.
-
Connect to Twitter Ads Data in Claris FileMaker Pro
Use the CData ODBC Driver for Twitter Ads in FileMaker Pro to connect to Twitter Ads and work with Twitter Ads in your FileMaker applications.
-
SAS Data Sets Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on SAS Data Sets facts in real time.
-
Viewing BambooHR Data in RAD Studio Data Explorer
How to view BambooHR in RAD Studio Data Explorer using the CData ODBC Driver for BambooHR.
-
Feed Discourse Data into FineReport
How to set Discourse as a JDBC data source in FineReport.
-
Automated Continuous Box Replication to Google BigQuery
Use CData Sync for automated, continuous, customizable Box replication to Google BigQuery.
-
How to publish and share Hive Data dashboards with Tableau Server
The CData ODBC driver for Hive enables you integrate Apache Hive into Tableau dashboards.
-
Access Tanda Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Tanda from your Oracle system.
-
Provide OData Services of SAP Business One Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for SAP Business One by developing a WCF Service Application.
-
Connect to Mocean in SpagoBI
Create reports featuring live Mocean in SpagoBI Studio. Host Mocean reports on SpagoBI Server.
-
Use Dash to Build to Web Apps on eBay Analytics Data
Create Python applications that use pandas and Dash to build eBay Analytics-connected web apps.
-
Connect to Dotmailer Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Dotmailer in the Denodo Virtual DataPort Administrator.
-
Configure the CData JDBC Driver for Power BI XMLA in a Connection Pool in Tomcat
Connect to Power BI XMLA from a connection pool in Tomcat.
-
Integrating Cursor CLI with Landbot 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.
-
Integrate LibreChat with Live Greenhouse Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Greenhouse from within the chat interface.
-
Rapidly Develop JotForm-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by JotForm.
-
Automated Continuous SAP Fieldglass Replication to Snowflake
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Snowflake.
-
Automated Continuous PivotalTracker Replication to Databricks
Use CData Sync for automated, continuous, customizable PivotalTracker replication to Databricks.
-
Connect to PivotalTracker Data in Aqua Data Studio
Access PivotalTracker from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Visualize Live MongoDB Data in the Power BI Service
Use CData Connect AI to connect to live MongoDB and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automated Continuous Dynamics CRM Replication to Databricks
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to Databricks.
-
Connect to MySQL Data in JRuby
Create a simple JRuby app with access to live MySQL.
-
Integrate ZohoDesk Data in the Pentaho Report Designer
Publish reports based on ZohoDesk in the Pentaho BI tool.
-
How to Visualize DocuSign Data in Python with pandas
Use pandas and other modules to analyze and visualize live DocuSign in Python.
-
Integrate Live Exact Online Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Exact Online to Blue Prism using the CData ODBC Driver for Exact Online to create automated workflows for repetitive business tasks.
-
Automated Continuous Amazon DynamoDB Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Amazon DynamoDB replication to Apache Cassandra.
-
Bidirectional Access to FTP Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate FTP Servers in Filemaker Pro for Mac or Windows.
-
Consume Azure Analysis Services OData Feeds in PowerBuilder
This article demonstrates how to consume Azure Analysis Services as OData feeds from PowerBuilder using the API Server.
-
Create Apps from MarkLogic Data in Qlik Sense Cloud
Use CData Connect AI to connect to MarkLogic Data and build apps from live MarkLogic in Qlik Sense Cloud.
-
Connect to Sybase IQ Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Sybase IQ and the SQL Gateway to access Sybase IQ from Google Apps Script.
-
Extend Google Sheets with Oracle HCM Cloud Data
Make calls to Oracle HCM Cloud from Google Apps Script via the API Server.
-
Build a PostgreSQL Interface for Jira Data using the CData JDBC Driver
Use the Remoting features of the Jira JDBC Driver to create a PostgreSQL entry-point for data access.
-
Access Campaigner Data from MySQL in PHP
Connect to Campaigner through the standard MySQL libraries in PHP.
-
Extract, Transform, and Load BigQuery Data in Informatica PowerCenter
Create a simple Workflow for Google BigQuery in Informatica PowerCenter.
-
Seamlessly Bring SAS Data Sets Data into Retool Using CData Connect AI
Integrate SAS Data Sets data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Create Splunk-Connected Nintex Workflows
Use CData Connect AI to connect to Splunk Data from Nintex Workflow Cloud and build custom workflows using live Splunk.
-
Connect to Microsoft Exchange Data from HeidiSQL
Use CData Connect AI to connect to and query live Microsoft Exchange from HeidiSQL.