CData Software - Knowledge Base
Recent Articles
-
Connect to and Query Google Ad Manager in QlikView over ODBC
Create data visualizations with Google Ad Manager in QlikView.
-
Create Informatica Mappings From/To a JDBC Data Source for SFTP
Create SFTP data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.
-
Connect to MySQL as an External Data Source using PolyBase
Use CData Connect AI and PolyBase to create an external data source in SQL Swerver with access to live MySQL.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Active Directory
Provide connectivity to Active Directory through an SAP BusinessObjects universe.
-
Access Live Oracle Eloqua Reporting in Coginiti Pro
Connect to and query live Oracle Eloqua Reporting from the GUI in the Coginiti Pro: SQL Analytics Tool.
-
Stream XML into Apache Kafka Topics
Access and stream XML Files in Apache Kafka using the CData JDBC Driver and the Kafka Connect JDBC connector.
-
Viewing AlloyDB in RAD Studio Data Explorer
How to view Google AlloyDB in RAD Studio Data Explorer using the CData ODBC Driver for AlloyDB.
-
Build Zendesk-Connected Apps in Choreo
Use CData Connect AI to connect to Zendesk from Choreo and build custom apps using live Zendesk.
-
Create a Data Access Object for Clio using JDBI
A brief overview of creating a SQL Object API for Clio in JDBI.
-
Query Phoenix in ColdFusion
Write standard ColdFusion data access code to connect to Apache Phoenix.
-
Building Dynamic Web Pages with Confluence Using AngularJS
Create single-page applications with live connectivity to Confluence using the CData API Server.
-
Connect to CockroachDB in SpagoBI
Create reports featuring live CockroachDB in SpagoBI Studio. Host CockroachDB reports on SpagoBI Server.
-
Connect to Slack in RazorSQL
Connect to Slack from wizards and query Slack from the GUI in the RazorSQL database management tool.
-
Integrating Dataiku with SendGrid via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Dataiku Agents to securely query and act on live SendGrid.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Freshdesk
Provide connectivity to Freshdesk through an SAP BusinessObjects universe.
-
Publish ClickUp-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live ClickUp.
-
Use the CData ODBC Driver for Confluence from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Confluence to connect to Atlassian Confluence from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Atlassian Confluence in Excel.
-
Rapidly Develop ConstantContact-Driven Apps with Active Query Builder
Leverage the Active Query Builder SQL interface builder and the ease of .NET data access to create data-driven WinForms and ASP.NET apps.
-
Analyze Live SAP HANA in SAS Viya
Use CData Connect AI to connect to SAP HANA from SAS Viya and deploy self-service analytics using live SAP HANA.
-
Building Dynamic Web Pages with PostgreSQL Using AngularJS
Create single-page applications with live connectivity to PostgreSQL using the CData API Server.
-
Publish Reports with Splunk in SAP Crystal Reports
Use the Report Wizard to design a report based on up-to-date Splunk.
-
Access Salesforce Pardot from MySQL in PHP
Connect to Salesforce Pardot through the standard MySQL libraries in PHP.
-
Analyze Access in R via JDBC
Use standard R functions and the development environment of your choice to analyze Microsoft Access with the CData JDBC Driver for Access.
-
Prepare, Blend, and Analyze SQL Server in Alteryx Designer (ODBC)
Build workflows to access live Microsoft SQL Server for self-service data analytics.
-
A PostgreSQL Interface for Snowflake using the CData ODBC Driver
Use the SQL Gateway and Snowflake ODBC Driver to create a PostgreSQL entry-point for data access.
-
How to pipe eBay Analytics to CSV in PowerShell
Use standard PowerShell cmdlets to access eBay Analytics tables.
-
Automated Continuous Calendly Replication to Azure SQL Database
Use CData Sync for automated, continuous, customizable Calendly replication to Azure SQL Database.
-
Automated Continuous Twitter Ads Replication to Google Cloud SQL
Use CData Sync for automated, continuous, customizable Twitter Ads replication to Google Cloud SQL.
-
Automated Continuous Microsoft Exchange Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Microsoft Exchange replication to Amazon S3.
-
Publish Vault CRM-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live Veeva Vault & Vault CRM.
-
Create an SAP BusinessObjects Universe on the CData ODBC Driver for Oracle SCM
Provide connectivity to Oracle SCM through an SAP BusinessObjects universe.
-
Automate Excel Online Replication to Azure Synapse
Use CData Sync to customize and automate Microsoft Excel Online replication to Azure Synapse.
-
Connect to Microsoft Teams from a Connection Pool in WebLogic
Use the CData JDBC Driver for Microsoft Teams to connect to Microsoft Teams from Web applications running on WebLogic.
-
Integrate Real-Time Access to Amazon DynamoDB in SAPUI5 MVC Apps
Use the built-in ODataModel class in SAPUI5 to create Web apps that reflect changes to Amazon DynamoDB in real time.
-
Publish SAP-Connected Dashboards in Tableau Server via JDBC
Use CData JDBC drivers and Tableau Server to visualize live SAP ERP/NetWeaver.
-
Connect to SAP BusinessObjects BI from AWS Glue
Use CData Connect AI to gain access to live SAP BusinessObjects BI from your AWS Glue jobs.
-
Use Azure AI Foundry to Talk to Your Confluence via CData Connect AI
Leverage the CData Connect AI Remote MCP Server to enable Azure AI Foundry agents to securely answer questions and take actions on your Atlassian Confluence for you.
-
Create a Data Access Object for Printify using JDBI
A brief overview of creating a SQL Object API for Printify in JDBI.
-
Process & Analyze SAP Ariba Source in Databricks (AWS)
Use CData, AWS, and Databricks to perform data engineering and data science on live SAP Ariba Source .
-
Connect and Visualize Live Amazon Athena Data in Databricks Lakehouse Federation with CData Connect AI
Use CData Connect AI to integrate live Amazon Athena into the Databricks platform and create visualization dashboards with real-time Amazon Athena.
-
Create Dynamic Authorize.Net Grids Using the Infragistics XamDataGrid
Learn how you can connect Authorize.Net to Infragistics XamDataGrid to build dynamic grids.
-
How to connect to HubSpot from Spring Boot
Connect to HubSpot in a Spring Boot Application using CData JDBC HubSpot Driver
-
Build MVC Applications with Connectivity to Oracle SCM
This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Oracle SCM from an ASP.NET MVC application.
-
Create Salesforce Pardot-Connected Visualizations in Klipfolio
Use CData Connect AI to connect to Salesforce Pardot from Klipfolio and build custom visualizations using live Salesforce Pardot.
-
Use the CData API Server to Access Airtable in Microsoft PowerPivot
Use the CData API Server to connect to live Airtable in the Power Pivot business intelligence tool.
-
Use the CData Software JDBC Driver for BigCommerce in MicroStrategy Desktop
Connect to BigCommerce in MicroStrategy Desktop using the CData Software JDBC Driver for BigCommerce.
-
Automated Continuous Kintone Replication to Amazon S3
Use CData Sync for automated, continuous, customizable Kintone replication to Amazon S3.
-
DataBind Controls to IBM Informix in Delphi
DataBind to IBM Informix in Delphi with standard data access components and controls.
-
Validate ClickUp with QuerySurge
Access and validate ClickUp in QuerySurge using the CData JDBC Driver.
-
Import Freshdesk into Microsoft Power Query
The CData API Server offers standards-based Web service endpoints that allow a variety of applications to access Freshdesk. In this article, you will use the OData format to import Freshdesk into Microsoft Power Query.
-
Build RSS-Powered Applications in Cursor with CData Code Assist MCP
-