CData Software - Knowledge Base
Recent Articles
-
Build a Simple VCL Application for Bitbucket
How to build a simple VCL Application to view Bitbucket in RAD Studio using the CData ODBC Driver for Bitbucket.
-
Replicate Salesforce Marketing from PowerShell
Write a quick PowerShell script to query Salesforce Marketing Cloud. Use connectivity to the live data to replicate Salesforce Marketing Cloud to SQL Server.
-
Create Data Visualizations in Cognos BI with JotForm
Access JotForm as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.
-
Twitter Ads Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Twitter Ads facts in real time.
-
Integrating Gumloop with Presto via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Gumloop to securely access and act on Presto within automated workflows.
-
Natively Connect to SFTP in PHP via ODBC (Linux)
Create PHP applications on Linux/UNIX machines with connectivity to SFTP. Leverage the native support for ODBC in PHP.
-
How to Query Live IBM Informix in Perplexity MacOS Desktop
Connect to and query live IBM Informix in Perplexity Desktop using CData Code Assist MCP.
-
Use JayDeBeApi to access Zendesk in Python
Use standard Python scripting and the development environment of your choice to access live Zendesk.
-
Extend Google Sheets with Paylocity
Make calls to the API Server from Google Apps Script.
-
Analyze WooCommerce in Cognos Analytics
Use CData Connect AI to connect to WooCommerce from Cognos Analytics and analyze live WooCommerce.
-
A PostgreSQL Interface for Google Directory using the CData ODBC Driver
Use the SQL Gateway and Google Directory ODBC Driver to create a PostgreSQL entry-point for data access.
-
Query SFTP using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume SFTP entities in PHP by modeling them as objects.
-
How to Connect to Live ShipStation Data from Sourcegraph Amp (via CData Connect AI)
Integrate Sourcegraph Amp with CData Connect AI to query and manage live ShipStation securely in real time.
-
Create Data Visualizations Based On BigCommerce in Mode
Use CData Connect AI to connect to BigCommerce from Mode and build visualizations using live
-
Connect to Oracle HCM Cloud in SpagoBI
Create reports featuring live Oracle HCM Cloud in SpagoBI Studio. Host Oracle HCM Cloud reports on SpagoBI Server.
-
Process & Analyze eBay Analytics in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live eBay Analytics .
-
Automated Continuous Google Analytics Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Google Analytics replication to Azure SQL Database.
-
Analyze Reckon in Infragistics Reveal
Use CData Connect AI to create on OData API on top of Reckon and visualize live Reckon in Infragistics Reveal.
-
Excel Spreadsheet Automation on IBM Cloud Object Storage with the QUERY Formula
Pull data, automate spreadsheets, and more with the QUERY formula.
-
How to integrate SingleStore with Apache Airflow
Access and process SingleStore in Apache Airflow using the CData JDBC Driver.
-
How to connect to SAP SuccessFactors from IntelliJ
Integrate connectivity to SAP SuccessFactors with wizards in IntelliJ.
-
How to Connect to & Open Oracle Service Cloud in Microsoft Excel
This article uses the CData ODBC driver for Oracle Service Cloud to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.
-
Azure Analysis Services Reporting in OBIEE with the Azure Analysis Services JDBC Driver
Deploy the Azure Analysis Services JDBC driver on OBIEE to provide real-time reporting across the enterprise.
-
Migrating data from SAS Data Sets to Databricks using CData SSIS Components.
Easily push SAS Data Sets to Databricks using the CData SSIS Tasks for SAS Data Sets and Databricks.
-
Use the CData ODBC Driver for Google Ad Manager from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Google Ad Manager to connect to Google Ad Manager from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Google Ad Manager in Excel.
-
Build Visualizations of Google Ads in Birst
Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Google Ads in Birst.
-
Connect to AlloyDB as an External Source in Dremio
Use the CData JDBC Driver to connect to AlloyDB as an External Source in Dremio.
-
Integrate Real-Time Access to Cloudant in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to IBM Cloudant in real time.
-
Connecting Mastra with Cassandra via CData Connect AI MCP Server
Leverage the CData Connect AI MCP Server to enable Mastra agents to securely query, read, and act on real-time data across hundreds of enterprise sources no replication required.
-
Connect to Zoho Books from a Connection Pool in Jetty
The Zoho Books JDBC Driver supports connection pooling: This article shows how to connect faster to Zoho Books from Web apps in Jetty.
-
Build Automated Workflows with Live SAP Ariba Source in Workato
Use CData Connect AI to connect to live SAP Ariba Source and build automated workflows in Workato.
-
How to Seamlessly Import Azure Synapse Data into IBM SPSS Modeler
Integrate Azure Synapse data into IBM SPSS Modeler using the CData ODBC Driver for real-time insights and advanced data analysis.
-
How to use SQLAlchemy ORM to access Microsoft Project in Python
Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Project.
-
Publish Stripe-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Stripe.
-
DataBind Oracle Financials Cloud to the DevExpress Data Grid
Use the CData Software ADO.NET Provider for Oracle Financials Cloud with the DevExpress Windows Forms and Web controls to provide Oracle Financials Cloud to a chart.
-
Integrating Claude Code with WooCommerce via CData Connect AI
Leverage CData Connect AI to enable Claude Code to securely access and act on WooCommerce within assisted coding and automated development workflows.
-
Build AI/ML Models with Live Azure Table Data using Dataiku
-