Skip to content

Data Sources Admin

Zuar Portal's Data Sources page allows you to create new data sources. It also facilitates editing and removal of existing data sources.

Adding New Data Sources

Add a new data source to Portal by clicking the New Data Source button in the upper right corner of the Data Sources page.

  1. Enter a descriptive name in the Name field.
  2. Database Connection: leave this blank to access Portal's built-in database, otherwise enter the database connection string.
  3. Enter the SQL SELECT query to return the desired data from the database in the SQL field.
  4. Use the Test button to verify database access. If successful, the records returned by the SQL query will be displayed below the button.
  5. In the Column Types tab, indicate the Data Type of each column returned in the SQL query.
  6. Click Save.

Data Source Actions

Click the three dots (...) to the right of existing data sources to access the following actions:

  • Edit - Change the data source's properties (e.g. database name, port, username, password).
  • Delete - Remove the data source from the Portal.