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

One Star

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

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
One Star

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

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
One Star

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

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
One Star

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

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
One Star

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

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.
One Star

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

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

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

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

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

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
One Star

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

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
One Star

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

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 !
One Star

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

Pedro,
Check in your Database under users ... I think you will find the list matches what you showed me.
They are NOT schemas ? Agree ?
One Star

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

Hi
It's a bug under SQL SERVER connection type.
Now I switch to SQL SERVER2005/2008.
I create a new Schema called ABC and a Table called "DemoABC".
Regards,
Pedro
One Star

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

Pedro,
Thank you, it's good to reach an agreement there !
SO, the next step....
I cannot get an NTLM connection to work on the 2005/2008 connection type.
I guess firstly, can you confirm that your last screen shot was done via NTLM ?
If you can, and I cannot, then we need to understand why.
Could you list what additional dll or jar files I should make sure I have downloaded, and how I need to have then located/registered in order for this to work ?
Many Thanks
Simon
XP professional
V2002 SP 3
32bit
One Star

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

Hi
The last screen shot wasn't done via NTLM.
I will report all these things on BugTracker.
I'm so sorry about this.
Regards,
Pedro
One Star

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

OK,
So to clarify, Talend OS DQ will not connect to SQL Server 2005/8 via NTLM and provide access to all Scemas.
It's ok, I'm not being mean by ramming that home, I just need to clarify.
As you can appreciate, when selecting a solution to a business scenario, many hours are spent researching more than just 1 product.
Many more hours and money may then be committed on the findings.
Hence my need to be precise about this.
We are keen on Talend in principle, it's now just a matter of working out if the bugs & support issues are bearable.
I am guessing that at this stage you have no idea how long this bug will take to be sorted ?
Is there any way I can be alerted on progress ? To be honest I do not want to have to keep logging back in to check progress every week/month/year ... I hope you can appreciate that this is not the only issue I have on my plate !
I am a 'potential' customer for your premium offerings, but obvioulsy we would go down that path without this basic functionality.
Hope you can advise...
Regards
Simon
One Star

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

Hi Pedro,
One last thing ... could you possibly throw me the Bugtracker referece please?
I've had a search with no succes, but it's a big place, maybe I'm searching on the wrong key words !
Many Thanks
One Star

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

Hi
Here it is. BugTracker
You can access it next time from the menu bar on the top of this page.
One more thing. For all issues about TDQ, please create topic at section.

Regards,
Pedro
One Star

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

Hi
I have reported it .
Regards,
Pedro
Employee

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

Hi simon and pedro,
I reproduced the issue and added a note to describe the solution in Jira.
http://jira.talendforge.org/browse/TDQ-4884
Please tell me whether it is your case.
One Star

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

Hi All
This bug has been fixed under TOS for DQ 5.0.3, 5.1.1.
Anyone who encounters this issue might update it.
Regards,
Pedro