CData Software - Knowledge Base
Recent Articles
-
How to Query Live Paylocity Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Paylocity data in natural language using Python.
-
Create Data Visualizations in Cognos BI with Snowflake Data
Access Snowflake as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Use the CData Software ODBC Driver for SparkPost in MicroStrategy Desktop
Connect to SparkPost in MicroStrategy Desktop using the CData Software ODBC Driver for SparkPost.
-
Integrate Live Active Directory Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Active Directory and integrate live Active Directory into apps built in Microsoft Power Apps.
-
Connect to ClickUp Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for ClickUp and the SQL Gateway to access ClickUp from Google Apps Script.
-
Add Retently Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Retently with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect and Query Live DocuSign Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live DocuSign into Databricks
-
Connect to Nethunt Data from a Connection Pool in Jetty
The Nethunt JDBC Driver supports connection pooling: This article shows how to connect faster to Nethunt from Web apps in Jetty.
-
Connecting GenSpark with Azure DevOps Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Azure DevOps without any replication or custom integration required.
-
How to publish and share ShipEngine Data dashboards with Tableau Server
The CData ODBC driver for ShipEngine enables you integrate ShipEngine into Tableau dashboards.
-
Integrating Cursor CLI with LinkedIn Ads 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.
-
Integrating Kiro CLI with ShipEngine 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.
-
Publish Parallel-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Parallel.
-
Visualize Live Adobe Commerce Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Adobe Commerce into custom reports in Power BI.
-
Create Informatica Mappings From/To a JDBC Data Source for SharePoint
Create SharePoint data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Import Real-Time JobNimbus Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use JobNimbus in ColdFusion.
-
Automate GetResponse Data Replication to SAP HANA
Use CData Sync to customize and automate GetResponse replication to SAP HANA.
-
Create Reports from Pipedrive Data in Looker Studio
Use CData Connect AI to gain access to live Pipedrive and create custom reports in Looker Studio.
-
Getting Started with the CData SSIS Components for Datadog
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Datadog.
-
How to publish and share SurveyMonkey Data dashboards with Tableau Server
The CData ODBC driver for SurveyMonkey enables you integrate SurveyMonkey into Tableau dashboards.
-
Automate Vault CRM Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Veeva Vault & Vault CRM from PowerShell? This article demonstrates how to utilize the Vault CRM Cmdlets for tasks like connecting to Veeva Vault & Vault CRM, automating operations, downloading data, and more.
-
Access Authorize.Net Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Authorize.Net.
-
Connect to Odoo from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Odoo ERP, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrating Antigravity CLI with DocuSign via CData CLI
Connect DocuSign to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Replicate Amazon Athena Data to Multiple Databases
Replicate Amazon Athena to disparate databases with a point-and-click configuration.
-
Integrate Live ActiveCampaign Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for CockroachDB
Provide connectivity to CockroachDB through an SAP BusinessObjects universe.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hacker News
Provide connectivity to Hacker News through an SAP BusinessObjects universe.
-
Automated Continuous BenchmarkEmail Replication to SingleStore
Use CData Sync for automated, continuous, customizable BenchmarkEmail replication to SingleStore.
-
Stream SAP HANA XS Advanced Data into Apache Kafka Topics
Access and stream SAP HANA XS Advanced in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Connect to Brex from a Connection Pool in WebLogic
Use the CData JDBC Driver for Brex to connect to Brex from Web applications running on WebLogic.
-
Connect to Auth0 Data in Jaspersoft Studio
Execute SQL to remote Auth0 in Jaspersoft Studio.
-
Replicate NetSuite SuiteAnalytics Data to Multiple Databases via the CData Sync CLI
Replicate NetSuite SuiteAnalytics to disparate databases with a single configuration.
-
Automated Continuous ClickUp Replication to Vertica
Use CData Sync for automated, continuous, customizable ClickUp replication to Vertica.
-
How to connect PolyBase to Slack
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Slack.
-
Integrating Antigravity CLI with Square via CData CLI
Connect Square to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Provide OData Services of MYOB AccountRight Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for MYOB AccountRight by developing a WCF Service Application.
-
Build AI/ML Models with Live Reply.io Data using Dataiku
Connect Reply.io Data with Dataiku using the CData API Driver for JDBC.
-
Create Informatica Mappings From/To an ODBC Data Source for CockroachDB
Create an ODBC connection to CockroachDB in Informatica and browse and transfer CockroachDB.
-
Connect to FHIR Data in ACL Analytics
Connect to FHIR via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FHIR.
-
Import and Visualize Deel Data in Power View
Create data visualizations based on Deel in Excel.
-
Build Apps with Live Quickbase in Adalo using CData Connect AI
Use CData Connect AI to integrate live Quickbase into the Adalo platform and build custom mobile and web applications with real-time Quickbase.
-
Automate PayPal Data Replication to Azure Data Lake
Use CData Sync to customize and automate PayPal replication to Azure Data Lake.
-
Model Zendesk Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Zendesk, enabling the direct import of real-time Zendesk.
-
Connect to and Visualize Live MailChimp Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live MailChimp.
-
Use JayDeBeApi to access Splunk Data in Python
Use standard Python scripting and the development environment of your choice to access live Splunk.
-
Integrate Real-Time Access to Vercel in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Vercel in real time.
-
Integrate Coda with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Coda with External Services.
-
3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers
Three ways to connect Claris FileMaker to external data via CData ODBC Drivers: ODBC import, FileMaker scripting, and live ESS through the SQL Gateway.
-
A PostgreSQL Interface for Box Data using the CData ODBC Driver
Use the SQL Gateway and Box ODBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Outlook Data in DBeaver
Use the CData ODBC Driver to connect to Outlook in DBeaver.
-
How to connect to AdRoll Data with Squirrel SQL client
Connect to AdRoll and execute queries in the Squirrel SQL Client.
-
How to connect to Freshteam Data in DBVisualizer
Integrate Freshteam with visual data analysis tools and data connection wizards in DBVisualizer
-
How to connect to Scrapfly Data from Spring Boot
Connect to Scrapfly in a Spring Boot Application using the CData API Driver for JDBC
-
Access Live Azure Data Lake Storage Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Azure Data Lake Storage in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Visualize Live PabblySubscriptions Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live PabblySubscriptions using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Natively Connect to Google Forms Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Google Forms. Leverage the native support for ODBC in PHP.
-
How to create an RPA flow for Vault CRM Data in UiPath Studio
Use the Vault CRM ODBC Driver to create workflows that access real-time Veeva Vault & Vault CRM without any coding.
-
Import Real-Time EmailOctopus Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use EmailOctopus in ColdFusion.
-
How to connect and process Telegram from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Telegram.
-
How to Connect to Cloudflare Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Cloudflare. Leverage the pyodbc module for ODBC in Python.
-
Automated Continuous REST Replication to Oracle
Use CData Sync for automated, continuous, customizable REST replication to Oracle.
-
Build an OLAP Cube in SSAS from Azure Data Lake Storage Data
Establish a connection to Azure Data Lake Storage data from SQL Server Analysis Services, and use the Azure Data Lake Storage Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to Notion in SpagoBI
Create reports featuring live Notion in SpagoBI Studio. Host Notion reports on SpagoBI Server.
-
Replicate CSV Data in Heroku for Use in Salesforce Connect
Replicate CSV/TSV Files to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Access Live FHIR Data in Visual Studio Code via Cline
Run CData MCP Server for FHIR on Windows Subsytem for Linux (WSL) and connect to live FHIR from the Cline extension in Visual Studio Code.
-
How to create Visio diagrams from SingleStore Data
Automatically update SingleStore with the changes you make to Visio master shapes.
-
Import Real-Time ZeroBounce Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use ZeroBounce in ColdFusion.
-
How to Connect the Power BI Service to TigerGraph: Complete Guide
Connect to the CData Software Power BI Connector for TigerGraph from PowerBI.com to provide real-time TigerGraph across the organization.
-
Access Greenhouse Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Greenhouse.
-
How to Work with Okta Data in ETL Validator JDBC
Connect to Okta from ETL Validator jobs using the CData Software JDBC Driver.
-
Connect to Google Translate Data in RapidMiner
Integrate Google Translate with standard components and data source configuration wizards in RapidMiner Studio.
-
Getting Started with the CData ODBC Driver for Zendesk
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Zendesk.
-
Getting Started with the CData Python Connector for Vault CRM
Learn to install and license the CData Python Connector
-
Use JayDeBeApi to access Customer.io Data in Python
Use standard Python scripting and the development environment of your choice to access live Customer.io.
-
Access Miro Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Miro from your Oracle system.
-
Connect to and Visualize Live SAP BusinessObjects BI Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live SAP BusinessObjects BI.
-
Connect to and Visualize Live Salesforce Data 360 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Salesforce Data 360.
-
How to Access Live TaxJar Data in Visual Studio Code via Cline
Run CData MCP Server for TaxJar on Windows Subsytem for Linux (WSL) and connect to live TaxJar from the Cline extension in Visual Studio Code.
-
Bind Live Keap Data in Wijmo FlexGrid with CData API Server
With CData API Server, easily create OData endpoints for live Keap data
-
Automated Continuous Todoist Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Todoist replication to Google Cloud SQL.
-
Provide OData Services of Google Translate Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Google Translate by developing a WCF Service Application.
-
How to Work with Sendwithus Data in AWS Glue Jobs Using JDBC
Connect to Sendwithus from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Trello Data from a Connection Pool in JBoss
Integrate Trello into Java servlets: Use the Management Console in JBoss to install the Trello JDBC Driver.
-
Create Azure Analysis Services-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Azure Analysis Services Data from Klipfolio and build custom visualizations using live Azure Analysis Services.
-
Use JayDeBeApi to access GetResponse Data in Python
Use standard Python scripting and the development environment of your choice to access live GetResponse.
-
DataBind EnterpriseDB Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for EnterpriseDB with the DevExpress Windows Forms and Web controls to provide EnterpriseDB to a chart.
-
Create Simplesat Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Simplesat from PowerBI.com to create Power BI Dataflows with real-time data.
-
Integrating Kiro CLI with Office 365 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.
-
Use Biml to Build SSIS Tasks to Replicate Eventbrite Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Eventbrite to SQL Server.
-
Migrating data from PingOne to Google BigQuery using CData SSIS Components.
Easily push PingOne to Google BigQuery using the CData SSIS Tasks for PingOne and Google BigQuery.
-
Create API-Connected Dashboards in Grafana
Connect to API Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to API.
-
Automate Sybase IQ Data Replication to Azure Data Lake
Use CData Sync to customize and automate Sybase IQ replication to Azure Data Lake.
-
Automated Continuous Box Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Box replication to Google Cloud SQL.
-
Integrate Live Adobe Analytics Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Adobe Analytics to Blue Prism using the CData ODBC Driver for Adobe Analytics to create automated workflows for repetitive business tasks.
-
Analyze Google Drive Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Google Drive from Power Pivot. You will use the Table Import Wizard to load Google Drive. You can visually build the import query or use any SQL supported by the driver.
-
How to Work with PostgreSQL Data in ETL Validator JDBC
Connect to PostgreSQL from ETL Validator jobs using the CData Software JDBC Driver.
-
Replicate Coinbase Data in Heroku for Use in Salesforce Connect
Replicate Coinbase to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to create Visio diagrams from Xero Data
Automatically update Xero Accounting with the changes you make to Visio master shapes.
-
How to Work with PhantomBuster Data in AWS Glue Jobs Using JDBC
Connect to PhantomBuster from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.