Generating a data warehouse index

An apparatus for generating a data warehouse index, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:

• storing, by an access manager, a refresh token for a user;
• obtaining, by the access manager automatically without user interaction, an access token for the user from an identity provider including providing the refresh token to the identity provider along with credentials for the access manager;
• submitting, by the access manager to a data warehouse, one or more queries requesting connection information for data structures of the data warehouse accessible by the user, including providing to the data warehouse the access token for authorization of the user;
• receiving, by the access manager from the data warehouse in response to the queries, one or more responses specifying connection information for data structures of the data warehouse accessible by the user;
• and
• generating, by the access manager, an index of the data warehouse for the user based on the received connection information for data structures of the data warehouse accessible by the user.

A computer program product for generating a data warehouse index, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:

• storing, by an access manager, a refresh token for a user;
• obtaining, by the access manager automatically without user interaction, an access token for the user from an identity provider including providing the refresh token to the identity provider along with credentials for the access manager;
• submitting, by the access manager to a data warehouse, one or more queries requesting connection information for data structures of the data warehouse accessible by the user, including providing to the data warehouse the access token for authorization of the user;
• receiving, by the access manager from the data warehouse in response to the queries, one or more responses specifying connection information for data structures of the data warehouse accessible by the user;
• and
• generating, by the access manager, an index of the data warehouse for the user based on the received connection information for data structures of the data warehouse accessible by the user.