• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Cannot retrieve schema from MSSQL 2008

#1 2010-08-18 23:59:09

anand14
Member
Registered: 2010-08-18
Posts: 27

Cannot retrieve schema from MSSQL 2008

Tags: [mssql]

Hi,
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

Thanks,

Offline

#2 2010-08-24 19:18:25

anand14
Member
Registered: 2010-08-18
Posts: 27

Re: Cannot retrieve schema from MSSQL 2008

Anybody ??

Offline

#3 2010-09-07 02:29:27

anand14
Member
Registered: 2010-08-18
Posts: 27

Re: Cannot retrieve schema from MSSQL 2008

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!

Offline

#4 2012-05-04 16:19:25

nicolasdiogo
Member
Company: BrainPowered - BI Services UK
Registered: 2006-11-24
Posts: 380
Website

Re: Cannot retrieve schema from MSSQL 2008

what version of Talend are you using?

have also checked that using old fashioned user/pass details instead of SSO?

thanks,

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Cannot retrieve schema from MSSQL 2008

Board footer

Powered by FluxBB