> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/data-center-1/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/data-center-1/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

This page displays step-by-step process on how to create 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 %}

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FnpMbhSqJZDTbqzwFx4Fp%2FFile%20Data%20store%20creation.gif?alt=media&#x26;token=c87d63a6-e869-40f4-9bd1-1886d769b252" alt=""><figcaption></figcaption></figure>

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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FDVppB5Ynkw4MWej0jwqd%2Fimage.png?alt=media&#x26;token=1488caad-226e-4588-93a6-ad501ac2cef9" alt=""><figcaption><p>Accessing the Data Store option under the New context menu</p></figcaption></figure>

* 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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FsiahJylkINjmFY4jZ4S5%2Fimage.png?alt=media&#x26;token=cb8caafc-3599-4b47-b9a6-e1b3300e599f" alt=""><figcaption><p>Accessing the <em><strong>Create Data Store</strong></em> option</p></figcaption></figure>

* The ***Getting Data*** tab option opens to create a new Data Store based on a Flat File Data Connector.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F0xfsTvDI11TZL7HhpCGV%2Fimage.png?alt=media&#x26;token=8772a7bf-ffb5-49ed-a5ae-7179380c48bf" alt=""><figcaption></figcaption></figure>

## **Getting Data** <a href="#getting-data" id="getting-data"></a>

* 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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FlSWN8hqHYTeb5xVFgz8Q%2Fimage.png?alt=media&#x26;token=757f03f5-5cc7-4942-9904-73b2d92ddd17" alt=""><figcaption><p>Configuring the <em><strong>Getting Data</strong></em> tab</p></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> The user can choose an Excel or CSV file as a file data connector.*
{% endhint %}

## **Data Type Definition** <a href="#data-type-definition" id="data-type-definition"></a>

* 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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FRUAHHztkzAbcTNr0UusZ%2Fimage.png?alt=media&#x26;token=e50cd9d9-6522-4111-af5d-63ff3af151c7" alt=""><figcaption><p>Configuring the <em><strong>Data Type Definition</strong></em> tab</p></figcaption></figure>

## **Hierarchy Definition** <a href="#hierarchy-definition" id="hierarchy-definition"></a>

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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FCNv9DkFxKAgyLyuAtHVp%2Fimage.png?alt=media&#x26;token=7c8ef642-0413-4827-b0cd-b271164d9fce" alt=""><figcaption><p>Configuring the <em><strong>Hierarchy Definition</strong></em> tab</p></figcaption></figure>

## **Data Restrictions** <a href="#data-restrictions" id="data-restrictions"></a>

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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2F0IE0Eneq4erQ80dnK13A%2Fimage.png?alt=media&#x26;token=2e586eb2-b2ee-4b67-921c-22444d287b99" alt=""><figcaption><p>The <em><strong>Data Restriction</strong></em> tab</p></figcaption></figure>

* 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.

<figure><img src="https://859511478-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FGDmsjfjJBNqow7Fo97cO%2Fuploads%2FSqhyjaH9V9NqawUmgqMz%2Fimage.png?alt=media&#x26;token=8a3fcef2-943e-48f0-b54e-35603439fe7f" alt=""><figcaption><p>The File Data Store gets added to the Data Stores list</p></figcaption></figure>