Import Metadata into an Application
Use these scripts to manually import application metadata from a file.
These scripts perform the following activities:
- Signs in to an environment.
- Uploads a metadata file.
- Imports metadata from the uploaded file into the application using a job.
- Refreshes the cube.
- Signs out.
Windows Sample Script
CreateimportMetadata.ps1
by copying the following
Script. Store it in a local
directory.$inputproperties = ConvertFrom-StringData(Get-Content ./input.properties -raw)
$username="$($inputproperties.username)"
$passwordfile="$($inputproperties.passwordfile)"
$serviceURL="$($inputproperties.serviceURL)"
$file1="$($inputproperties.file1)"
$jobName="$($inputproperties.jobName)"
epmautomate login ${username} ${passwordfile} ${serviceURL}
epmautomate uploadfile ${file1}
epmautomate importmetadata ${jobName} ${file1}
epmautomate refreshcube
epmautomate logout
Linux/UNIX Sample Script
CreateimportMetadata.sh
by copying the following
Script. Store it in a local directory.#!/bin/bash
. ./input.properties
export JAVA_HOME=${javahome}
${epmautomatescript} login "${username}" "${passwordfile}" "${serviceURL}"
${epmautomatescript} uploadfile "${file1}"
${epmautomatescript} importmetadata "${jobName}" "${file1}"
${epmautomatescript} refreshcube
${epmautomatescript} logout
Creating the input.properties File
Create the input.properties
file by copying one of
the following and updating it with information for your environment. Save the file
in the directory where importMetadata.ps1
or
importMetadata.sh
is stored.
username=exampleAdmin
passwordfile=examplePassword.epw
serviceURL=exampleURL
File1=FILE_NAME.zip
jobName=JOB_NAME
Linux/UNIX
javahome=JAVA_HOME
epmautomatescript=EPM_AUTOMATE_LOCATION
username=exampleAdmin
passwordfile=examplePassword.epw
serviceURL=exampleURL
File1=FILE_NAME.zip
jobName=JOB_NAME
Table 3-17 input.properties Parameters
Parameter | Description |
---|---|
javahome |
JAVA_HOME location. For Linux/UNIX only.
|
epmautomatescript |
Absolute path of EPM Automate
executable (epmautomate.sh ). For Linux/UNIX
only.
|
username |
User name of a Service Administrator, who also has the Identity Domain Administrator role. |
password |
Password of the Service Administrator or the name and location of the encrypted password file. |
serviceURL |
URL of the environment from which you want to generate the snapshot. |
File1
|
Name of the ZIP file containing the metadata to import. |
JobName
|
Job to use for importing the metadata. |
Running the Scripts
- Create
importMetadata.ps1
orimportMetadata.sh
by copying the script from a preceding section. - Create the
input.properties
file and save it in the directory where theimportMetadata
script is located. Contents of this file differs depending on your operating system. See Creating the input.properties File.Make sure that you have write privileges in this directory. For Windows, you may need to start PowerShell using the Run as Administrator option to be able to run the script.
- Launch the script.
- Windows PowerShell: run
importMetadata.ps1
. - Linux/UNIX: run
./importMetadata.sh
.
- Windows PowerShell: run