CData Software - Knowledge Base
Recent Articles
-
How to connect to Typeform Data from Spring Boot
Connect to Typeform in a Spring Boot Application using the CData API Driver for JDBC
-
Connect to Basecamp Data in ACL Analytics
Connect to Basecamp via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Basecamp.
-
Visualize Cloudant Data in Sisense
Create an ElastiCube in Sisense app with access to IBM Cloudant.
-
Integrating LlamaIndex with Monday.com Data via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable LlamaIndex ReAct agents to securely access and act on Monday.com in real time.
-
Connect to Todoist Data in DBeaver
Use the CData ODBC Driver to connect to Todoist in DBeaver.
-
Connect to Real-Time Cosmos DB Data in Power Apps Using Dataflows to Build Custom Applications
Use CData Power BI Connector for Cosmos DB and Dataflow to import and use Azure Cosmos DB in Power Apps.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Hubstaff
Provide connectivity to Hubstaff through an SAP BusinessObjects universe.
-
Connecting Moonlit Workflow with BigCommerce Data via CData Connect AI MCP Server
Leverage the CData Connect AI Remote MCP Server to enable Moonlit workflows to securely read and act on your BigCommerce in real time.
-
Connect to Vertica Data in Google Apps Script via Connect AI
Use CData Connect AI to access Vertica in Google Apps Script.
-
SageHR Reporting in OBIEE with the SageHR JDBC Driver
Deploy the SageHR JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Build a Singer.io Tap for Typeform With the CData Python Connector
Learn how to easily build a Singer.io Tap for live Typeform data using
-
Import Amazon Athena Data Using Azure Data Factory
Use CData Connect AI to connect to Amazon Athena Data from Azure Data Factory and import live Amazon Athena.
-
Query Bitbucket Data in ColdFusion
Write standard ColdFusion data access code to connect to Bitbucket.
-
Reckon Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Reckon facts in real time.
-
Establish a Live Connection with Outlook Data using Tableau Bridge
The CData ODBC Driver for Outlook enables you to integrate live Outlook into Tableau Cloud dashboards using the Tableau Bridge.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Sybase IQ
Provide connectivity to Sybase IQ through an SAP BusinessObjects universe.
-
Build Apollo-Connected Apps in Choreo
Use CData Connect AI to connect to Apollo Data from Choreo and build custom apps using live Apollo.
-
Build Apps with Live Procore Data Using the Low-Code Development Platform of Mendix
Connect Procore with Mendix to build apps using the CData API Driver for JDBC.
-
Use the CData Software JDBC Driver for SAP Hybris C4C in MicroStrategy
Connect to SAP Hybris C4C in MicroStrategy Developer using the CData Software JDBC Driver for SAP Hybris C4C.
-
Create Data Visualizations in Cognos BI with SAP Netweaver Gateway Data
Access SAP Netweaver Gateway as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Integrating Samanage Data in Talend Cloud Data Management Platform
Connect Samanage Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Build Zuora-Powered Applications in Cursor with CData MCP Server
Use the CData MCP Server for Zuora to explore live Zuora Data in Cursor to assist with building Zuora-powered applications.
-
Connect to Opsgenie Data as a Linked Server via SQL Gateway
Use the SQL Gateway and the ODBC Driver to set up a linked server for Opsgenie.
-
Integrating Codex CLI with Salesloft 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.
-
Use the CData Software ODBC Driver for PayPal in SAS for Real-Time Reporting and Analytics
Connect to real-time PayPal in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for PayPal.
-
Connect to Microsoft Teams Data in Ruby
Connect to Microsoft Teams in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access OpenWeatherMap Data from MySQL in Amazon QuickSight
Connect to OpenWeatherMap and build visualizations of OpenWeatherMap using a MySQL Connection in Amazon QuickSight.
-
Connect to Dynamics NAV Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Dynamics NAV from PowerBuilder using the Dynamics NAV JDBC Driver.
-
Getting Started with the CData ODBC Driver for HubSpot
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for HubSpot.
-
Feed SAP Concur Data into FineReport
How to set SAP Concur as a JDBC data source in FineReport.
-
Build Data Flows from SQL Server to Wave Financial through SSIS
Easily push SQL Server data to Wave Financial using the CData SSIS Tasks for Wave Financial.
-
How to Work with MessageBird Data in ETL Validator JDBC
Connect to MessageBird from ETL Validator jobs using the CData Software JDBC Driver.
-
Integrate with Mistral AI Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Mistral AI to a JSON file on disk.
-
Connect to Retently Data from PowerBuilder via JDBC
This article demonstrates how to access Retently from PowerBuilder using the Retently JDBC Driver.
-
Connect to Mailjet Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Mailjet to connect to Mailjet and execute queries in PowerBuilder.
-
Build MVC Applications with Connectivity to BenchmarkEmail Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access BenchmarkEmail from an ASP.NET MVC application.
-
Automated Continuous Everhour Replication to IBM DB2
Use CData Sync for automated, continuous, customizable Everhour replication to IBM DB2.
-
Use the CData Software ODBC Driver for SQL Server in SAS for Real-Time Reporting and Analytics
Connect to real-time Microsoft SQL Server in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for SQL Server.
-
Connect to Oracle Service Cloud Data in Google Apps Script via Connect AI
Use CData Connect AI to access Oracle Service Cloud in Google Apps Script.
-
Visualize TigerGraph Data in Sisense
Create an ElastiCube in Sisense app with access to TigerGraph.
-
Replicate Multiple Dynamics CRM Accounts
Replicate multiple Dynamics CRM accounts to one or many databases.
-
Connect to ZohoExpense Data in DBeaver
Use the CData ODBC Driver to connect to ZohoExpense in DBeaver.
-
Import Real-Time Miro Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use Miro in ColdFusion.
-
Create an SAP BusinessObjects Universe on the CData JDBC Driver for Gumroad
Provide connectivity to Gumroad through an SAP BusinessObjects universe.
-
Automated Continuous MailChimp Replication to Apache Kafka
Use CData Sync for automated, continuous, customizable MailChimp replication to Apache Kafka.
-
Connect to Teamwork in SpagoBI
Create reports featuring live Teamwork in SpagoBI Studio. Host Teamwork reports on SpagoBI Server.
-
Use the CData Software JDBC Driver for Confluence in MicroStrategy
Connect to Atlassian Confluence in MicroStrategy Developer using the CData Software JDBC Driver for Confluence.
-
Connect to Apollo Data in Airbyte ELT Pipelines
Use CData Connect AI to build ELT pipelines for Apollo in Airbyte.
-
Replicate Multiple SAP Netweaver Gateway Accounts
Replicate multiple SAP Netweaver Gateway accounts to one or many databases.
-
Import Real-Time XML Data via ODBC in ColdFusion to Build Applications
Use CData ODBC drivers to import and use XML Files in ColdFusion.
-
Connect to Box Data in Ruby
Connect to Box in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Automated Continuous ShipEngine Replication to SingleStore
Use CData Sync for automated, continuous, customizable ShipEngine replication to SingleStore.
-
How to Connect to Live Facebook Ads Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Facebook Ads for you.
-
Access Live MongoDB 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 MongoDB through MCP integration.
-
Access Google Forms Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Google Forms from HeidiSQL.
-
Visualize Live Google Search Results in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Google Search into custom reports in Power BI.
-
Query Avalara AvaTax Data using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Avalara AvaTax entities in PHP by modeling them as objects.
-
Connect to Zoho Projects Data from PowerBuilder via ODBC
This article demonstrates how to use the CData ODBC Driver for Zoho Projects to connect to Zoho Projects and execute queries in PowerBuilder.
-
How to Connect to Live Microsoft Teams Data from Google ADK Agents (via CData Connect AI)
Leverage the CData Connect AI Remote MCP Server to enable Google ADK agents to securely read and take actions on your Microsoft Teams for you.
-
Create Strava Reports on JasperReports Server
Deploy the CData JDBC Driver on JasperReports Server to provide real-time Strava data access from reports, embedded analytics, and more.
-
Viewing Teradata Data in RAD Studio Data Explorer
How to view Teradata in RAD Studio Data Explorer using the CData ODBC Driver for Teradata.
-
Build NetSuite Visualizations in Tableau Desktop
Use CData Connect AI to connect to live NetSuite CRM & ERP and build visualizations in Tableau.
-
LINQ to Jira 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 Jira Data Provider.
-
Parallel Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Parallel facts in real time.
-
Getting Started with the CData Power BI Connector for Google Cloud Storage
Complete guide to installing, licensing, and connecting with the CData Power BI Connector for Google Cloud Storage.
-
Use the CData ODBC Driver for NetSuite in MicroStrategy Desktop
Connect to NetSuite data in MicroStrategy Desktop using the CData ODBC Driver for NetSuite.
-
Natively Connect to SuiteCRM Data in PHP
The CData ODBC driver for SuiteCRM enables you to create PHP applications with connectivity to SuiteCRM. Leverage the native support for ODBC in PHP.
-
How to Use a Microsoft Access Database to Update SharePoint Excel Services Data in Real Time
Update SharePoint Excel Services data by creating a linked table in Microsoft Access with the CData SharePoint Excel Services ODBC Driver.
-
How to Connect to & Open PagerDuty Data in Microsoft Excel
This article uses the CData ODBC driver for PagerDuty to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Analyze Presto Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze Presto with the CData JDBC Driver for Presto.
-
How to Seamlessly Import Avaza Data into IBM SPSS Modeler
Integrate Avaza data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to connect Amazon QuickSight to Elasticsearch Data
Create a connection to Elasticsearch in CData Connect AI and insert Elasticsearch into Amazon QuickSight SPICE to build interactive dashboards.
-
Use Dash to Build to Web Apps on Databricks Data
Create Python applications that use pandas and Dash to build Databricks-connected web apps.
-
Integrate Live Cvent Data into Custom Business Apps Built in Power Apps
Use CData Connect AI to connect to Cvent and integrate live Cvent into apps built in Microsoft Power Apps.
-
Connect to and Visualize Live Auth0 Data in Tableau Prep
Use CData Tableau Connectors and Tableau Prep Builder to visualize live Auth0.
-
Use JayDeBeApi to access Oracle Sales Data in Python
Use standard Python scripting and the development environment of your choice to access live Oracle Sales.
-
Connect to ConvertAPI from Asprova with CData Software ODBC Driver for ConvertAPI
This article shows how to connect faster to ConvertAPI data from Asprova.
-
How to Connect DBeaver to Oracle Eloqua via a JDBC Driver
Manage Oracle Eloqua with visual tools in DBeaver like the query browser.
-
Connect to Freshdesk Data in CloverDX (formerly CloverETL)
Transfer Freshdesk using the visual workflow in the CloverDX data integration tool.
-
Visualize Live Google Sheets Data in the Power BI Service
Use CData Connect AI to connect to live Google Sheets and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Design BIRT Reports on EmailOctopus Data
Provide current EmailOctopus to your embedded analytics.
-
Manage Dynamics 365 Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for Dynamics 365.
-
Build BigCommerce-Powered Applications in Gemini Code Assist with CData MCP Server
Use the CData MCP Server for BigCommerce to explore live BigCommerce Data in Gemini Code Assist to assist with building BigCommerce-powered applications.
-
Create Zendesk-Connected Nintex Workflows
Use CData Connect AI to connect to Zendesk Data from Nintex Workflow Cloud and build custom workflows using live Zendesk.
-
Visualize VWO Data in Tableau
The CData ODBC driver for VWO enables you integrate VWO into Tableau dashboards.
-
How to connect to Zoho Creator Data in DBVisualizer
Integrate Zoho Creator with visual data analysis tools and data connection wizards in DBVisualizer
-
Build Dashboards with WordPress Data in Dundas BI
Create dynamic dashboards and perform analytics based on WordPress in Dundas BI.
-
Access Live Raisers Edge NXT Data in Coginiti Pro
Connect to and query live Raisers Edge NXT from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Configure the CData JDBC Driver for Oracle HCM Cloud in a Connection Pool in Tomcat
Connect to Oracle HCM Cloud from a connection pool in Tomcat.
-
Integrating Codex CLI with Email 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.
-
Prepare, Blend, and Analyze Dynamics 365 Business Central Data in Alteryx Designer (ODBC)
Build workflows to access live Dynamics 365 Business Central for self-service data analytics.
-
Process & Analyze Printify Data in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live Printify Data.
-
How to Seamlessly Import Oracle SCM Data into IBM SPSS Modeler
Integrate Oracle SCM data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Query, Visualize, and Share live Confluence Data in Redash
Use CData Connect AI to connect to live Atlassian Confluence in Redash for querying, visualizing, and sharing.
-
Operational Reporting on OneNote Data from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote Microsoft OneNote.
-
Use Dash to Build to Web Apps on Avalara AvaTax Data
Create Python applications that use pandas and Dash to build Avalara AvaTax-connected web apps.
-
How to connect to Codat Data from IntelliJ
Integrate connectivity to Codat with wizards in IntelliJ.
-
Integrate Amazon S3 Data in Your Informatica Cloud Instance
Use CData JDBC drivers with the Informatica Cloud Secure Agent to access live Amazon S3 from Informatica Cloud.
-
Connect to and Query Zoho Books Data in QlikView over ODBC
Create data visualizations with Zoho Books in QlikView.
-
Use the CData Software ODBC Driver for XML in MicroStrategy Web
Connect to XML Files in MicroStrategy Web using the CData Software ODBC Driver for XML.