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
In this table 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.
| Amazon DynamoDB | Amazon SimpleDB | Apache Cassandra | Apache HBase | Authorize.Net | Azure Table |
| Basecamp | Bing Search | Box | CSV/TSV Files | Couchbase Server | E*Trade |
| Exact Online | FreshBooks Accounting | Gmail | Google AdWords | ||
| Google Analytics | Google Apps | Google BigQuery | Google Search | Google Sheets | HPCC Systems |
| Highrise CRM | HubSpot | Intacct | Jira | JSON Services | LDAP Directory Services |
| Magento | MailChimp | Marketo | 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 | Stripe | Sugar CRM | Twilio |
| XML Files | Xero Accounting | YouTube | YouTube Analytics | Zoho CRM | |
| eBay | xBase |
Connect app to external service
App creation begins with the selection of the data source.
- In the "Connect External Service" section, click "Salesforce, Dynamics CRM, ..."
- Select the provider of your choice
The build process will then adjust depending on the selectet provider.
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 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.
Comments
0 comments
Please sign in to leave a comment.