Using transport templates
If you repeatedly need to create transports with certain export criteria, you can use transport templates. You create transport templates in the Database Transporter. Configure a transport and mark it as a transport template. This creates a transport template in XML format. You can use the transport templates when you create transport packages with the Database Transporter or with the DBTransporterCMD.exe command line program. This loads the export criteria from the transport template file.
To create a transport template
-
Start the Launchpad and log in to the One Identity Manager database.
-
In the Change & Extend view, select the Transport custom modifications entry and click Start.
This starts the Database Transporter program.
-
Select Create a transport file on the start page.
-
On the Select the database connection page, check the One Identity Manager database connection data and change it if necessary.
-
Enter the information about the transport file on the Define file name page.
-
Enter the name of the transport file and change the output directory as required.
-
Set the Create a transport template file option.
-
(Optional) To create a log file for the export, set the Create a log file for data export option.
The log file is saved in the output directory of the transport file.
-
Enter a description of the transport data on the Show and define transport parameters page.
-
Select the export criteria for the transport on the Define transport data page.
-
On the Transport template file page, enter the following information.
-
Template file name: Transport template file name.
-
Export path for template file: Repository for the transport template.
-
Description for template file: Detailed description of the transport template.
-
To start the export, click Next.
This creates the transport template file and the transport package. The program determines the data to export and displays the progress of the export in the dialog box. The export procedure can take some time.
-
On the last page, the name and storage path for the transport package are displayed. You can open the directory path using the link.
-
To end the program, click Finish on the last page.
Related topics
Importing data with the Data Import
With the Data Import program, the One Identity Manager offers a simple means of importing data from other systems. The program supports importing from .csv files and importing directly from other database systems. You can import data immediately. You also have the option to import data from customized processes using the import scripts that are created. The import definition is saved so that you can use it for future data imports.
The steps in the program are as follows:
-
Load export definitions
-
Select the import method
-
Configure the import
-
Create an import definition
-
Create an import script
-
Start the import
NOTE:
-
For regular data imports into One Identity Manager, you can also use the ScriptComponent process component.
-
The DataImporterCMD.exe program provides support for imports from the command line.
Detailed information about this topic
Importing data from a CSV file
Prerequisites
The data structure of the import file needs to fulfill the following requirements:
-
The data is separated by a delimiter or fixed column widths are used.
-
The data records are separated by a new line.
-
Data that contains a new line is marked with a text qualifier.
-
For more extensive CSV imports, the data in the import file is sorted in advance to resolve the object dependencies.
NOTE: For imports with small amounts of data, use the sorting options of the Data Import.
To import data from CSV files into the One Identity Manager database
-
Start the Launchpad and log in to the One Identity Manager database.
-
On the Configuration page, select Configure data import and click Start.
This starts the Data Import program.
-
On the Data Import start page, click Next.
-
On the Select the database connection page, check the One Identity Manager database connection data and change it if necessary.
-
(optional) On the Loading an import definition file page, load the import definition file, if available.
NOTE: Leave this field empty if you want to create a new import definition.
-
On the Select data source page, select the Import CSV file method.
-
On the Load import file page, load the import file and enter additional data about the import file.
-
On the File structure page, specify how the file is structured.
-
On the Defining the line structure page, specify the structure of the lines.
-
(Optional) On the Line condition page, specify a condition for importing lines.
-
Configure the import.
-
On the Match target tables and columns page, assign the data for target tables and target columns of the One Identity Manager database and specify the key columns.
-
On the Specify hierarchy page, specify the data hierarchy for the import.
-
On the Handling options for data sets page, specify options for handling the data.
-
On the Connection variables page, define variables that are set on import.
-
On the Saving the import definition page, save the import definition file and the import script.
-
On the Saving the import definition page, start the import.
-
On the last page of the Data Import, quit the program or start another import.
Detailed information about this topic
Loading the CSV file
On the Load import file page in Data Import, enter the following data about the import file.
Table 42: Import file settings
|
Import file |
Path to the .csv file containing the data to be imported. You can use the ... button beside the input field to navigate to and open the file. |
|
File encoding |
Encoding of the .csv file. Encoding of the character set is determined from the character set on your workstation when the import file is loaded. Change the setting if the file was created with another character set. |
|
File culture |
Language used to create the file. The language is required in order to read local character formats correctly, for example, dates. |
|
Time zones |
If date and time information is imported, select the time zone of the data. The time zone is required for converting the data to UTC. |
