# Create a database table data source for reporting only

Your database must be up and running in order for you to complete these steps:

1. Log in to the **User Console.**
2. Click **Create New**, then choose **Data Source** from the menu.
3. Click **New Data Source**.

   The **Data Source Wizard** appears.
4. Enter a name that identifies your new data source in the **Data Source Name** field.

   The following characters are not allowed in **Data Source** names:

   ```
   %/:[]*|\t\r\n
   ```

   ![Table Data Source Reporting Only](https://591371677-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFgwF7oC7Y6b7XWdahykf%2Fuploads%2Fgit-blob-42026cca7cfe86079134e9abde4f24e18832e2bd%2FPUC_Table_Data_Source_Reporting_Only.png?alt=media)
5. Select **Database Table(s)** from the **Source Type** drop-down menu. Under **Connection**, click to choose a database connection.
6. Click to select the **Reporting Only** radio button. Click **Next**.
7. Choose a schema from the **Schema**drop-down menu.

   A list of **Available Tables**appears.

   ![Table Data Source Reporting Only Available Tables](https://591371677-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFgwF7oC7Y6b7XWdahykf%2Fuploads%2Fgit-blob-0c0965fd9e54818e6ac7ce0f046b131effd24627%2FPUC_Table_Data_Source_Reporting_Only_Available_Tables.png?alt=media)
8. Choose a table from **Available Tables** and click the Right Arrow to move the table into the **Selected Tables** field.

   If you add a table you decide not to use, highlight the table and click the Left Arrow to remove it from the list of **Selected Tables**. To choose multiple tables, press the CTRL key down as you make your selections.
9. Click **Next**.

   The **Define Joins** window appears. While you can create a data source from a single table, the more common scenario is that you will choose multiple tables which must then be joined.

   ![Table Data Source Reporting Only Define Joins](https://591371677-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFgwF7oC7Y6b7XWdahykf%2Fuploads%2Fgit-blob-e1e4c42e1342f16006e68f9343cff67248931765%2FPUC_Table_Data_Source_Reporting_Only_Define_Joins.png?alt=media)
10. Choose the fact table from the **Left Table** drop-down menu, then choose a table to join to it from the **Right Table** drop-down menu. Click **Create Join**to define the inner join between each table.
11. Create join conditions for each entry in the **Left Table** and **Right Table** drop-down menus.

    The join relationship for each table is based on the field selected and is displayed in the lower portion of the dialog box. To delete a join, select the join and click **Delete Join**.
12. Click **Finish**. The **Data Source Created** window appears.

    You can choose to **Keep default model**or click **Customize model now** to launch the Data Source Model Editor and refine the model. Click **OK**.

    ![Table Data Source Reporting Only Data Source Created](https://591371677-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFgwF7oC7Y6b7XWdahykf%2Fuploads%2Fgit-blob-20e5098187b129a28916da09d95801ce592fc2cc%2FPUC_Table_Data_Source_Reporting_Only_Data_Source_Created.png?alt=media)