You are not logged in.
First of, I have searched the forums and got varied responses for the issue outlined above. I am still experiencing a problem retrieving a schema from the MS SQL Server Database
1) The Metadata connection checks out properly (even with Single Sign On). We are able to connect to the Database
2) A table called "PO" (no quotes) was created manually on SQL Server
3) There is data present in the "PO" table
4) However, when we try and retrieve the Schema under Talend's MetaData -> DbConnections --> Retrieve Schema, we experience the following:
It does not return the columns of the table as a schema. Instead it returns an empty schema.
Any pointers, suggestions will be appreciated.
We are using Talend Open Studio Version 4.0.2.r43696 on Windows 2008 Server 64-bit. The Java version is 32 bit. The JRE is 1.6.0_21-b07
Wonder if anyone else has run into my problem with retrieving schema from a MS SQL Server Database. I think SSO (Single Sign On) is the main problem here but was reaching out to the forum if anyone else has run into this issue.
If this continues to be a problem with Talend, there is no other option but to rebuilt the tables in the Talend --> Metadata section manually.
Any input on this will be appreciated.
Thanks in advance!