How to access Data Virtualization published ODATA URL from Microsoft Excel using basic authentication?
Article ID: KB0137685
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
Follow below steps :
(1) For the DV published ODATA URL that needs to be accessed, make sure the 'Basic' checkbox is selected and copy the Service URL (double click on the Service URL to copy it):
In this example, the Service URL is : http://muepvdipd1439.corp.cloud.com:9900/odata/test/
If you see an error in the Unsupported stating 'No primary key defined. Please defined a primary key to access this view via OData', make sure a primary key is defined for the underlying resource. Here are the steps to define a primary key.
(2) Open Excel. Select 'Data' tab > 'Get Data' > 'From Other Sources' > ODATA Feed. Paste the Service URL.
Note - if you would like to add any ODATA filters you can include the resource name in the service URL and the ODATA filter. Screenshot for reference -
URL : http://[DV_hostname]:9490/odata/test/customers?$filter=customerid eq 1
Click Ok.
(3) Select the Basic tab and provide the username and password.
Note: If connecting via LDAP user account, provide the username as LDAPuser@LDAPdomainName and the password of the ldap user. Here is an example where tdvuser09 is the LDAP user and ldapp is the name of the LDAP domain DV -
Click 'Connect'.
(4) Select the DV published resource and click on 'Load'.
If you would like to perform any customizations to the data, click on 'Transform Data' and it will open the data in Power Query Editor for further processing.
Environment
All supported Operating Systems
Issue/Introduction
This articles provides the steps on how to access Data Virtualization (DV) published ODATA URL from Microsoft Excel using basic authentication.
