CData Software - Knowledge Base
Recent Articles
-
Create Dynamic OData Grids Using the Infragistics XamDataGrid
Learn how you can connect OData to Infragistics XamDataGrid to build dynamic grids.
-
Bridge Hacker News Connectivity with Apache NiFi
Access and process Hacker News data in Apache NiFi using the CData JDBC Driver.
-
Integrating GitHub Copilot with Mixpanel 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.
-
Natively Connect to ServiceDesk Plus Data in PHP
The CData ODBC driver for ServiceDesk Plus enables you to create PHP applications with connectivity to ServiceDesk Plus data. Leverage the native support for ODBC in PHP.
-
Manage HCL Domino Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for HCL Domino.
-
Build an OLAP Cube in SSAS from MailChimp Data
Establish a connection to MailChimp data data from SQL Server Analysis Services, and use the MailChimp Data Provider to build OLAP cubes for use in analytics and reporting.
-
Integrate with JSON Services in JReport Designer
Create charts and reports based on JSON services in JReport Designer.
-
Use the CData Software ODBC Driver for Humanity in SAS for Real-Time Reporting and Analytics
Connect to real-time Humanity data in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Humanity.
-
A PostgreSQL Interface for Webflow Data using the CData ODBC Driver
Use the SQL Gateway and Webflow ODBC Driver to create a PostgreSQL entry-point for data access.
-
DataBind Cohere Data to the DevExpress Data Grid
Use the CData API Driver for ADO.NET with the DevExpress Windows Forms and Web controls to provide Cohere data to a chart.
-
Automate Office 365 Data Replication to SAP HANA
Use CData Sync to customize and automate Office 365 data replication to SAP HANA.
-
Automate ClickUp Data Replication to Azure Synapse
Use CData Sync to customize and automate ClickUp data replication to Azure Synapse.
-
Viewing Coinbase Data in RAD Studio Data Explorer
How to view Coinbase data in RAD Studio Data Explorer using the CData ODBC Driver for Coinbase.
-
LINQ to Google Forms 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 Google Forms Data Provider.
-
Excel Spreadsheet Automation on ZohoDesk Data with the QUERY Formula
Pull data from ZohoDesk, automate spreadsheets, and more with the QUERY formula.
-
Integrate OnePageCrm with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate OnePageCrm with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to OnePageCrm data.
-
Connect to Jira Assets Data from Crystal Reports
Use CData Connect AI to connect to and report on live Jira Assets data from Crystal Reports.
-
Enable the ZarMoney JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with ZarMoney data.
-
Build ActiveCampaign-Connected Apps in Bubble
Use CData Connect AI to create an OData feed for ActiveCampaign Data and create custom apps in Bubble.
-
Integrating Dataiku with Bitly Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live Bitly data.
-
Build Data Flows from Clio to SQL Server using SSIS
Easily back up Clio data to SQL Server using the SSIS components for Clio.
-
Replicate Multiple AlloyDB Accounts via the CData Sync CLI
Replicate multiple AlloyDB accounts to one or many databases.
-
Build Pipelines with Live WordPress Data in Google Cloud Data Fusion (via CData Connect AI)
Use CData Connect AI to connect to WordPress from Google Cloud Data Fusion, enabling the integration of live WordPress data into the building and management of effective data pipelines.
-
Use the CData ODBC Driver for Everhour from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Everhour to connect to Everhour data from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Everhour data in Excel.
-
Connect to Gmail Data from a Connection Pool in Jetty
The Gmail JDBC Driver supports connection pooling: This article shows how to connect faster to Gmail data from Web apps in Jetty.
-
Access Live Notion Data in AWS Lambda (with IntelliJ IDEA)
Connect to live Notion data in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Build Data Flows from Gmail to SQL Server using SSIS
Easily back up Gmail data to SQL Server using the SSIS components for Gmail.
-
Automate Everhour Data Replication to Couchbase
Use CData Sync to Customize and automate Everhour data replication to Couchbase.
-
Visualize Microsoft Teams Data from Tableau
Use the Tableau Desktop business intelligence tool to connect to Microsoft Teams data.
-
Use Dash to Build to Web Apps on Toggl Data
Create Python applications that use pandas and Dash to build Toggl-connected web apps.
-
Analyze Sage 300 Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Sage 300 from Power Pivot. You will use the Table Import Wizard to load Sage 300 data. You can visually build the import query or use any SQL supported by the driver.
-
Use the CData Software JDBC Driver for Anaplan in MicroStrategy Web
Connect to Anaplan data in MicroStrategy Web using the CData Software JDBC Driver for Anaplan.
-
Extract, Transform, and Load Suadeo Data in Informatica PowerCenter
Create a simple Workflow for Suadeo data in Informatica PowerCenter.
-
Query Bullhorn CRM Data as a SQL Server Database in Node.js
Execute SQL Server queries against Bullhorn CRM data from Node.js.
-
Build Reckon-Connected ETL Processes in Google Data Fusion
Load the CData JDBC Driver into Google Data Fusion and create ETL processes with access live Reckon data.
-
Visualize Live Couchbase Data in the Power BI Service
Use CData Connect AI to connect to live Couchbase data and create custom reports in the Power BI Service through the On-Premises Gateway.
-
How to connect PolyBase to Workday
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Workday data.
-
How to Connect to Act-On Data in Using Python: 6 Steps
Create Python applications on Linux/UNIX machines with connectivity to Act-On data. Leverage the pyodbc module for ODBC in Python.
-
Connect to SFTP from Asprova with CData Software ODBC Driver for SFTP
This article shows how to connect faster to SFTP data from Asprova.
-
Connect to Spotify Data in Jaspersoft Studio
Execute SQL to remote Spotify data in Jaspersoft Studio.
-
Connect to Live MongoDB Data in MicroStrategy through CData Connect AI
Create a live connection to MongoDB Data in CData Connect AI and connect to your MongoDB data from MicroStrategy.
-
Object-Relational Mapping (ORM) with Pipeliner CRM Data Entities in Java
Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Pipeliner CRM data into a Java-based ORM framework, Hibernate.
-
Analyze SQL Analysis Services Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of SQL Analysis Services data and visualize live SQL Analysis Services data in Infragistics Reveal.
-
Working with Paylocity Data in LINQPad
Execute LINQ queries to Paylocity data in LINQPad.
-
Query Coinbase Data in ColdFusion
Write standard ColdFusion data access code to connect to Coinbase data.
-
Automated Continuous Office 365 Replication to Databricks
Use CData Sync for automated, continuous, customizable Office 365 replication to Databricks.
-
Getting Started with the CData ADO.NET Provider for Teradata
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Teradata.
-
Connect to Adobe Analytics Data in CloverDX (formerly CloverETL)
Transfer Adobe Analytics data using the visual workflow in the CloverDX data integration tool.
-
View Reports on Real-Time Amazon S3 Data in Power BI Report Server
Use the CData ODBC Driver for Amazon S3 to visualize Amazon S3 data in Power BI Desktop and then publish them to Power BI Report Server.
-
Visualize PingOne Data in Sisense
Create an ElastiCube in Sisense app with access to PingOne data.
-
Automate Phoenix Data Replication to SAP HANA
Use CData Sync to customize and automate Phoenix data replication to SAP HANA.
-
Integrate ConvertAPI with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate ConvertAPI with External Services.
-
Integrate Tickspot Data in Pentaho Data Integration
Build ETL pipelines based on Tickspot data in the Pentaho Data Integration tool.
-
Enable the Mocean JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Mocean data.
-
Prepare, Blend, and Analyze Okta Data in Alteryx Designer (Connect AI)
Build workflows to access live Okta data for self-service data analytics.
-
How to Query SAP Business Warehouse Data in MySQL Workbench
Execute MySQL queries against live SAP Business Warehouse data from MySQL Workbench.
-
Getting Started with the CData ADO.NET Provider for Splunk
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Splunk.
-
Create Informatica Mappings From/To an ODBC Data Source for Klipfolio
Create an ODBC connection to Klipfolio in Informatica and browse and transfer Klipfolio data.
-
Connect to Todoist Data from a Connection Pool in JBoss
Integrate Todoist data into Java servlets: Use the Management Console in JBoss to install the Todoist JDBC Driver.
-
How to Create Power BI Visual Reports with Real-Time Zoho Projects Data
Use CData Power BI Connectors to visualize Zoho Projects data in Power BI.
-
Connect to and Query Webex Data in QlikView over ODBC
Create data visualizations with Webex data in QlikView.
-
Use the CData Software ODBC Driver for Discourse in MicroStrategy Web
Connect to Discourse data in MicroStrategy Web using the CData Software ODBC Driver for Discourse.
-
Connecting GenSpark with Jira Data via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to empower GenSpark agents with secure, real-time access to Jira data without any replication or custom integration required.
-
Rapidly Develop Gong-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 Gong.
-
Visualize Snapchat Ads Data in Sisense
Create an ElastiCube in Sisense app with access to Snapchat Ads data.
-
How to connect to Egnyte Data with Squirrel SQL client
Connect to Egnyte data and execute queries in the Squirrel SQL Client.
-
Integrate with Hive Data in SnapLogic
Use CData Connect AI to connect to and integrate with live Hive data in SnapLogic.
-
Using the CData Software ODBC Driver for Front in PyCharm
Connect to Front as an ODBC data source in PyCharm using the CData Software ODBC Driver for Front.
-
Connect to OData Services in the Denodo Platform
Use CData driver technologies to create a virtual data source for OData services in the Denodo Virtual DataPort Administrator.
-
DataBind Azure Synapse Data to the DevExpress Data Grid
Use the CData ADO.NET Provider for Azure Synapse with the DevExpress Windows Forms and Web controls to provide Azure Synapse data to a chart.
-
Integrate Google Forms with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate Google Forms with External Services.
-
Connect to Microsoft Teams Data in HULFT Integrate
Connect to Microsoft Teams as a JDBC data source in HULFT Integrate
-
Create Cosmos DB-Connected Dashboards in Grafana
Connect to Cosmos DB Data via CData Connect AI in Grafana and create custom business dashboards with real-time access to Cosmos DB data.
-
Integrate with live SAP Ariba Procurement Data in Jitterbit
Use CData Connect AI to connect to and integrate live SAP Ariba Procurement data in Jitterbit.
-
Build MVC Applications with Connectivity to Clari Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Clari from an ASP.NET MVC application.
-
Connect to Demio 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 Demio and work with Demio data in your FileMaker application.
-
Create Datasets from Short.io in Domo Workbench and Build Visualizations of Short.io Data in Domo
Use the CData Software ODBC Driver for Short.io to create datasets from Short.io data in Domo Workbench and then build visualizations in the Domo service.
-
Connect to Facebook 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 Facebook data.
-
Automated Continuous Aircall Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Aircall replication to Google Cloud SQL.
-
Import Real-Time eBay Analytics Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use eBay Analytics data in ColdFusion.
-
Bridge Figshare Connectivity with Apache NiFi
Access and process Figshare data in Apache NiFi using the CData JDBC Driver.
-
Import and Visualize FreshBooks Data in Power View
Create data visualizations based on FreshBooks data in Excel.
-
Integrate BigQuery with External Services using SnapLogic
Use CData JDBC drivers in SnapLogic to integrate BigQuery with External Services.
-
Build Agents in Relevance AI with Access to Live Bullhorn CRM Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Relevance AI to securely access and act on Bullhorn CRM data within intelligent agent workflows.
-
Connect to Freshservice Data in RapidMiner
Integrate Freshservice data with standard components and data source configuration wizards in RapidMiner Studio.
-
Connect to Humanity Data from Blazor Apps
Build ASP.NET Core Blazor C# apps that integrate with real-time Humanity data using standard SQL.
-
Prepare, Blend, and Analyze Quickbase Data in Alteryx Designer (Connect AI)
Build workflows to access live Quickbase data for self-service data analytics.
-
How to create Zoho CRM federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Zoho CRM data in MySQL .
-
Import Real-Time LinkedIn Ads Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use LinkedIn Ads data in ColdFusion.
-
Access Stack Exchange Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Stack Exchange data from HeidiSQL.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy
Connect to Slack data in MicroStrategy Developer using the CData Software JDBC Driver for Slack.
-
Connect Vercel Data to Claris FileMaker via ESS using an ODBC Driver and the CData SQL Gateway
Connect to your Vercel data using the ESS feature of Claris FileMaker with MySQL ODBC driver and CData SQL Gateway.
-
Analyze Adobe Target Data in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Adobe Target data and visualize live Adobe Target data in Infragistics Reveal.
-
Access NetSuite Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access NetSuite data from your Oracle system.
-
Access Live Adobe Analytics Data in Excel 365 Online (Excel for the web)
Connect to Adobe Analytics data from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Design BIRT Reports on Typeform Data
Provide current Typeform data to your embedded analytics.
-
Connect to HDFS Data in ACL Analytics
Connect to HDFS data via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to HDFS data.
-
Connect to and Query Google Contacts Data in QlikView over ODBC
Create data visualizations with Google Contacts data in QlikView.
-
How to Work with SAP Business Warehouse Data in AWS Glue Jobs Using JDBC
Connect to SAP Business Warehouse from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Zoho CRM
Provide connectivity to Zoho CRM data through an SAP BusinessObjects universe.