CData Software - Knowledge Base
Recent Articles
-
How to Query Live Azure Analysis Services Data in Perplexity MacOS Desktop
Connect to and query live Azure Analysis Services Data in Perplexity Desktop using CData MCP Server.
-
Model, Search, and Visualize Live Power BI XMLA Data in ThoughtSpot
Use CData Connect AI to connect to live Power BI XMLA for modeling, searching, and visualizing.
-
Automated Continuous Flowlu Replication to SQLite
Use CData Sync for automated, continuous, customizable Flowlu replication to SQLite.
-
ETL Teradata in Oracle Data Integrator
This article shows how to transfer Teradata into a data warehouse using Oracle Data Integrator.
-
Access Live Sybase IQ Data in TIBCO Data Virtualization
Use the Sybase IQ Tibco DV Adapter to create a Sybase IQ data source in TIBCO Data Virtualization Studio and gain access to live Sybase IQ from your TDV Server.
-
Use the CData Software ODBC Driver for Samanage in MicroStrategy
Connect to Samanage in MicroStrategy Developer using the CData Software ODBC Driver for Samanage.
-
Automated Continuous FreeAgent Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable FreeAgent replication to Azure SQL Database.
-
Import Oracle Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Oracle Database. In this article, you will use the OData format to import Oracle Database into Microsoft Power Query.
-
Integrate with live Redshift Data in Jitterbit
Use CData Connect AI to connect to and integrate live Amazon Redshift in Jitterbit.
-
How to use SQLAlchemy ORM to access Hugging Face Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Hugging Face.
-
Explore Geographical Relationships in Demio Data with Power Map
Create data visualizations with Demio in Power Map.
-
Connect to Delighted Data in Ruby
Connect to Delighted in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Analyze Yelp Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Yelp from Power Pivot. You will use the Table Import Wizard to load Yelp. You can visually build the import query or use any SQL supported by the driver.
-
How to Easily Query BigQuery Data in OpenOffice Base
Connect to BigQuery data in OpenOffice Base using the CData ODBC Driver for Google BigQuery and generate reports with live data insights.
-
Provide OData Services of Gumroad Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gumroad by developing a WCF Service Application.
-
Edit and Search Freshservice External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Freshservice to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Freshservice objects that you can access from apps and the dashboard.
-
LINQ to FormSite 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 FormSite Data Provider.
-
Access Live Square 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 Square through MCP integration.
-
Connect to PivotalTracker Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to PivotalTracker and work with PivotalTracker in your FileMaker applications.
-
How to Query Live Snowflake Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Snowflake data in natural language using Python.
-
Bridge Sugar CRM Connectivity with Apache NiFi
Access and process Sugar CRM in Apache NiFi using the CData JDBC Driver.
-
How to publish and share Hugging Face Data dashboards with Tableau Server
The CData ODBC driver for Hugging Face enables you integrate Hugging Face into Tableau dashboards.
-
Creating Google Spanner-Connected Applications in Unqork
You can use CData Connect AI to feed Google Spanner to Unqork and build custom business apps.
-
Automated Continuous Recurly Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Recurly replication to IBM DB2.
-
Integrate Cline with Live Marketo Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Cline to securely access and query live Marketo from within your IDE.
-
Use the CData Software ODBC Driver for SAP Business One in MicroStrategy Web
Connect to SAP Business One in MicroStrategy Web using the CData Software ODBC Driver for SAP Business One.
-
Connect to Grafana Data from PowerBuilder via JDBC
This article demonstrates how to access Grafana from PowerBuilder using the Grafana JDBC Driver.
-
Integrate Xero with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Xero with External Services.
-
Migrating data from NetSuite to Google BigQuery using CData SSIS Components.
Easily push NetSuite CRM & ERP to Google BigQuery using the CData SSIS Tasks for NetSuite and Google BigQuery.
-
Replicate Multiple Sybase Accounts via the CData Sync CLI
Replicate multiple Sybase accounts to one or many databases.
-
Integrate SendPulse Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live SendPulse from Informatica Cloud.
-
How to connect PolyBase to ZohoExpense
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live ZohoExpense.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Copper
Provide connectivity to Copper through an SAP BusinessObjects universe.
-
Query LaunchDarkly Data from Node.js
Use the OData endpoint of the CData API Server to connect to your LaunchDarkly and perform CRUD operations on LaunchDarkly from Node.js.
-
Use the CData Software JDBC Driver for Spark in MicroStrategy
Connect to Apache Spark SQL in MicroStrategy Developer using the CData Software JDBC Driver for Spark.
-
Automated Continuous Printify Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Printify replication to Google Cloud SQL.
-
Integrate with Instagram Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Instagram to a JSON file on disk.
-
How to connect Amazon QuickSight to Zoho Projects Data
Create a connection to Zoho Projects in CData Connect AI and insert Zoho Projects into Amazon QuickSight SPICE to build interactive dashboards.
-
How to load Rootly data into Elasticsearch via Logstash
Introducing a simple method to load Rootly data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Getting Started with the CData Excel Add-In for PolarTeamPro
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for PolarTeamPro.
-
Validate Scrapfly Data with QuerySurge
Access and validate Scrapfly in QuerySurge using the CData JDBC Driver.
-
Connect to Amazon Athena Data in Claris FileMaker Pro
Use the CData ODBC Driver for Amazon Athena in FileMaker Pro to connect to Amazon Athena and work with Amazon Athena in your FileMaker applications.
-
Build Dashboards with CSV Data in Dundas BI
Create dynamic dashboards and perform analytics based on CSV/TSV Files in Dundas BI.
-
Integrate with Acumatica Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Acumatica ERP in SnapLogic.
-
Replicate Workday Data to Multiple Databases via the CData Sync CLI
Replicate Workday to disparate databases with a single configuration.
-
Analyze Sugar CRM Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sugar CRM from Power Pivot. You will use the Table Import Wizard to load Sugar CRM. You can visually build the import query or use any SQL supported by the driver.
-
Publish Crystal Reports on Coda Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Coda.
-
How to Access Live Planio Data in Visual Studio Code via Cline
Run CData API Driver for MCP Server on Windows Subsytem for Linux (WSL) and connect to live Planio from the Cline extension in Visual Studio Code.
-
Explore Geographical Relationships in Facebook Data with Power Map
Create data visualizations with Facebook in Power Map.
-
How to Query Live Salesforce CRM Analytics Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Salesforce CRM Analytics data in natural language using Python.
-
Analyze Tavily Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Tavily in Microsoft R Open.
-
Build Google Contacts-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to Google Contacts Data from Zoho Analytics and import live Google Contacts.
-
Connect to Kintone Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with Kintone Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
Connect to PDFMonkey Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time PDFMonkey using standard SQL.
-
Create SSAS Tabular Models from Webex Data
How to build a SQL Server Analysis Service Tabular Model from Webex using CData drivers.
-
Automated Continuous DocuSign Replication to SQL Server
Use CData Sync for automated, continuous, customizable DocuSign replication to SQL Server.
-
Build a Singer.io Tap for Demio With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Demio data using
-
Connect to LeadDesk Data in HULFT Integrate
Connect to LeadDesk as a JDBC data source in HULFT Integrate
-
How to use SQLAlchemy ORM to access Planio Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Planio.
-
Integrating Cursor CLI with BenchmarkEmail 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.
-
Visualize Recurly Data in Tableau
The CData ODBC driver for Recurly enables you integrate Recurly into Tableau dashboards.
-
How to work with Odoo Data in Apache Spark using SQL
Access and process Odoo Data in Apache Spark using the CData Software JDBC Driver.
-
A PostgreSQL Interface for Attio Data using the CData ODBC Driver
Use the SQL Gateway and Attio ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to Query Live QuickBooks Data in Perplexity MacOS Desktop
Connect to and query live QuickBooks Data in Perplexity Desktop using CData MCP Server.
-
How to Work with Nethunt Data in AWS Glue Jobs Using JDBC
Connect to Nethunt from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Integrate with Exa Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Exa to a JSON file on disk.
-
Build Raisers Edge NXT-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for Raisers Edge NXT to explore live Raisers Edge NXT Data in Gemini Code Assist to assist with building Raisers Edge NXT-powered applications.
-
Analyze Sybase IQ Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Sybase IQ in Microsoft R Open.
-
Visualize Avaza Data in TIBCO Spotfire through OData
Integrate Avaza into dashboards in TIBCO Spotfire.
-
How to Access SendInBlue Data Using Entity Framework
This article shows how to access SendInBlue using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
How to publish and share Demio Data dashboards with Tableau Server
The CData ODBC driver for Demio enables you integrate Demio into Tableau dashboards.
-
Replicate Multiple Reckon Accounts via the CData Sync CLI
Replicate multiple Reckon accounts to one or many databases.
-
Use ChatGPT to Talk to Your Azure DevOps 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 Azure DevOps for you.
-
Visualize Live Google Drive Data in the Power BI Service
Use CData Connect AI to connect to live Google Drive and create custom reports in the Power BI Service through the On-Premises Gateway.
-
LINQ to QuickBooks 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 QuickBooks Data Provider.
-
Natively Connect to Parquet Data in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to Apache Parquet. Leverage the native support for ODBC in PHP.
-
Provide OData Services of Gorgias Data from a WCF Application
In this article, we will demonstrate the process of generating an OData feed for Gorgias by developing a WCF Service Application.
-
Integrate Bannerbear Data in the Pentaho Report Designer
Publish reports based on Bannerbear in the Pentaho BI tool.
-
Use the CData Software JDBC Driver for Square in MicroStrategy Desktop
Connect to Square in MicroStrategy Desktop using the CData Software JDBC Driver for Square.
-
Getting Started with the CData Tableau Connector for Helpscout
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
How to connect to Smartsheet Data from IntelliJ
Integrate connectivity to Smartsheet with wizards in IntelliJ.
-
Establish a Live Connection with Deel Data using Tableau Bridge
The CData ODBC Driver for Deel enables you to integrate live Deel into Tableau Cloud dashboards using the Tableau Bridge.
-
How to connect to Splunk Data from Spring Boot
Connect to Splunk in a Spring Boot Application using the CData JDBC Driver for Splunk
-
Connect to Authorize.Net Data in CloverDX (formerly CloverETL)
Transfer Authorize.Net using the visual workflow in the CloverDX data integration tool.
-
Visualize Google Ad Manager Data in Tableau
The CData ODBC driver for Google Ad Manager enables you integrate Google Ad Manager into Tableau dashboards.
-
Seamlessly Bring CouchDB Data into Retool Using CData Connect AI
Integrate CouchDB data into Retool with CData Connect AI to build smarter apps and streamline workflows with real-time data access.
-
Connect SpaceX to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live SpaceX using the CData Python MCP Server.
-
Integrating Kiro CLI with Gumroad 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.
-
Excel Spreadsheet Automation on Typeform Data with the QUERY Formula
Pull data from Typeform, automate spreadsheets, and more with the QUERY formula.
-
How to Connect to Live FHIR Data from crewAI Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable crewAI agents to securely read and take actions on your FHIR for you.
-
Automate Act-On Data Replication to SAP HANA
Use CData Sync to customize and automate Act-On replication to SAP HANA.
-
Model SAP HANA Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and SAP HANA, enabling the direct import of real-time SAP HANA.
-
GetResponse Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on GetResponse facts in real time.
-
Connect to WordPress Data from Crystal Reports
Use CData Connect AI to connect to and report on live WordPress from Crystal Reports.
-
Import Real-Time Asana Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Asana in ColdFusion.
-
Integrate LibreChat with Live Vault CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Veeva Vault & Vault CRM from within the chat interface.
-
Write a Simple Go Application to work with ShipEngine Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to ShipEngine.
-
How to connect to Google Campaign Manager 360 Data from IntelliJ
Integrate connectivity to Google Campaign Manager 360 with wizards in IntelliJ.
-
Replicate Salesloft Data to Multiple Databases
Replicate Salesloft to disparate databases with a point-and-click configuration.
-
How to Connect the Power BI Service to Planio: Complete Guide
Connect to the CData Software Power BI Connector for Planio from PowerBI.com to provide real-time Planio across the organization.