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 Reset password.

What identity and access management solution does Coherent Spark use?

Coherent uses Keycloak for identity and access management. See the related articles on Manage users and Authorization - API keys.

Spark also supports Single Sign-On (SSO). See the related articles in Single Sign-On.

Excel

Why can't I upload my models?

If you are having issues with a particular file, see Support.

Why doesn't my model work correctly?

Please 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.

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 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 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, as well as Client Credentials grant (OAuth 2.0).

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, it is possible to define a correlation_id which is echoed in the response_meta.

Does Coherent store Execute API requests and responses?

Yes, see API Call History.

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.

Support

What other ways are there to learn about Spark?

• Check out Get started in 5 minutes and Manage tenant settings.

• Coherent Academy is the place to participate in guided training courses and earn Spark certifications.

• Our YouTube channel contains video tutorials of complex use cases.

• See Support.

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

See Support.