API data migration from Enterprise 10 to Enterprise 11 Control Room
- Dernière mise à jour2020/05/12
API data migration from Enterprise 10 to Enterprise 11 Control Room
As a Control Room administrator with View and Manage Migration role permissions, use the Migration APIs to migrate data from Enterprise 10 to the latest Enterprise 11 Enterprise Control Room.
The Migration APIs allow you to,
- Save / update connection configuration to the 10.x Control Room database
- Save / update connection configuration to the 2.x Bot Insight database, if available
- Specify option to migrate data based on Roles, Users or Bots
- Fetch list of data based on option specified for migration that is, Roles, Users, or Bots
- View the migration progress summary
- View migration statistics of number of entities that succeeded / failed per migration
- Fetch list of new and updated bots from 10.x Control Room post migration
- Migrate files in bulk from the 10.x Control Room My docs folder post migration
Alternately, you can use the Migration wizard given in Administration > Migration module to migrate the data from the Control Room user interface. Refer Migration Overview for details.
API End Point
Use the following end points to access the API:
- For migration process use <Control Room URL>/v2/migration
- For migrating files from the My Docs folder of source 10.x Control Room after the migration process has completed use <Control Room URL>/v1/migration
For example,
https://crdevenv.com:81/v2/migration
Migration Process APIs
The Migration APIs allow you to migrate 10.x Control Room data to 11.x Control Room using the end point mentioned earlier.
Before accessing the Migration API's you must first use the authentication API and pass it as a token to use a particular Migration API.
- Use the POST method to generate a token using the end point
http(s)://<hostname:port>/v1/authentication. For this
provide the Control Room instance as Server
Name /Hostname /IP and
the Port number.
For example,https://crdevenv.com:81/v1/authentication
- Provide the following request payload in Headers
"X-Authorization" : "Authorization token"
"Content-Type" : "application/json"
- Provide the following request payload in Body:
{
"username": "<Username>",
"password": "<Password>"
}
For example,
{
"usename": "Ellie.Brown",
"password": "12345678"
}
1. Connect to source Control Room database
This API allows you to save and update the connection configuration to the source 10.x Control Room database.
- Provide the "X-Authorization" and "Content Type" parameters in Headers.
- Provide credential parameters in Body
- Use the POST method to connect to the 10.x Control Room database
using the end point
http(s)://<hostname:port>/v2/migration/connection
For example,https://crdevenv.com:81/v2/migration/connection
- Provide the following request parameters in Body:
{
"host": "string", "port": 0, "databaseName": "string", "username": "string", "password": "string", "integratedSecurity": true, "encrypt": true, "privateKey": "string", "repoPath": "string"
}
For example,
{
"host": "PRODUCTLT",
"port": 1433,
"databaseName": "CR104MIG",
"username": "Ellie.Brown",
"password": "12345678",
"integratedSecurity": true,
"encrypt": true,
"privateKey": "ABC123",
"repoPath": "D:\\Data\Automation Anywhere Server Files"
}
- Click Send.
Parameter Description
Parameter | Description |
---|---|
host | Source Control Room database host name |
port | Source Control Room database port number |
databaseName | Source Control Room database name |
username | Username to connect to database |
password | Password to connect to database |
integratedSecurity | An indicator whether to use Windows authentication when connecting to source database. Set this to true if you want use Windows authentication. The default value is false |
encrypt | An indicator whether to use secure connection to source database. Set this to true if you want to use a secure connection. The default value is false |
privateKey | The private key to decrypt credential values in source database. This is available for configuration during the initial Control Room setup. |
repoPath | The shared repository path where Control Room 10.x repository is stored |
2. Get stored connection details
This API allows you to fetch the stored connection details of source 10.x Control Room database from where the data can be migrated.
- Provide the "X-Authorization" and "Content Type" parameters in Headers.
- Provide credential parameters in Body
- Use the GET method to fetch the connection configuration of 10.x Control Room database using the end point
http(s)://<hostname:port>/v2/migration/connection
For example, https://crdevenv.com:81/v2/migration/connection
- Click Send
- You can view the result in Body data:
{
"host": "productlt",
"port": 1433,
"databaseName": "CR104MIG",
"username": "",
"password": "",
"integratedSecurity": true,
"encrypt": false,
"privateKey": "",
"repoPath": "D:\\DATA\AUTOMATION ANYWHERE SERVER FILES"
}
Parameter Description
Parameter | Description |
---|---|
host | Source database host |
port | Source database port |
databaseName | Source database name |
username | Username to connect to source database |
password | Password to connect to source database |
integratedSecurity | An indicator whether to use Windows authentication when connecting to source database, default value is false |
encrypt | An indicator whether to use secure connection to source database, default value is false |
privateKey | Private key to decrypt credential values in source database |
repoPath | The shared repository path where Control Room 10.x repository is stored |
3. Connect to 2.x Bot Insight database, if available
This API allows you to connect to the source 2.x Bot Insight database if available, to migrate analytics data.