You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-03-03 19:16:03

plumberg
Member
115 posts

plumberg said:

SAM with SQLSERVER Data Source

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.

Offline

#2 2017-03-08 05:02:03

xldai
Talend Team


xldai said:

Re: SAM with SQLSERVER Data Source

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.

Offline

#3 2017-03-08 13:58:54

plumberg
Member
115 posts

plumberg said:

Re: SAM with SQLSERVER Data Source

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!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy