The runtableimport program extracts data from a file in XML or ZIP format (XML event format) and updates a table in an analysis realm. Import file, table, and analysis realm are specified by parameters.
Prerequisite
The user has the Data import function privilege.
You run the runtableimport program in the command prompt by entering the parameters listed.
runtableimport.bat
-user <user name>
-password <password>
-realm <realm name>
[-mode (add | replace | delete)]
[(-datasource <file name> |
-table <table name>
-file <path>)]
[-client <client name>]
[-recoveryfile {yes | no}]
[-version]
[-protocolfile <file name>]
[-language <ISO code>]
[-information {yes | no | default}]
[-warning {yes | no | default}]
[-error {yes | no | default}]
[-alltables]
[-reinitanalysisserver {yes | no | auto}]
Parameter |
Description |
---|---|
user <user name> |
User name for logging in to a client Default: system Specification: Mandatory |
password <password> |
Password for logging in to a client Default: manager Specification: Mandatory |
realm <realm name> |
Name of the analysis realm to be imported Specification: Mandatory |
mode (add | replace | delete) |
Specifies whether the data imported is to be added (add) to the existing data, or whether the existing data will be replaced by the new data (replace), or whether the existing data will be deleted (delete). If the "add" mode is selected and the table has a key, existing table rows are replaced by new ones. (See chapter Configure analysis realm) In delete mode, the data of one or all tables of an analysis realm are deleted in the database and the analysis server. This mode is applied in case of inconsistencies in the analysis server and database. Default value: add Specification: Optional |
datasource <file name> |
Name and path of the data source; contains references to the importing file, table names, and data connection Specification: Mandatory if import file and table are not specified |
table <table name> |
Name of the table to be imported. The table is part of the analysis realm. Specification: Mandatory if no data source is specified |
file <path> |
Path including name of the file to be imported. Specification of the file format is optional, the default format is XML. You can also specify a ZIP file containing multiple XML files. By including a placeholder (*) in the file name you can import multiple files simultaneously. Specification: Mandatory if no data source is specified |
-client <client name> |
Name of the PPM client into which the data is to be imported. If no client is specified, the default client is used. Specification: Optional |
-recoveryfile {yes|no} |
Indicates whether the Data analytics relevant recovery files are to be saved after the import is complete. Default value: Yes Specification: Optional By default, all data (i.e., all tables in all analysis realms) is saved, even if only one table is imported. If an import is canceled, a recovery file will not be created. |
-version |
Outputs the version without importing |
-protocolfile <file name> |
Name of the log file to which the program output is to be written Specification: Optional |
-language <ISO code> |
Language of data imported. The language is specified in ISO code. If no language is specified the current operating system language is used. Specification: Optional |
-information {yes|no|default} |
Specifies whether information messages are to be output. Specification: Optional |
-warning {yes|no|default} |
Specifies whether warnings are to be output. Specification: Optional |
-error {yes|no|default} |
Specifies whether error messages are to be output. Specification: Optional |
-alltables |
Indicates whether the action is to be performed for all tables of an analysis realm, e.g., deletion of all tables. Specification is mandatory depending on the context |
-reinitanalysisserver {yes | no | auto} |
Indicates whether the analysis realm in the analysis server is to be reinitialized. With the auto setting, the analysis realm is reinitialized only if required. The no (default) setting prevents reinitialization in general. See also chapter Reinitialize analysis server. |
VM settings
The program is started with its own VM settings configured in the batch file _vmparam.bat. This file is located in the folder config/<client>/bin.
Default values are
These values cannot be set in CTK.