CData Software - Knowledge Base
Recent Articles
-
Manage Ontraport Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Ontraport.
-
Build an OLAP Cube in SSAS from Yelp Data
Establish a connection to Yelp data from SQL Server Analysis Services, and use the Yelp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Connect to DocuSign Data through External Services in Salesforce
Use CData Connect AI to securely connect Salesforce External Services with DocuSign Data using OpenAPI, exposing APIs to enable streamlined integration and secure, scalable, real-time data sharing across platforms.
-
How to connect and process Redis from Azure Databricks
Use CData, Azure, and Databricks to perform data engineering and data science on live Redis.
-
Add Google Calendar Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Google Calendar with the Informatica Enterprise Data Catalog to classify and organize data.
-
Connect to Real-Time PayPal Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for PayPal and Dataflow to import and use PayPal in Power Apps.
-
Build an OLAP Cube in SSAS from Strava Data
Establish a connection to Strava data from SQL Server Analysis Services, and use the Strava Data Provider to build OLAP cubes for use in analytics and reporting.
-
Use the CData Software JDBC Driver for Close in MicroStrategy
Connect to Close in MicroStrategy Developer using the CData Software JDBC Driver for Close.
-
Import Google Sheets Data Using Azure Data Factory
Use CData Connect AI to connect to Google Sheets Data from Azure Data Factory and import live Google Sheets.
-
How to connect to ZohoPeople Data with Squirrel SQL client
Connect to ZohoPeople and execute queries in the Squirrel SQL Client.
-
Connect to Zoho Creator Data in DBeaver
Use the CData ODBC Driver to connect to Zoho Creator in DBeaver.
-
Import Pipeliner CRM Data into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Pipeliner CRM. In this article, you will use the OData format to import Pipeliner CRM into Microsoft Power Query.
-
Visualize Workable Data in TIBCO Spotfire through OData
Integrate Workable into dashboards in TIBCO Spotfire.
-
Build SuiteCRM-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SuiteCRM and build web apps with connectivity to live SuiteCRM.
-
How to connect to HubSpot Data with Squirrel SQL client
Connect to HubSpot and execute queries in the Squirrel SQL Client.
-
Create Reports with FTP Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date FTP Servers.
-
Automate Avalara AvaTax Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Avalara AvaTax from PowerShell? This article demonstrates how to utilize the Avalara AvaTax Cmdlets for tasks like connecting to Avalara AvaTax, automating operations, downloading data, and more.
-
Access Demio Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Demio.
-
Build MVC Applications with Connectivity to Perigon Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Perigon from an ASP.NET MVC application.
-
Build Google Cloud Storage-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Google Cloud Storage and build Google Cloud Storage-connected web apps with Axios.
-
Visualize Klipfolio Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Klipfolio.
-
Connect MarkLogic to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live MarkLogic using the CData Python MCP Server.
-
Query Dropbox Data in ColdFusion
Write standard ColdFusion data access code to connect to Dropbox.
-
Add Salesforce Marketing Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Salesforce Marketing with the Informatica Enterprise Data Catalog to classify and organize data.
-
Automate IBM Informix Data Replication to Couchbase
Use CData Sync to Customize and automate IBM Informix replication to Couchbase.
-
Prepare, Blend, and Analyze PayPal Data in Alteryx Designer (ODBC)
Build workflows to access live PayPal for self-service data analytics.
-
Automate Sybase IQ Data Replication to SAP HANA
Use CData Sync to customize and automate Sybase IQ replication to SAP HANA.
-
Integrate Stripe Data in Pentaho Data Integration
Build ETL pipelines based on Stripe in the Pentaho Data Integration tool.
-
Write a Simple Go Application to work with Sybase IQ Data on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Sybase IQ.
-
Automate ElevenLabs Integration Tasks from PowerShell
Are you in search of a quick and easy way to access ElevenLabs from PowerShell? This article demonstrates how to utilize the ElevenLabs Cmdlets for tasks like connecting to ElevenLabs, automating operations, downloading data, and more.
-
Access Snowflake Data in Mule Applications Using the CData JDBC Driver
Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Snowflake.
-
Access Nuclia Data from MySQL in PHP
Connect to Nuclia through the standard MySQL libraries in PHP.
-
Publish Quickbase-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Quickbase.
-
Analyze Float Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Float and visualize live Float in Infragistics Reveal.
-
How to publish and share ScrapingBee Data dashboards with Tableau Server
The CData ODBC driver for ScrapingBee enables you integrate ScrapingBee into Tableau dashboards.
-
Integrating Antigravity CLI with ClickTime via CData CLI
Connect ClickTime to Antigravity CLI through CData CLI to configure drivers, activate licenses, and run SQL queries from your terminal.
-
Build a Simple VCL Application for Dropbox Data
How to build a simple VCL Application to view Dropbox in RAD Studio using the CData ODBC Driver for Dropbox.
-
Publish Crystal Reports on Azure DevOps Data
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Azure DevOps.
-
Connect to Paylocity Data in NetBeans
Connect to Paylocity in NetBeans with the data source configuration wizard.
-
Integrate HubDB Data in Pentaho Data Integration
Build ETL pipelines based on HubDB in the Pentaho Data Integration tool.
-
How to Access Live Amazon DynamoDB Data in Visual Studio Code via Cline
Run CData MCP Server for Amazon DynamoDB on Windows Subsytem for Linux (WSL) and connect to live Amazon DynamoDB from the Cline extension in Visual Studio Code.
-
Bidirectional Access to Dynamics 365 Data from FileMaker Pro
Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Dynamics 365 in Filemaker Pro for Mac or Windows.
-
Visualize Live Clio Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Clio using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect to Authorize.Net Data from Spring Boot
Connect to Authorize.Net in a Spring Boot Application using the CData JDBC Driver for Authorize.Net
-
How to Access Live Excel Online Data in Visual Studio Code via Cline
Run CData MCP Server for Excel Online on Windows Subsytem for Linux (WSL) and connect to live Microsoft Excel Online from the Cline extension in Visual Studio Code.
-
Getting Started with the CData Power BI Connector for ZohoInvoice
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData SSIS Components for Productboard
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Productboard.
-
Connect to Close Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Close.
-
Connect Everhour to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Everhour with IBM WebSphere for seamless data integration and connectivity.
-
Automated Continuous Moosend Replication to Apache Cassandra
Use CData Sync for automated, continuous, customizable Moosend replication to Apache Cassandra.
-
Edit and Search External Cvent Objects in Salesforce Connect
Use CData Connect AI to securely provide OData feeds of Cvent to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Cvent Data objects that you can access from apps and the dashboard.
-
Manage Google Drive Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Google Drive.
-
Building Dynamic Web Pages with Mixpanel Data Using AngularJS
Create single-page applications with live connectivity to Mixpanel using the CData API Server.
-
How to Connect to & Open FreshBooks Data in Microsoft Excel
This article uses the CData ODBC driver for FreshBooks to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Migrating data from Bugsnag to Snowflake using CData SSIS Components.
Easily push Bugsnag to Snowflake using the CData SSIS Tasks for Bugsnag and Snowflake.
-
Create Reports from Hive Data in Looker Studio
Use CData Connect AI to gain access to live Apache Hive and create custom reports in Looker Studio.
-
Integrate Trello Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Trello from Informatica Cloud.
-
How to Connect to Live PayPal 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 PayPal for you.
-
How to Access Live OpenWeatherMap Data in Power Automate Desktop via ODBC
The CData ODBC Driver for OpenWeatherMap enables you to integrate OpenWeatherMap into workflows built using Microsoft Power Automate Desktop.
-
Connect xBase Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your xBase using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
How to connect to xBase Data in DBVisualizer
Integrate xBase with visual data analysis tools and data connection wizards in DBVisualizer
-
Access Live GraphQL Data in Tableau with CData API Server
With CData API Server, easily create OData endpoints for live GraphQL data and connect directly in Tableau for real-time dashboards, reporting, and analytics without manual data movement.
-
Integrate LinkedIn Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to LinkedIn and integrate live LinkedIn into your Power Automate tasks.
-
Create Data Visualizations Based On Apollo Data in Mode
Use CData Connect AI to connect to Apollo Data from Mode and build visualizations using live
-
Integrating GitHub Copilot CLI with Clari 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.
-
How to create an RPA flow for Wistia Data in UiPath Studio
Use the Wistia ODBC Driver to create workflows that access real-time Wistia without any coding.
-
Establish a Live Connection with Landbot Data using Tableau Bridge
The CData ODBC Driver for Landbot enables you to integrate live Landbot into Tableau Cloud dashboards using the Tableau Bridge.
-
Create Power BI Reports on Real-Time Avalara AvaTax Data
Use the CData ODBC Driver for Avalara AvaTax to visualize Avalara AvaTax in Power BI Desktop.
-
Use the CData Software JDBC Driver for Workable in MicroStrategy
Connect to Workable in MicroStrategy Developer using the CData Software JDBC Driver for Workable.
-
How to Connect the Power BI Service to CapsuleCRM: Complete Guide
Connect to the CData Software Power BI Connector for CapsuleCRM from PowerBI.com to provide real-time CapsuleCRM across the organization.
-
Use the CData Software ODBC Driver for SAS Data Sets in MicroStrategy
Connect to SAS Data Sets in MicroStrategy Developer using the CData Software ODBC Driver for SAS Data Sets.
-
Integrate GraphQL Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live GraphQL from Informatica Cloud.
-
Connect to SharePoint Excel Services Data in RapidMiner
Integrate SharePoint Excel Services with standard components and data source configuration wizards in RapidMiner Studio.
-
Create Informatica Mappings From/To an ODBC Data Source for Pinecone
Create an ODBC connection to Pinecone in Informatica and browse and transfer Pinecone.
-
Analyze Dropbox Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Dropbox in Microsoft R Open.
-
Create SAP SuccessFactors LMS Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time SAP SuccessFactors LMS data access from reports, embedded analytics, and more.
-
How to Connect DBeaver to Shippo via a JDBC Driver
Manage Shippo with visual tools in DBeaver like the query browser.
-
Connect to SAP SuccessFactors LMS Data in ACL Analytics
Connect to SAP SuccessFactors LMS via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to SAP SuccessFactors LMS.
-
How to create an RPA flow for HubSpot Data in UiPath Studio
Use the HubSpot ODBC Driver to create workflows that access real-time HubSpot without any coding.
-
Connect to ShipStation Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for ShipStation to connect to ShipStation and execute queries in PowerBuilder.
-
Integrate Google Ads Data into Automated Tasks with Power Automate
Use CData Connect AI to connect to Google Ads and integrate live Google Ads into your Power Automate tasks.
-
Stream PhantomBuster Data into Apache Kafka Topics
Access and stream PhantomBuster in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Operational Reporting on Stripe Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Stripe.
-
How to Connect the Power BI Service to LightSpeedRetail: Complete Guide
Connect to the CData Software Power BI Connector for LightSpeedRetail from PowerBI.com to provide real-time LightSpeedRetail across the organization.
-
Connect to Microsoft OneDrive Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft OneDrive from PowerBuilder using the Microsoft OneDrive JDBC Driver.
-
Integrate with Drip Data in JReport Designer
Create charts and reports based on Drip in JReport Designer.
-
Getting Started with the CData Excel Add-In for HBase
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for HBase.
-
Building Dynamic Web Pages with Amplitude Data Using AngularJS
Create single-page applications with live connectivity to Amplitude using the CData API Server.
-
Build Charts with Opsgenie Data in Clear Analytics
Create dynamic charts and perform analytics based on Opsgenie in Clear Analytics.
-
How to connect to LinkedIn Data from Spring Boot
Connect to LinkedIn in a Spring Boot Application using the CData JDBC Driver for LinkedIn
-
Replicate Multiple DocuSign Accounts via the CData Sync CLI
Replicate multiple DocuSign accounts to one or many databases.
-
Integrating Claude Code with Instagram Data via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on Instagram within assisted coding and automated development workflows.
-
LINQ to Supabase 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 Supabase Data Provider.
-
Import Real-Time Missive Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use Missive in ColdFusion.
-
Automated Continuous SendGrid Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable SendGrid replication to Apache Kafka.
-
Create Informatica Mappings From/To a JDBC Data Source for OnePageCrm
Create OnePageCrm data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Automate Humanity Data Replication to Azure Data Lake
Use CData Sync to customize and automate Humanity replication to Azure Data Lake.
-
Integrate Live BambooHR Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to BambooHR and integrate live BambooHR into apps built in Microsoft Power Apps.
-
Connect to Real-Time PagerDuty Data in Power Apps Using Dataflows to Build Custom Applications
Use CData API Driver for Power BI and Dataflow to import and use PagerDuty in Power Apps.
-
Validate Elasticsearch Data with QuerySurge
Access and validate Elasticsearch in QuerySurge using the CData JDBC Driver.