Configuring Data Import Connections
Role : Administrator
Before you configure any Data Import Connections, make sure that the Asset Processor Configuration is defined. For details, refer to Asset Processor Configuration.
Use SQL server authentication credentials, not Windows authentication. You should also have the db_datareader permissions for the database.
Use the Data Integration Wizard to import data from a predefined source into the Neurons for ITSM database.
Viewing, Cloning, and Deleting Data Import Connections
To view, clone, or delete Data Import Connections, follow these steps:
- From the Configuration console, click Extend > Integration Tools > Data Import Connections to open the Data Source Manager page.
Data Source Manager
The Data Source Manager page has the following fields:
Field | Description |
|---|---|
Name | The name of the data import connection. |
Connector | The connection import type:
|
Connection Source | Information about the source, such as server name and database name (for SCCM and Discovery Release 9.3.x and later) or server path and file name (for file). |
-- | Displays the creation and last modification dates of the data import connection. |
Active | Indicates whether the connection is active. Only published connections can be active. Click ON to activate or OFF to deactivate the connection. |
Published | Indicates whether the data import connection is published. |
Mapping | The name of the integration job associated with the connection. |
- To clone a data import connection, including all mappings and schedules:
a. Click the Clone icon
b. In the confirmation message, click Ok.
The new data import connection appears in the list as unpublished.
Ensure that the connection being cloned is of the same type as the target connection. Cloning a connection and changing its type may cause errors with the new connection. If errors occur, delete the new connection and clone another, ensuring the source connection matches the target connection type.
- To delete a data import connection:
a. Click the Delete icon
b. In the confirmation message, click Ok.
c. If there are any mappings associated with this data import connection, a second confirmation message appears. Click Ok.
The data import connection is no longer displayed.
- To submit an integration job for execution by the integration server:
a. Click Run Now at the end of the row.
b. In the confirmation message, click Yes.
For a manual upload, the application prompts you to upload the file before submitting the job.
Setting Up a Data Import Connection
Use this process to set up a connection to the server where the data is located.
If you import data on a schedule, the options are defined in the Schedule Entry workspace. Refer to About the Schedule Entry and Scheduled Jobs Workspaces for more information.
For example, to set up an Endpoint Manager integration, define a daily CMDB import schedule in the Schedule Entry workspace before selecting it in the Import Wizard. The schedule setting option only appears if Discovery 9.x, SCCM, (EPM, Secure FTP (SSH), or Ivanti Cloud Connector is selected as the connection type, or if you create a new web service connection. The basic steps shown below are followed by specific set ups for different connectors.
Data Import Setup Sequence -- Connection Setting
- From the Configuration console, click Extend > Integration Tools > Data Import Connections, to open the Data Source Manager page.
The page lists all the connections that are already defined for your installation.
- Click Add New to create a new connection and open the Settings page.
Connection Settings Page
- In the Connection Name field, enter a unique name for the connection.
- Select a Connection Type from the dropdown list:
- Email Import. Refer to Email Import.
- Discovery 9.x. (Only applicable for Discovery Release 9.3.x and later). Refer to Ivanti HEAT Discovery File.
- Manual File Upload. Refer to Manual File Upload.
- SCCM. Refer to About Importing Data from SCCM into Neurons for ITSM.
- Secure FTP (SSH). Refer to Secure FTP (SSH)
- EPM. Refer to Endpoint Manager (EPM) Connector.
- Ivanti Cloud Connector. Refer to Ivanti Neurons Connector.
The File on Shared Folder and FTP Connection Type features are deprecated. For customers who prefer to use FTP, we recommend switching to Secure FTP (SSH).
Email Import
Select this option to import data from an email message and continue to Enter information about the specific file. Select the file type to import:
Ivanti HEAT Discovery File
Select this option to import data from a Discovery Release 9.3.x and later database.
a. Enter information into the fields.
Field | Description |
|---|---|
Connection Name | The connection name. Always use Discovery 9.x. Do not change the name unless you are setting up a new configuration or modifying this one for your import. |
SSL Encryption | Specifies if the connection uses SSL encryption. |
Server Name | The server path, such as Servername or IP Address, where the database is located. |
Database Name | The database name. Enter Ivanti HEAT Discovery. |
b. Continue to Importing Data from Ivanti HEAT Discovery Release 9.3.x or Later to set the object mapping, field setting, field mapping, and schedule settings.
Whenever you connect to Ivanti Neurons for ITSM to import data from EPM, or SCCM, or Secure FTP, enter the server name, database name, and authentication credentials (login and password), even if the credentials were saved during a previous configuration. Credentials cannot be saved for this connection.
Manual File Upload
Select this option to create a non-scheduled one-time data import. You can import data from a local file source into your database. This import configuration can be saved to your list of integration connections, but cannot be scheduled, due to the nature of a manual import. You must manually import the data file each time you run the connection. Supported file types are .CSV, .XLS, and .XML
a. Enter information into the fields.
Field | Description |
|---|---|
Data File Name | The name of the data file. Refer to About Importing Multiple Files for information about using the * wildcard to import multiple files at once. |
Secure FTP (SSH)
Select this option to connect to a secure file server (not a web server) to transfer data. The Secure FTP protocol is used to upload files from a workstation to a specified secure FTP server.
The global constant EnableFTPSharing must be set to True to display the Secure FTP options in the Connection Type dropdown list.
a. Enter information into the fields.
Field | Description |
|---|---|
Data File Path | The path of the data file. |
Template File Path | Optional. The path of the file that is a subset of the mapping file. If your mapping file is large, you might want to create a smaller file containing only the columns or fields for mapping, to create a map before data import. |
b. Continue to Enter authentication information if required.
Endpoint Manager (EPM) Connector
Select this option if you are using Ivanti Endpoint Manager and you want to import data from the Endpoint Manager database into Ivanti Neurons for ITSM.
a. Enter information into the fields.
Field | Description |
|---|---|
Server Name | The name or the IP address of the server where the Endpoint Manager data is located. |
Database Name | Use the default of EPM. |
b. Enter authentication information as seen in Enter authentication information if required.
c. Next, test the connection: Test the data import connection. As specified, do not click Close or move to the next step until the connection test is successful.
d. If the connection is successful, click Close then click Next to specify Object-level Mappings. Refer to Object Mapping and Mapping Fields for Import. When creating a mapping for this connector, select EPM Connector from the dropdown.
Use the wizard to identify the next step in the process to map fields or objects, use transitions, and to schedule your import.
Use the following steps only as indicated by the connector.
- Enter authentication information if required.
Field | Description |
|---|---|
Use global constants for login and password | Specifies if the login and password information are global constants. If you check this option, you must create the login and password global constants before you can use them. Refer to Using Global Constants to Hide Login ID and Password Information. |
Login | The login ID used to access the server. Enter a value if you did not check Use global constants for login and password. Select a value from the dropdown list if you checked Use global constants for login and password). |
Password | The password used to access the server. Enter a value if you did not check Use global constants for login and password. Select a value from the dropdown list if you checked Use global constants for login and password). |
- Enter information about the specific file. Select the file type to import:
- XML
Comma Delimited (CSV)
Most applications, including Microsoft Word and Microsoft Excel, can read CSV files. However, this format does not support line breaks. Do not include including commas in the data of the last column. If a value in the last column contains a comma even when enclosed in quotes CSV interprets it as a field separator.
For example: "Initials", "mail", "telephoneNumber", "givenName", "company", "Wilma", "wasselt", "Asselt", "van".
In this example, the last field represents lastName, with the value "Asselt, "van". If this field appears in any column other than the last, the import correctly recognizes "Asselt, "van" as a single value. However, if it is in the last column, the import reads only "Asselt" and ignores the data after the comma.
Field | Description |
|---|---|
Delimiter | Defines the character used to separate fields in the file. Select an option from the dropdown list:
|
Excel Spreadsheet (XLS, XLSX)
Microsoft Excel and other compatible applications can read these file formats. You can import only a single worksheet per Excel file. You can import up to 5,000 rows per file. If your file contains more than 5,000 records, split it into smaller files and import each file separately.
About Multiple Role Support for CSV and XLS files
To support multiple roles, add a column named Role (including the asterisks) to the input file. This column must contain the role display names, not the internal role names.
- Use display names like Self Service, not internal names like SelfService.
- Separate multiple roles in the same cell with commas.
The application does not create new roles during import. You must define roles in the system before assigning them to employees.
When importing, the application merges roles by default. For example, if an employee currently has two roles Service Desk and IT and you import three roles IT, admin, and service owner the final result is four roles:
Service Desk, IT, admin, service owner.
XML
Imports generic XML data.
Field | Description |
|---|---|
Table Element | The name of the table object. |
Row Element | The name of the row object. |
Include Header Row | Inputs an XML file in legacy GBU format. In this format, the table element is "Rows", and row element is "Row". <Rows> <Row> <Field>PrimaryEmail</Field> <Field>FirstName</Field> ... <Row> <Rows> Do not check this option to use the flexible two-level format. In this example,the table element is "Employee_Info", and the row element is "Employee". The field names for this "Employee" object can be an element (such as Name) or a row-level attribute (such as Employee_Number). <Employee_Info xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="employee.xs"> <Employee Employee_Number="105"> <Name>Masashi Okamura</Name> <Department>Design Department</Department> ... </Employee> </Employee_Info> |
Data with null values do not appear in the XML file, which can cause problems when exporting data.
For example, consider the following XML. Note the data for the second employee contains an email cell with no attributes. This cause the data to import incorrectly.
<Employee_Info> <Employee Employee_Number="105"> <Name>Masashi Okamura</Name> <Department>Design Department</Department> <Email>[email protected]</Email> <Phone>408.555.1234</Phone> </Employee> <Employee Employee_Number="106"> <Name>Frank Smith</Name> <Department>Design Department</Department> <Email></Email> <Phone>408.555.1235</Phone> </Employee> </Employee_Info>
To alleviate this issue, create an empty string:
<Employee_Info> <Employee Employee_Number="105"> <Name>Masashi Okamura</Name> <Department>Design Department</Department> <Email>[email protected]</Email> <Phone>408.555.1234</Phone> </Employee> <Employee Employee_Number="106"> <Name>Frank Smith</Name> <Department>Design Department</Department> <Email>""</Email> <Phone>408.555.1235</Phone> </Employee> </Employee_Info>
Hierarchical XML
Use this option to import structured XML files.
Field | Description |
|---|---|
Table Element Row Element Include Header Row | These options are disabled because the values are automatically picked up by the XML file. |
Main XSLT | (Optional) Defines a template to apply to your XML file. Click Upload and navigate to your template file. |
Additional XSLT | Click to add additional XSLT files. |
For more details, see Importing Hierarchical XML Data.
Files larger than 50 MB take longer to preview. This happens because the application downloads the entire file before displaying the first batch. For hierarchical XML, the application skips the mapping pages, so the file is only copied or downloaded when you preview it.
Enter hierarchical information into the fields.
Field | Description |
|---|---|
Decimal separator | The decimal separator symbol. Enter a value or choose one from the dropdown list. |
Encoding | The character standard of your file. Select from the dropdown list. |
Date Format Time Format Time Zone | The date, time, and time zone format of your file. Select values from the dropdown lists. This ensures that your data is imported correctly into the database. If your data does not contain date or time fields, use the default settings. |
Test the data import connection
- Click Test Connection.
If your connection is set up correctly, the application displays a success confirmation message and updates the connection date and time.
If the connection fails, do not click Next until the test connection shows the success message. The connection could fail because of various reasons such as incorrect authentication, restricted or no FTP access, or restricted file permissions.
- Click Next.
Depending on the data import connection type, the next page in the Data Integration Wizard appears. The next page is as follows:
Connection Type | Additional Pages |
|---|---|
Email Import | none |
Discovery 9.x (only for Discovery Release 9.3.x and later) | Object Mapping Filter Setting Field Mapping Schedule Setting Review and Publish |
Manual File Upload | Object Mapping Filter Setting Field Mapping Review and Publish |
SCCM | |
Secure FTP (SSH) | Object Mapping Filter Setting Field Mapping Schedule Setting Review and Publish |
EPM Connector | Object Mapping Filter Setting Field Mapping Schedule Setting Review and Publish |
- When testing the connection, the application checks if $ and URI exist in the Server Path. If it does, then the following error message is displayed.
Object Mapping
Data Import Setup Sequence -- Object Mapping
- Enter information into the fields. Some fields do not appear on all options.
Field | Description |
|---|---|
Mapping | The mapping. Select the default mapping or select Add New from the dropdown list. |
Name | The mapping name. Use the default name, modify the name, or choose Add New from the dropdown list to create a new mapping. To modify the existing name, click Save as New. The application creates a clone of the mapping, which you can then modify. This button is only enabled if you select an existing mapping. |
Source Mapping Tables |
|
Max file size | Read only. Shows the maximum file size that you can import. The default maximum file size is 250 MB. |
Max size | For EPM Connector: Enter the number of records that should be retrieved each time the database is queried. |
Root Table | For EPM Connector: Select the table that contains the records which can uniquely identify the computers or other machines in your organization. |
Source File Name | Read only. Taken from the value in the File Name field. |
Source Unique Key/Unique Key | Lists the fields containing keys that uniquely identify your record. The fields that appear in the list are taken from the first record in your source file. Select the field that is primary in identifying your records, which can be used to retrieve additional information. |
Change Time column | For EPM Connector: Select TimeKey; this records the time when a record is updated. Keep the default Computer since this is a top-level object equivalent to a CI Business object. |
Target Business Object | The primary business object in Neurons for ITSM into which the data is imported. Highlight the business object in the list. The list shows all the business objects in Neurons for ITSM. Use the Target Business Object field to enter a few letters of the target business object and then click Filter by Name or Filter by Object to narrow your search. For example, if you are importing a list of employee records into Neurons for ITSM, the primary business object you need to map to is the Employee business object. |
- Click Next. The application displays the Filter Setting page.
To include the decimal value in the EPM database, a new method is added (ToDecimal) that divides an integer value by 100 and returns decimal with two digits.
Setting Filter Conditions
Data Import Setup Sequence -- Filter Setting
After mapping the business object tables to query, you can optionally specify filter conditions for the root business object.
- Click Create Filter. The filter fields appear. If the Create Filter button is not visible, delete the default mappings on the previous page.
- Select a condition.
- Enter the fields and operators into the form.
Do not use comma-separated values in the Create Filter field. If the source database has a device name with comma-separated values (for example, VMWare7,1), then use Microsoft SQL function "CHAR(44)" that converts ASCII code 44 to "," character.
Filter Manager Conditions and Fields
- Click the add icon to add another row.
- Select the Fetch data post last import timestamp check box.
The Fetch data post last import timestamp option is available only when a filter is applied to a connector. It is applicable only for OData Connections to fetch the delta records since last import from Neurons. This cannot be used for any other connector, if used, system will ignore this condition as the filter conditions will not be satisfied.
Mapping Fields
Mapping Fields for Import
Data Import Setup Sequence -- Field Mapping
Use this page to define the field level mapping and transformation. The left column shows the source file name and the right column shows the target business object field name. It is assumed that the Source mapping names are known or identified in advance.
For Endpoint Manager (EPM) The first 5 field mappings: Audit.TimeStamp, Audit.RequestID, Audit.FirstSequence, Audit.LastSequence. Audit.Type are required.
Map Fields for Import
- If appropriate, select a transformation function from the middle column. Refer to About Transformation Functions for a list of the transformation functions.
- Select the field names to map between the source file and the target business object in Neurons for ITSM.
For example: an EPM Connector (EPM) field CompSystem.Manufacturer would map to Neurons for ITSM ComputerSystem.Property.Manufacturer asset identifier.
- If the target field is a link field, determine the name of the field to use. Refer to About Mapping Link Fields.
- (Optional) Click Auto Map to map the source file column header to the target field name. Remapping the source column header does not change your existing mapping.
- Click Next. The application displays the Schedule Setting page or the Review and Publish page.
About Transformation Functions
The following table lists the transformation functions.
Function Name | Category | Description | Input | Output |
|---|---|---|---|---|
--> | None | Returns the source value (does nothing). |
|
|
Abs | Math | The absolute value of input value. | Double | Double |
AssetIdentifier | Special | Creates a unique identifier from the SCCM or EPM Connector machine ID and the instance key. | SCCM machineID SCCM InstanceKey EPM machineID |
|
Avg | Math | The arithmetic mean or average of all the input values. | Double | Double |
Cbrt | Math | The cube root of the input value. | Double | Double |
Ceiling | Math | Smallest integer value less, greater than, or equal to the given value. | Double | Double |
Century | DateTime | Returns the century part of the input date time value. | DateTime | Double |
CIType | Special | Returns configuration item types from the SCCM or EPM mappings and role. Refer to Example 1: Mapping CI Type. For EPM, mapping examples are: If role = SQLServer, return Server If role=not defined or does not exist, return default value Computer If role=LM_Workstation, return Workstation. | SCCM Mapping and Role EPM Mapping and role. |
|
CIType2 | Special | Returns configuration item types from the SCCM mappings, role, model and virtual keywords. Refer to Example 1: Mapping CI Type. | SCCM Mapping and Role EPM Mapping |
|
Concat | String | Concatenates string values together. | String Array | String |
ConvertToLocal | DateTime | Converts a DateTime value to a local DateTime value. | DateTime | DateTime |
ConvertToUTC | DateTime | Converts a DateTime value to a UTC DateTime value. | DateTime | DateTime |
DateTimeNow | DateTime | Current date and time in yyyy-MM-ddThh🇲🇲ss format. | None | String |
DateTimeUTCNow | DateTime | Current UTC date and time in yyyy-MM-ddThh🇲🇲ss format. | None | String |
DayOfMonth | DateTime | Returns the day of the month of the input DateTime value. | DateTime | Double |
DayOfWeekNo | DateTime | Returns the day number of the week of the input DateTime value. 0: Sunday 1: Monday 2: Tuesday 3: Wednesday 4: Thursday 5: Friday 6: Saturday | DateTime | Double |
DayOfWeekStr | DateTime | Returns the day string of the week of the input DateTime value. Sunday Monday Tuesday Wednesday Thursday Friday Saturday | DateTime | String |
DayOfYear |
| Returns the day of the year of the input DateTime value. | DateTime | Double |
Diff | Math | Subtracts all the values from the first value. | Double Array | Double |
Div | Math | Divides the first value by the remainder of the values. | Double Array | Double |
Floor | Math | Largest integer value less, greater than, or equal to the given value. | Double | Double |
Hour | DateTime | Returns the hour part of the input DateTime value. | DateTime | Double |
IsoWeek | DateTime | Returns the ISO week number of the input DateTime value. | DateTime | Double |
Leap |
|
|
|
|
Length | String | The length of the string. | String | Double |
Max |
|
|
|
|
Min |
|
|
|
|
Minute | DateTime | Returns the minute part of the DateTime value. | DateTime | Double |
Mod | Math | Remainder after dividing first value by the second value. | Double, Double | Double |
Month | DateTime | Returns the month part of the input DateTime value. | DateTime | Double |
Pow | Math | The number raised to the power. | Double | Double |
Product | Math | Product of all values. | Double Array | Double |
Quarter | DateTime | Returns the quarter of the input DateTime value. Quarter ranges from 1 to 4. | DateTime | Double |
RegexMatch | String | Returns a matched value from the input value for a pattern in a position (zero-based). | String |
|
RegexReplace | String | Returns a string that has been replaced with a string that matches a pattern in the input string. | String |
|
Replace | String | Replaces the part of a string with given value. | String | String |
Round | Math | Rounds a double-precision floating-point value to the nearest integer. | Double | Double |
Second | DateTime | Returns the second part of the DateTime value. | DateTime | Double |
Select | Special | Return the first item in the list where the corresponding predicate is equal to a given value. | String | String |
SelectNotNull | Special | Returns the first input value that is not empty or not null for the group of items. | String | String |
SelectSort | Special | Returns the first item in the list after sorting by the SortField on SortValue; Asc for ascending order and Desc for descending order, where the corresponding predicate is equal to a given value. SortValue should be either Asc or Desc, and the SortFeild should support three types of datatypes such as Integer, Datetime, and String. | String | String |
Split | String | Returns a specific part of a string split using a separator. | String | String |
Sqrt | Math | The square root of the input value. | Double | Double |
Substring | String | Returns part of a string. | String | String |
Sum | Math | Sum of given values. | Double | Double |
Switch | Special | Returns the string based on the input value and corresponding mappings (delimiter is ':') | String | String |
TimeDiff | DateTime | Returns the period between two DateTime values. | DateTime, DateTime | TimeSpan |
ToLower | String | Converts to lowercase text. | String | String |
ToProper | String | Converts to proper case text. | String | String |
ToUpper | String | Converts to uppercase text. | String | String |
Trim | String | Removes all leading and trailing white spaces. | String | String |
TrimLeft | String | Removes the leading white spaces. | String | String |
TrimRight | String | Removes the trailing white spaces. | String | String |
Truncate | Math | The integral part of the value. In other words, rounds up or down towards zero. | Double | Double |
Week | DateTime | Returns the standard week number of the input DateTime value. | DateTime | Double |
Year | DateTime | Returns the year part of the input DateTime value. | DateTime | Double |
About Mapping Link Fields
When specifying links to a related business object as part of data import, note the following:
- Data import can only be linked when using link fields such as OrgUnitLink or ManagerLink. Only a one-to-one link is supported.
- For CSV files, the data should display the name of a business object. For example, for organization unit, use the name of the organization. For employee, use the display name of the employee (for example, Marcia S Hendric) rather than the login ID (MHendric).
When mapping link fields, such as OrgUnitLink or ManagerLink, note the following:
- For the source value, on the left, use the value of the Display field under the Special Purpose Fields section and not the value of the Display Name field. You need to determine this field name before mapping the fields.
Linked Field Reference
- For the target value, on the right, use the name of the link field, such as OrgUnitLink or ManagerLink.
The following shows mapping a linked field using the field name:
Field Mapping Example - Linked Field
About Mapping Files with Currency Data
To prevent errors while importing files containing currency data, map the currency value and the currency type separately.
For example, if your file contains a currency code value such as NNN.NN GBP (for example, 8999.00 GBP), create a column for the numeric value (NNN.NN) and another column for the currency type (GBP).
If that is not practical, then you can use the Split function on the Field Mapping page:
"Currency", , 0 - Split - "Currency"
"Currency", , 1 - Split - "Currency_Currency"
Field Mapping for Currency
Setting the Data Import or Web Service Connection Schedule
After mapping the fields you must schedule the import and associate the mapping with one or more existing or previously created schedule entries.
Data Import Setup Sequence -- Schedule Setting
This option only appears if you select one of the following connection types: Discovery 9.x, SCCM, EPM Connector, or Secure FTP (SSH), or if you create a new web service connection. In addition, when the Global Constant EnableNeuronSyncByAPI is activated, the schedule option is activated on two connectors: Ivanti Neurons Connector - Device and Ivanti Neurons Connector - Invoice. For more information on scheduling inside these connectors, refer to the Scheduling API Data Sync from Ivanti Neurons for Discovery to Ivanti Neurons for ITSM help document.
As noted in Setting Up a Data Import Connection, the schedule options are defined and can be viewed in the Schedule Entry workspace. Refer to About the Schedule Entry and Scheduled Jobs Workspaces for more information.
Data Import Schedule
Schedules determine when the import or data connection is added to the queue for processing. You can create multiple entries in the Schedule Entry table to run multiple imports of the same data each day.
- Select one or more schedules from the schedule list. (Use the Ctrl key to select more than one schedule.)
The application displays information about each schedule that you select at the bottom of the page.
If you are not the owner of a schedule that you have selected, and the schedule is changed by the owner, your import time might be affected.
The supported schedule types are: Daily, Weekly (once a week), or Monthly (once a month with a date).
- Click Next. The application displays the Review and Publish page.
Reviewing and Publishing Import or Web Service Connection Data
Data Import Setup Sequence -- Review and Publish
Click the Test Transformation button in order to view all the mappings specified by you. The mapping configurations appear in a pop-up window as an xml file. If desired, you can copy and paste the information from this window to another file.
You have four options to review or publish your import data:
- Preview: Views the form with your field mappings. All records from the first batch appear showing the mapping configuration and the associated data. You can check these records for import errors before beginning import.
- Publish: The application only shows this option if there is a schedule involved, like with the Secure FTP (SSH) connection types. Activates the connection so that it can run according to the schedule.
- Publish & Run Now: Runs the import immediately and places it on the import schedule.
- Publish & Test Run: Runs the import with only the first batch of records. A batch is 200 records. If errors or problems occur in this job, you can go back to your data and troubleshoot before running the entire job.
The application automatically saves all field mappings even if they are not immediately published. After you publish the data, the job runs based on the schedule/s you selected.
Viewing, Changing or Deactivating a Published Connection
- Log in to the Neurons for ITSM application.
- Open the Integration workspace.
- Select a record to open and view the settings.
- To deactivate a Published connection, uncheck the Active check box then click Save.
You can resume the imports by checking the Active checkbox if needed.
Troubleshooting
Troubleshoot your connections using one of the following methods:
View the Integration Log
Use the log to view details of the job from the Integration workspace.
- Log in to the Neurons for ITSM application.
- Open the Integration Log workspace.
- Select a log to view the details.
Field | Description |
|---|---|
Name | Name of the mapping. |
Start Time/ EndTime | Indicates the time the job should run and the time the job should end. |
Log Type | Queued: Indicates that the source ID from SCCM has been queued in the inventory management asset data processor. Verified: Indicates that the source ID from SCCM has been successfully created in the Neurons for ITSM database. Stats: Displays statistics about the number of rows processed. |
Total Processed | Total number of records processed. If no new mappings were added, no records will be processed. |
Source ID | The root table key shown on the Object Mapping page of the wizard. |
Failed Count | Displays the number of records that failed to process. |
Target ID | The Asset ID derived from the asset identifier mapping function on the Field Mapping page of the wizard. |
Message | Varies based on the log type. the messages can be viewed wile the job is being processed |
View the Integration Queue
While the job runs, you can view the record in the Integration Queue workspace. After the job completes, you can the record only in the Integration Log workspace.
Questions and Answers
Q. I made attribute mapping changes to the SCCM integration. Whenever I run the integration, it appears to be pulling information for all computers that have been audited since the last SCCM integration was run.
Is it possible to perform a complete import of all computers regardless of when they were last audited by SCCM?
A. Yes. Follow these steps:
- Log in to the Neurons for ITSM application.
- Open the Integration workspace.
- Open the integration to update.
- In the Last Data Changed Time field, set the last scanned date to a really old date, such as January 1, 1949.
Setting an Arbitrary Date for the Last Audit
- Run the job as scheduled.
The application captures all information.
Example: Importing Configuration Item Relationships
This example shows how to import data for a configuration item (CI) map tree.
Previously, to define a relationship between a configuration item and an application, you used the Map Tree tab to link related configuration items based on a specific named relationship. This method still works, but it can be time‑consuming if you need to map many configuration items.
In Neurons for ITSM Release 2015.1,a new feature lets you use data integration to link multiple configuration items from a CSV or Microsoft Excel file. To use this feature, you must have:
- The DataIDs, SourceIDs, and TargetIDs of the configuration item records to link as well as
- The RecID of the CINamedRelConstraints record that defines the name of the relationship between the configuration items (such as "managed by" or "runs on").
This feature also requires the CINamedRelLink business object, which is new in Neurons for ITSM Release 2015.1. If you do not have that business object, contact Ivanti.
Importing Relationship Records
To import the relationship records, follow the steps in Setting Up a Data Import Connection and then continue with the steps below:
- Follow steps 1-4 in Setting Up a Data Import Connection.
- In the Connection Type field, select Manual File Upload.
- In the Data File Name field, click Upload to navigate to the file that contains the configuration item relationship information. In this example, the file is called CIRelations.csv.
- Test the data import connection by clicking Test Connection and click Close to close the dialog box.
- Click Next.
The application displays the Object Mapping screen.
- Enter the following:
- In the Mapping field, select Add new.
- In the Name field, enter a name, such as CI Name Relation mapping.
- In the Source Unique Key field, select all three keys (DataID, SourceID, TargetID).
- In the Target Business Object field, enter CINamedRelLink [CINamedRelLink#].
- Click Next. The application displays the Filter Setting screen.
- Enter the following values:
Source: CIRelations.csv |
| Target: CINamedRelLink# |
|---|---|---|
DataID | --> | DataID |
SourceID | --> | SourceID |
TargetID | --> | TargetID |
- Click Next. The application displays the Field Mapping screen.
- Enter values. Refer to Mapping Fields.
- Click Next. The application displays the Review and Publish screen.
- Click Publish & Run Now.