> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/bdb-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/bdb-documentation/data-center/data-stores/creating-a-new-data-store/data-store-using-a-flat-file-data-connector.md).
# Data Store using a Flat File Data Connector
{% hint style="success" %}
*Look at the given walk-through on how to create a Flat File connector based Data Store.*
{% endhint %}
This section describes steps to create a Data Store using a Flat File.
* Navigate to the Data Center homepage.
* Click the ***New*** option.
* Select the ***Data Store*** option from the context menu.
* The Data Connectors page opens.
* Select a Connector Type from the ***Data Source*** filter (E.g., A file data source is selected in the following image).
* Select a data connector from the Data Connector list.
* Click on the ***Create Data Store*** option.
* The ***Getting Data*** tab option opens to create a new Data Store based on a Flat File Data Connector.
### **Getting Data**
* Enter a name for the Data Store.
* The *pre-selected* ***Data Connector Name*** gets displayed.
* Click the ***Choose File*** option to browse a file from the system.
* Select a sheet using the ***Sheet List*** drop-down menu.
* Select an option to display ***Sheet Layout*** using the drop-down menu out of Column Headers or Row Headers.
* Click the ***Next*** option to proceed.
{% hint style="info" %} Please Note: *The user can choose an Excel or CSV file as a file data connector.*
{% endhint %}
### **Data Type Definition**
* Navigate to the ***Data Type Definition*** tab.
* Define the required Dimensions, Measures, and Time by interchanging the categories.
* Enable the Dimensions by using a checkmark to avail LOV lookup in the filter panel of the Self-service BI Report.
* Click the ***Next*** option to proceed.
### **Hierarchy Definition**
Define hierarchy using multiple dimensions or dropping the selecting time fields in the Drill Definition box.
* Navigate to the ***Hierarchy Definition*** tab.
* Click the ***Add*** option provided in the Hierarchy Definition window.
* A new ***Drill Def*** box gets added to the screen.
* Drag and drop the dimensions or time options to define a hierarchy.
* Proceed to the next tab by clicking the ***Next*** option.
### **Data Restrictions**
The Administrator can restrict access to data for a specific user by configuring the User Property via the ***Data Restrictions*** tab.
**E.g.,** If for a user/user group ***Country*** custom field value is ***USA*** and the administrator passes ***Country*** as a User Property while creating a data store. Users for whom ***USA*** was selected as a value for the ***Country*** custom field can access data related only to the USA from the data store.
* Navigate to the
* Click the ***Add*** icon to add a new box for inserting the data restriction parameter.
* Select a dimension using the drop-down menu.
* Enter the user/group-specific custom field to restrict the data.
* Click the ***Finish*** option.
* A success message appears to confirm the data store configuration.
* The ***Data Stores*** list opens.
* The newly created Data Store gets added at the top of the ***Data Stores*** list.
###
###