# 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://learn.squirrel365.io/components-functions-and-connections/overview-2/other-1/sap-webi-connector.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.