Talend 6.0 Retrieve Schema

[Anonymous]

Hello,

I am facing issue while  clicking on Retrieve schema from metadata option using access DB in Talend 6.0

New views which are created in access database are not showing in Retrieve Schema therefore its difficult to add those views in Talend Job.

Please look into this issue.

Thanks & Regards

Sanjoy

[Anonymous]

Hello Richard,

I have checked all the views and find out that in one of the view we used iif syntax in access database for which we are not able to retrieve view in Talend. Suppose we have view query in which we used iif statement like select iif ([Qty] > 10, "large", "small") as qty from R_View so when trying to retrieve schema R_view is not appear in retrieve schema list, but If I changed the query and remove iif statement like this select QTY from R_View then it appear in retrieve schema list. so could you suggest why Talend is not taking this kind of if statement expression that used in access database in
view query.

Looking forward to your response.

Thanks & Regards
Sanjoy

[Anonymous]

I do not know why this would not be supported. I'm afraid I do not use Access. Have you tried creating a "wrapper" view for the one with the iif statement? So, take your R_View_IIF view (the view using the IIF) and create a view using this code...

SELECT *
FROM R_View_IIF

The other thing to try is to simply manually create the schema and try to use it. I suspect that this will work.