Welcome Guest! Log in
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.

The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…


First Consider using Configurations

Configurations are the most integrated way to manage connection properties. They can be declared at development stage, and overriden at deployment stage (through Stambia Analytics).

They allow you to define multiple connection strings, schema names and many other properties, for a single metadata.

For more information, search the Designer's documentation about Configurations.

 

What we want to do

In this article, we want to make a process which executes a query on a database, an make this database's user and password parametrized.

 

Creating the metadata

We create a simple metadata for an Oracle Database server:

111-05

 

Note the User property references the process parameter "jdbcUser". And the Password property references the process parameter "jdbcPassword" (as indicated in the Description).

 

 

Developing the process

Our process is simple:

  • A "JdbcUser" parameter
  • A "JdbcPassword" parameter
  • A SqlOperation for executing the query

 

111-01

 

The JdbcPassword is encrypted. Here is how to encrypt a password.

Click the "Runtime Command" button in the "Runtime" View.

111-02

 

This will open the "Runtime Command" Console.

Type "connect" + Enter.

111-03

Note : you may have to specify the runtime histname and port if this is a distant Runtime: connect to <hostname> port <port>

 

Type "encrypt <password>" + Enter.

111-04

The Runtime will encrypt the password for you.

Copy the encrypted password (in the above example, CE466977E6A4B21AE0D09695BBB744924D1E22C238D63022BC1BB786D4A1875C).

 

We dragged the Oracle Metadata on the SqlToParameters action.

Here is the code for the SqlToParameters action :

<sqlToParameters>
<parameter name="~/result" type="String" failsIfNoRecord="true" defaultValue="ko">
select 'ok' from dual
</parameter>
</sqlToParameters>

 

Now, this process can be started in command line, passing the user and encrypted password like this :

startdelivery.bat -name metadataPasswordParametrized -var ~/jdbcUser user1 -var ~/jdbcPassword CE466977E6A4B21AE0D09695BBB744924D1E22C238D63022BC1BB786D4A1875C

... or with an ExecuteDelivery action, or as a subprocess:

111-06

 

 

 

Articles

Suggest a new Article!