# SAP Webi Connector

{% hint style="success" %}
**Who can use this feature?**

The **SAP Webi Connector** can be used by those with the **Builder** subscription plan.

For more details, see our [**pricing comparison matrix**](https://squirrel365.io/pricing/).
{% endhint %}

The **SAP Webi Connector** can is used to connect the Squirrel project to an external BusinessObjects database.

## SAP Webi Properties- Credentials

### AUTHENTICATION

A BusinessObjects URL is required to use the **SAP Webi Connector**.

* **Standard WACS port** - this option can be checked to enable the standard port for the BusinessObjects URL. When unchecked, a field will populate where a specific port can be defined.
  * For more information on WACS ports, [**see here**](https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/2e167338c1b24da9b2a94e68efd79c42/4698c7096e041014910aba7db0e91070.html)

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FjWaAKjK3bLpcjYlUU19Z%2FSAP_Authentication.png?alt=media&#x26;token=52b91ab1-e609-44e8-909b-e752869d1cb9" alt=""><figcaption></figcaption></figure>

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FWnqi1vu9TBwppOtNmVyf%2FSAP_Auth.png?alt=media&#x26;token=0a9f7c91-7686-4981-922e-ceda50573482" alt=""><figcaption></figcaption></figure>

### WEBI REPORT

Once logged into and connected to the SAP environment, the properties panel will populate a WEBI REPORT drawer

Click to expand this drawer and click "Select Webi Document"

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FtVlD8oJtV9x44nHuCotL%2FSAP_WebiDocuments.png?alt=media&#x26;token=866905e0-3848-40ad-be0b-61fe19ae0766" alt=""><figcaption></figcaption></figure>

A list of all known documents in the connected environment will populate below. Navigate through and select the desired report to bring through to Squirrel.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FpNpKRRPTSWiH5MQttDsU%2FSAP_WebiNavigation.png?alt=media&#x26;token=f96d6c2b-ae53-4f11-b94b-680c32b865d3" alt=""><figcaption></figcaption></figure>

After a document has been selected, follow the steps to select a report and table.&#x20;

Finally, an option will appear to select how the data will populate in the spreadsheet.

* **Create new data sheet** - creates a datasheet in the spreadsheet that will bringi nthe data.

{% hint style="warning" %}
Datasheets cannot be edited, only referenced in cell bindings and formulas in other sheets.
{% endhint %}

* **Select range in existing sheet**

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FYgkT6cWzxH8yHztQGqvs%2FSAP_WebiInsert.png?alt=media&#x26;token=4fbeb2a0-4130-44e4-827d-8f92e9635a6e" alt=""><figcaption></figcaption></figure>

### USAGE

* **Refresh on Load** - Causes the data to populate and refresh in the spreadsheet on load of the project
* **Refresh on Cell Changes** - causes the data to populate and refresh in the spreadsheet on the change of a designated cell
* **Insert loading status in cell** - inserts the status of the loading Webi Report in the spreadsheet. Can be used to track the initiation, progress, and completion, or failure.

<figure><img src="https://911720298-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FkLBGzn2hXrIMe50klQCv%2Fuploads%2FJPOphdjmFDaftzMcMzIS%2FSAP_Usage.png?alt=media&#x26;token=9746ba5d-04a4-4b40-a585-b2f91dbb5efb" alt=""><figcaption></figcaption></figure>