SAS^® Anti-Money Laundering 8.3 provides a sample script to create a CSAMLETL<DEPLOYMENTID Extraction-Transformation-Loading (ETL) database user, which you can use to run ETL jobs for loading data to CORE and Knowledge Center (KC) schemas.

The steps to create this optional ETL user are as follows:

1. Locate the script that creates the ETL user based on your database:

• PostgreSQL: /opt/sas/spre/home/SASFoundation/misc/amlcoresrv/ddl/sample/csamletl_user_postgres.sql
• Microsoft SQL Server: /opt/sas/spre/home/SASFoundation/misc/amlcoresrv/ddl/sample/csamletl_user_sqlsrv.sql
• Oracle: /opt/sas/spre/home/SASFoundation/misc/amlcoresrv/ddl/sample/csamletl_user_oracle.sql​​​​​​

2. Modify the following values before you run the script:

• If there is a deployment ID set, replace <DEPLOYMENTID> with the deployment ID that you created.
• Replace <aml_database> with the name of the tenant that you want to deploy.
• Replace <password> with the password, enclosed in single quotation marks, for the two user IDs in the script. The passwords for each user ID should be different.

3. Run the script on the database.

Note: You can modify the scripts to add additional privileges for the user if needed.

To use this new ETL authentication domain, you need to set the following macro variables in the fcf_autoexec.sas file:

no_change_YN=Y;AmldbAuth_fcf%let

%let AMLdbAuth = <new ETL authdomain name>; 

Operating System and Release Information

An update for this issue is available for SAS Compliance Solutions 8.3. For instructions on how to access and apply these software updates, see the documentation links at the top of