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

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.

/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":[]
}