webMethods connecting with Redshift database

[fernando3 (fernando *)]

Hi all,
I would like to connect the IS v10.7 with the Redshift database.
Anyone know what are should be the driver, source class, Network protocol and Other properties values should I use?

Thanks,
Fernando Martins

[Holger_von_Thomsen]

Hi Fernando,

JDBC Driver can be downloaded from here:

Download the Amazon Redshift JDBC driver, version 2.1 - Amazon Redshift

If you plan to use WmJDBCAdapter, check if this driver supports DataSource class implementation, otherwise you will have to use the WmDB package.

See also:

Registering the driver class - Amazon Redshift

Getting the JDBC URL - Amazon Redshift (plus following chapter).

As long as Redshift is not mentiioned in the webMethods Adapters SystemRequirements Guide it is not officially supported by the JDBC Adapter.
It might work, but it is not sure.

Regards,
Holger

[fernando3 (fernando *)]

Hi Holger,
Thabns for your reply… I will try and let you know…
Did you already try config a JDBC connection with Redshift? If yes, can you send me a screenshot of this configuration?

Thanks,
Fernando Martins

[sandeepl (sandeep)]

Hi Fernando,

If you have plans to use the Connector and CloudStreams have been installed in your IS, you can try with Connector available from the below link.

Amazon Redshift

[SAG_Icon_webMethods_100x100px_Dec20_V2] webMethods CloudStreams Provider for Amazon Redshift integrates webMethods CloudStreams with Amazon Web Services (AWS). Amazon Redshift is a cloud based data-warehouse solution that makes it simple and cost-effective to analyse data using existing business intelligence tools. Product information Download files Documentation Developer webMethods CloudStreams Provider for Amazon Redshift 9.6 Amazon Redshift API supported version: 2013-12-02 Down…

Regards,
Sandeep

[Holger_von_Thomsen]

Hi Fernando,

no, I dont have tried connections to a Redshift database.

I was just doing some Google Research on it and stumbled over the mentioned links.

Regards,
Holger

[fernando3 (fernando *)]

@Amazon Redshift

[SAG_Icon_webMethods_100x100px_Dec20_V2] webMethods CloudStreams Provider for Amazon Redshift integrates webMethods CloudStreams with Amazon Web Services (AWS). Amazon Redshift is a cloud based data-warehouse solution that makes it simple and cost-effective to analyse data using existing business intelligence tools. Product information Download files Documentation Developer webMethods CloudStreams Provider for Amazon Redshift 9.6 Amazon Redshift API supported version: 2013-12-02

Thank you! I will try as well.

[fernando3 (fernando *)]

Hi Holger,
Thanks for your reply.

[rmg]

Hi Fernando,I think the best bet would be using via WmCloudStreams OOB connector to AWS RDS.(ETL) But still unsure if standalone WmJDBCAdapter supports it or not. give it a try though and post here updates.

HTH,
RMG