EnterWorks Connectivity - EnterWorks - Fusion - Match_and_Merge - Precisely_EnterWorks - 3.1

EnterWorks Fusion

Product type
Software
Portfolio
Verify
Product family
EnterWorks
Product
Precisely EnterWorks > Fusion
Precisely EnterWorks > Match and Merge
Version
3.1
Language
English
Product name
Precisely EnterWorks
Title
EnterWorks Fusion
Copyright
2023
First publish date
2007
Last updated
2024-03-02
Published on
2024-03-02T02:58:49.255209

EnterWorks Source Properties

EnterWorks uses two source types. The properties for configuring them are listed below:

  • EnterworksSource: The EnterworksSource source type uses the API to access the database. All EnterWorks user permissions are respected.

    The configuration parameters for an EnterworksSource are:

    • hostName: Enter the following text, without the quotes: "localhost:8090".

    • userNameand password: Use the system EnterWorks login credentials. Using an administrator's username and password ensures that all requests are honored.

    • basicAccessToken: Enter the following text, without the quotes: "ZXBpbS1jbGllbnQ6ZXBpbS1jbGllbnQ="

    • UIURL: This setting is used to implement impersonation when InfoLink is embedded into the EnterWorks UI. If you set this, it is concatenated as a prefix to the /enable-api/reauth call. If it is not provided, the prefix is constructed from the current browser URL.

    • passGetTokenCredentialsInURL: This specifies whether to pass the user's credentials in the header or in the URL. Whether you set this or not depends on the version of EnterWorks you are running:

      • EnterWorks versions prior to 10.2.1: EnterWorks passed the credentials in the URL rather than in the header. Set passGetTokenCredentialsInURL to true.

      • EnterWorks 10.3 or later: This field is deprecated. Leave it empty.

  • SQLServer: The SQLServer source type directly accesses the database. You will need to get the unencrypted EPIM database password from the system administrator. The rest of the settings you will need to configure a SQLServer source are located in the file:

    <drive>:\Enterworks\EnableServer\tomcat\enterworks-props\sharedConfig.properties

    Below is an example of the settings in Tomcat's sharedConfig.properties file. Any value in brackets is a placeholder for the actual value. Your Tomcat's sharedConfig.properties file will contain the actual values.

    • connStr: The EPIM database connection string. Use the value for the setting: epim.connection.url, minus the "jtds:". For example, if the setting is:

      epim.connection.url=jdbc:jtds:sqlserver://<localhost>:1433;databasename=EPIM;instance=;

      set the data source's connStr parameter to:

      jdbc:sqlserver://<localhost>:1433;databasename=EPIM;instance=;
    • user: The EPIM database username. Use the value of the setting epim.connection.username=.

    • password: The unencrypted EPIM database password. The value of the setting epim.connection.password=is the encrypted password. Do not use it. Use the unencrypted value of the password. This is not located in a system file. You will have to get the unencrypted password from the system administrator.

RunSourceJob Operation Examples

The RunSourceJob operation supports the following types of jobs:

  • /api/items/promote: Here is an example:

    {
       "into":{
          "spaceName":null,
          "sourceName":null,
          "tableName":null
       },
       "opName":"RunSourceJob",
       "opParams":{
          "name":"/api/items/promote",
          "sourceName":"Enable_API",
          "params":{
             "repositoryId":"10321"
          },
          "body":[]
       },
       "title":"RunSourceJob: /api/items/promote",
       "targetTables":[]
    }
    
  • /api/items/validateAll: Here is an example:

    {
       "into":{
          "spaceName":null,
          "sourceName":null,
          "tableName":null
       },
       "opName":"RunSourceJob",
       "opParams":{
          "name":"/api/items/validateAll",
          "sourceName":"Enable_API",
          "params":{
             "repositoryId":"10321"
          },
          "body":{
             "validateDynAttrInd":0,
             "correctionFileTypeCode":0,
             "savedSetId":0,
             "validationLevelInd":4,
             "correctionFileInd":0,
             "validationOption":1
          }
       },
       "title":"RunSourceJob: /api/items/validateAll",
       "targetTables":[]
    }