CData Software - Knowledge Base
Recent Articles
-
Connect to Amazon DynamoDB from Crystal Reports
Use CData Connect AI to connect to and report on live Amazon DynamoDB from Crystal Reports.
-
Create a Data Access Object for Google Data Catalog using JDBI
A brief overview of creating a SQL Object API for Google Data Catalog in JDBI.
-
Connect Klipfolio to IBM WebSphere Using the CData JDBC Driver
Use the CData JDBC Driver to connect Klipfolio with IBM WebSphere for seamless data integration and connectivity.
-
Build Semantic Layer Views for Microsoft Teams in APOS Live Data Gateway
Use the CData Connect AI and APOS Live Data Gateway to build Semantic Layer Views for Microsoft Teams.
-
DataBind Controls to Databricks in C++Builder
DataBind to Databricks in C++Builder with standard components and controls.
-
Connecting Mastra with MailChimp 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 300+ enterprise sources no replication required.
-
Visualize Live Sugar CRM in Power BI (via CData Connect AI)
Use the CData Power BI Connector and CData Connect AI to integrate live Sugar CRM into custom reports in Power BI.
-
A PostgreSQL Interface for SAS Data Sets using the CData ODBC Driver
Use the SQL Gateway and SAS Data Sets ODBC Driver to create a PostgreSQL entry-point for data access.
-
Automate MariaDB Tasks in Power Automate Using CData API Server
With CData API Server, easily create OData endpoints for live MariaDB and automate complex workflows in Power Automate, such as automated emails, CRM and ERP sync, and more.
-
Use Crystal Reports to create reports with Salesforce data
The CData Data Providers (JDBC, ODBC, and ADO.NET) implement standards based access to various data source which enables third party tools to interoperate. In this article we use the CData JDBC Driver for Salesforce from Crystal Reports to publish reports based on Salesforce data.
-
Query Oracle SCM using the OData SDK for PHP
Use the API Server and the OData PHP SDK to easily consume Oracle SCM entities in PHP by modeling them as objects.
-
Visualize Live Google Spanner of Power BI Report Builder in Power BI Service
Use CData Power BI Connectors to connect to live Google Spanner using Power BI Report Builder and create custom reports in the Power BI Service through the On-Premises Gateway.
-
Integrate FTP with JetBrains RubyMine using CData JDBC Drivers
Learn how to integrate FTP with JetBrains RubyMine using the CData JDBC Driver for live SQL based access to FTP Servers.
-
Create Dynamic SAP HANA Grids Using the Infragistics XamDataGrid
Learn how you can connect SAP HANA to Infragistics XamDataGrid to build dynamic grids.
-
Connect to Lakebase from a Connection Pool in WebLogic
Use the CData JDBC Driver for Lakebase to connect to Lakebase from Web applications running on WebLogic.
-
How to import Facebook Ads into Apache Solr
Use the CData Software JDBC Driver for Facebook Ads in Data Import Handler and create an automated import of Facebook Ads to Apache Solr Enterprise Search platform.
-
Access Redshift from MySQL in Amazon QuickSight
Connect to Redshift and build visualizations of Amazon Redshift using a MySQL Connection in Amazon QuickSight.
-
Publish Crystal Reports on JSON Services
Use the Report Wizard and standard ADO.NET to design a report based on up-to-date JSON.
-
Analyze HubSpot with Power Pivot
This article walks you through the process of using the CData ODBC Driver for HubSpot from Power Pivot. You will use the Table Import Wizard to load HubSpot. You can visually build the import query or use any SQL supported by the driver.
-
Migrating data from Snowflake to Snowflake using CData SSIS Components.
Easily push Snowflake to Snowflake using the CData SSIS Tasks for Snowflake and Snowflake.
-
Replicate CSV in Heroku for Use in Salesforce Connect
Replicate CSV/TSV Files to a PostgreSQL database on Heroku and connect it to Salesforce using Salesforce Connect.
-
Feed Amazon Athena into FineReport
How to set Amazon Athena as a JDBC data source in FineReport.
-
Getting Started with the CData Python Connector for Basecamp
Learn to install and license the CData Python Connector
-
Connect to Google Spanner from Excel & GoogleSheets!
Connect Spreadsheets is a free, easy-to-use add-in that allows you to access and work with data from Google Spanner, and over 250 other data sources, right inside your Excel and Google spreadsheets!
-
Write a Simple Go Application to work with SharePoint on Linux
Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to Microsoft SharePoint.
-
Connect to Tally in Aqua Data Studio
Access Tally ERP from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.
-
Connect to Oracle Eloqua in DBArtisan
Use wizards in DBArtisan to configure Oracle Eloqua as a data source.
-
Creating ActiveCampaign-Connected Applications in Unqork
You can use CData Connect AI to feed ActiveCampaign to Unqork and build custom business apps.
-
Use the CData ODBC Driver for Active Directory from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Active Directory to connect to Active Directory from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Active Directory in Excel.
-
Visualize Paylocity from Tableau
Use the Tableau Desktop business intelligence tool to connect to Paylocity.
-
Use Grok to Talk to Your LinkedIn 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 LinkedIn for you.
-
Use the CData ODBC Driver for ActiveCampaign in Microsoft Power Query
You can use the CData ActiveCampaign ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import ActiveCampaign into Microsoft Power Query.
-
Google Drive Reporting and Star Schemas in OBIEE
Create a star schema that shows perspectives on Google Drive facts in real time.
-
Access Live PostgreSQL in Excel 365 Online (Excel for the web)
Connect to PostgreSQL from Excel 365 Online (Excel for the web) with CData Connect AI.
-
Load Amazon Athena to a Database Using Embulk
Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Amazon Athena to a database.
-
Build Apps with Live Blackbaud FE NXT Using the Low-Code Development Platform of Mendix
-