Skip to content
ALTR ALTR ALTR Documentation

Connect to Repository Through Impersonation

As a data consumer, log into ALTR with single sign-on. Then, generate a proxy access token and generate a connection string. Your access to repositories and users is determined by configured impersonation policies. Learn more .

Use the token to generate a JDBC connection string, which includes everything needed for the sidecar to connect to the repository. Paste this connection string into your SQL tool and start querying data.

To connect to your repository through a sidecar:

  1. Generate an access token.
    1. Log into ALTR through Okta.
    2. Click New Access Token .
    3. Select a Token Expiration . You must generate the connection string and connect to the sidecar with the access token before the expiration time runs out.
    4. Click Generate Token ; the access token displays.
    5. Click Copy .
    6. Close the modal.
  2. Generate a connection string
    1. From the All Data Repositories page, click a repository to view it’s details.
    2. Expand your repository user.
    3. Paste in the Access Token .
    4. Populate the fields specific to your database type:
      1. Microsoft SQL Server— Enter the Database Name.
      2. MySQL— Enter the Database Name.
      3. Oracle— Select the Oracle identifier type that the service uses from the Oracle Service Name / SID dropdown. Options are Oracle Service Name or SID. Then, enter the Oracle Service Name / SID value.
      4. PostgreSQL— Enter the Database Name.
    5. Click Generate Connection String . ALTR generates a connection string that contains all the necessary connection details for the sidecar.
  3. Connect to the repository
    1. Copy the connection string for the repository user and paste it as a URL in your SQL tool to connect to the repository. Once connected, you can begin querying data securely.
    2. Repeat for each repository user you need access to.
© 2026 ALTR Solutions, Inc.