Getting Started with Predictive Analytics

Log in to your system database and select your database. Click on the Administration icon and under the Overview tab, next to Installed Plug-ins check that AFL is installed.

Open an SQL command line to your database and check again that AFL PAL Functions are installed.

SELECT * FROM SYS.AFL_FUNCTIONS WHERE PACKAGE_NAME='PAL';

If a list of AFL functions is generated, AFL PAL Functions are installed.

Through your SQL command line, create a new tenant database.

CREATE DATABASE <DATABASE_NAME> SYSTEM USER PASSWORD <password>;

Example:

CREATE DATABASE AFL_TEST SYSTEM USER PASSWORD Password1;

Activate script server on your new tenant database.

ALTER DATABASE <DATABASE_NAME> ADD 'scriptserver';

Open an SQL command line to your tenant database.

Create a new user:

CREATE USER <NEW_USER> PASSWORD <password>;

Example:

CREATE USER DEVUSER PASSWORD Password1;

Note:
The script in the following tutorial assumes your new username is DEVUSER. Consider naming your new user DEVUSER to avoid additional steps.

Authorize creation, removal, and execution of PAL Procedures:

GRANT AFLPM_CREATOR_ERASER_EXECUTE, AFL__SYS_AFL_AFLPAL_EXECUTE TO <NEW_USER>;

Enable modeling:

GRANT MODELING TO <NEW_USER>;

Enable Native Development:

GRANT EXECUTE ON REPOSITORY_REST TO <NEW_USER>;
GRANT REPO.READ, REPO.EDIT_NATIVE_OBJECTS, REPO.ACTIVATE_NATIVE_OBJECTS, REPO.MAINTAIN_NATIVE_PACKAGES ON ".REPO_PACKAGE_ROOT" TO <NEW_USER>;

Grant access to the sample data:

GRANT SELECT ON SCHEMA PAL TO <NEW_USER>;
GRANT SELECT ON SCHEMA PAL TO _SYS_REPO;

Open an SQL command line to your tenant database through your new user and enter the following:

GRANT SELECT, INSERT, DELETE ON SCHEMA <NEW_USER> TO _SYS_REPO;