Introduction
Sample Template is a set of pre-configured templates using which you can demonstrate Spectrum migration capabilities. It eliminitates the need to create data flows from scratch. You need to create a couple of connections and import these flows into your system to demonstrate the migration capabilities. This section describes the end-to-end process of data migration using sample flows.
Locating the Sample Template
Program Files\Pitney Bowes\Spectrum\server\modules\metadata-insights\connectors\samplesThe folder contains all the required files to configure the data flow.
Creating Connections
You need to create two connections to import and deploy required files to configure the data flow. Follow these steps to create connections:
- Install the latest Spectrum platform Server
- Open the Spectrum Server home page
- Click Platform Client Tools and then click Web
- Open the Management Console view
- Click Resources menu and then click Data Sources and create two connections.
Importing and Deploying Files to the Server
With connection in place, now you need a command line utility to import and deploy the files to the server.
- Open the Spectrum platform home page, click Platform Client Tools
followed by Command Line and download the following files:
- Job Executor, which is an individual .jar file
- Administration Utility, which is a zipped file (spectrum-cli)
- Unzip the spectrum-cli file
- Copy all the files from the Sample Template folder to the spectrum-cli folder. This saves you from entering full path of every file with each command
- Run cli.cmd utility located in the spectrum-cli-12.1 folder. The command line interface of the Spectrum Platform is launched
- Connect to the Spectrum Server using following commands: connect <server name>:<port> --u <username> --p <password>. Successful connection is confirmed by message: Connected to server<server name> :< port>
- Type and execute the following commands in the given order to import and deploy
the sample data flows:
- Import modelstore using command: spectrum> modelstore bulkImport --importDependency true This command imports the modelstore with all the dependencies.
- Deploy modelstore using command:modelstore deploy --n <name>
- Import dbconnection using command: dbconnection import --f <name.json>
- Import data flows using command: dataflow import --f <name.df>
Remove any extra spaces around commands of filenames
Replace the placeholder <name> with the exact name of the file
Viewing Imported Files
After successful import, you can use these data flows to demonstrate the Spectrum capabilities. Files are stored at following locations:
- Modelstore: In the Physical Model and Model Store tabs in Metadata Insights
- Dataflow: In the Server Explorer of Enterprise Designer application
- Json: In the Model Store in Management Console
Imported flows can be used to migrate data from one system to other using Enterprise Designer. Detailed steps for each of the flows is mentioned in their respetive following secitons.