You can translate the question and the replies:

External metadata database (postgresql)

On data platform for VDP in design studio we can mention the schema name specifically. regenerateMetadata --adapter <adapter-name> --version <adapter-version> --driver <driver-classname> [--driverProperties <driver-properties>] --classPath <driver-classpath> [--externalDriver <path-to-external-driver>] --databaseUri <uri> --user <user> --password <password> [--useKerberos] [--useKeyTab] [--keyTabFile <path-to-keytab-file>] [--useKrbCache] [--krbCacheFile <path-to-krb-cache-file>] [--catalog <catalog>] **[--schema <schema>]** [--initialSize <pool-initial-size>] [--maxActive <pool-max-active>] [--testConnections] [--pingQuery <pool-validation-query>] [--reset] [--yes] There is no option to mention for Solution Manager, Scheduler and Data Catalog, is there a possible way we can mention different schema other than default schema (public in case of poatgresql). Please let me know and is there any future update on this
Solution Manager External Metadata DB VDP Scheduler Data catalog external metadata DB
user
20-07-2023 11:23:27 -0400
code

3 Answers

Hi, I’ve found a similar question linked [here](https://community.denodo.com/answers/question/details?questionId=906Du00000000YAIAY&Solution+Manager+Setting-Up+an+External+Database). For storing the metadata of the solution manager in an external database through Solution Manager GUI, you can follow the steps mentioned in the [Setting-Up an External Database](https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/configuration/database_configuration/database_configuration) of the Solution Manager Administration Guide. Hope this helps!
Denodo Team
21-07-2023 07:43:49 -0400
code
There is no option to mention for **Scheduler and Data Catalog**, is there a possible way we can mention **different schema other than default schema (public in case of poatgresql).** Please let me know and is there any future update on this
user
21-07-2023 09:19:23 -0400
Hi, To set up an external database in Denodo Scheduler check the section [How To Configure The External Metadata Database](https://community.denodo.com/docs/html/browse/8.0/en/scheduler/administration/administration/server_configuration/server_setup#how-to-configure-the-external-metadata-database) and to do it in Denodo Data Catalog check the section [Use an External Database for the Data Catalog](https://community.denodo.com/docs/html/browse/8.0/en/vdp/data_catalog/administration/servers_configuration/servers_configuration#use-an-external-database-for-the-data-catalog). If you are a Denodo customer, for future updates check or request enhancements in [the Denodo Support Site](https://support.denodo.com/). Hope this helps!
Denodo Team
31-07-2023 05:07:29 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here