CData Software - Knowledge Base
Recent Articles
-
Visualize WordPress in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load WordPress into TIBCO Spotfire.
-
Use the CData Software ODBC Driver for SQL Analysis Services in MicroStrategy
Connect to SQL Analysis Services in MicroStrategy Developer using the CData Software ODBC Driver for SQL Analysis Services.
-
Create Active Directory-Connected Business Apps in AppSheet
Connect to Active Directory via CData Connect AI in Google AppSheet and create custom business applications with real-time access to Active Directory.
-
Natively Connect to SAS xpt in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SAS XPORT. Leverage the native support for ODBC in PHP.
-
Visualize FTP in TIBCO Spotfire through ODBC
The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load FTP Servers into TIBCO Spotfire.
-
Connect to SAP Netweaver Gateway in Ruby
Connect to SAP Netweaver Gateway in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.
-
Access XML from MySQL in Amazon QuickSight
Connect to XML and build visualizations of XML Files using a MySQL Connection in Amazon QuickSight.
-
Connect to Excel Online in RunMyProcess through Connect AI
Use CData Connect AI to create on OData API for Excel Online and connect to Microsoft Excel Online in Akorbi Digital RunMyProcess.
-
Automate Certinia Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live Certinia and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Automate SAP HANA Replication to Azure Data Lake
Use CData Sync to customize and automate SAP HANA replication to Azure Data Lake.
-
Create Power BI Reports on Real-Time Adobe Target
Use the CData ODBC Driver for Adobe Target to visualize Adobe Target in Power BI Desktop.
-
Use the CData Software ODBC Driver for Paylocity in SAS for Real-Time Reporting and Analytics
Connect to real-time Paylocity in SAS for reporting, analytics, and visualizations using the CData Software ODBC Driver for Paylocity.
-
How to Connect to Live Presto from Claude Agent SDK (via CData Connect AI)
Leverage CData Connect AI to enable Claude Agent SDK applications to securely read and take actions on your Presto for you.
-
Build Semantic Layer Views for ActiveCampaign in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for ActiveCampaign.
-
Automated Continuous SQL Server Replication to AlloyDB
Use CData Sync for automated, continuous, customizable SQL Server replication to AlloyDB.
-
Use the CData Software JDBC Driver for Slack in MicroStrategy Desktop
Connect to Slack in MicroStrategy Desktop using the CData Software JDBC Driver for Slack.
-
Connect to Hive in ACL Analytics
Connect to Apache Hive via CData Connect AI in ACL Analytics to run your data analysis workflows with real-time access to Apache Hive.
-
Query HBase as a MySQL Database in Node.js
Execute MySQL queries against Apache HBase from Node.js.
-
Operational Reporting on JSON Services from Spotfire Server
Create and share Spotfire data visualizations with real-time connectivity to remote JSON.
-
Write a Simple Go Application to work with Microsoft Exchange on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft Exchange.
-
Use the CData API Server in Microsoft Power BI
You can use the CData API Server to feed Zoho Creator to Power BI dashboards. Simply drag and drop Zoho Creator into data visuals on the Power BI canvas.
-
Use Claude to Talk to Your Outreach.io via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Claude to securely answer questions and take actions on your Outreach.io for you.
-
Connect to QuickBooks Time as an External Source in Dremio
Use the CData JDBC Driver to connect to QuickBooks Time as an External Source in Dremio.
-
How to Work with BambooHR in AWS Glue Jobs Using JDBC
Connect to BambooHR from AWS Glue jobs using the CData Software JDBC Driver hosted in Amazon S3.
-
A PostgreSQL Interface for Azure Active Directory using the CData ODBC Driver
Use the SQL Gateway and Azure Active Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Use JayDeBeApi to access Twilio in Python
Use standard Python scripting and the development environment of your choice to access live Twilio.
-
Import and Visualize Email in Power View
Create data visualizations based on Email in Excel.
-
Create a Data Access Object for Tally using JDBI
A brief overview of creating a SQL Object API for Tally ERP in JDBI.
-
Feed Twitter into FineReport
How to set Twitter as a JDBC data source in FineReport.
-
Visualize Live BigCommerce in the Power BI Service
Use CData Connect AI to connect to live BigCommerce and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Analyze Live Office 365 in SAS Viya
Use CData Connect AI to connect to Microsoft Office 365 from SAS Viya and deploy self-service analytics using live Microsoft Office 365.
-
Automate Odoo Integration Tasks from PowerShell
Are you in search of a quick and easy way to access Odoo ERP from PowerShell? This article demonstrates how to utilize the Odoo Cmdlets for tasks like connecting to Odoo ERP, automating operations, downloading data, and more.
-
Create Informatica Mappings From/To an ODBC Data Source for Azure Active Directory
Create an ODBC connection to Azure Active Directory in Informatica and browse and transfer Azure Active Directory.
-
Build MYOB AccountRight-Powered Applications in Claude Code with CData Code Assist MCP
-