wso2datasourcewso2-data-services-serverdataservice

How to get data source information from WSO2 DSS?


Usually, we will use WSO2 DSS to config a data source and issue data service based specified data table. How would I get the related data source information about configured data source, including: data-source name, table names, and column names?


Solution

  • I am not sure if that's what you mean but I'll give it a go: In: wso2dss-installfolder\repository\deployment\server\dataservices\ You will find the data services you have configured as .dbs files, it's actually just an xml that contains all the information.

    EDIT: From Get all table names of a particular database by SQL query? I found that this MS SQL query will give you the names of all your tables in YOUR_DATABASE:

    select table_name from YOUR_DATABASE.INFORMATION_SCHEMA.TABLES where TABLE_TYPE = 'BASE TABLE'