You can import the data from CompanyBase into Powerpivot (Excel 2010 and higher) and start building your dashboards using the new business intelligence capabilities offered by this feature.
Of course you can also import the data in any other OData- or MS Access-compliant application.
When requesting data, you'll have to provide credentials. Those credentials aren't stored in CompanyBase but are immediately passed to Exact online.
Your credentials, along with the data, are all transmitted over a secured channel (https). The data is secured with a 2048-bit key