pentahopentaho-design-studio

Pentaho xaction - How can I change database name on runtime?

I am using Pentaho Design Studio(pds-ce-win-32-4.0.0-stable). In an xaction file I need to change database name in the url like 

jdbc:sqlserver://IP:1433;databaseName=??????;integratedSecurity=false

I generated an output as result set column that holds the url. When I run the xaction that url is shown as output. But when I use that result set column as database url of next process it doesnt work.

Solution

  • Not sure why you use url pattern, in xaction so far I used the jndi name for DB resource:

    <jndi><![CDATA[tsi_test_blade4]]></jndi>

    and this can be also replaced with variable:

    <jndi>{JNDDDI}</jndi>

    So as JNDI you pass as parameter that resource is used.