====== 5.2 Excel with Certificate ======

OData connection with certificate authentication.

===== Prerequisite =====

  * Certificate installed in Windows certificate store

===== Establish Connection =====

  - **Data** -> **Get Data** -> **From OData Feed**
  - Enter URL: ''https://gateway.company.com/odata/erp''
  - When prompted for certificate: Select your certificate
  - **Connect**

===== Certificate Selection =====

Windows shows a list of your certificates. Select the certificate with:
  * Your name
  * Issued by: "Company Internal CA"
  * Valid until: Date in the future

===== Save Connection =====

Excel remembers the certificate assignment. For later refreshes, the correct certificate is automatically used.