CData Software - Knowledge Base
Recent Articles
-
Use the CData Software ODBC Driver for Quaderno in MicroStrategy
Connect to Quaderno in MicroStrategy Developer using the CData Software ODBC Driver for Quaderno.
-
Access Live FTP Data in Excel 365 Online (Excel for the web)
Connect to FTP Servers from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Natively Connect to Google Ad Manager Data in PHP
The CData ODBC driver for Google Ad Manager enables you to create PHP applications with connectivity to Google Ad Manager. Leverage the native support for ODBC in PHP.
-
Connect to Office 365 Data from PowerBuilder via JDBC
This article demonstrates how to access Microsoft Office 365 from PowerBuilder using the Office 365 JDBC Driver.
-
Import Real-Time RabbitMQ Data via JDBC in ColdFusion to Build Applications
Use CData JDBC drivers to import and use RabbitMQ in ColdFusion.
-
Build MVC Applications with Connectivity to Adobe Experience Manager Data
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Adobe Experience Manager from an ASP.NET MVC application.
-
LinkedIn Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on LinkedIn facts in real time.
-
Connect to Klaviyo from a Connection Pool in WebLogic
Use the CData JDBC Driver for Klaviyo to connect to Klaviyo from Web applications running on WebLogic.
-
Building Dynamic Web Pages with Slack Data Using AngularJS
Create single-page applications with live connectivity to Slack using the CData API Server.
-
Connect to Splunk Data in HULFT Integrate
Connect to Splunk as a JDBC data source in HULFT Integrate
-
Access Wistia Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Wistia from HeidiSQL.
-
Automate Quaderno Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Quaderno and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Explore Geographical Relationships in Authorize.Net Data with Power Map
Create data visualizations with Authorize.Net in Power Map.
-
Build Automated Workflows with Live ServiceNow Data in Workato
Use CData Connect AI to connect to live ServiceNow and build automated workflows in Workato.
-
How to Easily Query SAS Data Sets Data in OpenOffice Base
Connect to SAS Data Sets data in OpenOffice Base using the CData ODBC Driver for SAS Data Sets and generate reports with live data insights.
-
Sage Cloud Accounting Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Sage Cloud Accounting facts in real time.
-
Analyze Accelo Data in R via ODBC
Create data visualizations and use high-performance statistical functions to analyze Accelo in Microsoft R Open.
-
Visualize Live HCL Domino Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live HCL Domino using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate Live Cosmos DB Data into Amazon SageMaker Canvas with RDS
Use CData Connect AI to connect to Cosmos DB from Amazon RDS connector in Amazon SageMaker Canvas and build custom models using live Azure Cosmos DB.
-
Access Live Office 365 Data in Excel (Desktop) through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Microsoft Office 365 from your Excel spreadsheets.
-
Publish Tally-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Tally ERP.
-
How to connect to Kintone Data from Spring Boot
Connect to Kintone in a Spring Boot Application using the CData JDBC Driver for Kintone
-
Access Live Simplesat Data in TIBCO Data Virtualization
Use the CData API Driver for Tibco DV to create a Simplesat data source in TIBCO Data Virtualization Studio and gain access to live Simplesat from your TDV Server.
-
Use the CData Software JDBC Driver for SharePoint in MicroStrategy
Connect to Microsoft SharePoint in MicroStrategy Developer using the CData Software JDBC Driver for SharePoint.
-
How to Query Live YouTube Analytics Data in Perplexity MacOS Desktop
Connect to and query live YouTube Analytics Data in Perplexity Desktop using CData MCP Server.
-
How to Import Data from Oracle HCM Cloud into Google Sheets
Import Oracle HCM Cloud into a Google spreadsheet that is automatically refreshed.
-
Access Live Freshteam Data in Coginiti Pro
Connect to and query live Freshteam from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Access Live RabbitMQ Data in AWS Lambda (with IntelliJ IDEA)
Connect to live RabbitMQ in AWS Lambda using IntelliJ IDEA and the CData JDBC Driver to build the function.
-
Integrate with Sentry Data in JReport Designer
Create charts and reports based on Sentry in JReport Designer.
-
Extend Google Sheets with Google Forms Data
Make calls to Google Forms from Google Apps Script via the API Server.
-
Connect to Act CRM Data in Google Apps Script via SQL Gateway
Use the ODBC Driver for Act CRM and the SQL Gateway to access Act CRM from Google Apps Script.
-
How to Connect to Live HubSpot Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live HubSpot securely in real time.
-
Edit and Search Microsoft OneDrive External Objects in Salesforce Connect (API Server)
Use the API Server to securely provide OData feeds of Microsoft OneDrive to smart devices and cloud-based applications. Use the API Server and Salesforce Connect to create Microsoft OneDrive objects that you can access from apps and the dashboard.
-
Use the CData Software ODBC Driver for Bannerbear in MicroStrategy
Connect to Bannerbear in MicroStrategy Developer using the CData Software ODBC Driver for Bannerbear.
-
How to load Salesforce Pardot data into Elasticsearch via Logstash
Introducing a simple method to load Salesforce Pardot data using the ETL module Logstash of the full-text search service Elasticsearch and the CData JDBC driver.
-
Building Dynamic Web Pages with Impala Data Using AngularJS
Create single-page applications with live connectivity to Impala using the CData API Server.
-
Amplitude Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Amplitude facts in real time.
-
Replicate Multiple Facebook Accounts
Replicate multiple Facebook accounts to one or many databases.
-
Connect to SAP Ariba Source Data in Aqua Data Studio
Access SAP Ariba Source from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Create SSAS Tabular Models from Salesforce Data 360 Data
How to build a SQL Server Analysis Service Tabular Model from Salesforce Data 360 using CData drivers.
-
How to Visualize SAP Hybris C4C Data in Python with pandas
Use pandas and other modules to analyze and visualize live SAP Hybris C4C in Python.
-
Easily Integrate SAP SuccessFactors LMS Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP SuccessFactors LMS in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Access Dotmailer 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 Dotmailer.
-
Query Google Tasks Data through ODBC in Node.js
Use node-odbc to execute SQL queries against Google Tasks from Node.js.
-
How to Seamlessly Import Aha! Data into IBM SPSS Modeler
Integrate Aha! data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
Integrate ServiceNow with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate ServiceNow with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to ServiceNow.
-
Integrating CapsuleCRM Data in Talend Cloud Data Management Platform
Connect CapsuleCRM Data with Talend Cloud Data Management Platform using the CData API Driver for JDBC.
-
Visualize Mocean Data in Sisense
Create an ElastiCube in Sisense app with access to Mocean.
-
Integrate Instagram Data in Pentaho Data Integration
Build ETL pipelines based on Instagram in the Pentaho Data Integration tool.
-
Integrating OpenCode Terminal with Google Sheets 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.
-
How to work with LinkedIn Data in Apache Spark using SQL
Access and process LinkedIn Data in Apache Spark using the CData Software JDBC Driver.
-
Moving Data from Apollo to SQL Server Using Toad Data Point and CData ODBC Driver
Query, export, and automate live Apollo data pipelines into SQL Server using Toad Data Point and the CData ODBC Driver, no ETL required.
-
Connect to Amazon DynamoDB Data in ACL Analytics
Connect to Amazon DynamoDB via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Amazon DynamoDB.
-
Analyze PivotalTracker Data in R via JDBC
Use standard R functions and the development environment of your choice to analyze PivotalTracker with the CData JDBC Driver for PivotalTracker.
-
Create Data Visualizations Based On eBay Data in Mode
Use CData Connect AI to connect to eBay Data from Mode and build visualizations using live
-
Connect to Webex Data in Claris FileMaker Pro
Use the CData API Driver for ODBC in FileMaker Pro to connect to Webex and work with Webex in your FileMaker applications.
-
Consume SAP SuccessFactors LMS OData Feeds in SAP Lumira
Use the API Server to create data visualizations on SAP SuccessFactors LMS feeds that reflect any changes in SAP Lumira.
-
DataBind Charts to Rootly Data
Use the standard ADO.NET procedures for databinding to provide bidirectional access to Rootly from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.
-
A PostgreSQL Interface for Oracle Service Cloud Data using the CData ODBC Driver
Use the SQL Gateway and Oracle Service Cloud ODBC Driver to create a PostgreSQL entry-point for data access.
-
Manage PingOne Data in DBArtisan as a JDBC Source
Use wizards in DBArtisan to create a JDBC data source for PingOne.
-
How to connect to Superchat Data with Squirrel SQL client
Connect to Superchat and execute queries in the Squirrel SQL Client.
-
Automated Continuous Freshservice Replication to Amazon Redshift
Use CData Sync for automated, continuous, customizable Freshservice replication to Amazon Redshift.
-
Access Google Sheets Data from MySQL in Amazon QuickSight
Connect to Google Sheets and build visualizations of Google Sheets using a MySQL Connection in Amazon QuickSight.
-
Visualize Live Trello Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Trello using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Migrating data from Discord to Snowflake using CData SSIS Components.
Easily push Discord to Snowflake using the CData SSIS Tasks for Discord and Snowflake.
-
DataBind Controls to Zoho Books Data in Delphi
DataBind to Zoho Books in Delphi with standard data access components and controls.
-
Visualize Live Lakebase Data of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Lakebase using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Getting Started with the CData Tableau Connector for SendGrid
Complete guide to installing, licensing, and connecting with the CData Tableau Connector for SendGrid.
-
Integrate with Parallel Data using Apache Camel2
Create a simple Java app that uses Apache Camel routing and the CData JDBC Driver to copy Parallel to a JSON file on disk.
-
Access Live Oracle Service Cloud Data in Google Sheets through Connect Spreadsheets
Use Connect Spreadsheets by CData to gain access to live Oracle Service Cloud from your Google Sheets.
-
Access Stripe Data from MySQL in HeidiSQL
Use CData ODBC Driver and SQL Gateway to connect and query live Stripe from HeidiSQL.
-
Integrate Live Apollo Data in the Windsurf IDE via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Windsurf
-
Build SQL Analysis Services-Connected Visualizations in datapine
Use CData Connect AI and datapine to build visualizations and dashboards with access to live SQL Analysis Services.
-
Build SAP Netweaver Gateway-Connected Apps in Choreo
Use CData Connect AI to connect to SAP Netweaver Gateway Data from Choreo and build custom apps using live SAP Netweaver Gateway.
-
Access Teamgate Data as a Remote Oracle Database
Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Teamgate from your Oracle system.
-
How to create Visio diagrams from MarkLogic Data
Automatically update MarkLogic with the changes you make to Visio master shapes.
-
Connect to Google Ad Manager Data in NetBeans
Connect to Google Ad Manager in NetBeans with the data source configuration wizard.
-
Visualize Templated 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 Templated into TIBCO Spotfire.
-
Connect to Accelo Data in Aqua Data Studio
Access Accelo from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Analyze Microsoft Teams Data in Infragistics Reveal
Use the CData API Server to create an OData API on top of Microsoft Teams and visualize live Microsoft Teams in Infragistics Reveal.
-
Import GitHub Data Using Azure Data Factory
Use CData Connect AI to connect to GitHub Data from Azure Data Factory and import live GitHub.
-
Access Live Planio Data in Coginiti Pro
Connect to and query live Planio from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
How to Connect to Live Dynamics CRM 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 Dynamics CRM for you.
-
Natively Connect to GitHub Data in PHP
The CData ODBC driver for GitHub enables you to create PHP applications with connectivity to GitHub. Leverage the native support for ODBC in PHP.
-
Use the CData SSIS Components to Insert New or Update Existing Paylocity Records from SQL Server
Easily push SQL Server data to Paylocity using the CData SSIS Components. This example uses an SSIS workflow to either insert new records into Paylocity or update existing records with data from a SQL Server database.
-
Use the CData Software JDBC Driver for Redshift in MicroStrategy
Connect to Amazon Redshift in MicroStrategy Developer using the CData Software JDBC Driver for Redshift.
-
Migrating data from Salesforce CRM Analytics to Snowflake using CData SSIS Components.
Easily push Salesforce CRM Analytics to Snowflake using the CData SSIS Tasks for Salesforce CRM Analytics and Snowflake.
-
Use Grok to Talk to Your Certinia 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 Certinia for you.
-
Getting Started with the CData ODBC Driver for Dotmailer
Complete guide to installing, licensing, and connecting with the CData ODBC Driver for Dotmailer.
-
Use the CData Software ODBC Driver for Sage Intacct in SAS for Real-Time Reporting and Analytics
Connect to real-time Sage Intacct in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Sage Intacct.
-
Working with EmailOctopus Data in LINQPad
Execute LINQ queries to EmailOctopus in LINQPad.
-
Automate Databricks Data Replication to Azure Synapse
Use CData Sync to customize and automate Databricks replication to Azure Synapse.
-
Establish a Live Connection with QuickBooks Time Data using Tableau Bridge
The CData ODBC Driver for QuickBooks Time enables you to integrate live QuickBooks Time into Tableau Cloud dashboards using the Tableau Bridge.
-
How to Connect Flowise AI Agents to Live Greenplum Data via CData Connect AI
Integrate Flowise AI with the CData Connect AI MCP Server to enable agents to securely query and act on live Pivotal GreenPlum without replication.
-
Connect to Omnisend in SpagoBI
Create reports featuring live Omnisend in SpagoBI Studio. Host Omnisend reports on SpagoBI Server.
-
Easily Integrate SAP HANA XS Advanced Data in Lazarus Pascal IDE
Learn how to easily integrate live SAP HANA XS Advanced in Lazarus Pascal IDE using the CData ODBC Driver for real-time insights.
-
Connect to Google Spanner Data from PowerBuilder via JDBC
This article demonstrates how to access Google Spanner from PowerBuilder using the Google Spanner JDBC Driver.
-
Query MySQL Data in ColdFusion
Write standard ColdFusion data access code to connect to MySQL.
-
Analyze Outreach.io Data with Power Pivot
This article walks you through the process of using the CData ODBC Driver for Outreach.io from Power Pivot. You will use the Table Import Wizard to load Outreach.io. You can visually build the import query or use any SQL supported by the driver.
-
Access Live Jira Data in SAS JMP via ODBC
You can use the CData ODBC Driver to integrate Atlassian Jira into the statistical analysis tools available in SAS JMP. This article shows how to use Atlassian Jira in the Graph Builder and Query Builder.