CData Software - Knowledge Base
Recent Articles
-
Use the CData Software JDBC Driver for OneNote in MicroStrategy Desktop
Connect to Microsoft OneNote in MicroStrategy Desktop using the CData Software JDBC Driver for OneNote.
-
Query Phoenix Data in DataGrip
Create a Data Source for Phoenix in DataGrip and use SQL to query live Apache Phoenix.
-
Visualize JotForm Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load JotForm into TIBCO Spotfire.
-
Integrate Azure DevOps with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Azure DevOps with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Azure DevOps.
-
Connect to AdRoll Data in DBeaver
Use the CData ODBC Driver to connect to AdRoll in DBeaver.
-
Integrate with Oracle Sales Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Oracle Sales to a JSON file on disk.
-
Edit and Search External Freshdesk Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Freshdesk to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Freshdesk Data objects that you can access from apps and the dashboard.
-
Bridge Invoiced Connectivity with Apache NiFi
Access and process Invoiced in Apache NiFi using the CData JDBC Driver.
-
Automated Continuous Blackbaud FE NXT Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Blackbaud FE NXT replication to Azure SQL Database.
-
Import and Visualize PayPal Data in Power View
Create data visualizations based on PayPal in Excel.
-
Connect Harvest to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Harvest with IBM WebSphere for seamless data integration and connectivity.
-
Connect to Contentful Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Contentful to connect to Contentful and execute queries in PowerBuilder.
-
A PostgreSQL Interface for Nethunt Data (MySQL Remoting via JDBC)
Use the Remoting features of the Nethunt JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query QuickBooks Online Data through ODBC in Node.js
Use node-odbc to execute SQL queries against QuickBooks Online from Node.js.
-
DataBind Charts to Act-On Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Act-On from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
Connect to Perplexity from a Connection Pool in WebLogic
Use the CData JDBC Driver for Perplexity to connect to Perplexity from Web applications running on WebLogic.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Teamgate
Provide connectivity to Teamgate through an SAP BusinessObjects universe.
-
Connecting Pipedream with Pipedrive Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Pipedrive data in real time.
-
Extend Google Sheets with QuickBooks Online Data
Make calls to QuickBooks Online from Google Apps Script via the API Server.
-
Manage RabbitMQ Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for RabbitMQ.
-
How to create an RPA flow for ConvertAPI Data in UiPath Studio
Use the ConvertAPI ODBC Driver to create workflows that access real-time ConvertAPI without any coding.
-
Connect to Egnyte Data in DBArtisan
Use wizards in DBArtisan to configure Egnyte as a data source.
-
Import NetSuite SuiteAnalytics Data into the Power BI Service for Visualizations
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data and provide access to live NetSuite SuiteAnalytics for custom reports in the Power BI Service.
-
Extract, Transform, and Load iContact Data in Informatica PowerCenter
Create a simple Workflow for iContact in Informatica PowerCenter.
-
Connect to and Query FHIR Data in QlikView over ODBC
Create data visualizations with FHIR in QlikView.
-
Replicate Egnyte Data in Heroku for Use in Salesforce Connect
Replicate Egnyte to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect Flowise AI Agents to Live Oracle Eloqua Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Oracle Eloqua without replication.
-
Using the CData Software ODBC Driver for Discourse in PyCharm
Connect to Discourse as an ODBC data source in PyCharm using the CData Software ODBC Driver for Discourse.
-
How to Use a Microsoft Access Database to Update Exact Online Data in Real Time
Update Exact Online data by creating a linked table in Microsoft Access with the CData Exact Online ODBC Driver.
-
Connect to Box Data in ACL Analytics
Connect to Box via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Box.
-
Analyze Adobe Analytics Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Adobe Analytics and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Connect to Amazon DynamoDB Data from a Connection Pool in JBoss
Integrate Amazon DynamoDB into Java servlets: Use the Management Console in JBoss to install the Amazon DynamoDB JDBC Driver.
-
Edit and Search Azure Synapse External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Azure Synapse to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Azure Synapse objects that you can access from apps and the dashboard.
-
Bind Live Azure Data Catalog Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Azure Data Catalog data
-
Connect to eBay Data in DBeaver
Use the CData ODBC Driver to connect to eBay in DBeaver.
-
Build SAS Data Sets-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for SAS Data Sets to explore live SAS Data Sets Data in GitHub Copilot to assist with building SAS Data Sets-powered applications.
-
Design BIRT Reports on Exa Data
Provide current Exa to your embedded analytics.
-
Establish a Live Connection with Teamwork Data using Tableau Bridge
The CData ODBC Driver for Teamwork enables you to integrate live Teamwork into Tableau Cloud dashboards using the Tableau Bridge.
-
Analyze Zoho Inventory Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Zoho Inventory from Power Pivot. You will use the Table Import Wizard to load Zoho Inventory. You can visually build the import query or use any SQL supported by the driver.
-
Create a Data Access Object for Azure Data Catalog Data using JDBI
A brief overview of creating a SQL Object API for Azure Data Catalog in JDBI.
-
Bridge Aha! Connectivity with Apache NiFi
Access and process Aha! in Apache NiFi using the CData JDBC Driver.
-
Integrate Goose with Live Microsoft Planner Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Microsoft Planner from within the local AI agent.
-
Establish a Live Connection with Grafana Data using Tableau Bridge
The CData ODBC Driver for Grafana enables you to integrate live Grafana into Tableau Cloud dashboards using the Tableau Bridge.
-
Integrate Google
Leverage the CData Connect AI Remote MCP Server to enable Antigravity agents to securely access and act on live CSV/TSV Files using the Model Context Protocol.
-
Automated Continuous Snapchat Ads Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Snapchat Ads replication to Azure SQL Database.
-
Create Data Visualizations in Cognos BI with Adobe Analytics Data
Access Adobe Analytics as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Automated Continuous Google Analytics Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Google Analytics replication to AlloyDB.
-
Getting Started with the CData Python Connector for Azure Data Lake Storage
Learn to install and license the CData Python Connector
-
Automate Microsoft Exchange Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Microsoft Exchange and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
How to connect SharePoint with Azure Data Catalog Data through external lists
Provide Azure Data Catalog to SharePoint users as an external list.
-
Connect to Confluence Data from PowerBuilder via JDBC
This article demonstrates how to access Atlassian Confluence from PowerBuilder using the Confluence JDBC Driver.
-
Automated Continuous Cosmos DB Replication to Vertica
Use CData Sync for automated, continuous, customizable Cosmos DB replication to Vertica.
-
Connect to SAP Business One from a Connection Pool in WebLogic
Use the CData JDBC Driver for SAP Business One to connect to SAP Business One from Web applications running on WebLogic.
-
Connect to Oracle Service Cloud Data in Claris FileMaker Pro
Use the CData ODBC Driver for Oracle Service Cloud in FileMaker Pro to connect to Oracle Service Cloud and work with Oracle Service Cloud in your FileMaker applications.
-
How to publish and share BigCommerce Data dashboards with Tableau Server
The CData ODBC driver for BigCommerce enables you integrate BigCommerce into Tableau dashboards.
-
Access Live PingOne Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live PingOne data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Query Telegram Data in ColdFusion
Write standard ColdFusion data access code to connect to Telegram.
-
Analyze MySQL Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for MySQL from Power Pivot. You will use the Table Import Wizard to load MySQL. You can visually build the import query or use any SQL supported by the driver.
-
How to use SQLAlchemy ORM to access Google Spanner Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Spanner.
-
How to Access Salesforce Marketing Data Using Entity Framework
This article shows how to access Salesforce Marketing Cloud using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Use the CData Software JDBC Driver for SAP SuccessFactors in MicroStrategy Desktop
Connect to SAP SuccessFactors in MicroStrategy Desktop using the CData Software JDBC Driver for SAP SuccessFactors.
-
How to connect to Keap Data in DBVisualizer
Integrate Keap with visual data analysis tools and data connection wizards in DBVisualizer
-
Use JayDeBeApi to access Microsoft Ads Data in Python
Use standard Python scripting and the development environment of your choice to access live Microsoft Ads.
-
How to update Google Directory from Excel
This article explains how to transfer data from Excel to Google Directory using the Excel Add-In for Google Directory.
-
How to Connect the Power BI Service to Microsoft Entra ID: Complete Guide
Connect to the CData Software Power BI Connector for Microsoft Entra ID from PowerBI.com to provide real-time Microsoft Entra ID across the organization.
-
Work with Live Email Data in Power Query
Use CData Connect AI to connect to Email and work with live Email in Microsoft Power Query.
-
Integrating Kiro CLI with Deel 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.
-
Query EnterpriseDB Data through ODBC in Node.js
Use node-odbc to execute SQL queries against EnterpriseDB from Node.js.
-
Create SSAS Tabular Models from ShipStation Data
How to build a SQL Server Analysis Service Tabular Model from ShipStation using CData drivers.
-
Getting Started with the CData ADO.NET Provider for Klaviyo
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Klaviyo.
-
How to Connect DBeaver to SAP Business Warehouse via a JDBC Driver
Manage SAP Business Warehouse with visual tools in DBeaver like the query browser.
-
Build Amazon Marketplace-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Amazon Marketplace and build Amazon Marketplace-connected web apps with Axios.
-
Connect to ZarMoney Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ZarMoney and the SQL Gateway to access ZarMoney from Google Apps Script.
-
Build Charts with Gorgias Data in Clear Analytics
Create dynamic charts and perform analytics based on Gorgias in Clear Analytics.
-
Replicate Facebook Ads Data in Heroku for Use in Salesforce Connect
Replicate Facebook Ads to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
LINQ to Calendly Data
LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Calendly Data Provider.
-
Use the CData Software JDBC Driver for Google Forms in MicroStrategy Desktop
Connect to Google Forms in MicroStrategy Desktop using the CData Software JDBC Driver for Google Forms.
-
How to create MailerLite federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for MailerLite in MySQL .
-
Connect to ZohoDesk Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
How to load SAP SuccessFactors data into Elasticsearch via Logstash
Introducing a simple method to load SAP SuccessFactors data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Extract, Transform, and Load Bullhorn CRM Data in Informatica PowerCenter
Create a simple Workflow for Bullhorn CRM in Informatica PowerCenter.
-
Analyze Blackbaud FE NXT Data in SAP Analytics Cloud
Use CData Connect AI to create an OData API on top of Blackbaud FE NXT and visualize Blackbaud FE NXT in SAP Analytics Cloud.
-
Deploy the ADO.NET Provider for Notion on an SSRS Report Server
Connect to Notion 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.
-
Write a Simple Go Application to work with Billsby Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Billsby.
-
Access Live BigQuery Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Google BigQuery from your Excel spreadsheets.
-
Visualize Live eBay Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live eBay using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Automate GitHub Data Replication to Azure Synapse
Use CData Sync to customize and automate GitHub replication to Azure Synapse.
-
Connect to DocuSign from Asprova with CData Software ODBC Driver for DocuSign
This article shows how to connect faster to DocuSign data from Asprova.
-
Access Live Sybase IQ Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Sybase IQ into the statistical analysis tools available in SAS JMP. This article shows how to use Sybase IQ in the Graph Builder and Query Builder.
-
Connecting Pipedream with Microsoft Ads Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Pipedream workflows to securely read and take actions on Microsoft Ads data in real time.
-
How to publish and share SAP HANA XS Advanced Data dashboards with Tableau Server
The CData ODBC driver for SAP HANA XS Advanced enables you integrate SAP HANA XS Advanced into Tableau dashboards.
-
Build Semantic Layer Views for Gong Data in APOS Live Data Gateway
Use the CData Connector for Gong in APOS Live Data Gateway to build Semantic Layer Views for Gong.
-
Analyze Monday.com Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Monday.com in Microsoft R Open.
-
Bidirectional Access to Shopify Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Shopify in Filemaker Pro for Mac or Windows.
-
View Reports on Real-Time Mailjet Data in Power BI Report Server
Use the CData ODBC Driver for Mailjet to visualize Mailjet in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Mailjet Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Mailjet data access from reports, embedded analytics, and more.
-
Connect to and Visualize Live LaunchDarkly Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live LaunchDarkly.
-
Connect to and Query Keap Data in QlikView over ODBC
Create data visualizations with Keap in QlikView.
-
Automate SparkPost Integration Tasks from PowerShell
Are you in search of a quick and easy way to access SparkPost from PowerShell? This article demonstrates how to utilize the SparkPost Cmdlets for tasks like connecting to SparkPost, automating operations, downloading data, and more.
-
Access FormSite Data from MySQL in PHP
Connect to FormSite through the standard MySQL libraries in PHP.