Import Opal Archive

Import an archive of XML files, to be found in Opal file system.

opal import-spss <CREDENTIALS> <OPTIONS> [EXTRAS]


Option Description
--destination DESTINATION, -d DESTINATION Destination datasource name
--tables TABLES [TABLES ...], -t TABLES [TABLES ...] The list of tables to be imported (defaults to all)
--incremental -i Incremental import
--identifiers IDENTIFIERS, -id IDENTIFIERS Name of the ID mapping
--policy POLICY, -po POLICY
ID mapping policy:

required : each identifiers must be mapped prior importation (default),
ignore : ignore unknown identifiers,
generate : generate a system identifier for each unknown identifier.
--path PATH -pa PATH Path to the zip of XML files to import on the Opal file system
--merge, -mg Merge imported data dictionary with the destination one (default is false, i.e. data dictionary is overridden).


Authentication can be done by username/password credentials OR by personal access token OR by certificate/private key pair (two-way SSL authentication).

Option Description
--opal OPAL, -o OPAL Opal server base url
--user USER, -u USER Credentials auth: user name (requires a password)
--password PASSWORD, -p PASSWORD Credentials auth: user password (requires a user name)
--otp, -ot Whether a one-time password is to be provided (required when connecting with username/password AND two-factor authentication is enabled)
--token TOKEN, -tk TOKEN Token auth: user’s personal access token
--ssl-cert SSL_CERT, -sc SSL_CERT Two-way SSL auth: certificate/public key file (requires a private key)
--ssl-key SSL_KEY, -sk SSL_KEY Two-way SSL auth: private key file (requires a certificate)


Option Description
-h, --help Show the command help’s message.
--verbose, -v Verbose output.
--json, -j Output pretty-print JSON


Import tables from 20-onyx ZIP file to the opal-data datasource:

# Import all tables
opal import-xml --opal --user administrator --password password --path /home/administrator/ --destination opal-data

# Import only ArmSpan and BloodPressure tables
opal import-xml --opal --user administrator --password password --path /home/administrator/ --destination opal-data --tables ArmSpan BloodPressure