# FAQ

## General

### What is the Coherent platform?

Coherent powers Enterprise Excel Estates with a world-leading technology platform that connects your business, unlocks impactful intelligence, and enhances your control.

Transform complex Excel logic into production-ready code. Coherent Spark compiles your models into high-performance APIs, seamlessly integrating with your existing systems and workflows and bridges the gap between business expertise and IT infrastructure, enabling seamless integration, enhanced performance, and robust governance.

## Login

### What is the link to my environment?

The link to Spark should be provided by a member of the Coherent team. Usually, the format of the link to a Coherent environment will be constructed as:

`https://spark.{environment}.coherent.global/{tenant}`, e.g. `https://spark.qa.de.coherent.global/superfunbank`

* `environment` represents the name of the environment (e.g. `qa.de`).
* `tenant` represents the name that identifies your organization's account (e.g. `superfunbank`).

It is advised not to bookmark the initial landing page however any pages within Spark can be bookmarked by the browser.

### How do I reset my password?

See [Login and logout](/navigation/login-and-logout.md#reset-password).

### What identity and access management solution does Coherent Spark use?

Coherent uses [Keycloak](https://www.keycloak.org/) for identity and access management. See the related articles on [Manage users](/tenant-administration/manage-users.md) and [Authorization - API keys](/spark-apis/authorization-api-keys.md).

Spark also supports Single Sign-On (SSO). See the related articles in [Single Sign-On](/identity-and-access-management/single-sign-on.md).

## Excel

### Why can't I upload my models?

If you are having issues with a particular file, see [Support](/support/support.md).

### Why doesn't my model work correctly?

Please [How to: Create a Spark service](/build-spark-services/how-to-create-a-spark-service.md#review-the-upload-log) and see if there are any warnings that should be addressed. If you are having issues with a particular file, see [Support](/support/support.md).

### Does Spark support Excel Macros or Visual Basic for Applications?

Spark does not support the conversion of Excel Macros or Visual Basic for Applications code. Spark does provide extensive support Excel's [`LAMBDA`](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67) functions which enable users to create their own user-defined functions.

## Integration via API

### Where can I learn more about the Execute API?

See [Execute API](/spark-apis/execute-api.md) for more details and to understand the differences between `v3` and `v4`.

### What authentication methods are supported?

Spark supports API keys generated from [Authorization - API keys](/spark-apis/authorization-api-keys.md), as well as [Client Credentials grant (OAuth 2.0)](/identity-and-access-management/client-credentials/client-credentials-grant-oauth-2.0.md).

### What happens if I omit a parameter from the Execute API request?

The value that is saved within the Excel file is used as a default value.

### What happens if extra parameters are included as part of an Execute API request?

These parameters are not used as part of the request.

### How can I identify an Execute API call for reference?

In the [Execute API](/spark-apis/execute-api.md), it is possible to define a `correlation_id` which is echoed in the [Execute API (v3)](/spark-apis/execute-api/execute-api-v3.md#response_meta).

### Does Coherent store Execute API requests and responses?

Yes, see [API Call History](/navigation/api-call-history.md).

## Deployment models

### How can Spark be deployed?

Spark is served using a Software as a Service (SaaS) model with hybrid and on-premises deployment options, see [Hybrid Runner](/hybrid-runner/introduction-to-the-hybrid-runner.md).

## Support

### What other ways are there to learn about Spark?

* Check out [Get started in 5 minutes](/getting-started-in-5-minutes.md) and [Manage tenant settings](/tenant-administration/manage-tenant-settings.md).
* [Coherent Academy](https://coherentacademy.coherent.global/) is the place to participate in guided training courses and earn Spark certifications.
* Our [YouTube](https://www.youtube.com/@coherentspark) channel contains video tutorials of complex use cases.
* See [Support](/support/support.md).

### Where can I get help if I cannot find the answer?

See [Support](/support/support.md).


---

# 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://docs.coherent.global/support/faq.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.
