Interfaces | SQL, Databases, API,...

Our goal is to simplify the way you connect and work with data. This approach allows companies to create apps based on data from Excel and other (structured) data sources such as ERP, CRM, or SharePoint, without programming skills.

With the SaaS Driver Wizard, we offer a simple way for the integration of Open as App into your Salesforce, SAP, Analytics, Oracle and many more.

Depending on the package, the connection to third-party systems is already included in the package price. For more information visit the Open as App pricing page.

The following systems are supported

Here you will find a list of the systems that could be connected. Some of them are already available, others need to be implemented on request.

Connect app to external service

App creation begins with the selection of the data source.

1. In the "Connect External Service" section, click "Salesforce, Dynamics CRM, ..."
   
2. Select the provider of your choice
   

The build process will then adjust depending on the selected provider.

SQL webinar

The following webinar provides information about creating an app using Microsoft SQL Server and the workflows during the app creation.

REST API

Apps can be created, updated, and distributed through a simple REST API. Authentication takes place via OAuth2 / OpenID Connect.

Single Sign-On via OpenID Connect is currently in the test phase.

Apps created with Open as App can be distributed using a classic role-based user rights management system. Users of the organization can be grouped into groups for easier distribution. In addition to classic read access, users can also be assigned administrator rights. (Read more in this article: "Usermanagement in Open as App".)

In addition, apps need access to the underlying Excel file (which acts as a data and logic backend for the app). If this is hosted by an external cloud service (Microsoft Excel Online, Dropbox, Google Sheets, Box) or on-premises, the management of the system can be swapped to it. Without access to the underlying Excel file, a user can not use the app.

Connect REST Web Service via Bearer Token

Bearer authentication is an HTTP authentication scheme that involves security tokens called Bearer Tokens. You can use this method, but please make sure, you're not missing the quotation marks in the header. The blanks are also important. Your custom header should look like this: { "Authorization": "Bearer ey0J......." }