Configuring Plex ODBC with Plex IAM

Home > Support Articles > Plex ERP > Configuring Plex ODBC with Plex IAM

To use ODBC with Identity Access Management (IAM) you must configure ODBC to use a Personal Access Code.

You can follow these instructions bellow once you installed the required Plex ODBC software which can be obtained from Plex Installing ODBC driver on Windows (plex.com)

 

Obtain a Personal Access Code
  1. Log in to accounts.plex.com.
  2. Click Access Codes.
  3. On the Create A Personal Access Code screen, complete the following:
  • Description - Type a description of the Access Code.
  • Expiration - Select an expiration time.
  1. Click OK.
  2. On the Code Created screen, your Personal Access Code is displayed.
  3. Copy your Personal Access Code to a local file and save it immediately. This is the only time that this code will be displayed and you cannot retrieve it again. If you lose this code, you will have to create a new Access Code.
Configure ODBC to use a Personal Access Code
  1. Open ODBC.
  2. Open an existing ODBC DSN to edit, or click Add to create a new DSN.
  3. If you are creating a new DSN, click the Security tab and select the checkbox for Enabled (SSL).
  4. If you are creating a new DSN, click the General tab and complete the following:
  • Data Source Name - Type a name for this Data Source.
  • Description - Type a description.
  • Service Host - Type odbc.plex.com
  • Service Port - Type 19995.
  • Service Data Source - Select ReportDataSource.
  1. Click the Custom Properties tab and add the following two properties to the custom properties string:
authmethod=iam;accesstoken=[Enter the personal access code from accounts.plex.com]

** No brackets required.

Note: The personal access token takes the place of the company code, password, and if present, the username values in the Custom Properties string. The custom properties is both case sensitive and cannot have any spaces.

The token remains valid until it reaches the expiration date that was assigned to it when the token was created; or until someone revokes the token through accounts.plex.com.
  1. Click the "Security tab" and enabled the checkbox for encrypted SSL
  2. Click OK
  3. Test if your connection was successful.
Configure your application to work with the personal access token DSN

You may need to configure your applications that use ODBC to use a personal access token.

Ensure that your applications are using the following:

  • User name - the PMC user name of the account which was used to create the personal access token on accounts.plex.com
  • Password - this may be left blank

 

Updated:

Other Articles

and 35 more ...