> For the complete documentation index, see [llms.txt](https://docs.pentaho.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pentaho.com/pba/10.2-analytics/data-source-wizard-cp-overview/choose-a-data-source-type/create-a-database-table-source.md).

# Create a database table source

When you create a **Database Table** data source, you are presented with two options: **Reporting Only** or **Reporting and Analysis**. The choice you make depends on the structure of the database tables you are accessing and the User Console tools being used.

Before you begin working with **Database Table** data sources, there are a few key terms that you should know.

* **Fact table**

  Records measurements or metrics for a specific event, and usually consists of numbers.
* **Star schema**

  Has one or more fact tables that reference any number of dimension tables. Star schemas are good for simpler queries.
* **Snowflake schema**

  Has centralized fact tables that are connected to multiple dimensions. Snowflake schemas are good for more complex queries.

| Explore Considerations | Choose Options                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Reporting Only         | Reporting and Analysis                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| Summary                | <p>Choose the <strong>Reporting Only</strong>option if you are accessing data in a relational database that is operational or transactional in nature, or if you need to show detailed rows and then sort and filter the details.When you choose the <strong>Reporting Only</strong> option, a relational model is automatically generated and can be refined in the Data Source Model Editor or further extended using <strong>Pentaho Metadata Editor</strong>.</p><p>Relational models on large databases are sometimes slow and benefit from a powerful database.</p> | <p>Choose the <strong>Reporting and Analysis</strong> option if you are accessing a multidimensional database that contains tables arranged in a star schema (tables are separated into dimensions related to a single fact table, such as a data warehouse), or if you need summaries and details.</p><p>When you choose the <strong>Reporting and Analysis</strong> option, a multidimensional model is automatically generated and can be refined in the Data Source Model Editor or further extended using <strong>Pentaho Schema Workbench</strong>.</p><p>Additionally, you can create a <strong>Reporting and Analysis</strong> data source using a single table where the table acts as the single fact table and also contains dimensional data.</p> |
| Expertise              | Knowledge of relational database structures.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              | Knowledge of multidimensional database structures.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            |
| Time                   | Approximately 15 minutes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 | Approximately 30 minutes.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
| Recommendation         | Select this if you want to use for Report Designer, Interactive Reports, and Metadata Editor.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | Select this if you want to use for Report Designer, Analyzer (PUC), Dashboard Designer, Schema Workbench, and Aggregation Designer.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

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

Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters:

```
GET https://docs.pentaho.com/pba/10.2-analytics/data-source-wizard-cp-overview/choose-a-data-source-type/create-a-database-table-source.md?ask=<question>&goal=<user_goal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case.

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.
