SQLServer 2008 Schema tables not listing (TOSDQ v5.0.2.r78327)

[Anonymous]

Hello,
and yes, I have searched the forums on this issue, but alas to no resolve.
Having failed to get any joy out of an NTLM connection, I've reverted to username/password.
I connect succesfully, and can 'explore' at least the dbo Schema, alas not any other.
(there is a yellow warning that 'version 10 detected on server' .. of what relevance I'm not sure, it IS a 2008 database)
As for the profiler .. the connections shows nodes for database roles, all of which show '0' Tables/Views.
I've spend 2 or 3 hours searching the forums, but alas I am no where closer to finding a solution.
The Talend responses to people's questions are lame to say the least and lead you nowhere but to another 'maybe' solution.
So ... does 'Telend Open Studio for Data Quality' work with SQL Server 2008 or not ?
It's a simple question.
If so, then where are the instructions for doing so ?
I must say, that I'm finding the whole experience utterly riddiculous.
Having seen a working demo of Talend conected to a MYSQL database, we were most impressed and keen to see how far we could go with it.
We may even have spent money on it.
That opinion is quickly changing !
Any help or comment welcome, but please make them quick before this whole line of research just gets classified as 'not with a barge pole'.
Many Thanks

[Anonymous]

Hi
Welcome to Talend Community!
Take it easy!
NO.1 : Connect to SQL SERVER in Windows authentication mode.
- Step 1: Download the driver here. http://sourceforge.net/projects/jtds/files/
- Step 2: You will find in the folder SSO a file called ntlmauth.dll. Put it in c:\windows\system32 and restart TOS.
- Step 3: Create a new MSSQL connection and leave user & password fields empty.
NO.2 : Why do you fail to retrieve schema?
When you create metadata-->DB Connection, "DataBase" and "Schema" shouldn't be empty.
If not, the connection shows nodes for database roles.

Regards,
Pedro

[Anonymous]

Pedro,
Thanks for the response.
NTMLAuth.dll has been installed.
However, this still does not allow a trusted connection when selecting 'Microsoft SQL Server 2005/2008' in the connection properties.
I have got it to work however with "Microsoft SQL Server".
Similarly, I see you talk below about '-->DB Connection, "DataBase" and "Schema"'
... but the Schema option is only available in the NON-'2005/2008' connection properties, hence I asssume you are here confirming for me, that I should be using "Microsoft SQL Server" and not 'Microsoft SQL Server 2005/2008' .

Really hope you can clarify this point.
And if so, that I am to use the "Microsoft SQL Server" connection ... what the heck is 'Microsoft SQL Server 2005/2008' for ??
Many Thanks

[Anonymous]

Hi
When you choose "Microsoft SQL Server", you will find that String of Connection is like "jdbc:jtds:sqlserver".
When you choose "Microsoft SQL Server 2005/2008", it turns to "jdbc:sqlserver".
They are different ways to connect to SQL Server.
Now i'm sure you can connect to MSSQL in windows authentication mode by choosing "Microsoft SQL Server".
Wait for your feedback.
Regards,
Pedro

[Anonymous]

Well firstly may I say, I feel it's pretty pointless and counter productive to put an option on there as '2005/8' , if indeed you shouldn't be using to connect to a 2008/5 database !
I mean seriously ??
But nevertheless, yes I can connect using "Microsoft SQL Server" via NTLM.
However, under the node for my Domain user, no tables/views listed.
I can see tables under Schema dbo & ABC, but not DEF.
My Domain account is db_owner and owns all Schemas
Now, if I use the 2005/8 connection, and a User who has been asigned db_datareader .... I can see absolutely every table/view there is.
So ... maybe this is something in my permissions?
Any guidance at to what Talend needs for me to see the object that I own when I log in as me ?
Apologies if I sound bitter .... but after battling my way through a very poorly explained and mis-instructed system for too many hours, I may be a little weary.

[Anonymous]

Hi
Recreate connection.
Choose "Microsoft SQL Server" and leave "schema" empty this time.
Regards,
Pedro

[Anonymous]

I already left 'schema' empty.
Not sure what makes you think I did not ?

[Anonymous]

No, I don't think this is my Db permission settings.
Just tried to connect to another SQL database.
This Database I have connected to using Integrated Security via MS Client Tools, Information Steward and a few other applications without issue.
Yet within TOS, it's still listing roles instead of Schemas.
I simply cannot get to tables in specific schemas.
Connection type : MS SQL Server
User/Pass : Empty
Schema : Empty
Parameters : Empty

[Anonymous]

Hi
Connection type: MS SQL Server
USER/PASS: Empty
Server: localhost
Port:1286
Database:test
Schema:Empty
Parameters:Empty
But I can get tables and schemas.
OS: Windows XP.
TOSDQ: TOSDQ v5.0.2.r78327
Regards,
Pedro

[Anonymous]

Pedro,
I can't see any tables there ?
Please if I am blind, point them out to me ?

Now create a schema called ABC, create a table in it ... and show me that tbale listed.

Really, your last response was lame !