Talend community forum / JDBCSP component

ZeljkaMom · 2011-05-11 20:06:49

Tags: [context, database, date, deployment, mssql]

Hi everyone,

How do I pass the JDBCSP component jdbc connection properties from a configuration file?

For example, I have one database server for testing, one database server for production environment. I don't want to hardcode the JDBC connection string/user/password in the component, I want to be able to pass the properties at run-time.

thanks
Zeljka

jholman · 2011-05-11 21:00:09

Export the connection stings to context in the connection wizard. You can then use different contexts for default values, or override the defaults using tContextLoad.

ZeljkaMom · 2011-05-12 10:12:13

Could you please give me some example as I am not sure what you have mean by "Export the connection string to context in the connection wizard" ...

below is schema of my work and I just need to be able to have "context.JDBC" under JDBC URL .

Uploaded Images

Last edited by ZeljkaMom (2011-05-12 10:13:13)

shong · 2011-05-12 14:21:25

Hi
jholman meant click on the 'export as context' button to export the connection string to context. see my screenshot.

Best regards
Shong

ZeljkaMom · 2011-05-12 15:57:47

hi shong,

I can't see any screen shot , could you please re send again.

Thanks
Zeljka

ZeljkaMom · 2011-05-12 16:10:13

I am not sure if I was clear what actully I will need it.

I do not want to hard code connection to my server on JDBCSP component and also I am just passing paraments to it.
I want my XML file to be writine in the database as string. (see my schema).

Thanks
Zeljka

Announcement

Unanswered posts

#1 2011-05-11 20:06:49

JDBCSP component

#2 2011-05-11 21:00:09

Re: JDBCSP component

#3 2011-05-12 10:12:13

Re: JDBCSP component

#4 2011-05-12 14:21:25

Re: JDBCSP component

#5 2011-05-12 15:57:47

Re: JDBCSP component

#6 2011-05-12 16:10:13

Re: JDBCSP component

Board footer