Your SQL table must follow a specific schema so the importer can correctly map fields. Review these requirements before running an SQL-based import.
For the SQL query in Task: Import the prepared data to run successfully, the table must have the following structure:
Column name | Data type | Allow Nulls |
|---|---|---|
userid | nvarchar(50) | ✓ |
[Practice Area] | nvarchar(50) | ✓ |
Manager | nvarchar(50) | ✓ |
Telephone | nvarchar(50) | ✓ |
[Additional Locations] | nvarchar(50) | ✓ |
Department | nvarchar(50) | ✓ |
[Job Title] | nvarchar(50) | ✓ |
The userid field isn't a metadata field itself but is required to correctly assign the metadata to the proper user. All database columns must exactly match the field names in the SELECT statement for proper data mapping.
NOTE: The same SQL query can be used when removing a user account that was added to iManage Threat Manager by import and isn't connected to an iManage Work account. For details, refer to Removing metadata or accidental user imports.