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

User136828
User136828 New Altair Community Member
edited November 5 in Community Q&A
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?
Tagged:

Answers

  • BalazsBaranyRM
    BalazsBaranyRM New Altair Community Member
    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
    Marco_Boeck New Altair Community Member
    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
    sgenzer
    Altair Employee
    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 :wink: ]

    Scott

Categories