Define tables from data source

Once your data source is connected to Studio, you can select components or tables from the data source that you want to use. The following options are available:

  • Add Table: If know the table name that you want to add, you can manually enter the table name and click OK.

  • Get Tables: Click the Get Tables button to request a list of tables available for the data source. You can select the required tables or select the Check all option, and then click Add Tables. Including all tables in the database is the preferred method unless the number of tables is very large, or if security on the database prevents your user credentials from querying to get the full list of tables.

  • Remove Tables: To remove the added tables from the Data database, select the tables from the list, or select the Check all option, and then click the Remove Tables button.

On the Actions toolbar, be sure to save the updated data source.