Feature Request: Export\Import Connections Descriptions

[AndrewKhitrin]

We need ability to export Database Connection Description in a transportable file and ability to import such file in other Database Connection Tree

[jerherder]

HEllo

you can export the connexions in copying the file .dbeaver-data-sources.xml in c:\users\username.dbeaver4\General

[juliardi]

+1 for this. Yes, we can export the entire connection by copying .dbeaver-data-sources.xml file. But, what if we only need to export a single connection?

[p91paul]

@AndrewKhitrin has interest for implementing this feature declined? I've seen other bug reports requesting the same (e.g #3440). In https://github.com/dbeaver/dbeaver/wiki/Admin-Manage-Connections#importing-connections-from-csvxml it is stated that you can import from csv/xml but not how you would do such an import.

[givanovexpe]

@AndrewKhitrin the Import fuctionality works for connections without any custom properties. What I mean is that the supported keys for the import wizard are:

name Connection name
url JDBC URL
host Database server host name
port Database server port
database Database/schema name
user User name
password User password

However the ImportConnectionInfo class at dbeaver/plugins/org.jkiss.dbeaver.ext.import_config/src/org/jkiss/dbeaver/ext/import_config/wizards/ImportConnectionInfo.java supports not only simple connection properties in the constructor but also properties and providerproperties. It will be very difficult to define an input schema for these in the csv import format, but trivial to define in xml (as it can mirror the dbeaver connection config format).

I would like to be able to define custom properties in my import xml file. An use case for this is import the configuration for connecting to redshift (using AD credentials). For instance:

<connection name="Postgre Import XML 1" host="remote-redshift-cluster" port="5439" database="sample" url="jdbc:postgresql:iam://remote-redshift-cluster:5439/sample" user="postgres" password="postgres" type="dev">
    <property name="idp_port" value="443"/>
    <property name="DbGroups" value="readonly"/>
    <property name="idp_host" value="sso-endpoint"/>
    <property name="plugin_name" value="com.amazon.redshift.plugin.AdfsCredentialsProvider"/>
    <property name="preferred_role" value="arn:aws:iam::123456789123:role/redshift"/>
</connection>

[dellagustin-sap]

@p91paul I did not test it yet, but I am assuming (and will eventually test) that it is File -> Import, Select Third Party Configuration then Custom, select the driver and then you will be shown a dialog window to select your CSV or XML file. That is for importing, I did not find a way to export them.

Here are some screenshots for you: