CData Software - Knowledge Base
Recent Articles
-
How to connect to Insightly Data from Spring Boot
Connect to Insightly in a Spring Boot Application using the CData API Driver for JDBC
-
Integrate Live Power BI XMLA Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Use the CData Software JDBC Driver for Shippo in MicroStrategy Desktop
Connect to Shippo in MicroStrategy Desktop using the CData Software JDBC Driver for Shippo.
-
Build MVC Applications with Connectivity to Unbounce Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Unbounce from an ASP.NET MVC application.
-
Building Dynamic Web Pages with SAP SuccessFactors LMS Data Using AngularJS
Create single-page applications with live connectivity to SAP SuccessFactors LMS using the CData API Server.
-
Connect and Query Live GitHub Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live GitHub into Databricks
-
Moving Data from Mistral AI to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Mistral AI data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Use Grok to Talk to Your Neo4J Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Grok AI to securely answer questions and take actions on your Neo4J for you.
-
Integrating Antigravity CLI with Vercel via CData CLI
Connect Vercel to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Automated Continuous FHIR Replication to SQL Server
Use CData Sync for automated, continuous, customizable FHIR replication to SQL Server.
-
Connect to Avro Data in CloverDX (formerly CloverETL)
Transfer Apache Avro using the visual workflow in the CloverDX data integration tool.
-
Analyze AdRoll Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze AdRoll in Microsoft R Open.
-
Migrating data from Impala to Snowflake using CData SSIS Components.
Easily push Apache Impala to Snowflake using the CData SSIS Tasks for Impala and Snowflake.
-
Integrating Cursor CLI with AfterShip 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.
-
Integrate with SAP Fieldglass Data in JReport Designer
Create charts and reports based on SAP Fieldglass in JReport Designer.
-
Integrating Gumloop with BigCommerce Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on BigCommerce within automated workflows.
-
How to connect to Factorial Data from IntelliJ
Integrate connectivity to Factorial with wizards in IntelliJ.
-
How to use SQLAlchemy ORM to access SAP Ariba Procurement Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Ariba Procurement.
-
Feed Salesforce Data 360 Data into FineReport
How to set Salesforce Data 360 as a JDBC data source in FineReport.
-
Connect to Impala Data from PowerBuilder via ADO.NET
This article demonstrates how to access Apache Impala from Appeon PowerBuilder using the CData ADO.NET Provider for Impala.
-
Getting Started with the CData ADO.NET Provider for Zoho Projects
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Zoho Projects.
-
How to Query Live Adobe Experience Manager Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Adobe Experience Manager data in natural language using Python.
-
Access Live SQL Analysis Services Data in Coginiti Pro
Connect to and query live SQL Analysis Services from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live ZendeskSell Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ZendeskSell in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Edit and Search External QuickBooks Online Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of QuickBooks Online to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create QuickBooks Online Data objects that you can access from apps and the dashboard.
-
Working with Oracle HCM Cloud Data in LINQPad
Execute LINQ queries to Oracle HCM Cloud in LINQPad.
-
Integrate Live SAS Data Sets Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to Query Rebilly Data in MySQL Workbench
Execute MySQL queries against live Rebilly from MySQL Workbench.
-
Build Apps with Live Xero Data Using the Low-Code Development Platform of Mendix
Connect Xero Accounting with Mendix to build apps using the CData JDBC Driver for Xero.
-
Excel Spreadsheet Automation on Avaza Data with the QUERY Formula
Pull data from Avaza, automate spreadsheets, and more with the QUERY formula.
-
Working with Google Sheets Data in LINQPad
Execute LINQ queries to Google Sheets in LINQPad.
-
Create HubSpot-Connected Enterprise Applications in OutSystems
Use CData Connect AI to connect to HubSpot Data from OutSystems and build custom enterprise apps using live HubSpot.
-
How to Connect to & Open Elorus Data in Microsoft Excel
This article uses the CData ODBC driver for Elorus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Viewing Jira Assets Data in RAD Studio Data Explorer
How to view Jira Assets in RAD Studio Data Explorer using the CData ODBC Driver for Jira Assets.
-
Create Power BI Reports on Real-Time Discord Data
Use the CData ODBC Driver for Discord to visualize Discord in Power BI Desktop.
-
Connect and Query Live Zoho Projects Data in Databricks with CData Connect AI
Use CData Connect AI to integrate live Zoho Projects into Databricks
-
Connect to Pinterest Data from PowerBuilder via JDBC
This article demonstrates how to access Pinterest from PowerBuilder using the Pinterest JDBC Driver.
-
Build Act CRM-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Act CRM.
-
Establish a Live Connection with Oracle Eloqua Data using Tableau Bridge
The CData ODBC Driver for Oracle Eloqua enables you to integrate live Oracle Eloqua into Tableau Cloud dashboards using the Tableau Bridge.
-
Query Zuora Data from Node.js
Use the OData endpoint of the CData API Server to connect to your Zuora and perform CRUD operations on Zuora from Node.js.
-
Analyze Live MailChimp Data in SAS Viya
Use CData Connect AI to connect to MailChimp from SAS Viya and deploy self-service analytics using live MailChimp.
-
Access Live Raisers Edge NXT Data in AWS Lambda
Connect to live Raisers Edge NXT in AWS Lambda using the CData JDBC Driver.
-
Seamlessly Bring Google Directory Data into Retool Using CData Connect AI
Integrate Google Directory data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Replicate Landbot Data from PowerShell
Write a quick PowerShell script to query Landbot. Use connectivity to the live data to replicate Landbot to SQL Server.
-
How to integrate Metabase with MarkLogic Data
Use CData Connect AI to connect to live MarkLogic and create an interactive dashboard in Metabase from MarkLogic.
-
Automate Google Spanner Data Replication to Azure Data Lake
Use CData Sync to customize and automate Google Spanner replication to Azure Data Lake.
-
Build a Simple VCL Application for ServiceNow Data
How to build a simple VCL Application to view ServiceNow in RAD Studio using the CData ODBC Driver for ServiceNow.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Authorize.Net
Provide connectivity to Authorize.Net through an SAP BusinessObjects universe.
-
Model, Search, and Visualize Live Couchbase Data in ThoughtSpot
Use CData Connect AI to connect to live Couchbase for modeling, searching, and visualizing.
-
Import Real-Time Smartsheet Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Smartsheet in ColdFusion.
-
Automated Continuous HCL Domino Replication to SingleStore
Use CData Sync for automated, continuous, customizable HCL Domino replication to SingleStore.
-
Connect to Demio Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Demio.
-
Provide OData Services of Microsoft Ads Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Microsoft Ads by developing a WCF Service Application.
-
Connect to Elasticsearch Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Elasticsearch using standard SQL.
-
How to Work with Reply.io Data in ETL Validator JDBC
Connect to Reply.io from ETL Validator jobs using the CData Software JDBC Driver.
-
Analyze Acumatica Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Acumatica from Power Pivot. You will use the Table Import Wizard to load Acumatica ERP. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Couchbase Data in Excel for the Web (Excel 365/Online) through Connect Spreadsheets
Connect to Couchbase from Excel 365 Online (Excel for the web) with Connect Spreadsheets.
-
Extend Google Sheets with Outreach.io Data
Make calls to Outreach.io from Google Apps Script via the API Server.
-
Replicate Multiple Office 365 Accounts
Replicate multiple Office 365 accounts to one or many databases.
-
Connect to Gmail in SpagoBI
Create reports featuring live Gmail in SpagoBI Studio. Host Gmail reports on SpagoBI Server.
-
Connect to Microsoft Planner Data as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live Microsoft Planner.
-
Connect to FTP Data in ACL Analytics
Connect to FTP Servers via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to FTP Servers.
-
Automated Continuous Google Analytics Replication to SQL Server
Use CData Sync for automated, continuous, customizable Google Analytics replication to SQL Server.
-
Write a Simple Go Application to work with SAP Fieldglass Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SAP Fieldglass.
-
Integrate Live Slack Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Slack from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Slack.
-
LINQ to Greenhouse 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 Greenhouse Data Provider.
-
How to import OData Services into Apache Solr
Use the CData Software JDBC Driver for OData in Data Import Handler and create an automated import of OData to Apache Solr Enterprise Search platform.
-
Connect to Harvest Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Harvest and the SQL Gateway to access Harvest from Google Apps Script.
-
Connect to Factorial Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Factorial.
-
Access Live ConvertAPI Data in AWS Lambda (with IntelliJ IDEA)
Connect to live ConvertAPI in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Tanda Reporting in OBIEE with the Tanda JDBC Driver
Deploy the Tanda JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Use the CData Software JDBC Driver for PingOne in MicroStrategy Desktop
Connect to PingOne in MicroStrategy Desktop using the CData Software JDBC Driver for PingOne.
-
Query Anaplan Data as a MySQL Database in Node.js
Execute MySQL queries against Anaplan from Node.js.
-
Import Real-Time Oracle Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Oracle Database in ColdFusion.
-
Publish Reports with Procore Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Procore.
-
How to load ADP data into Elasticsearch via Logstash
Introducing a simple method to load ADP data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Use the CData Software JDBC Driver for Mixpanel in MicroStrategy Desktop
Connect to Mixpanel in MicroStrategy Desktop using the CData Software JDBC Driver for Mixpanel.
-
How to Import Data from Zendesk into Google Sheets
Import Zendesk into a Google spreadsheet that is automatically refreshed.
-
How to Connect to Live Google Analytics Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Google Analytics for you.
-
Connect to Impala Data in Aqua Data Studio
Access Apache Impala from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Automated Continuous Helpscout Replication to SingleStore
Use CData Sync for automated, continuous, customizable Helpscout replication to SingleStore.
-
Consume Sage 300 OData Feeds in PowerBuilder
This article demonstrates how to consume Sage 300 as OData feeds from PowerBuilder using the API Server.
-
Connect to EmailOctopus Data in CloverDX (formerly CloverETL)
Transfer EmailOctopus using the visual workflow in the CloverDX data integration tool.
-
Query Accelo Data in ColdFusion
Write standard ColdFusion data access code to connect to Accelo.
-
Seamlessly Bring Zoho Creator Data into Retool Using CData Connect AI
Integrate Zoho Creator data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Automate Teradata Data Replication to Azure Synapse
Use CData Sync to customize and automate Teradata replication to Azure Synapse.
-
Connect to Scrapfly Data as an External Source in Dremio
Use the CData JDBC Driver to connect to Scrapfly as an External Source in Dremio.
-
Manage HubDB Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HubDB.
-
Integrate Workday Data into Power Automate Desktop using CData Connect
CData Connect for Workday Data enables you to integrate Workday into workflows built using Microsoft Power Automate Desktop.
-
How to publish and share Jodoo Data dashboards with Tableau Server
The CData ODBC driver for Jodoo enables you integrate Jodoo into Tableau dashboards.
-
Getting Started with the CData Python Connector for Mocean
Learn to install and license the CData Python Connector
-
Build Charts with Reply.io Data in Clear Analytics
Create dynamic charts and perform analytics based on Reply.io in Clear Analytics.
-
Work with SAP Business One Data in FoxPro
Load SAP Business One into a FoxPro database. This article includes full code and a walk-through of the process.
-
Analyze Campaigner Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Campaigner in Microsoft R Open.
-
Integrating LangChain with Act CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LangChain agents to securely access and act on Act CRM within automated workflows.
-
Provide OData Services of Workday Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Workday by developing a WCF Service Application.
-
Integrating Kiro CLI with Redis 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.
-
Viewing Mixpanel Data in RAD Studio Data Explorer
How to view Mixpanel in RAD Studio Data Explorer using the CData ODBC Driver for Mixpanel.
-
Use the CData ODBC Driver for XML in Microsoft Power Query
You can use the CData XML ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import XML Files into Microsoft Power Query.
-
Automate Vercel Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Vercel from PowerShell? This article demonstrates how to utilize the Vercel Cmdlets for tasks like connecting to Vercel, automating operations, downloading data, and more.