Using REST API to Execute Schema Imports

You can manually run schema imports using the Migration Schema Service Import Business Service from inbound REST requests. This is one of the steps that happen automatically during a migration invoked using the Migration Application, but you can run the steps and services individually.

When running the service, care must be taken when providing the Schema Owner Password used in the request.

We allow the Schema Owner Password to be encrypted using the encryptstring utility or passed as a Base64 encoded string but not both. Encrypting the password using the encryptstring utility is optional but recommended. When you do wish to use an encrypted password for inbound REST calls to execute the MigrationSchemaServiceImport Business Service, you use the following parameter:

pwdPreEncrypted

Examples:

“pwdPreEncrypted”:”true” (password has been encrypted)
“pwdPreEncrypted”:”false” (password has not been encrypted)

Setting this parameter to true tells the Siebel Migration Application that you have encrypted the Schema Owner Password using the encryptstring utility and are passing that encrypted password in the inbound REST call. Setting it to false means you are passing a Base64 encoded password.

In order to make sure you can successfully use either strategy, follow the steps listed below.

Steps

If you wish to run the MigrationSchemaServiceImport Business Service using a Base64 encoded password set the pwdPreEncrypted parameter to false and provide the Base64 encoded password.

In this example the password is Base64 encoded and the pwdPreEncrypted parameter is set to false.

"migrationid":"88-38ZVN4",
"password":"b3JhNjYzMTEy", 
"pwdPreEncrypted":"false",
"filename":"ZGRsZXhwb3J0XzNBMERGOTdCNDdGQS5sb2c=", 
"isUnicodeDatabase":"Y",
"username":"ora663112"}}

If you wish to run the MigrationSchemaServiceImport Business Service using an encrypted password set the pwdPreEncrypted parameter to true and provide the encrypted password.

In this example the password has already been encrypted and the pwdPreEncrypted parameter is set to true.

{"body":{
"migrationid":"88-38ZVR5",
"password":"JvJbl4ZukuAV0JRnLpneNQXv3gAA", 
"pwdPreEncrypted":"true",
"filename":"ZGRsZXhwb3J0XzNBMERGQkVDRDNGNi5sb2c", 
"isUnicodeDatabase":"Y",
"username":"ora663112"}}

Note: Your encrypted password is passed as is. Don't further encode it (for example don't take an encrypted password and then Base64 encode it) or you'll receive an error.