Create a New Data Source in Portal | Scribe

    Create a New Data Source in Portal

    • Patrick McGrory |
    • 11 steps |
    • 46 seconds
    1
    # Data Sources Overview To give Portal access to data in Portal's internal database or external database, create a Data Source. Data Sources are used for many advanced use cases in Portal. Some examples include: custom filter values, dynamically displaying Portal objects based on logged in user, Data Table blocks. Data Sources must include the following: - Name - Database Connection - SQL Query SQL queries are often written to include all data from a table. For example: `SELECT * FROM table`
    2
    Click "Data Sources" in the edit menu to view and add new Data Sources to your Portal
    3
    Click "NEW DATA SOURCE"
    4
    Enter the "Name" of the Data Source
    5
    Apply any Tags
    6
    Click the "Enter a connection string for your database or leave blank for default" field. This typically includes the URL of the database along with Credentials and parameters
    7
    Write your SQL query and click test
    8
    If your Query was successful it will display the results below in a table
    9
    "COLUMN TYPES" allows you to define the SDL of each column so that the data is interpreted correctly,
    10
    An example of Column Types
    11
    When you are done creating your new Data Source Click "SAVE"