DB Configuration

Support questions related to CloverETL Server

sameerj365
Posts: 17
Joined: Tue Mar 25, 2014 8:39 am

DB Configuration

Postby sameerj365 » Tue Jun 17, 2014 3:00 am

I am trying to configure the DB connection which can be used from the ETL server. The help file shows that the encrypted credentials can be stored in the clover.properties file and parameter can be used in the connection. It doesnt work :( Do I need to enclose the parameter in quotes ?

sameerj365
Posts: 17
Joined: Tue Mar 25, 2014 8:39 am

Re: DB Configuration

Postby sameerj365 » Wed Jun 18, 2014 1:31 pm

Appreciate any help

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: DB Configuration

Postby slechtaj » Thu Jun 19, 2014 2:12 pm

Hi Sameerj365,

from your post, I am not sure what does not work. Could you please describe the issue more closely? It would also be very helpful to know what you have done. In order to set secure parameters, you need to work with Server sandbox (since secure parameters are designed for Server projects only) and have master password set. The master password can be set in Server GUI under Configuration / Secure Parameters. When the master password is set, you should be able to set the secure parameter (see the encrypted password).
SecureParameters.png
New Secure Parameter
SecureParameters.png (16.37 KiB) Viewed 2310 times

Now when we have configured the secure parameter we can select it in DB Connection dialog in Password attribute's drop-down menu:
DBConenctionDialog.png
Secure Parameter in Database connection dialog
DBConenctionDialog.png (23.47 KiB) Viewed 2310 times
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support

sameerj365
Posts: 17
Joined: Tue Mar 25, 2014 8:39 am

Re: DB Configuration

Postby sameerj365 » Thu Jun 19, 2014 4:31 pm

Thnk You.. I generated the encrypted password using secure cfg jar and defined it in clover.properties.
I have few questions:

(a) instead of defining at graph level if i keep it in config file then why the parameter substitution doesnt work while defining the new db connection?

(b) is there a way to hide it so that it is not even visible in the server console.

Regards

slechtaj
Posts: 192
Joined: Wed Aug 15, 2012 8:18 am

Re: DB Configuration

Postby slechtaj » Tue Jun 24, 2014 1:52 pm

Hi,

now I think I understand the question. The password created this way cannot be used for this purpose (please refer to our documentation - it is only used to "encrypt values persisted in the database table secure_param_passwd"). However, I have created a new ticket for this improvement: https://bug.javlin.eu/browse/CLO-4067

What you might take into consideration is using appropriate user/group settings. You can disable Secure params admin permission for a group. This way you can expose the master password to authorized users only.

For more information about user/group settings, please see our documentation.
For user settings: http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/users.html
For group settings: http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.server.docs/docs/groups.html

Hope this helps.
Jan Slechta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

How to speed up communication with CloverCARE support

sameerj365
Posts: 17
Joined: Tue Mar 25, 2014 8:39 am

Re: DB Configuration

Postby sameerj365 » Mon Jul 14, 2014 10:59 am

slechtaj wrote:Hi,

I have created a new ticket for this improvement: https://bug.javlin.eu/browse/CLO-4067


Please let me know if there is any update on the ticket which you have raised.

imriskal
Posts: 383
Joined: Wed Aug 15, 2012 8:18 am

Re: DB Configuration

Postby imriskal » Tue Jul 15, 2014 9:28 am

Hi,

We are very sorry but we unfortunately do not have capacity for such notification of individual users. Our bug tracker does not support change notifications for unregistered users.

However, you can very easily use an external service like https://www.changedetection.com/ for watching this URL: https://bug.javlin.eu/browse/CLO-4067

Thank you for your understanding.

Regards,
---
Lubos Imriska
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support

danny_dang
Posts: 1
Joined: Tue Oct 20, 2015 1:30 am

Re: DB Configuration

Postby danny_dang » Tue Oct 20, 2015 1:36 am

I am now trying to create a connection to my Local DB from the Clover Server. However, I always received this message: "Can't connect to DB: Network error IOException: Connection refused: connect"

Please help
Attachments
Capture.GIF
Capture.GIF (134.68 KiB) Viewed 1713 times

cholastal
Posts: 107
Joined: Tue Sep 01, 2015 1:22 pm

Re: DB Configuration

Postby cholastal » Wed Oct 21, 2015 12:37 pm

Hi Danny

I would like to know if the Database server is on the same machine as the Clover Server or if it's on the same machine as the Designer. I assume you want set up a connection which can be used in graphs for data output. In case you want to set up an external system DB for your Clover Server, please let me know.

Thank you.
Best regards
---
Lukas Cholasta
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com
How to speed up communication with CloverCARE support


cron