Add support for Amazon DocumentDb

[akshaysasidrn]

Is your proposal related to a problem?

ToolJet cannot connect to Amazon DocumentDb. Even though DocumentDb is compatible with MongoDB client, we don't currently support the auth mechanism required to connect to it.

Describe the solution you'd like

We need to add explicit integration with DocumentDb using the official client as a part of our plugin catalogue.
https://www.npmjs.com/package/@aws-sdk/client-docdb

You can follow the steps here, for creating a plugin.

[Just-A-Pixel]

Hello! Can I try this issue?

[harshbsharma]

Please assign

[FurquanAnwer]

Please assign this issue to me !

[akshaysasidrn]

@Just-A-Pixel would you pick this up? Will assign.

[Just-A-Pixel]

@akshaysasidrn yes I'd like to pickup this issue

[akshaysasidrn]

Have assigned. Happy coding!

[Just-A-Pixel]

Hi @akshaysasidrn!
Apologies for the delay, some unavoidable circumstances led me to start late!

I looked into the problem and these are the concerns that I have:

1. Should we be making an entirely new plugin to support documentDB? The functionality should be the same as Mongodb, so why are we not enhancing the existing Mongodb manifest.json to support it, instead?
2. For all AWS-related plugins, I was wondering if having a common manifest (or similar) that handles aws auth would provide a better user and developer experience.

[609harsh]

Hi @akshaysasidrn please assign this issue to me

[2001asjad]

Hey @Just-A-Pixel , are you still working on this issue? Do let us know if you're not going forward with it.

[2001asjad]

Hello @609harsh, let us know if you would want to go forward working on the issue.

[Abhinav-CHD]

Hi, is this still up for grabs? If yes, then please assign it to me.

[2001asjad]

Sure, @Abhinav-CHD, since there have been no updates from the previous contributors, I am assigning this issue to you. Thanks for contributing to ToolJet.

[Abhinav-CHD]

@2001asjad while going through the docs there is no mention of the Amazon DocumentDb, do I need to create a page in data-sources as well explaining how to use it?

[2001asjad]

Hi @Abhinav-CHD, let me confirm with the team once, and I'll tell you. Thanks for your patience.

[2001asjad]

Hey @Abhinav-CHD, we only need to create the plugin for this issue.

[Abhinav-CHD]

Hi @2001asjad, do I need to integrate DocumentDb using TLS and if so, how do I access the global-bundle.pem file?

[2001asjad]

Let me loop-in @akshaysasidrn , to confirm this.

[2001asjad]

Hi @Abhinav-CHD , will you be able to go forward with the issue?

[Abhinav-CHD]

Hi @2001asjad, yesterday I got confirmation from Akshay on Slack on using a different approach, will raise PR by today hopefully.

[Abhinav-CHD]

Hi @2001asjad, this has almost been implemented just testing locally from my end, will push the code by the weekend