Create a New Data Source in Portal | Scribe

Create a New Data Source in Portal

  • Patrick McGrory |
  • 0 step |
  • 46 seconds
  • ZuarZuar
  • CalendlyCalendly
  • ZuarbaseZuarbase
# 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`
Click "Data Sources" in the edit menu to view and add new Data Sources to your Portal
Click "NEW DATA SOURCE"
Enter the "Name" of the Data Source
Apply any Tags
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
Write your SQL query and click test
If your Query was successful it will display the results below in a table
"COLUMN TYPES" allows you to define the SDL of each column so that the data is interpreted correctly,
An example of Column Types
When you are done creating your new Data Source Click "SAVE"
Want to make guides like this in seconds? Yes, it's really that fast.
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe