topic Re: SAM with SQLSERVER Data Source in Talend Studio

SAM with SQLSERVER Data Source

root — Sat, 16 Nov 2024 10:01:29 GMT

I am trying to setup SAM by using MSSQL Server as a data source instead of Derby.

I installed the SQLSERVER DataSource by adding the sqljdbc*.jar file into

<TalendRuntimePath>/deploy folder

I installed SQLServer DataSource in OSGI by giving the command:

feature:install tesb-datasource-sqlserver

I edited

<TalendRuntimePath>/etc/org.talend.esb.datasource.sqlserver.cfg

and provided my DB connection details

From Karaf, I ran:

tesb:start-sam

This created a Derby Data Source and installed the Derby-starter and tesb-datasource-derby feature.

Why would this happen? How can I force use only SQLSERVER data source?
Please advise. Thank you.

Re: SAM with SQLSERVER Data Source

Anonymous — Wed, 08 Mar 2017 04:02:03 GMT

Hi,

The "tesb:start-sam" is an aliase command for start the default Derby datasource and SAM server/services.

tesb:start-sam = { feature:install tesb-datasource-derby tesb-derby-starter tesb-sam-service-soap tesb-sam-service-rest } ;

So in case of other datasource you want to use, the "tesb:start-sam" should not be run in your final step, instead, you can do:
feature:install tesb-sam-service-soap
feature:install tesb-sam-service-rest

Regards.

Re: SAM with SQLSERVER Data Source

root — Wed, 08 Mar 2017 12:58:54 GMT

xldai wrote:
Hi,

The "tesb:start-sam" is an aliase command for start the default Derby datasource and SAM server/services.

tesb:start-sam = { feature:install tesb-datasource-derby tesb-derby-starter tesb-sam-service-soap tesb-sam-service-rest } ;

So in case of other datasource you want to use, the "tesb:start-sam" should not be run in your final step, instead, you can do:
feature:install tesb-sam-service-soap
feature:install tesb-sam-service-rest

Regards.

Ahh, I see. Makes sense. Will try that!