Architecture advise - How to provide data via API etc? RRS feed

  • Question

  • I have following requirements and need architecture advice.

    Can we meet requirements with Azure Storage Data Lake Gen2 alone? Do I need other Azure tools too? Is there better tools? 

    1) Collect ERP, CRM, IoT data to No-SQL storage on Azure (not using Azure SQL if possible)
    2) Provide data to Power BI (100+ users. Azure Analysis Services is ok)
    3) Provide data via API (100+ concurrent users)
    4) Provide role based data access


    Tuesday, June 18, 2019 9:21 AM

All replies

  • You can use ADF to move data from ERP/CRM/Iot to ADL Gen2 . You did not mentioned which ERP or CRM you are using we do have connectors for few like SAP , Dynamics etc. . We can integrate PowerBI to pull from ADL gen2. One of the main criteria for API is performance , so the data on the blob should be properly partitioned . DocumentDB does lot of these  , you may try to explore that as an option .

    Thanks Himanshu

    Tuesday, June 18, 2019 10:45 PM