CData Software - Knowledge Base
Recent Articles
-
Create Dynamic Google Calendar Grids Using the Infragistics XamDataGrid
Learn how you can connect Google Calendar to Infragistics XamDataGrid to build dynamic grids.
-
Build Apps with Live Onfleet Data Using the Low-Code Development Platform of Mendix
Connect Onfleet with Mendix to build apps using the CData API Driver for JDBC.
-
Build CSV Visualizations in Tableau Cloud
Use CData Connect AI to connect to live CSV/TSV Files and build visualizations in Tableau Cloud.
-
Integrating GitHub Copilot CLI with NetSuite CRM & ERP 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 Avalara AvaTax from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Avalara AvaTax, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Integrate EnterpriseDB Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live EnterpriseDB from Informatica Cloud.
-
Analyze Hacker News Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Hacker News with the CData JDBC Driver for Hacker News.
-
BigQuery Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on BigQuery facts in real time.
-
Migrating data from EmailOctopus to Databricks using CData SSIS Components.
Easily push EmailOctopus to Databricks using the CData SSIS Tasks for EmailOctopus and Databricks.
-
Automated SendGrid Data Replication to Teradata
Use CData Sync to Customize and automate SendGrid replication to Teradata.
-
How to load Aha! data into Elasticsearch via Logstash
Introducing a simple method to load Aha! data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Load LeadDesk Data to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load LeadDesk to a database.
-
Build Box-Powered Applications in Claude Code with CData MCP Server
Use the CData MCP Server for Box to explore live Box Data in Claude Code to assist with building Box-powered applications.
-
Build a PostgreSQL Interface for Instantly Data using the CData JDBC Driver
Use the Remoting features of the Instantly JDBC Driver to create a PostgreSQL entry-point for data access.
-
Getting Started with the CData JDBC Driver for Databricks
Complete guide to installing, licensing, and connecting with the CData JDBC Driver for Databricks.
-
Connect to Google Spanner Data in Jaspersoft Studio
Execute SQL to remote Google Spanner in Jaspersoft Studio.
-
View Reports on Real-Time Excel Online Data in Power BI Report Server
Use the CData ODBC Driver for Excel Online to visualize Microsoft Excel Online in Power BI Desktop and then publish them to Power BI Report Server.
-
Create Amazon Marketplace Dataflows on PowerBI.com
Connect to the CData Power BI Connector for Amazon Marketplace from PowerBI.com to create Power BI Dataflows with real-time data.
-
Connect to Oracle Service Cloud Data in HULFT Integrate
Connect to Oracle Service Cloud as a JDBC data source in HULFT Integrate
-
Build AI/ML Models with Live Box Data using Dataiku
Connect Box Data with Dataiku using the CData JDBC Driver for Box.
-
How to use SQLAlchemy ORM to access SAP Fieldglass Data in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of SAP Fieldglass.
-
Use the CData Software ODBC Driver for Freshteam in MicroStrategy
Connect to Freshteam in MicroStrategy Developer using the CData Software ODBC Driver for Freshteam.
-
How to Access Nuclia Data Using Entity Framework
This article shows how to access Nuclia using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.
-
Query Live Dropbox Data in Zed Editor via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Zed Editor to securely access and query live Dropbox directly from the development environment.
-
Getting Started with the CData Power BI Connector for Billsby
Complete guide to installing, licensing, and connecting with the CData API Driver for Power BI.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed PingOne to Power BI dashboards. Simply drag and drop PingOne into data visuals on the Power BI canvas.
-
Integrate Live Highrise Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Highrise CRM and integrate live Highrise CRM into apps built in Microsoft Power Apps.
-
Access Live FHIR Data in AWS Lambda (with IntelliJ IDEA)
Connect to live FHIR in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Query Webex Data in ColdFusion
Write standard ColdFusion data access code to connect to Webex.
-
Add Access Data to Informatica Enterprise Data Catalog
Use the CData Software JDBC Driver for Access with the Informatica Enterprise Data Catalog to classify and organize data.
-
Build Couchbase-Connected Web Apps with Axios and CData Connect AI
Use CData Connect AI to connect to live Couchbase and build Couchbase-connected web apps with Axios.
-
Create Informatica Mappings From/To a JDBC Data Source for Dynamics NAV
Create Dynamics NAV data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Getting Started with the CData Power BI Connector for Salesloft
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Salesloft.
-
SAP SuccessFactors LMS Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to SAP SuccessFactors LMS through CData Connect AI using different applications and tools.
-
Analyze Oracle HCM Cloud Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Oracle HCM Cloud with the CData JDBC Driver for Oracle HCM Cloud.
-
Query Microsoft Ads Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Microsoft Ads entities in PHP by modeling them as objects.
-
How to create Microsoft Planner federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Planner in MySQL .
-
Extract, Transform, and Load Databricks Data in Informatica PowerCenter
Create a simple Workflow for Databricks in Informatica PowerCenter.
-
Build a PostgreSQL Interface for Gmail Data using the CData JDBC Driver
Use the Remoting features of the Gmail JDBC Driver to create a PostgreSQL entry-point for data access.
-
Use Grok to Talk to Your Marketo 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 Marketo for you.
-
View Reports on Real-Time Neo4J Data in Power BI Report Server
Use the CData ODBC Driver for Neo4J to visualize Neo4J in Power BI Desktop and then publish them to Power BI Report Server.
-
Integrate GitHub Data into Power Automate Desktop using CData Connect
CData Connect for GitHub Data enables you to integrate GitHub into workflows built using Microsoft Power Automate Desktop.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho Projects to Power BI dashboards. Simply drag and drop Zoho Projects into data visuals on the Power BI canvas.
-
Use the CData Software JDBC Driver for ShipEngine in MicroStrategy
Connect to ShipEngine in MicroStrategy Developer using the CData Software JDBC Driver for ShipEngine.
-
Connect and Visualize Live Cassandra Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Apache Cassandra into the Databricks platform and create visualization dashboards with real-time Apache Cassandra.
-
How to connect PolyBase to OnePageCrm
Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live OnePageCrm.
-
Build Ontraport-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Ontraport and build web apps with connectivity to live Ontraport.
-
Explore Geographical Relationships in Vercel Data with Power Map
Create data visualizations with Vercel in Power Map.
-
Build Salesforce Data 360-Connected Web Apps in Servoy
Use Servoy Developer to easily connect to Salesforce Data 360 and build web apps with connectivity to live Salesforce Data 360.
-
Build AI/ML Models with Live ServiceNow Data using Dataiku
Connect ServiceNow Data with Dataiku using the CData JDBC Driver for ServiceNow.
-
Enable the Float JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with Float.
-
How to Access Live FreeAgent Data in Power Automate Desktop via ODBC
The CData ODBC Driver for FreeAgent enables you to integrate FreeAgent into workflows built using Microsoft Power Automate Desktop.
-
How to Work with Google Tasks Data in AWS Glue Jobs Using JDBC
Connect to Google Tasks from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
Connect to Twilio Data from PowerBuilder via JDBC
This article demonstrates how to access Twilio from PowerBuilder using the Twilio JDBC Driver.
-
Automated Continuous Active Directory Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable Active Directory replication to Apache Kafka.
-
Feed Drip Data into FineReport
How to set Drip as a JDBC data source in FineReport.
-
LeadDesk Reporting in OBIEE with the LeadDesk JDBC Driver
Deploy the LeadDesk JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
How to connect to Landbot Data in DBVisualizer
Integrate Landbot with visual data analysis tools and data connection wizards in DBVisualizer
-
Easily Integrate Nethunt Data in Lazarus Pascal IDE
Learn how to easily integrate live Nethunt in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect and Visualize Live SAP Business One Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live SAP Business One into the Databricks platform and create visualization dashboards with real-time SAP Business One.
-
Getting Started with the CData Excel Add-In for BigCommerce
Complete guide to installing, licensing, and connecting with the CData Excel Add-In for BigCommerce.
-
Connect to eBay Data in Ruby
Connect to eBay in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Enable the SAP Concur JDBC Driver in KNIME
Use standard data access components in KNIME to create charts and reports with SAP Concur.
-
Integrate Live Klaviyo Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
How to create Salesforce Marketing federated tables in MySQL
Use the SQL Gateway and the ODBC Driver to set up federated tables for Salesforce Marketing Cloud in MySQL .
-
Access Live Authorize.Net 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 Authorize.Net through MCP integration.
-
Use the CData Software ODBC Driver for SharePoint Excel Services in MicroStrategy Web
Connect to SharePoint Excel Services in MicroStrategy Web using the CData Software ODBC Driver for SharePoint Excel Services.
-
Automated Continuous LaunchDarkly Replication to Local Delimited Files
Use CData Sync for automated, continuous, customizable LaunchDarkly replication to delimited files (CSV/TSV).
-
Publish Reports with Trello Data in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Trello.
-
Connect to Missive from a Connection Pool in WebLogic
Use the CData JDBC Driver for Missive to connect to Missive from Web applications running on WebLogic.
-
How to Query Live Jira Assets Data in Natural Language in Python using LlamaIndex
Use LlamaIndex to query live Jira Assets data in natural language using Python.
-
How to Connect DBeaver to Oracle Eloqua Reporting via a JDBC Driver
Manage Oracle Eloqua Reporting with visual tools in DBeaver like the query browser.
-
Create Raisers Edge NXT-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Raisers Edge NXT Data from Klipfolio and build custom visualizations using live Raisers Edge NXT.
-
Replicate Okta Data from PowerShell
Write a quick PowerShell script to query Okta. Use connectivity to the live data to replicate Okta to SQL Server.
-
Connect to ShipStation Data from PowerBuilder via JDBC
This article demonstrates how to access ShipStation from PowerBuilder using the ShipStation JDBC Driver.
-
Query, Visualize, and Share live Adobe Commerce Data in Redash
Use CData Connect AI to connect to live Adobe Commerce in Redash for querying, visualizing, and sharing.
-
Connect to and Query SQL Analysis Services Data in QlikView over ODBC
Create data visualizations with SQL Analysis Services in QlikView.
-
Integrating GitHub Copilot CLI with Microsoft Entra ID 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 Query Nethunt Data in MySQL Workbench
Execute MySQL queries against live Nethunt from MySQL Workbench.
-
Connect to SharePoint Data from Crystal Reports
Use CData Connect AI to connect to and report on live Microsoft SharePoint from Crystal Reports.
-
Easily Integrate Salesforce Data in Lazarus Pascal IDE
Learn how to easily integrate live Salesforce & Force.com in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Consume XML OData Feeds in SAP Lumira
Use the API Server to create data visualizations on XML feeds that reflect any changes in SAP Lumira.
-
Use the CData Software ODBC Driver for HBase in SAS for Real-Time Reporting and Analytics
Connect to real-time Apache HBase in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for HBase.
-
How to Easily Query Google Ads Data in OpenOffice Base
Connect to Google Ads data in OpenOffice Base using the CData ODBC Driver for Google Ads and generate reports with live data insights.
-
Use Databricks Agent Bricks to Talk to Your Zendesk Data via CData Connect AI
Leverage CData Connect AI to enable Databricks Agent Bricks to securely answer questions and take actions on your Zendesk for you.
-
Use Dash to Build to Web Apps on Oracle Service Cloud Data
Create Python applications that use pandas and Dash to build Oracle Service Cloud-connected web apps.
-
Build a PostgreSQL Interface for Hubstaff Data using the CData JDBC Driver
Use the Remoting features of the Hubstaff JDBC Driver to create a PostgreSQL entry-point for data access.
-
Connect to Postmark Data in DigitalSuite Studio through RunMyProcess DSEC
Use Arkobi Digital
-
Connect to Shortcut Data in NetBeans
Connect to Shortcut in NetBeans with the data source configuration wizard.
-
How to connect to Trello Data from Spring Boot
Connect to Trello in a Spring Boot Application using the CData JDBC Driver for Trello
-
Create Datasets from SAP BusinessObjects BI in Domo Workbench and Build Visualizations of SAP BusinessObjects BI Data in Domo
Use the CData Software ODBC Driver for SAP BusinessObjects BI to create datasets from SAP BusinessObjects BI in Domo Workbench and then build visualizations in the Domo service.
-
Connect to PolarTeamPro Data in Jaspersoft Studio
Execute SQL to remote PolarTeamPro in Jaspersoft Studio.
-
Build Data Flows from Monday.com to SQL Server using SSIS
Easily back up Monday.com to SQL Server using the SSIS components for Monday.com.
-
Use the CData Software JDBC Driver for Avalara AvaTax in MicroStrategy Web
Connect to Avalara AvaTax in MicroStrategy Web using the CData Software JDBC Driver for Avalara AvaTax.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Wrike
Provide connectivity to Wrike through an SAP BusinessObjects universe.
-
How to Connect the Power BI Service to IBM Informix: Complete Guide
Connect to the CData Software Power BI Connector for IBM Informix from PowerBI.com to provide real-time IBM Informix across the organization.
-
Getting Started with the CData ADO.NET Provider for Sybase
Complete guide to installing, licensing, and connecting with the CData ADO.NET Provider for Sybase.
-
How to Design Sugar CRM Power Apps with Database-Like Connectivity
Gain real-time, database-like connectivity to Sugar CRM from mobile and tablet Power Apps.
-
Visualize Auth0 Data in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Auth0 into TIBCO Spotfire.
-
How to Access Dotmailer Data Using Entity Framework
This article shows how to access Dotmailer using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.