data source type for Data Objects in Service Catalog report Builder

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

In Service Catalog / Report Builder / Data Object / Define new Query / Add data Source, the option for data source type is SQL / Oracle / Ingres.
Is it possible to add an option to MySQL. Is there any way to add this type?

In Service Catalog / Report Builder / Data Object / Define new Query / Add data Source, the option for data source type is SQL / Oracle / Ingres.
Is it possible to add an option to MySQL. Is there any way to add this type?

Environment

Service Catalog 17.x

Resolution

Since these are really hard coded, as a workaround, from Oracle can be created a view that points to another database. So if cusotmer did that then he could create an Oracle report object which queries that view through Oracle. Not sure if MSSQL has something similar but it probably does. Customer would need to create the connection from his MDB to his mysql database somehow and then query the MDB.

When you create a data source, it has the dropdown for selecting the db type with the hardcoded available types.
 

Additional Information

create-a-linked-server-to-mysql-from-sql-server

select-from-linked-mysql-server