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 2006-09-20 10:55:23

dabratt
Member
7 posts

dabratt said:

SQL Server NT authentication

Is there a way to use NT authentication to create a connection to SQL Server through Talend Open Studio ?

Offline

#2 2006-09-20 11:11:46

plegall
Talend Team


plegall said:

Re: SQL Server NT authentication

I'm the author of the tDBInput component. So I won't talk about the "Database connection wizard".

Is there any relation with ODBC?

When you choose "Microsoft (ODBC driver)" in tDBInput, the way it works today is the following:

1. "host" and "port" properties become useless
2. "database" property is used as the ODBC connection name you find in your ODBC configuration (that's where you set the host and port parameters)
3. Perl script connects to ODBC with the given database, and authenticate with "username" and "password" properties

Offline

#3 2006-09-20 13:30:27

dabratt
Member
7 posts

dabratt said:

Re: SQL Server NT authentication

With the "Database connection wizard", by selecting "Microsoft SQL Server" as dbType, it seems that NT authentication doesn't work or isn't implemented.
On the other hand, it works fine with the ODBC dbType!

Can we test a connection created with the tDBInput component (built-in connection) ?

Offline

#4 2006-09-20 14:30:49

plegall
Talend Team


plegall said:

Re: SQL Server NT authentication

dabratt wrote:

With the "Database connection wizard", by selecting "Microsoft SQL Server" as dbType, it seems that NT authentication doesn't work or isn't implemented.

I'll let cantoine (responsible of this wizard) answer this question.

dabratt wrote:

Can we test a connection created with the tDBInput component (built-in connection) ?

Of course you can :-)

1. create a job/process
2. drop a tDBInput and a tLogRow linked by a "row main" link
3. fill the tDBInput properties, and a simple query "select id, name, service from employee"
5. run the process and see what is output in the console (tLogRow component prints its output in the "Run process" console)

Offline

#5 2006-09-20 17:08:51

cantoine
Talend Team


cantoine said:

Re: SQL Server NT authentication

Hello,

If your configuration is a MS SQLServer with Odbc Driver you must choose Odbc/Jdbc in the DbType of the Wizard.
About MS SQLServer DbType in the wizard, you must to connect with a Host and a Port, it's a different access method.

In your case, use a Odbc/Jdbc DbType to work on your MS SQLServer configuration.

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy