topic Re: How to retrieve schema in dynamoDB connection? in Talend Studio

How to retrieve schema in dynamoDB connection?

Anonymous — Fri, 27 Jul 2018 13:31:48 GMT

Established DynamoDB connection from Talend BigData tool using General JDBC. Installed DynamoDB driver jar. Connection got established. But, unable to retrieve schema.

When trying to retrieve schema,no tables are displayed. Please help.

Thanks,

Sree Laxmi.CN

Re: How to retrieve schema in dynamoDB connection?

Anonymous — Mon, 30 Jul 2018 05:29:53 GMT

Hi sreelaxmich
To be honest, we have never test this, I think the General JDBC is not suitable for this kind of NoSQL database such as DynamoDB, Talend already has DynamoDB connectors, are you to read DynamoDB tables with tDynamoDBinput component?

Regards
Shong

Re: How to retrieve schema in dynamoDB connection?

Anonymous — Mon, 30 Jul 2018 05:37:14 GMT

Hi Shong,

Thanks for your response.

Yes.I need to read DynamoDB tables.

When tried to get DB connections from Metadata -> DB connections , we don't have an option there to select "DynamoDB" in DB type. So tried with a solution of General JDBC option and drivers. How so ever, my requirement is to read tables fro dynamoDB.

Regards,

Sree Laxmi.C.N

Re: How to retrieve schema in dynamoDB connection?

Anonymous — Mon, 30 Jul 2018 09:08:04 GMT

This should be a new feature, add DynamoDB to the DB type list under NoSql Connections. For now, try to use the tDynamoDBInput to read tables from DynamoDB and let me know if you meet any issues.

Re: How to retrieve schema in dynamoDB connection?

Anonymous — Thu, 02 Aug 2018 05:22:35 GMT

Hi shong,

Thanks for your reply. Tried as you suggested. Now am able to connect to dynamoDB, read and write the data.

I required to retrieve data based on key and attributes from dynamoDB. triyind with scan and query. Can you please suggest .

Regards,

Sree Laxmi.CN