Data sources are definitions to your backend data. Configure them once and use them in every web page you want. Data sources make it easy to display live data from other backend sources at the position in your web page you prefer.
At the moment we support Domino backend sources, but soon this will be extended with other backends (i.e. MS SQL, DB2, Oracle, MySQL) that will work very similar.
To create a data source :
- Navigate in the section Site content to the sub section Data sources.
- Click on the view action New.
- Fill in an title.
- Fill in the domino server that stores the database.
(i.e.: CN=islnpr05/OU=servers/O=infosphere)
- Fill in the path and filename of the database.
(i.e.: Shazzoo/CRM.nsf)
- Fill in the query.
(i.e. SELECT Form = "frmOrders" & ArticleCategory = "office")
- Fill in the source attribute names.
(i.e. product, amount, customer, date)
- Fill in the destination labels.
(i.e. Product, Amount, Customer, Order date)
- Click on the form action Save - Save and close.
- You see the new data source in the view.
For an overview of all properties and form actions related to a data source, click here.
For an overview of all columns and view actions of the data sources view, click here.
Out-of-the-box Shazzoo offers you the list component to display backend data of a data source. However, based on your wishes and requirements we can fully customize Shazzoo and create customized components to display backend data.
To use data source for display of backend data:
- Open the page you want to display backend data.
- Focus your cursor on the position where you want to include the data.
- Right click your mouse and click Insert list from the context menu.
- Select Data source at the property Type.
- Click on the button Select at the property Data source.
- Select the applicable data source from the picklist and click Ok.
- Select the fields you want to include in the list.
- Select the field you want to sort on.
- Select the sort order.
- Click Ok.
- Now you see the live backend data displayed in your web page.