During the setup of the Seemless BMC Connector, Avnet provides plenty of information for their client. A little harder to find is how to setup access for the client to the DWH database.
Is the Database called DWH_inventory? If I create a user in the GUI User Management what level of access should I provide and does it even provide access to the MySQL database. If not how do I create that user?
I don't have any hands on time with the BMC connector, but I am going to guess that it is using the built in, read-only MySQL user the OCI DWH exposes. This mysql user is dwhuser / netapp123
dwh_inventory is one of the databases this user has read only access to. The inventory mart is a point in time (as of the last ETL) inventory view of the world, as your OCI servers merged together will see it