Currently the pivot table supports to connect OLAP database from remote server alone with dpump *.dll. So, need to provide a provision to connect the OLAP database from local machine.
It will be connected by providing following information.
- SQL server name
- Catalog name
- Locale identifier (if required)
- Authentication (if required)
To connect local database, need to create a API service where the above information should be provided. So, the above information won't be shown in browser. Also, the API service will be supported to connect OLAP database from remote server with dpump *.dll.