Before you can execute xSQL commands to manipulate data in Incent, Connect requires you to register a valid Incent username and password. This is necessary because scheduled pipelines and steps are run by Connect’s scheduler; when the scheduler invokes a step or pipeline, it uses the stored Incent credential to establish the connection with Incent.

 

NOTE: Your Incent credentials might be different from the credentials you used to establish the session with Connect.

 

Connect stores your Incent credentials securely, and the stored credential spans sessions so that you can use it later to invoke Incent xSQL commands.

 

NOTE: An Incent administrator can add this privilege to user accounts via the Incent UI.

 

Let’s set the credential:

 

1 SQL> incent credential (Username=‘your_Incent_username‘, Password=‘your_Incent_password‘);

 

If your credentials are invalid, it will return an exception message:

 

Test the credential:

 

1 SQL> incent credential test;