I use Custom data source OData2 to connect to Sharepoint. From this Custom Data source, I defined many Base Views. Each Base View represents one Sharepoint List (i.e., Entity Collection). The username and password is stored in each Base View. So if I have 10 Sharepoint List I want to include in my Denodo database, I'd have 1 Custom Data Source (OData2) with 10 Base Views and in each Base View the username and password to connect to the Sharepoint List is defined.
The issue is that I have to make a change to the username and password. While going into 10 base views to change the username and password isn't too time consuming, it becomes extremely inefficient when multiple environments need to have the changes made. And, when there are more than 10, it gets even worst.
When I look at the VQL for the Base View it has the following format:
CREATE WRAPPER CUSTOM bvsharepointlist1
FOLDER = ...
DATASOURCENAME = ...
PARAMETERS ( ...
...
'User' = ...
'Password' = ...
...
)
...
Is it possible to use VQL similar to above to only change the username and password on a base view WITHOUT first dropping the base view? For example something like this?
For Base View 1, change username and password to new one.
For Base View 2, change username and password to new one.
. . . . .
For Base View n, change username and password to new one.
Notice no drop if exist statements above.
If it is possible, what does should be the exact VQL?
