6 Replies Latest reply on Oct 21, 2011 8:29 AM by nheinze

    Trying to understand how to access repository tables/views from within PowerCenter Designer

    New Member

      Good Day -

      I am tasked with taking wf/session statistics out of the repository and placing them in  a external SQL db.  I have determined that using the MX views will most likely be the mechanism I want, but have been unable to find anything giving me information on how I might be able to access them.  My goal, is to import the view as  source and use informatica to ETL the fields i want to the seperate DB.

       

      We are all fairly new to this process here, and so are unsure of why, when we connect to the DB, we can't find the views, and (assuming) this is permissions based, where we need to set these permissions in Admin Console? 

       

      Any help would be greatly appreciated.

       

      Thanks!