==What is OData?==
OData is described in the following article: [https://en.wikipedia.org/wiki/Open_Data_Protocol]
==How does it work==
Smartsimple provide SmartSimple provides OData V4 services - Can . These can be consumed by OData clients like such as MS Excel, MSSQL MS SQL server,SafeforceSaleForce, or used though another API such as API (.NET has very good support) etc. What SS ==SmartSimple Entities exposed Exposed to OData Services ? Report Only (however it does not exclude us to expose raw == Currently Reports are the only entities like people, organization, Levelone, notes in exposed through Odata. In the future) Why Report Only ? 1other entities may be added. Reports were chosen for the following reasons: # Easier to control security and data format like fields and fieldname, any end user can perform this task 2. # Most clients consume ready only data anyway 3. # Data relationships are handled in SS, external client does not need to understand underlying data relationships 4. #Easy to implement as no need to configure OData service and metadata enpoints(these are required by OData protocol), it is handled by SS report engine automaticaly 5. # More flexible as SS user are able to create dummy tables (like SQL views) by combining tables , applying formulas and aggregrations 6. aggregations # Filtering ans ordering are pre-defined in SS report, eliminate SQL injection vulnerability ==Where is my OData services endpoint ? == https://mysmartsimpleurl/OData/V4/Services.svc/ How to setup in SS ? 1. Create a new user and set access to "web access" 2. Set a password 3. Edit report in neo builder and enable OData checkBox 4. Done How to connect from Salesforces ? I will add more details with screen shots How to connect from MSExcel ? I will add more details with screen shots
