CData Software - Knowledge Base
Recent Articles
-
Build Data Flows from eBay to SQL Server using SSIS
Easily back up eBay data to SQL Server using the SSIS components for eBay.
-
Connect to Presto Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Presto Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Migrating data from Couchbase to Google BigQuery using CData SSIS Components.
Easily push Couchbase data to Google BigQuery using the CData SSIS Tasks for Couchbase and Google BigQuery.
-
How to work with BambooHR Data in Apache Spark using SQL
Access and process BambooHR Data in Apache Spark using the CData Software JDBC Driver.
-
Getting Started with the CData Tableau Connector for Elorus
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
ChargeOver Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on ChargeOver facts in real time.
-
Analyze Adobe Commerce Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Adobe Commerce data with the CData JDBC Driver for Adobe Commerce.
-
Use Biml to Build SSIS Tasks to Replicate Asana Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Asana data to SQL Server.
-
How to Create Power BI Visual Reports with Real-Time Placid Data
Use CData Power BI Connectors to visualize Placid data in Power BI.
-
Automated Continuous PostgreSQL Replication to Snowflake
Use CData Sync for automated, continuous, customizable PostgreSQL replication to Snowflake.
-
Build Microsoft Teams-Connected Apps in Choreo
Use CData Connect AI to connect to Microsoft Teams Data from Choreo and build custom apps using live Microsoft Teams data.
-
Connect to Cosmos DB Data from HeidiSQL
Use CData Connect AI to connect to and query live Cosmos DB data from HeidiSQL.
-
Use the CData Software ODBC Driver for Spotify in SAS for Real-Time Reporting and Analytics
Connect to real-time Spotify data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Spotify.
-
Integrate Cline with Live SendGrid Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live SendGrid data from within your IDE.
-
Snowflake Drivers: How to Setup and Use OAuth Authentication
A guide on configuring OAuth authentication in Snowflake and using OAuth authentication with CData Snowflake solutions.
-
Build ZohoPeople-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live ZohoPeople data.
-
Visualize Microsoft Ads 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 Microsoft Ads data into TIBCO Spotfire.
-
Connect to Accelo 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 Accelo and work with Accelo data in your FileMaker application.
-
Write a Simple Go Application to work with Clari Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Clari data.
-
Query Sendwithus Data as a MySQL Database in Node.js
Execute MySQL queries against Sendwithus data from Node.js.
-
Create Google Spanner-Connected Applications in Appsmith
Connect to Google Spanner Data via CData Connect AI in Appsmith and create custom business applications with real-time access to Google Spanner data.
-
Prepare, Blend, and Analyze SendGrid Data in Alteryx Designer (ODBC)
Build workflows to access live SendGrid data for self-service data analytics.
-
Access Live Monday.com 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 Monday.com data through MCP integration.
-
Automated Continuous QuickBooks Online Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable QuickBooks Online data replication to OneLake in Microsoft Fabric.
-
Build Cvent-Connected Apps in Mendix
Use CData Connect AI to create an OData feed for Cvent Data and create custom apps in Mendix.
-
Visualize Live Pipedrive Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Pipedrive data using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate with Live CouchDB Data in MuleSoft (via CData Connect AI)
Use CData Connect AI to connect to CouchDB from the MuleSoft Anypoint Platform to integrate live CouchDB data into custom reports and dashboards.
-
Query Foursquare Data in DataGrip
Create a Data Source for Foursquare in DataGrip and use SQL to query live Foursquare data.
-
Automated Continuous API Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable API data replication to OneLake in Microsoft Fabric.
-
Use Claude to Talk to Your SharePoint Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your SharePoint data for you.
-
Connect to ConstantContact Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for ConstantContact data.
-
Automated Continuous Dynamics CRM Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable Dynamics CRM replication to delimited files (CSV/TSV).
-
Build an OLAP Cube in SSAS from FTP Data
Establish a connection to FTP data data from SQL Server Analysis Services, and use the FTP Data Provider to build OLAP cubes for use in analytics and reporting.
-
Visualize Google Forms Data in Tableau
The CData ODBC driver for Google Forms enables you integrate Google Forms data into Tableau dashboards.
-
How to Visualize Blackbaud FE NXT 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 Blackbaud FE NXT data in Python.
-
How to Connect Odoo Data to Gemini Enterprise via CData Connect AI
Connect CData Connect AI Remote MCP to Gemini Enterprise to securely read and take actions on live Odoo data in real time using natural language.
-
Query CockroachDB Data as a SQL Server Database in Node.js
Execute SQL Server queries against CockroachDB data from Node.js.
-
Connect to Live PolarTeamPro Data in PostGresSQL Interface through CData Connect AI
Create a live connection to PolarTeamPro in CData Connect AI and connect to your PolarTeamPro data from PostgreSQL.
-
Automated Continuous Aweber Replication to MySQL
Use CData Sync for automated, continuous, customizable Aweber replication to MySQL.
-
Create Strava Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Strava from PowerBI.com to create Power BI Dataflows with real-time data.
-
Automated Continuous Stripe Data Replication to OneLake in Microsoft Fabric
Use CData Sync for automated, continuous, customizable Stripe data replication to OneLake in Microsoft Fabric.
-
Connect to Real-Time Kintone Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Kintone and Dataflow to import and use Kintone data in Power Apps.
-
Integrate Open WebUI with Live Oracle Financials Cloud Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Open WebUI to securely access and query live Oracle Financials Cloud data from within the chat interface.
-
Create Datasets from Google Sheets in Domo Workbench and Build Visualizations of Google Sheets Data in Domo
Use the CData Software ODBC Driver for Google Sheets to create datasets from Google Sheets data in Domo Workbench and then build visualizations in the Domo service.
-
Automated Continuous OneNote Replication to SQLite
Use CData Sync for automated, continuous, customizable OneNote replication to SQLite.
-
Connect Excel to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Excel with IBM WebSphere for seamless data integration and connectivity.
-
ShipEngine Reporting in OBIEE with the ShipEngine JDBC Driver
Deploy the ShipEngine JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Connect to and Query Front Data in QlikView over ODBC
Create data visualizations with Front data in QlikView.
-
Replicate PagerDuty Data to Multiple Databases via the CData Sync CLI
Replicate PagerDuty data to disparate databases with a single configuration.
-
HubSpot Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on HubSpot facts in real time.
-
Provide OData Services of Act-On Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Act-On data by developing a WCF Service Application.
-
How to import Okta Data into Apache Solr
Use the CData Software JDBC Driver for Okta in Data Import Handler and create an automated import of Okta data to Apache Solr Enterprise Search platform.
-
Query Trello Data as a SQL Server Database in Node.js
Execute SQL Server queries against Trello data from Node.js.
-
Connect and Query Live Teradata Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Teradata data into Databricks and enable direct, live querying and analysis without replication.
-
Connect SAP HANA XS Advanced to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect SAP HANA XS Advanced with IBM WebSphere for seamless data integration and connectivity.
-
Analyze Raisers Edge NXT Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of Raisers Edge NXT data and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Integrate OpenCode with Live Reckon Accounts Hosted Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable OpenCode to securely access and query live Reckon Accounts Hosted data from within your AI coding agent.
-
How to Connect to Live Google Calendar Data in Mistral AI Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Mistral AI to securely access, query, and take action on live Google Calendar data without replication.
-
Visualize BigCommerce Data in TIBCO Spotfire through ADO.NET
Integrate BigCommerce data into dashboards in TIBCO Spotfire.
-
Create Reports from SuiteCRM Data in Looker Studio
Use CData Connect AI to gain access to live SuiteCRM data and create custom reports in Looker Studio.
-
How to publish and share Clio Data dashboards with Tableau Server
The CData ODBC driver for Clio enables you integrate Clio data into Tableau dashboards.
-
Automated Continuous SageHR Replication to Databricks
Use CData Sync for automated, continuous, customizable SageHR replication to Databricks.
-
Analyze Miro Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Miro data in Microsoft R Open.
-
Integrate Goose with Live Omnisend Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Goose to securely access and query live Omnisend data from within the local AI agent.
-
How to Connect to Live Oracle Financials Cloud Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live Oracle Financials Cloud data securely in real time.
-
Use the CData Software JDBC Driver for CircleCI in MicroStrategy
Connect to CircleCI data in MicroStrategy Developer using the CData Software JDBC Driver for CircleCI.
-
Integrating LlamaIndex with NetSuite SuiteAnalytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on NetSuite SuiteAnalytics data in real time.
-
Easily Integrate BigQuery Data in Lazarus Pascal IDE
Learn how to easily integrate live BigQuery data in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Create Data Visualizations in Cognos BI with Pushbullet Data
Access Pushbullet data as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Analyze Amazon Athena Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Amazon Athena from Power Pivot. You will use the Table Import Wizard to load Amazon Athena data. You can visually build the import query or use any SQL supported by the driver.
-
How to Create a Linked Server in AWS RDS for SQL Server
Learn how to create and use linked servers with AWS RDS for SQL Server, including limitations, stored procedure setup, and query examples.
-
Analyze ZohoMarketingHub Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze ZohoMarketingHub data in Microsoft R Open.
-
Create Perigon Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Perigon data access from reports, embedded analytics, and more.
-
Integrating LangGraph with Impala Data via CData Connect AI
Leverage CData Connect AI to enable LangGraph agents to securely access and act on Impala data within automated workflows.
-
Access GitLab Data from MySQL in PHP
Connect to GitLab through the standard MySQL libraries in PHP.
-
How to Create Power BI Visual Reports with Real-Time Zoom Data
Use CData Power BI Connectors to visualize Zoom data in Power BI.
-
How to connect to Hubstaff Data with Squirrel SQL client
Connect to Hubstaff data and execute queries in the Squirrel SQL Client.
-
Build Procore-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Procore data and build web apps with connectivity to live Procore data.
-
Build an OLAP Cube in SSAS from Hubstaff Data
Establish a connection to Hubstaff data data from SQL Server Analysis Services, and use the Hubstaff Data Provider to build OLAP cubes for use in analytics and reporting.
-
Migrating data from Teradata to Databricks using CData SSIS Components.
Easily push Teradata data to Databricks using the CData SSIS Tasks for Teradata and Databricks.
-
Connecting Moonlit Workflow with Quickbase Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your Quickbase data in real time.
-
Connect to LaunchDarkly Data in JRuby
Create a simple JRuby app with access to live LaunchDarkly data.
-
Automate Adobe Target Data Replication to Couchbase
Use CData Sync to Customize and automate Adobe Target data replication to Couchbase.
-
Integrating Cursor with Access 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.
-
Replicate Multiple Datadog Accounts via the CData Sync CLI
Replicate multiple Datadog accounts to one or many databases.
-
Automated Continuous Grafana Replication to AlloyDB
Use CData Sync for automated, continuous, customizable Grafana replication to AlloyDB.
-
Build Jira Assets-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Jira Assets data and build web apps with connectivity to live Jira Assets data.
-
Connect to Acumatica from Asprova with CData Software ODBC Driver for Acumatica
This article shows how to connect faster to Acumatica data from Asprova.
-
Connect to Klaviyo Data in Google Apps Script via Connect AI
Use CData Connect AI to access Klaviyo data in Google Apps Script.
-
How to connect to SendGrid Data from IntelliJ
Integrate connectivity to SendGrid data with wizards in IntelliJ.
-
Create a Data Access Object for Mailjet Data using JDBI
A brief overview of creating a SQL Object API for Mailjet data in JDBI.
-
Create IBM Informix-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to IBM Informix Data from OutSystems and build custom enterprise apps using live IBM Informix data.
-
Feed Vercel Data into FineReport
How to set Vercel data as a JDBC data source in FineReport.
-
Use the CData Software JDBC Driver for Oracle HCM Cloud in MicroStrategy Web
Connect to Oracle HCM Cloud data in MicroStrategy Web using the CData Software JDBC Driver for Oracle HCM Cloud.
-
How to Connect to & Open SAP Fieldglass Data in Microsoft Excel
This article uses the CData ODBC driver for SAP Fieldglass to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Connect to Bugsnag Data in DBArtisan
Use wizards in DBArtisan to configure Bugsnag data as a data source.
-
Connect to Real-Time SAP Netweaver Gateway Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for SAP Netweaver Gateway and Dataflow to import and use SAP Netweaver Gateway data in Power Apps.
-
Connect to CampaignMonitor Data in JRuby
Create a simple JRuby app with access to live CampaignMonitor data.
-
Connect to Foursquare Data in DBArtisan
Use wizards in DBArtisan to configure Foursquare data as a data source.
-
Analyze Oracle Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle data with the CData JDBC Driver for Oracle.