CData Software - Knowledge Base
Recent Articles
-
Connect to Jira Assets Data from a Connection Pool in Jetty
The Jira Assets JDBC Driver supports connection pooling: This article shows how to connect faster to Jira Assets from Web apps in Jetty.
-
Integrate Splunk Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Splunk from Informatica Cloud.
-
Build AI/ML Models with Live Spotify Data using Dataiku
Connect Spotify Data with Dataiku using the CData API Driver for JDBC.
-
Use the CData ODBC Driver for Sybase IQ in Microsoft Power Query
You can use the CData Sybase IQ ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import Sybase IQ into Microsoft Power Query.
-
Connect to Brex Data from a Connection Pool in JBoss
Integrate Brex into Java servlets: Use the Management Console in JBoss to install the Brex JDBC Driver.
-
Build Visualizations of SAP ByDesign Data in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of SAP Business ByDesign in Birst.
-
Create Informatica Mappings From/To a JDBC Data Source for Google Analytics
Create Google Analytics data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Rapidly Develop CSV-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface and .NET data access to create data-driven WinForms and ASP.NET apps backed by CSV.
-
Build SendPulse-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to SendPulse and build web apps with connectivity to live SendPulse.
-
Connect to JDBC-ODBC Bridge Data in Jaspersoft Studio
Execute SQL to remote JDBC-ODBC Bridge in Jaspersoft Studio.
-
Migrating data from SendGrid to Google BigQuery using CData SSIS Components.
Easily push SendGrid to Google BigQuery using the CData SSIS Tasks for SendGrid and Google BigQuery.
-
Connect to Bright Data Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Bright Data and work with Bright Data in your FileMaker applications.
-
Load Quaderno Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Quaderno to a database.
-
Connect to and Query Gumroad Data in QlikView over ODBC
Create data visualizations with Gumroad in QlikView.
-
Automated Continuous RSS Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable RSS replication to Amazon Redshift.
-
Use Biml to Build SSIS Tasks to Replicate Freshteam Data to SQL Server
Use Biml to dynamically build SSIS tasks using CData SSIS Components to replicate Freshteam to SQL Server.
-
Getting Started with the CData SSIS Components for Excel Online
Complete guide to installing, licensing, and connecting with the CData SSIS Components for Excel Online.
-
How to Design Snowflake Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Snowflake from mobile and tablet Power Apps.
-
Integrate with Tickspot Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Tickspot to a JSON file on disk.
-
How to connect PolyBase to SAS Data Sets
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live SAS Data Sets.
-
How to Connect to & Open Sendwithus Data in Microsoft Excel
This article uses the CData ODBC driver for Sendwithus to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
DataBind Controls to HDFS Data in C++Builder
DataBind to Apache HDFS in C++Builder with standard components and controls.
-
DataBind Controls to CSV Data in C++Builder
DataBind to CSV/TSV Files in C++Builder with standard components and controls.
-
Query Freshservice Data in ColdFusion
Write standard ColdFusion data access code to connect to Freshservice.
-
Automated Continuous CampaignMonitor Replication to Oracle
Use CData Sync for automated, continuous, customizable CampaignMonitor replication to Oracle.
-
How to Connect the Power BI Service to Freshdesk: Complete Guide
Connect to the CData Software Power BI Connector for Freshdesk from PowerBI.com to provide real-time Freshdesk across the organization.
-
Use the CData ODBC Driver for LinkedIn in Microsoft Power Query
You can use the CData LinkedIn ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import LinkedIn into Microsoft Power Query.
-
Create Informatica Mappings From/To a JDBC Data Source for AfterShip
Create AfterShip data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
How to Access Live Brex Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Brex enables you to integrate Brex into workflows built using Microsoft Power Automate Desktop.
-
DataBind VWO Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide VWO to a chart.
-
Query Notion Data as a MySQL Database in Node.js
Execute MySQL queries against Notion from Node.js.
-
Access SpaceX 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 SpaceX.
-
Visualize Bugsnag Data in Tableau
The CData ODBC driver for Bugsnag enables you integrate Bugsnag into Tableau dashboards.
-
Import Real-Time Act-On Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Act-On in ColdFusion.
-
Build MVC Applications with Connectivity to HubSpot Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access HubSpot from an ASP.NET MVC application.
-
How to Work with Amazon S3 Data in ETL Validator JDBC
Connect to Amazon S3 from ETL Validator jobs using the CData Software JDBC Driver.
-
Build Apps with Live TaxJar Data Using the Low-Code Development Platform of Mendix
Connect TaxJar with Mendix to build apps using the CData JDBC Driver for TaxJar.
-
DataBind Controls to Bitly Data in C++Builder
DataBind to Bitly in C++Builder with standard components and controls.
-
Connect ServiceDesk Plus to AI Assistants With the CData Python MCP Server
Learn how to give AI assistants like Claude direct access to live ServiceDesk Plus using the CData Python MCP Server.
-
Build Semantic Layer Views for Google Drive Data in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Google Drive.
-
Analyze Eventbrite Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Eventbrite with the CData JDBC Driver for Eventbrite.
-
Publish Hive-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Apache Hive.
-
How to use SQLAlchemy ORM to access SendInBlue Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SendInBlue.
-
Publish Toggl-Connected Dashboards in Tableau Server
Use CData Tableau Connectors and Tableau Server to visualize live Toggl.
-
Integrating Cursor CLI with Slack 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.
-
Connect to Google Spanner Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Spanner.
-
Visualize Live Hive Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Apache Hive using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrating Gumloop with YouTube Analytics Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on YouTube Analytics within automated workflows.
-
Integrating Gumloop with Snapchat Ads Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Snapchat Ads within automated workflows.
-
Query Factorial Data in DataGrip
Create a Data Source for Factorial in DataGrip and use SQL to query live Factorial.
-
How to create Adobe Experience Manager federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Adobe Experience Manager in MySQL .
-
Connect to Printify Data in RazorSQL
Connect to Printify from wizards and query Printify from the GUI in the RazorSQL database management tool.
-
Create CampaignMonitor Dataflows on PowerBI.com
Connect to the CData Power BI Connector for CampaignMonitor from PowerBI.com to create Power BI Dataflows with real-time data.
-
How to Query Drift Data in MySQL Workbench
Execute MySQL queries against live Drift from MySQL Workbench.
-
Integrate LibreChat with Live Dynamics 365 Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LibreChat to securely access and query live Microsoft Dynamics 365 from within the chat interface.
-
Connect to Google Calendar Data in JRuby
Create a simple JRuby app with access to live Google Calendar.
-
Getting Started with the CData Power BI Connector for Omnisend
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Getting Started with the CData Tableau Connector for Omnisend
Complete guide to installing, licensing, and connecting with the CData API Driver for Tableau.
-
Automate Typeform Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Typeform from PowerShell? This article demonstrates how to utilize the Typeform Cmdlets for tasks like connecting to Typeform, automating operations, downloading data, and more.
-
Create Power BI Reports on Real-Time Cassandra Data
Use the CData ODBC Driver for Cassandra to visualize Apache Cassandra in Power BI Desktop.
-
Use Claude to Talk to Your Azure Data Lake Storage 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 Azure Data Lake Storage for you.
-
Connect to OData from Asprova with CData Software ODBC Driver for OData
This article shows how to connect faster to OData data from Asprova.
-
Replicate Pipeliner CRM Data in Heroku for Use in Salesforce Connect
Replicate Pipeliner CRM to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Build a PostgreSQL Interface for MySQL Data using the CData JDBC Driver
Use the Remoting features of the MySQL JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use the CData ODBC Driver for MariaDB in Microsoft Power Query
You can use the CData MariaDB ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import MariaDB into Microsoft Power Query.
-
Working with Jumpseller Data in LINQPad
Execute LINQ queries to Jumpseller in LINQPad.
-
Load Apify Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Apify to a database.
-
Connect to Paylocity from Asprova with CData Software ODBC Driver for Paylocity
This article shows how to connect faster to Paylocity data from Asprova.
-
How to connect to Parquet Data with Squirrel SQL client
Connect to Apache Parquet and execute queries in the Squirrel SQL Client.
-
How to create Visio diagrams from REST Data
Automatically update REST with the changes you make to Visio master shapes.
-
Query Freshservice Data in DataGrip
Create a Data Source for Freshservice in DataGrip and use SQL to query live Freshservice.
-
Replicate Sugar CRM Data to Multiple Databases via the CData Sync CLI
Replicate Sugar CRM to disparate databases with a single configuration.
-
Integrating OpenCode Terminal with Figshare 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.
-
Analyze ADP Data in Slingshot with CData API Server
Use the CData API Server to build an OData API on top of ADP and visualize the live Data in Slingshot (formerly Reveal BI) for seamless insights.
-
Create Informatica Mappings From/To an ODBC Data Source for Tavily
Create an ODBC connection to Tavily in Informatica and browse and transfer Tavily.
-
How to Design SingleStore Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to SingleStore from mobile and tablet Power Apps.
-
Moving Data from iContact to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live iContact data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
View Reports on Real-Time SAP Netweaver Gateway Data in Power BI Report Server
Use the CData ODBC Driver for SAP Netweaver Gateway to visualize SAP Netweaver Gateway in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate Neo4J Data in Pentaho Data Integration
Build ETL pipelines based on Neo4J in the Pentaho Data Integration tool.
-
Model Azure Table Data Using Azure Analysis Services
Leverage CData Connect AI to establish a connection between Azure Analysis Services and Azure Table, enabling the direct import of real-time Azure Table Storage.
-
Prepare, Blend, and Analyze Zoho Recruit Data in Alteryx Designer (ODBC)
Build workflows to access live Zoho Recruit for self-service data analytics.
-
Trigger Amazon Athena IFTTT Flows in Azure App Service
Automate IFTTT (if-this-then-that) workflows for Amazon Athena with standard wizards in Logic Apps.
-
Visualize Teamwork Data in Sisense
Create an ElastiCube in Sisense app with access to Teamwork.
-
Viewing Tally Data in RAD Studio Data Explorer
How to view Tally ERP in RAD Studio Data Explorer using the CData ODBC Driver for Tally.
-
Create Dynamic ADP Grids Using the Infragistics XamDataGrid
Learn how you can connect ADP to Infragistics XamDataGrid to build dynamic grids.
-
Build an OLAP Cube in SSAS from SendPulse Data
Establish a connection to SendPulse data from SQL Server Analysis Services, and use the SendPulse Data Provider to build OLAP cubes for use in analytics and reporting.
-
Getting Started with the CData JDBC Driver for TaxJar
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for TaxJar.
-
Build Semantic Layer Views for Kintone Data in APOS Live Data Gateway
Use the CData Connector for Kintone in APOS Live Data Gateway to build Semantic Layer Views for Kintone.
-
How to Access Live Oracle Service Cloud Data in Visual Studio Code via Cline
Run CData MCP Server for Oracle Service Cloud on Windows Subsytem for Linux (WSL) and connect to live Oracle Service Cloud from the Cline extension in Visual Studio Code.
-
Create SSAS Tabular Models from LightSpeedRetail Data
How to build a SQL Server Analysis Service Tabular Model from LightSpeedRetail using CData drivers.
-
Connect to Vercel Data in the Denodo Platform
Use CData driver technologies to create a virtual data source for Vercel in the Denodo Virtual DataPort Administrator.
-
Access Live Acumatica Data in Excel 365 Online (Excel for the web)
Connect to Acumatica ERP from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Replicate Pipedrive Data in Heroku for Use in Salesforce Connect
Replicate Pipedrive to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Connect to Azure Data Catalog Data in Aqua Data Studio
Access Azure Data Catalog from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Add ActiveCampaign Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for ActiveCampaign with the Informatica Enterprise Data Catalog to classify and organize data.
-
Access Live SAS Data Sets 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 SAS Data Sets through MCP integration.
-
Connect to ServiceDesk Plus Data from PowerBuilder via ADO.NET
This article demonstrates how to access ServiceDesk Plus from Appeon PowerBuilder using the CData API Driver for ADO.NET.
-
Build SAP Netweaver Gateway-Connected Dashboards Using Zoho Analytics
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Zoho Analytics and import live SAP Netweaver Gateway.
-
LINQ to Oracle HCM Cloud 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 Oracle HCM Cloud Data Provider.
-
Building Dynamic Web Pages with Dynamics 365 Data Using AngularJS
Create single-page applications with live connectivity to Dynamics 365 using the CData API Server.