# 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](/files/bQlUjCbtQTZvqUIbJ3zi)
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](/files/xqNGUz1jB2g4bejRaM9d)
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](/files/JQTcG5TdjazTk7CitXMk)
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](/files/GGnyQfhNXKAuOBKnVnN3)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.pentaho.com/pba/data-source-wizard-cp-overview/choose-a-data-source-type/create-a-database-table-source/create-a-database-table-data-source-for-reporting-only.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.