Import Data (N-OC and Sabre Rocade integration)
This article will show you how to synchronize data from two N-OC databases or between a Sabre Rocade database and N-OC for example.
4 Set-ups are required for this to function correctly:
- Human Resource
- Com Channel
- Business Job
- Data Conversion
Human Resource
- Go to Menu.
- Click the Human Resource menu.
- Click the Human Resources tab.
- Select the crewmembers, i.e. EmpNo 1002 Captain Fantastic.
Note: The key field between the two databases is HR.ShortCode2. If the source is Sabre Rocade, the key field is EMPNO.
The Human Resources must have the exact same value in the two databases for the synchronization to work.
Com Channel
Click the Com Channels tab to set up the Dataservice.
Additional remark File Type: Select the applicable.
Business Job
Create a Business job in the Automation Factory.
Field | Description |
| JobType | N-OC API or choose from the dropdown options. |
| DataType | Human Resources or choose from the dropdown options. |
| FilterType | Select filter from GUEST system. (#1) - mandatory. |
| Company | Select Company for which we will apply Conversion Pattern (described in next point). (# 2) - mandatory.  |
| Filter | Fill in the name of HR filter in HOST system. This is a mandatory field. |
| Com Channel | Name of the Com Channel we created above. |
| Period Template | Define the period that shall be synchronized. |
Note: The user must always be set to ‘Sleipner’ and the active checkbox toggle for the Business Job to work properly.
Data Conversion
To create a data converter, refer to the Data Conversion article for further details on how to set it up.
Data converters are used to convert incoming values from the HOST system.
Example: Two Data Converters for Company Smartlynx Airlines, which will convert HOST HTL Rostert Activity and OFF Roster Activity into proper activities in the GUEST system.
Running the Data Converters & checking the synchronization
- Save everything and make sure that Sleipner is running.
- Change Roster Activities for selected Human Resources in the HOST system.
- Wait for Sleipner processing.
- Check Roster Gantt in the GUEST system. Note: It should refresh activities for synchronized rosters.