Creating a new datasheet from an external RDBMS is a two step process
To upload a database schema to Docube, necessary Database configuration must be created with relevant database details. This can be done by clicking on the “Configuration” option from the upload window. Once the configuration is created all the schemas are shown in a panel on the left side of the screen. The configuration may be edited by clicking on the more option in the row that houses the configuration.
Upon clicking on the configuration, all the available schemas are shown on a panel on the left. The schema that the user wishes to upload to Docube will be choosen and will be previewed by clicking on it. Once previewed, click on the “Edit Query” button to edit the SQL query to select the columns the user wishes to include (* for all columns to be included) and the number of rows (eg: limit 10). Click on the play button to run the query, upon which then the data can be published.