Documentation Center

Creating the Access Management database

Create the Access Management database using the provided PowerShell script.

Before you begin

  • To complete this task, you need access to a database server machine that runs a supported database version. Database support is the same as for Content Manager.
  • To run PowerShell database scripts for this database, the machine must meet the requirements described in Creating databases for Content Manager security.

About this task

Tridion Access Management (or simplyAccess Management) provides implementors with a simplified approach to identity management and gives administrators a central location for ongoing management of access to applications.

Procedure

  1. On your database server machine, open a PowerShell prompt.
  2. In the location of your Tridion Docs installation media, navigate to the folder for the type of database you are creating:
    • For a Microsoft SQL Server database: Database\InfoShareAM\MSSQL\
    • For an Oracle database:Database\InfoShareAM\Oracle\
  3. For Oracle databases, specify a host, port, service name and other connection information for the PowerShell script, either before or while running the script:
    • Before you run the script, you can define a variable in PowerShell, let's say $MyDatabaseServer, and set it to your connection string. When you invoke the script, you then append the string -DatabaseServer $MyDatabaseServer to the PowerShell command.
    • Alternatively, you can just invoke the script as is, and while you run the script, PowerShell prompts you for a value for Net Service, and you can then enter one of the following:
      • Enter the Net Service Name for this database if you have defined a Net Service Name in a tnsnames.ora file and specified the location of that file in a TNS_ADMIN environment variable.
      • Enter the string %manual% to let the script prompt you for the following: Host name, Port and Service name.
      • Enter the actual connection string directly on a single line if you have more to provide than just a host, port and service name. For example:
        (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ora)))
  4. Run the following PowerShell command, following the instructions that appear:
    & '.\Install Access Management database.ps1'
    By completing this step, you have created the Access Management database.