data source type for Data Objects in Service Catalog report Builder

book

Article ID: 132002

calendar_today

Updated On:

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