Hi,
Currently, I would retrieve the metadata information of Virtual DataPort server with [REST API](https://community.denodo.com/docs/html/browse/latest/en/vdp/data_catalog/appendix/rest_api/rest_api). But, the functionality to configure data source in REST API is not available.
However, as a workaround to update the Database URI of a JDBC Microsoft SQL Server connection without using Web Design studio or any other graphical tool, I would use the **[JiSQL](https://community.denodo.com/kb/en/view/document/Testing%20JDBC%20connections)** - Java based command line utility. With this out-of-the-box tool, I can connect, execute queries and show results in the command-line.
To achieve in your use case, I would execute the following in command line, after downloading the JiSQL.
`java -classpath “lib/jisql-2.0.11.jar:lib/jopt-simple-3.2.jar:lib/javacsv.jar:lib/denodo-vdp-jdbcdriver.jar” com.xigole.util.sql.Jisql -user <username> -password <password> -driver com.denodo.vdp.jdbc.Driver -cstring jdbc:vdb://<host>:<port>/<database_name> -c “;” -query "alter datasource jdbc <datasource> databaseuri='jdbc:sqlserver://<host>:<port>;databaseName=<database>';"`
You can take a look at the [JDBC Data Sources](https://community.denodo.com/docs/html/browse/latest/en/vdp/vql/generating_wrappers_and_data_sources/creating_data_sources/jdbc_data_sources) section of Virtual DataPort VQL Guide for more information.
Hope this helps!
