Configure an Internal Function Datasource
When you select to create a Data Source type of Internal Function you will see the following dialog:
Click on the Refresh button to return a list of existing functions in the PostgreSQL database. You may then select one from the list taking care to pick a function that does actually return a dataset. You may also specify a list of parameters.
Once you click OK you will be able to configure the General Data Share Connection Details.
Rules for configuring Internal functions for use in iShare Studio
When creating internal functions in any schema for use in iShare Studio, only functions with names prefixed
intfn_and comments beginning with "Reserved - Internal Function," will be available for selection from the Functions list in iShare Studio.You must also make sure you add the execute_isharedata grant as this is important - see below for details.
Comments on a function need to follow this example in order for the parameter information to be displayed correctly:
The following creates a fictitious function purely to show what is required.
Add a comment