CData Software - Knowledge Base
Recent Articles
-
Connect to Redshift Data as a SQL Server Linked Server
Use CData Connect AI to create a linked server for live Redshift data.
-
How to Use a Microsoft Access Database to Update SAP Concur Data in Real Time
Update SAP Concur data by creating a linked table in Microsoft Access with the CData SAP Concur ODBC Driver.
-
Use CData Connect AI to Access MongoDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live MongoDB data in the Power Pivot business intelligence tool.
-
Connect to BigCommerce Data from Filemaker Pro (Mac)
Use CData Connect AI to connect to and query live BigCommerce data from Filemaker Pro on Mac.
-
Connect to Live Salesforce Marketing Data in PostGresSQL Interface through CData Connect AI
Create a live connection to Salesforce Marketing in CData Connect AI and connect to your Salesforce Marketing data from PostgreSQL.
-
How to Connect to Live Excel Online Data from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Excel Online data for you.
-
Query Redis Data in DataGrip
Create a Data Source for Redis in DataGrip and use SQL to query live Redis data.
-
Integrate Live Parquet Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Parquet data to Blue Prism using the CData ODBC Driver for Parquet to create automated workflows for repetitive business tasks.
-
Build Charts with Mode Data in Clear Analytics
Create dynamic charts and perform analytics based on Mode data in Clear Analytics.
-
Using the CData Software ODBC Driver for GitLab in PyCharm
Connect to GitLab as an ODBC data source in PyCharm using the CData Software ODBC Driver for GitLab.
-
Build Semantic Layer Views for Greenhouse Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Greenhouse data.
-
How to Query Live Workday Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Workday data data in natural language using Python.
-
Access Google Cloud Storage Data from MySQL in PHP
Connect to Google Cloud Storage through the standard MySQL libraries in PHP.
-
Build a Singer.io Tap for Teamgate With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Teamgate data using the CData Python Connector.
-
Moving Data from Printify to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Printify data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Visualize Smartsheet Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Smartsheet data.
-
Analyze Planio Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Planio data in Microsoft R Open.
-
Connect to Excel Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital's low-code cloud native platform RunMyProcess's DigitalSuite EnterpriseConnect (DSEC) to connect to Excel.
-
Connect to Oracle Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Oracle Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Integrate Freshteam Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Freshteam data from Informatica Cloud.
-
Getting Started with the CData SSIS Components for SAS Data Sets
Complete guide to installing, licensing, and connecting with the CData SSIS Components for SAS Data Sets.
-
How to update Spark from Excel
This article explains how to transfer data from Excel to Spark using the Excel Add-In for Spark.
-
ETL FreshBooks in Oracle Data Integrator
This article shows how to transfer FreshBooks data into a data warehouse using Oracle Data Integrator.
-
Visualize Salesforce CRM Analytics Data in TIBCO Spotfire through OData
Integrate Salesforce CRM Analytics data into dashboards in TIBCO Spotfire.
-
Access Live Klaviyo Data in Excel (Desktop) via Connect AI
Use CData Connect AI to gain access to live Klaviyo data from your Excel spreadsheets.
-
Prepare, Blend, and Analyze Aha! Data in Alteryx Designer (ODBC)
Build workflows to access live Aha! data for self-service data analytics.
-
Connect and Query Live WordPress Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live WordPress data into Databricks and enable direct, live querying and analysis without replication.
-
Automated Continuous Kintone Replication to PostgreSQL
Use CData Sync for automated, continuous, customizable Kintone replication to PostgreSQL.
-
Connect to Azure Data Lake Storage from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Azure Data Lake Storage data, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Create Perplexity-Connected Dashboards in Grafana
Connect to Perplexity Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Perplexity data.
-
Use CData Connect AI to Access HubDB Data in Microsoft Power Pivot
Use CData Connect AI to connect to live HubDB data in the Power Pivot business intelligence tool.
-
Replicate Multiple RabbitMQ Accounts via the CData Sync CLI
Replicate multiple RabbitMQ accounts to one or many databases.
-
Connecting Agentforce with Avro Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Agentforce to securely read and take actions on your Avro data for you.
-
Integrate Dify with Live BenchmarkEmail Data via CData Connect AI
Use the CData Connect AI Remote MCP Server to enable Dify agents and workflows to securely access and query live BenchmarkEmail data.
-
Work with Live Lakebase Data in Power Query
Use CData Connect AI to connect to Lakebase data and work with live Lakebase data in Microsoft Power Query.
-
How to connect PolyBase to FreeAgent
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live FreeAgent data.
-
Automate Amazon Marketplace Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Amazon Marketplace data from PowerShell? This article demonstrates how to utilize the Amazon Marketplace Cmdlets for tasks like connecting to Amazon Marketplace data, automating operations, downloading data, and more.
-
How to Work with Avaza Data in AWS Glue Jobs Using JDBC
Connect to Avaza from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Operational Reporting on Act-On Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Act-On data.
-
Access Live Azure Data Lake Storage Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Azure Data Lake Storage data from your Google Sheets.
-
How to Build an ETL App for Acumatica Data in Python with CData
Create ETL applications and real-time data pipelines for Acumatica data in Python with petl.
-
A PostgreSQL Interface for ConvertKit Data (MySQL Remoting via JDBC)
Use the Remoting features of the ConvertKit JDBC Driver to create a PostgreSQL entry-point for data access.
-
Query Tickspot Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Tickspot data from Node.js.
-
Creating ZohoMarketingHub-Connected Applications in Unqork
You can use CData Connect AI to feed ZohoMarketingHub data to Unqork and build custom business apps.
-
Stream ConvertKit Data into Apache Kafka Topics
Access and stream ConvertKit data in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Automated Continuous Rootly Replication to MySQL
Use CData Sync for automated, continuous, customizable Rootly replication to MySQL.
-
Create Google Analytics-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to Google Analytics Data from OutSystems and build custom enterprise apps using live Google Analytics data.
-
Connect to and Visualize Live Bannerbear Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Bannerbear data.
-
How to Build an ETL App for Clockify Data in Python with CData
Create ETL applications and real-time data pipelines for Clockify data in Python with petl.
-
Back Up GetResponse data 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 GetResponse data data.
-
Automate Salesloft Data Replication to SAP HANA
Use CData Sync to customize and automate Salesloft data replication to SAP HANA.
-
Connect to Harvest 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 Harvest and work with Harvest data in your FileMaker application.
-
Access Live Act CRM Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Act CRM data into the statistical analysis tools available in SAS JMP. This article shows how to use Act CRM data in the Graph Builder and Query Builder.
-
Migrating data from Mode to Databricks using CData SSIS Components.
Easily push Mode data to Databricks using the CData SSIS Tasks for Mode and Databricks.
-
How to Connect the Power BI Service to Teamwork: Complete Guide
Connect to the CData Software Power BI Connector for Teamwork from PowerBI.com to provide real-time Teamwork data across the organization.
-
Use the CData Software JDBC Driver for Jodoo in MicroStrategy Desktop
Connect to Jodoo data in MicroStrategy Desktop using the CData Software JDBC Driver for Jodoo.
-
How to Connect SharePoint 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 SharePoint data in real time using natural language.
-
Integrating LlamaIndex with Sybase IQ Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Sybase IQ data in real time.
-
Build Zoom-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Zoom Data from Zoho Analytics and import live Zoom data.
-
Analyze Live Workday Data in SAS Viya
Use CData Connect AI to connect to Workday data from SAS Viya and deploy self-service analytics using live Workday data.
-
Replicate PhantomBuster Data in Heroku for Use in Salesforce Connect
Replicate PhantomBuster data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
How to Connect Flowise AI Agents to Live ZohoMarketingHub 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 ZohoMarketingHub data without replication.
-
JDBC-ODBC Bridge Reporting in OBIEE with the JDBC-ODBC Bridge JDBC Driver
Deploy the JDBC-ODBC Bridge JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to Build an ETL App for MarkLogic Data in Python with CData
Create ETL applications and real-time data pipelines for MarkLogic data in Python with petl.
-
Use CData Connect AI to Access Sage 200 Data in Microsoft Power Pivot
Use CData Connect AI to connect to live Sage 200 data in the Power Pivot business intelligence tool.
-
Connect to AfterShip Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for AfterShip data.
-
Replicate Multiple HDFS Accounts
Replicate multiple HDFS accounts to one or many databases.
-
Manage MailerSend Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for MailerSend.
-
How to create an RPA flow for Wrike Data in UiPath Studio
Use the Wrike ODBC Driver to create workflows that access real-time Wrike data without any coding.
-
Deploy the ADO.NET Provider for NASA on an SSRS Report Server
Connect to NASA data 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.
-
DataBind Controls to Blackbaud FE NXT Data in Delphi
DataBind to Blackbaud FE NXT data in Delphi with standard data access components and controls.
-
How to Connect to Live WooCommerce Data in n8n Workflows and Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable n8n to securely read and take actions on your WooCommerce data for you.
-
Back Up Acumatica data to SQL Server through SSIS
Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Acumatica. In this article, we will employ an SSIS workflow to populate a database with Acumatica data data.
-
Replicate Mouseflow Data to Multiple Databases via the CData Sync CLI
Replicate Mouseflow data to disparate databases with a single configuration.
-
Build Quickbase-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Quickbase Data from Zoho Analytics and import live Quickbase data.
-
Connect to Paddle Data from a Connection Pool in JBoss
Integrate Paddle data into Java servlets: Use the Management Console in JBoss to install the Paddle JDBC Driver.
-
Access Live SendPulse Data in Emergent via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Emergent agents to securely access and build applications with live SendPulse data through MCP integration.
-
Connect to Customer.io Data from a Connection Pool in Jetty
The Customer.io JDBC Driver supports connection pooling: This article shows how to connect faster to Customer.io data from Web apps in Jetty.
-
Integrate Cline with Live ZohoDesk Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live ZohoDesk data from within your IDE.
-
Migrating data from OneNote to Google BigQuery using CData SSIS Components.
Easily push OneNote data to Google BigQuery using the CData SSIS Tasks for OneNote and Google BigQuery.
-
Use Dash to Build Web Apps on Oracle HCM Cloud Data via CData Connect AI
Build interactive Dash web apps on live Oracle HCM Cloud data using pandas and the CData Connect AI Python SDK.
-
Aweber Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Aweber facts in real time.
-
Replicate Spotify Data in Heroku for Use in Salesforce Connect
Replicate Spotify data to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Aweber Data in Google Apps Script via Connect AI
Use CData Connect AI to access Aweber data in Google Apps Script.
-
Use the CData Software JDBC Driver for Everhour in MicroStrategy Web
Connect to Everhour data in MicroStrategy Web using the CData Software JDBC Driver for Everhour.
-
Connect to Live SFTP Data in MicroStrategy through CData Connect AI
Create a live connection to SFTP Data in CData Connect AI and connect to your SFTP data from MicroStrategy.
-
How to Build an ETL App for Todoist Data in Python with CData
Create ETL applications and real-time data pipelines for Todoist data in Python with petl.
-
Integrate Live Airtable Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Airtable from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Airtable data.
-
How to connect to Harvest Data with Squirrel SQL client
Connect to Harvest data and execute queries in the Squirrel SQL Client.
-
Connect Box to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Box with IBM WebSphere for seamless data integration and connectivity.
-
Use the CData Software JDBC Driver for Azure Analysis Services in MicroStrategy Desktop
Connect to Azure Analysis Services data in MicroStrategy Desktop using the CData Software JDBC Driver for Azure Analysis Services.
-
Visualize Live SAP HANA XS Advanced Data in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live SAP HANA XS Advanced data into custom reports in Power BI.
-
Connect to EnterpriseDB from Asprova with CData Software ODBC Driver for EnterpriseDB
This article shows how to connect faster to EnterpriseDB data from Asprova.
-
Connect Retently to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Retently with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous SAP Fieldglass Replication to Oracle
Use CData Sync for automated, continuous, customizable SAP Fieldglass replication to Oracle.
-
Build Jumpseller-Connected Apps in Choreo
Use CData Connect AI to connect to Jumpseller Data from Choreo and build custom apps using live Jumpseller data.
-
Integrate Live Cloudflare Data into Blue Prism for Intelligent Robotic Process Automation (RPA)
Connect live Cloudflare data to Blue Prism using the CData API Driver for ODBC to create automated workflows for repetitive business tasks.
-
LINQ to Tavily 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 Tavily Data Provider.
-
Access Live Workday Data in Excel 365 Online (Excel for the web)
Connect to Workday data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Build Automated Aweber-Connected Workflows in Zapier
Use CData Connect AI to connect to live Aweber data and build automated workflows in Zapier.