Request for Datasource Information

Hi Denodo Team How can we pull list of Datasources in below format. Could you pls help me to provide complete query. Datasource Name | Database URI | Username Thanks
user
20-12-2017 07:02:31 -0500

1 Answer

Hi, You can use the stored procedure '[CATALOG_ELEMENTS](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/catalog_elements)' to get the list of data sources and use the DESC command in order to obtain the datasource information. You can refer the question on '[data source connection string information](https://community.denodo.com/answers/question/details?questionId=9060g0000004ElSAAU&title=data+source+connection+string+information)' for the steps to get datasource information. Hope this helps!
Denodo Team
21-12-2017 03:18:48 -0500
You must sign in to add an answer. If you do not have an account, you can register here