Question Setting SQL Connection in SQL Operation by using a variable

Hi eveybody,

My prupose is simple, by using a parameter table , wich contains everything for creating connection (driver,url , user, password) , i would like to use bind variable for setting SQL Connection in SQL Operation.
Do i need to use scripting ?

Hello,
I'm not sure I understand what you are trying to achieve.
What is the final goal ?

Usually, working with multiple database connections in a single process is done by metadatas.
Each metadata can be parameterized with process parameters.
Maybe this article can help :
www.stambia.org/doc/80-development-hints...onnection-properties

Hello ,

All is good. I use metadata configuration , and i have a bad issue due to a lack of password on HSQL database.
I just modify the password , update my param table with the encrypt password, and It's ok.
Thx

OK great

Note to future readers :
- parameterizing connection properties with process parameters is a specific method, useful when these properties are stored in external files or tables.
- the standard Stambia DI method is to configure the metadata and overrride connection setting when building the Delivery, with Analytics or with a Configuration file.