FDMEE script to connect to external SQL database configured in topology manager

Hi all,

I need to write a FDMEE script that connects to an external database custom schema for inserting data into a table. I am able to do so by with the help of sql class as follows:

import java.sql as sql

sourceConn = sql.DriverManager.getConnection("jdbcUrl", "user", "password");

However, this forces me to write unencrypted password in the script; my company policies prohibits me from doing that.

I have added this db connection as "Physical Architecture" in Topology manager. Is there a way for FDMEE jython script to read or utilize ODI topology manager connection credentials?

In other words, how do I read the jdbc url, database name, userid and password from topology manager of ODI and pass it has argument to sql.DriverManager.getConnection() function using FDMEE jython scripts.