DataStage - Data Integration

 View Only
  • 1.  Add rule in DS project by command line.

    Posted Mon December 13, 2021 08:19 AM
    Hello.

    How to add user with development or adm rules in the datastage in project from the command line.

    I tried  the command DirectoryCommand.sh, but without success.

    what is the syntax. For example: I want to add the user Smit as a developer in the TEX project.

    Thank you.

    ------------------------------
    Rafael Nery
    ------------------------------


  • 2.  RE: Add rule in DS project by command line.

    Posted Wed December 15, 2021 05:50 PM
    Edited by HOW MING YONG Wed December 15, 2021 05:54 PM
    Hi

    In this link, it provide a sample script for you to achieve that - https://www.ibm.com/docs/en/iis/11.7?topic=tools-directorycommand-tool

    In this example, the following values would need to be replaced with actual values. The groups and projects must be created before running the command.

    • dsusr and qsusr: groups that the user is being added to
    • HOSTNAME: the registered engine host name or configured DSAlias for the engine.
    • DSProd and DSDev: project names that the user is being added to as an InfoSphere DataStage operator.

    This script would create the specified user ID and assign the default password, which has been encrypted with the encrypt command and pasted into the script. (You could send e-mail with the plain text password to the user with a request to change it upon first login.) The DirectoryCommand then assigns the user to the DataStageUser role. It then assigns the user to the dsusr and qsusr groups. It then assigns the user to the DSProd and DSDev projects on the InfoSphere Data Click engine, indicated here as HOSTNAME. And, in the same command, assigns the user to the DataStageOperator project role.

    This is for Linux and UNIX -
    #!/bin/sh echo Adding a typical DataStage user with the default password.

    npass={iisenc}HEf6s6cG+Ee6NdGDQppQNg==
    nrole=DataStageUser
    prole=DataStageOperator
    cmd=/opt/IBM/InformationServer/ASBNode/bin/DirectoryCommand.sh
    af=/opt/IBM/InformationServer/ASBNode/conf/isadmin.credentials

    echo New user ID to create:
    read nuser
    echo First name for the user:
    read fname
    echo Last name for the user:
    read lname

    #This command create a User in Information Server
    $cmd -authfile $af -a_usr $nuser~$npass~$fname~$lname
    #This command assign the User to a User Role in Information Server
    $cmd -authfile $af -usr_roles $nuser\$$nrole
    #This command assign the User to a User Group in Information Server
    $cmd -authfile $af -a_usr_grp $nuser\$dsusr~qsusr
    #This command assign the User to a DataStage Project with the Project Role.
    $cmd -authfile $af -proj_usr_roles HOSTNAME/DSProd~HOSTNAME/DSDev\$$nuser\$$prole

    ​​​​
    There's 2 steps in User setting from DataStage perspective -
    1. Creation of User\Group in Information Server and assigning it to DataStage Credential.
    2. Assignment of the UNIX/Linux ID as DataStage Credential. Some customer may set a default DataStage Credential.


    ------------------------------
    HOW MING YONG
    ------------------------------



  • 3.  RE: Add rule in DS project by command line.

    Posted Wed December 15, 2021 06:12 PM

    I run the following command to get the roles -
    C:\IBM\InformationServer\ASBNode\bin>DirectoryCommand.bat -host HostNameOfInformationServer -port 9446 -list ROLES
    Please type user name:isadmin
    Please type password:
    Info The -host and -port options have been deprecated. Please use the -url option.
    ------------------ Listing roles in ASB directory. ------------------
    Role ID: "CMAdmin" Name: "Common Metadata Administrator".
    Role ID: "CMImporter" Name: "Common Metadata Importer".
    Role ID: "CMUser" Name: "Common Metadata User".
    Role ID: "DataPreviewUser" Name: "Data Preview Service User".
    Role ID: "DataStageAdmin" Name: "DataStage and QualityStage Administrator".
    Role ID: "DataStageDeveloper" Name: "DataStage and QualityStage Developer".
    Role ID: "DataStageOperationsViewer" Name: "DataStage and QualityStage Operations Viewer".
    Role ID: "DataStageOperator" Name: "DataStage and QualityStage Operator".
    Role ID: "DataStageProductionManager" Name: "DataStage and QualityStage Production Manager".
    Role ID: "DataStageSuperOperator" Name: "DataStage and QualityStage Super Operator".
    Role ID: "DataStageUser" Name: "DataStage and QualityStage User".
    Role ID: "EMAdmin" Name: "Exception Management Administrator".
    Role ID: "EMBusinessSteward" Name: "Exception Management Business Steward".
    Role ID: "EMDataSteward" Name: "Exception Management Data Steward".
    Role ID: "EMStewardManager" Name: "Exception Management Steward Manager".
    Role ID: "FastTrackAdministrator" Name: "FastTrack Project Administrator".
    Role ID: "FastTrackProjectAuthor" Name: "FastTrack Project Author".
    Role ID: "FastTrackProjectManager" Name: "FastTrack Project Manager".
    Role ID: "FastTrackProjectUser" Name: "FastTrack Project User".
    Role ID: "FastTrackUser" Name: "FastTrack User".
    Role ID: "ISDAdministrator" Name: "ISD Administrator".
    Role ID: "ISDConsumer" Name: "ISD Consumer".
    Role ID: "ISDDesigner" Name: "ISD Designer".
    Role ID: "ISDOperator" Name: "ISD Operator".
    Role ID: "ISDProjectAdministrator" Name: "ISD Project Administrator".
    Role ID: "ISDUser" Name: "ISD User".
    Role ID: "SorcererBusinessAnalyst" Name: "Information Analyzer Business Analyst".
    Role ID: "SorcererDataAdmin" Name: "Information Analyzer Data Administrator".
    Role ID: "SorcererDataAnalyst" Name: "Information Analyzer Data Analyst".
    Role ID: "SorcererOperator" Name: "Information Analyzer Data Operator".
    Role ID: "SorcererDataSteward" Name: "Information Analyzer Data Steward".
    Role ID: "SorcererDeveloper" Name: "Information Analyzer Developer".
    Role ID: "SorcererDrilldownUser" Name: "Information Analyzer DrillDown User".
    Role ID: "SorcererAdmin" Name: "Information Analyzer Project Administrator".
    Role ID: "SorcererUser" Name: "Information Analyzer User".
    Role ID: "CatalogDataProtectionAuthor" Name: "Information Governance Catalog Data Protection Author".
    Role ID: "GlossaryAdmin" Name: "Information Governance Catalog Glossary Administrator".
    Role ID: "GlossaryAuthor" Name: "Information Governance Catalog Glossary Author".
    Role ID: "GlossaryBasicUser" Name: "Information Governance Catalog Glossary Basic User".
    Role ID: "GlossaryReviewer" Name: "Information Governance Catalog Glossary Reviewer".
    Role ID: "MDWAdministrator" Name: "Information Governance Catalog Information Asset Administrator".
    Role ID: "GlossaryAssigner" Name: "Information Governance Catalog Information Asset Assigner".
    Role ID: "MDWUser" Name: "Information Governance Catalog Information Asset Author".
    Role ID: "InformationAssetReviewer" Name: "Information Governance Catalog Information Asset Reviewer".
    Role ID: "GlossaryUser" Name: "Information Governance Catalog User".
    Role ID: "RulesAdministrator" Name: "Rules Administrator".
    Role ID: "RulesAuthor" Name: "Rules Author".
    Role ID: "RulesManager" Name: "Rules Manager".
    Role ID: "RulesUser" Name: "Rules User".
    Role ID: "SuiteAdmin" Name: "Suite Administrator".
    Role ID: "SuiteUser" Name: "Suite User".
    ------------------------------------------------------------.

    C:\IBM\InformationServer\ASBNode\bin>

    ------------------------------
    HOW MING YONG
    ------------------------------



  • 4.  RE: Add rule in DS project by command line.

    Posted Thu December 16, 2021 07:10 AM
    Thank you. I will to tes here.

    ------------------------------
    Rafael Nery
    ------------------------------