Navigation:  Admin Panel > My Items > Item Types > General Settings >

Import from Oracle

Previous pageReturn to chapter overviewNext page

Select Oracle from the different possible Connection Types:

clip0102

The screen will refresh and show you the appropriate boxes for this Connection Type:

clip0099

Defining the Oracle Connection:

Connection String : Define the connection string to access the Oracle Server & DB.
SQL Query : Define the query to load the required data from the DB.
Update Type : SSP supports 3 possible update types:

Option 1 will import the complete database, add the new items, and update existing items, if person unique ID & Serial Nr & item date match. Note that the import also has a date to it. This means that you can store historical data and run trend reports on the data in My Items.

Option 2 will empty the complete database for this Item Type and only import the data in the source Oracle DB.

Option 3 is used to delete items in My Items.

Import Start Datetime : Define when the first import needs to run. Use the calendar icon to select a date. The hour must follow the standard input of HH:MM (hours in 2 digits, minutes in 2 digits).
Interval : Define the interval to run this query. Enter a number and then select a timescale in the drop down : Minutes - Hours - Days- Weeks.
Last Run Time : Indicates the last run time - this field is not editable.
Next Run Time : Indicates the next import, or shows the button clip0100to manually start the import (as in the screenshot above).

 

Field denomination

SSP works with Critical & Secondary Fields when importing data to fill My Items. Critical Fields are required to make a unique Item. The 4 critical fields need to be filled in. If not, the import will skip this item. After 100 errors, the import will stop and return an error message.

Secondary fields are not mandatory, but are used for reporting and statistics. When these fields are not filled in, reporting will show little data. It is therefore advised to complete these fields as well. They will however not stop an import if not filled in.

clip0101

Person Unique ID : The unique number of the User. This is normally linked to the LDAP number of the User.
Item Unique ID : The unique number (serial number or auto number) of the Item.
Item Date : the label to identify the date of this data.
Status : can be Active or Not Active. Enter 1 for Active, and 0 for Not Active. Other options are : 
Model : Name of the item, example: iPhone 4, BMW 320D, Fixed Line.
Cost : the Cost of the item, in € or $.
Usage : A number, indicating the usage. This number can be the size of a mailbox in megabytes, the kilometers of a car, bandwidth, ...

 

Buttons:

clip0022: disregards any changes and returns you to the list of all Item Types.
OK: Saves any changes and returns you to the list of all Item Types.
clip0020: Saves any changes but remains on the current page.
clip0093: Saves any changes and clears all fields, allowing you to easily enter another Item Type.