CData Software - Knowledge Base
Recent Articles
-
Create Data Visualizations Based On NetSuite SuiteAnalytics Data in Mode
Use CData Connect AI to connect to NetSuite SuiteAnalytics Data from Mode and build visualizations using live
-
Connect to Anaplan Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Anaplan as an External Source in Dremio.
-
Connect to Google Drive Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Google Drive as an External Source in Dremio.
-
Access Live Perigon Data in Coginiti Pro
Connect to and query live Perigon from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Connect to QuickBooks Online from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from QuickBooks Online, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Getting Started with the CData Python Connector for iContact
Learn to install and license the CData Python Connector
-
Operational Reporting on SageHR Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote SageHR.
-
Integrate Live Exact Online Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Exact Online and integrate live Exact Online into apps built in Microsoft Power Apps.
-
How to Work with Printful Data in ETL Validator JDBC
Connect to Printful from ETL Validator jobs using the CData Software JDBC Driver.
-
How to Connect the Power BI Service to HubDB: Complete Guide
Connect to the CData Software Power BI Connector for HubDB from PowerBI.com to provide real-time HubDB across the organization.
-
Connect NetSuite to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect NetSuite with IBM WebSphere for seamless data integration and connectivity.
-
Build an OLAP Cube in SSAS from JSON Services
Establish a connection to JSON data from SQL Server Analysis Services, and use the JSON Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrating Codex CLI with Azure Analysis Services 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 Twitter Ads with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate Twitter Ads with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to Twitter Ads.
-
How to Query Live eBay Analytics Data in Claude Desktop
Connect to and query live eBay Analytics Data in Claude Desktop using CData MCP Server.
-
How to Easily Query OData Services in OpenOffice Base
Connect to OData data in OpenOffice Base using the CData ODBC Driver for OData and generate reports with live data insights.
-
Connect to Tavily Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Tavily and work with Tavily in your FileMaker application.
-
ETL Printify in Oracle Data Integrator
This article shows how to transfer Printify into a data warehouse using Oracle Data Integrator.
-
Publish Vimeo-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Vimeo.
-
Connect to Zoom Data in Jaspersoft Studio
Execute SQL to remote Zoom in Jaspersoft Studio.
-
Connect to Lakebase Data from a Connection Pool in JBoss
Integrate Lakebase into Java servlets: Use the Management Console in JBoss to install the Lakebase JDBC Driver.
-
Use the CData Software ODBC Driver for Retently in MicroStrategy Desktop
Connect to Retently in MicroStrategy Desktop using the CData Software ODBC Driver for Retently.
-
Enable the Clari JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Clari.
-
Connect to Recurly Data from a Connection Pool in Jetty
The Recurly JDBC Driver supports connection pooling: This article shows how to connect faster to Recurly from Web apps in Jetty.
-
Connect to Gorgias Data in HULFT Integrate
Connect to Gorgias as a JDBC data source in HULFT Integrate
-
Write a Simple Go Application to work with HCL Domino Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to HCL Domino.
-
Use the CData Software JDBC Driver for SAP ByDesign in MicroStrategy
Connect to SAP Business ByDesign in MicroStrategy Developer using the CData Software JDBC Driver for SAP ByDesign.
-
Automate TaxJar Integration Tasks from PowerShell
Are you in search of a quick and easy way to access TaxJar from PowerShell? This article demonstrates how to utilize the TaxJar Cmdlets for tasks like connecting to TaxJar, automating operations, downloading data, and more.
-
Connect and Query Live MySQL Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live MySQL into Databricks
-
Connect to Google Drive Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Google Drive to connect to Google Drive and execute queries in PowerBuilder.
-
How to Seamlessly Import Microsoft Dataverse Data into IBM SPSS Modeler
Integrate Microsoft Dataverse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Use ChatGPT to Talk to Your Vertica Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable ChatGPT to securely answer questions and take actions on your Vertica for you.
-
Access Microsoft Exchange Data from MySQL in Amazon QuickSight
Connect to Microsoft Exchange and build visualizations of Microsoft Exchange using a MySQL Connection in Amazon QuickSight.
-
Use Dash to Build Web Apps on Freshdesk Data via CData Connect AI
Build interactive Dash web apps on live Freshdesk using pandas and the CData Connect AI Python SDK.
-
Use the CData Software ODBC Driver for SAP SuccessFactors LMS in MicroStrategy
Connect to SAP SuccessFactors LMS in MicroStrategy Developer using the CData Software ODBC Driver for SAP SuccessFactors LMS.
-
How to Query Salesloft Data in MySQL Workbench
Execute MySQL queries against live Salesloft from MySQL Workbench.
-
Create Informatica Mappings From/To an ODBC Data Source for Productboard
Create an ODBC connection to Productboard in Informatica and browse and transfer Productboard.
-
DataBind Controls to Onfleet Data in C++Builder
DataBind to Onfleet in C++Builder with standard components and controls.
-
Extract, Transform, and Load Google Translate Data in Informatica PowerCenter
Create a simple Workflow for Google Translate in Informatica PowerCenter.
-
Connect to Real-Time Presto Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Presto and Dataflow to import and use Presto in Power Apps.
-
Back Up Pipeline CRM to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData API Driver for ADO.NET. In this article, we will employ an SSIS workflow to populate a database with Pipeline CRM data.
-
Build Epicor Kinetic-Powered Applications in GitHub Copilot with CData MCP Server
Use the CData MCP Server for Epicor Kinetic to explore live Epicor Kinetic Data in GitHub Copilot to assist with building Epicor Kinetic-powered applications.
-
Connect to Clari Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Clari using standard SQL.
-
Easily Integrate ZeroBounce Data in Lazarus Pascal IDE
Learn how to easily integrate live ZeroBounce in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
LINQ to Google Tasks 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 Google Tasks Data Provider.
-
Connect Shopify Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Shopify using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Connect to PagerDuty Data as an External Source in Dremio
Use the CData JDBC Driver to connect to PagerDuty as an External Source in Dremio.
-
Connect to SuiteCRM Data in RapidMiner
Integrate SuiteCRM with standard components and data source configuration wizards in RapidMiner Studio.
-
Validate Slack Data with QuerySurge
Access and validate Slack in QuerySurge using the CData JDBC Driver.
-
Connect to Azure Analysis Services Data from PowerBuilder via JDBC
This article demonstrates how to access Azure Analysis Services from PowerBuilder using the Azure Analysis Services JDBC Driver.
-
Automated Continuous Highrise Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Highrise replication to Amazon S3.
-
Connect to Acumatica Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Integrate Cline with Live SQL Analysis Services Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SQL Analysis Services from within your IDE.
-
Configure a Solicit-Response Send Port for the CData BizTalk Adapter for Salesforce
Use the CData BizTalk Adapter for Salesforce with a solicit-response send port to execute updategrams and data manipulation SQL in BizTalk.
-
Connect to SAP Ariba Source Data in NetBeans
Connect to SAP Ariba Source in NetBeans with the data source configuration wizard.
-
LINQ to Parquet 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 Parquet Data Provider.
-
How to Connect to Live Microsoft OneDrive Data from Gemini CLI (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Gemini CLI to securely read and take actions on your Microsoft OneDrive for you.
-
How to connect and process BambooHR from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live BambooHR.
-
Connect to eBay Data in RapidMiner
Integrate eBay with standard components and data source configuration wizards in RapidMiner Studio.
-
How to Connect Flowise AI Agents to Live Excel Online 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 Microsoft Excel Online without replication.
-
Query Aha! Data in DataGrip
Create a Data Source for Aha! in DataGrip and use SQL to query live Aha!.
-
Connect to Salesforce Data 360 Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Salesforce Data 360.
-
Automate ZohoSubscriptions Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ZohoSubscriptions from PowerShell? This article demonstrates how to utilize the ZohoSubscriptions Cmdlets for tasks like connecting to ZohoSubscriptions, automating operations, downloading data, and more.
-
Connect to Amazon S3 Data from PowerBuilder via ADO.NET
This article demonstrates how to access Amazon S3 from Appeon PowerBuilder using the CData ADO.NET Provider for Amazon S3.
-
How to connect to Sage 200 Data from IntelliJ
Integrate connectivity to Sage 200 with wizards in IntelliJ.
-
Connect and Query Live Couchbase Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Couchbase into Databricks
-
Automated Continuous Azure Synapse Replication to Snowflake
Use CData Sync for automated, continuous, customizable Azure Synapse replication to Snowflake.
-
Trigger Elasticsearch IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Elasticsearch with standard wizards in Logic Apps.
-
Process & Analyze Moosend Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Moosend Data.
-
How to Visualize Microsoft OneDrive Data in Python with pandas via CData Connect AI
Use the CData Connect AI Python SDK with pandas and Matplotlib to analyze and visualize live Microsoft OneDrive in Python.
-
Automated Continuous ActiveCampaign Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable ActiveCampaign replication to Apache Kafka.
-
Automated Continuous Opsgenie Replication to SQLite
Use CData Sync for automated, continuous, customizable Opsgenie replication to SQLite.
-
Write a Simple Go Application to work with ChartMogul Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ChartMogul.
-
How to connect to XML Data from Spring Boot
Connect to XML in a Spring Boot Application using the CData JDBC Driver for XML
-
Establish a Live Connection with Asana Data using Tableau Bridge
The CData ODBC Driver for Asana enables you to integrate live Asana into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect PolyBase to ServiceDesk Plus
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ServiceDesk Plus.
-
Connect Aweber to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Aweber with IBM WebSphere for seamless data integration and connectivity.
-
Import Real-Time Spotify Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Spotify in ColdFusion.
-
Deploy the ADO.NET Provider for OpenWeatherMap on an SSRS Report Server
Connect to OpenWeatherMap 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.
-
Automated Continuous OneNote Replication to Snowflake
Use CData Sync for automated, continuous, customizable OneNote replication to Snowflake.
-
Build Microsoft Teams-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Microsoft Teams Data and create custom apps in Mendix.
-
Consume Zoho Inventory OData Feeds in SAP Lumira
Use the API Server to create data visualizations on Zoho Inventory feeds that reflect any changes in SAP Lumira.
-
Connect and Visualize Live Adobe Analytics Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Adobe Analytics into the Databricks platform and create visualization dashboards with real-time Adobe Analytics.
-
Create Informatica Mappings From/To a JDBC Data Source for Excel
Create Excel data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to Zoom Data Using the Script Function in Claris FileMaker Pro
Use the CData API Driver for ODBC and the Script function in FileMaker Pro to connect to Zoom and work with Zoom in your FileMaker application.
-
Connect to Slack Data from AWS Glue
Use CData Connect AI to gain access to live Slack from your AWS Glue jobs.
-
Analyze QuickBooks Time Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of QuickBooks Time and visualize live QuickBooks Time in Infragistics Reveal.
-
Create Datasets from Google Spanner in Domo Workbench and Build Visualizations of Google Spanner Data in Domo
Use the CData Software ODBC Driver for Google Spanner to create datasets from Google Spanner in Domo Workbench and then build visualizations in the Domo service.
-
Choosing the Best Method to Connect Paddle to SQL Server: 5 Options Explained
Discover multiple ways to connect and use Paddle from SQL Server, with ideal use cases for developers, SQL Server experts, SSIS users, and business users.
-
Integrate Zuora Data in Pentaho Data Integration
Build ETL pipelines based on Zuora in the Pentaho Data Integration tool.
-
Connect to CockroachDB Data in DBeaver
Use the CData ODBC Driver to connect to CockroachDB in DBeaver.
-
Access Avalara AvaTax Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Avalara AvaTax from your Oracle system.
-
Connect Freshteam Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Freshteam using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Build Visualizations of Flowlu Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Flowlu in Birst.
-
Access Live Neo4J Data in TIBCO Data Virtualization
Use the Neo4J Tibco DV Adapter to create a Neo4J data source in TIBCO Data Virtualization Studio and gain access to live Neo4J from your TDV Server.
-
Getting Started with the CData Tableau Connector for Excel
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for Excel.
-
Access Live OData Services in TIBCO Data Virtualization
Use the OData Tibco DV Adapter to create a OData data source in TIBCO Data Virtualization Studio and gain access to live OData from your TDV Server.
-
Connect to Mailjet Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Mailjet and work with Mailjet in your FileMaker applications.
-
Query Live Oracle Eloqua 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 Oracle Eloqua directly from the development environment.
-
Connect to and Query Paymo Data in QlikView over ODBC
Create data visualizations with Paymo in QlikView.