End-user database Workflow

Here is an example workflow for connecting to a database:

1. Install Ark SDK: pip3 install ark-sdk-python
2. Create a profile:
   • Interactively:

     ark configure
     

   • Silently:

     ark configure --silent --work-with-isp --isp-username myuser
     

3. Log in to Ark:

   ark login --silent --isp-secret <my-ark-secret>
   

4. Get a short-lived SSO password for a database from the DPA service:

   ark exec dpa sso short-lived-password
   

5. One of these:
   • Log in directly to the database:

     psql "host=mytenant.postgres.cyberark.cloud user=user@cyberark.cloud.12345@postgres@mypostgres.fqdn.com"
     

   • Log in to the database from Ark:

     ark exec dpa db psql --target-username postgres --target-address mypostgres.fqdn.com