One Star

Retrieving shema issue

Hello,
I have connected an sql server to talend successfuly via odbc driver, but an error occured while retriving schema, its said "connection failure, check databas settings ...."
Best regards,
Khaled.
4 REPLIES
Moderator

Re: Retrieving shema issue

Hi,
First of all, did you checked your local ODBC setting in Windows it self. The ODBC bridge (that is what you actually use) depends on this.
Secondly, make sure Sql Server DB in a good condition. Could you please take a testing on your other DB(MySql, Oracle .etc) to see if this issue repro?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving shema issue

Hi,
Can any one help me with this!
Iam new to talend, I want to load data from mongodb source. In basic settings I have option of edit schema, how to specify schema for nested document in mongodb??
Best Regards
Moderator

Re: Retrieving shema issue

Hi,
Please see the component reference tMongoDBInput and the related scenarios.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Retrieving shema issue

Hi Sabrina,
Thanks for your help.
Sorry to bother you again!! can you help me with this:
i have following document:
{"hashtags" :
}

I want to fetch 106 in my result.
Iam witing parent node as : "hashtags.0.indices.0"
but iam not sure what to write for columns?
Please help..

Best Regards
Snigdha