Is it possible to export database connections from a server and import to a different server?

We recently set up a new RapidMiner server and I would like to copy the database connections from an existing server to the new server. Is there a way to easily do this?

Find more posts tagged with

AI Studio

Server

Databases

Accepted answers

All comments

BalazsBaranyRM

Hi!

There is no supported or easy way to do this.
However, the connections are stored in a database table in the Server's backend database. You could try to export the contents of just this table and import it on the new server. But it's a good idea to be careful and do it step by step, one by one first.
The encryption of access credentials might be different on the new server, so it might be necessary to re-enter them.

Regards,
Balázs

Marco_Boeck

Hi,

Currently, there is indeed no easy way. However, with the new connection management coming in 9.3, this will be alot easier for future connections as you can then copy them over from one Server repository to the other.

Regards,
Marco

sgenzer

haha I was just about to write the same thing as @Marco_Boeck....stay tuned for HUGE improvements in connection mgmt in RapidMiner 9.3.

[For veteran users like myself with connection chaos on my machine going back versions and versions, this solves a huge pain point. PM me if you want a sneak preview

]

Scott