SOA 12c: Rename MFT Source, Target, Transfer

Introduction:
Guess, what if we have created a MFT Source or Target or Transfer and we have been asked to change its name. This post is quick and easy solution (with little bit of hacking) to achieve the same, so instead of redeveloping MFT components you can just rename it without changing its functionalities.

Prerequisites:
You should know what is MFT source, Target, Transfer and how it is created.

Steps:
For purpose of showing this case, I have created Sample Source, Target and Transfer.
Sample Source name: T1; Sample Target:TestTargt; Sample Transfer: testtransfer

Now suppose all my components are ready and at last minute I found some mistake while defining names.
Don't worry, you can easily rectify it. Here I am going to rename Source name T1 to Source1, Just follow below steps:

1) Export transfer file, just click on export (present on transfer window on right hand side)
2) Once you export the file, you will see a file - [TransferName]_export.zip downloaded.

 3) Right click on that file and open the zip using Windows Explorer, as shown below. (Note - with normal Winzip or any other tool it will not work)

4) A new folder will open containing mft folder. mft folder will contain 3 more directories as shown below

5) Navigate to source folder, you will see an XML file there. Open that file (you can copy that file to different location, edit and then replace the file under mft/source folder).

As shown below, Source name is T1

 6) Edit the name to Source1, save and copy it back to mft/source

7) Once file is copied, close the zip folder

8) Now go back to MFT console, Administration Tab and Import the zip file.

9) Once Import is done, go back to Design Tab of MFT console, refresh the Designer palette. You can see new Source name (Source1) appearing there in place of T1

10) Same source name will automatically appear under Transfer as well

So you are all set, just deploy and test.

For renaming Target or Tansfers, follow same steps.
For Targets, navigate to mft/target folder and make changes, and for transfer follow mft/transfer.

WLST for MFT

Introduction:
I have been using WLST (WebLogic Scripting Tool) for MFT a lot, so wanted to dedicate some of the post specifically for that. These are pretty simple ones but can help many.

Steps:
If I talk specifically about WLST for MFT,  to connect to the server you need to follow below steps.

1. Open WLS_Home\mft\common\bin (Below screen shot is my system location)

2. Open command prompt (Run as administrator), navigate till the WLS_Home\mft\common\bin

3. Once you are on that location, type - wlst.cmd (for Linux it is ./wlst.sh)

4. You will be on wlst prompt

WLST commonly used Commands:

1. For connecting to the server
connect("username","password","t3://hostname:port")

Example: connect("weblogic","welcome1","t3://localhost:7101")

2. For disconnecting from WLST
You can either use - disconnect () or exit ()

Some of WLST Commands for MFT:

Coming soon...

Oracle 12c MFT - Using PGP Decryption

Introduction:
This is in continuation of my last blog, Oracle 12c MFT - Using PGP Encryption, here we will understand on how to decrypt the file which was encrypted using PGP Encryption technique.

I would recommend you to go through my PGP Encyption blog to understand the process.

Steps:
Once the Keys are available (created and imported during Encryption), doing Decryption will be quite simple. We will be using Private Key for decrypting the file.

1) Goto MFT console Design Tab, and for Transfer, select add pre-processing actions.

2) Once window opens, select PGP Decryption for the drop down and Add to the list.
Select Decryption Alias. Click OK

And you are all done.

Oracle 12c MFT - Using PGP Encryption

Introduction:
While creating Transfers in MFT, we have came across various pre-processing actions, such as Compress, decompress, PGP Encryption and PGP Decryption. These operations will be done for securing Files which is getting transferred from Source to Target.

Lets learn now how to use PGP Encryption.

Steps:
Before using PGP Encryption, we need to create PGP Key using WLST command. Below are detailed steps on how to acheive the same.

1) Navigate to OracleWLS_Home\mft\common\bin
2) Once you are there, Run wlst.cmd

3) You are now on wlst prompt, Now connect to your server using following command
connect("username","password","t3://hostname:port")

4) Above prompt shows that you are now connected to server. Now we will have to generate the PGP Key to create a password-protected PGP key pair. Fire the wlst command for generating Key, as-
generateKeys('PGP', 'Password for the key','Location name where you want keys to get generated')

Note: I have created a seperate new directory under my local domain to contain all the Keys

This will create two keys - pub.asc (Public) and secret.asc (Private)

5) Now you will have to import the PGP key pair to the server and will also create an alias for both Public and Private keys.
Use below commands to do the same:
importCSFKey('PGP', 'PUBLIC', 'Alias Name', 'full location/pub.asc')
importCSFKey('PGP', 'PRIVATE', 'Alias Name', 'full location/secret.asc')

6) Now as your Key pairs are generated and imported successfully, Go back to MFT console. Now rest of the configuration will happen there.

7) Login to MFT console and navigate to administration Tab - Keystores.
Enter the same password which was used during Generating key in the PGP Keystore section. Save the changes

8) Now you are all good to use this setup in creating Transfers. Goto MFT console Design Tab, and for Transfer, select add pre-processing actions.

Once a window opens, select PGP Encryption for the drop down and Add to the list.
Select Encryption Alias and the Armored section. Click OK

 And you are all set. You file will be Encrypted.

Oracle 12c MFT - Configuring sFTP Embed

Introduction:
Oracle 12c MFT includes built-in sFTP (SSH-FTP) server, known as sFTP Embedded. You can see this in MFT console drop down when you configure Source.

sFTP Embed has its own file system directories for sending and receiving files. By default, this is disabled, we need to configure it before using it.

Lets learn step by step on how to configure this.

Steps:
For configuring sFTP (SSH-FTP), we need to create SSH Keystore using WLST command. Below are detailed steps on how to acheive the same.

1) Navigate to OracleWLS_Home\mft\common\bin
2) Once you are there, Run wlst.cmd

3) You are now on wlst prompt, Now connect to your server using following command
connect("username","password","t3://hostname:port")

4) Above prompt shows that you are now connected to server. Now we will have to generate the Key to create a password-protected private SSH key. The key type is RSA and the key size is 1024 bits. Fire the wlst command for generating Key, as
generateKeys('SSH','Password for the key','Key Name with full location')

Note: I have created a new directory under my local domain to contain all the Keys

5) Now you will have to import the key to the server and will also create an alias for the key.
Use below command to do the same:
importCSFKey('SSH', 'PRIVATE', 'Alias Name', 'Key Name with full location')

6) Now as your Key generation and import is done, Go back to MFT console. Now rest of the configuration will happen there.

7) Login to MFT console and navigate to administration Tab - Keystores.
Enter the same password which was used during Generating key in the SSH Keystore section. Save the changes

8) Click on Embedded servers and go to the sFTP tab. Check the Enabled button, Choose Authentication Type as Password and Host Key Alias (the same alias which was created at the time of importing the key to the server).

Save the changes, click on Start button

9) Now your sFTP Embed server is up and running, this by default runs on Port 7522. You can check the same in the Ports section (You can change the port, but I would recommend to keep this as it is.)

10) So now you are all set to use sFTP Embedded feature of Oracle 12c MFT. You can even connect to the sFTP location using any client like WinScp.

Go ahead and try this awesome feature.

Note: The default root directory location for this is OracleWLS_Home/user_projects/domains/your -Default Domain/mft/ftp_root (This can be changed and configured from MFT console, I would prefer to use the same path)

Updating SOA 12c Domain for MFT

Introduction:
This is the last step required for MFT. After this is complete you can go ahead and use MFT.

Prerequisites:
You should complete steps specified earlier such as SOA 12c Installation with Default local server setup, Database Installation, MFT Installation and RCU creation.

Steps for Updating Domain:

1) Open cmd for Administrator and navigate to ORACLE_HOME\oracle_common\common\bin, as shown below.

Note: ORACLE_HOME is the location where your SOA12c is installed.

2) You need to set JVM argument as -

SET CONFIG_JVM_ARGS=-Dcom.oracle.cie.config.showProfile=true

3) Then run config.cmd

4) This will open Wizard, as you have already a domain setup (your local SOA server), we will update the existing domain for MFT. Make sure the Domain location is your local server location. Choose Next

5) Choose the check boxes as shown below for MFT, click Next

6) Here choose AutoConfiguration option as RCU
Vendor: Oracle
DBMS/Service: This will be the SID which you had used during Database installation time. IN my case this was orcl.
Give Hostname, Port, User name and password
Schema Owner: It should be the Schema which was created during RCU creation. In my case it was DEV_STB and then provide schema password.

Once this is done press Get RCU Configuration. Once it is all OK, Click Next

7) Choose MFT specific check boxes as specified in screen shot, Click Next

8) Choose as per the Screen shot below, Click Next

9) Leave this page as it is and Click Next

10) Now click Update on the summary page

11) This will update the existing domain, and shows its progress, Click Next once done

12)  Thats all, click Finish.

So that's it. You are all good to use MFT.

You can open MFT Console using URL: http://hostname:port/mftconsole
You can change Hostname & port according to your environment setup. By default for local system port will be 7101

RCU Creation for Oracle 12c MFT

Introduction:
This is continuation of my previous blog which is about MFT installation. We have already covered Database 12c installation and MFT installation, now lets focus on RCU creation for MFT.

Step by Step:

RCU file resides under your ORACLE_HOME\oracle_common\bin
ORACLE_HOME here is place where your SOA is installed

1) To start with, first of all you will have to set your Java Jdk Home and Oracle Home (Oracle Database home). I have configured it based on the plave where I had installed Java and Database, as shown in below screen shot.

2) Navigate to ORACLE_HOME\oracle_common\bin and run rcu.bat (for Windows)

3) This will open RCU welcome window as shown below, Click Next

4) This window you will have to provide your database details, like port, SID, sys username and its password (which you have given during Database installation). Choose Role as Sysdba and click Next

5) DEV_MFT for MFT RCU is selected, Click Next. After this Prerequisite check window will appear, click Ok once complete

6) Choose Schema Password, Click Next

7) Click Next, Click OK on confirmation window, which will then create Tablespace

8) Once Summary is displayed, verify the details (keep a screen shot of this window, it will be required during MFT Domain creation), and Click on Create

Once this is complete, Completion Summary page will appear showing status of the RCU run. Choose Close button, RCU run is completed successfully.

Now refer to my next blog which will talk about updating the existing Domain for MFT.