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 planned SaaS Driver Wizard we offer a simple way for the integration of Open as App into your Salesforce, SAP, Analytics, Oracle etc. ...
The following systems are supported
|Amazon DynamoDB||Amazon SimpleDB||Apache Cassandra|
|Apache HBase||Authorize.Net||Azure Table|
|CSV/TSV Files||Couchbase Server||E*Trade|
|FreshBooks Accounting||Gmail||Google AdWords|
|Google Analytics||Google Apps||Google BigQuery|
|Google Search||Google Sheets||HPCC Systems|
|Jira||JSON Services||LDAP Directory Services|
|Microsoft Access||Microsoft Active Directory||Microsoft Dynamics AX|
|Microsoft Dynamics CRM||Microsoft Dynamics GP||Microsoft Dynamics NAV|
|Microsoft Excel||Microsoft Exchange||Microsoft Project|
|Microsoft SQL Server||Microsoft SharePoint||Mongo DB|
|MySQL||NetSuite CRM & ERP||OData Services|
|OFX Financial Accounts||Office 365||Oracle|
|Oracle Marketing Cloud||PayPal||PowerShell|
|Quandl||QuickBooks DEsktop||QuickBooks Online|
|QuickBooks Point of Sale||RSS Feeds||Reckon|
|SAP NetWeaver||SQLite||Sage 50 UK|
|Salesforce & Force.com||SendGrid||ServiceNow|
|SharePoint Excel Services||Smartsheet.com||Square|
|XML Files||Xero Accounting|
|YouTube||YouTube Analytics||Zoho CRM|
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 roll-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.
Extract from the roadmap
- Loading user-specific data from external systems. [Q3]
- Push to server: Restore changes to external systems. [Q3]
- Flexible authentication: Extending authentication against other systems is extended to those that do not use OAuth. [Q3]
- Multi data sources: Bundle data from different systems into one single app. [Q3]