HomeSQLServerPedia SyndicationData Platform products for Microsoft gaps

Comments

Data Platform products for Microsoft gaps — 12 Comments

  1. Very helpful article James! I think that Synapse allows virtualization with Storage accounts as well in addition to ADLS. Also, Talend data catalog is very good with auto scrolling capacity.

    • Microsoft has had forecasting for many years. It’s a part of SQL Server Analysis Services. Unfortunately, I think that it was removed in the 2017 release. We used to do a LOT of forecasting for different retailers, I worked for a company that got bought by AC Nielsen.

      • A financial forecast, on the detailed level of accounts? In the format of 3/9, 6/6 and 9/3? I would have liked to see that in SSAS using the data mining tools, especially with the limited documentation.

  2. For a non IAAS solution,

    Azure managed instance sql will also support polybase on ADLS gen 2. It has been in private preview since February. In the first release, it will support the Parquet and CSV format.

    Additionally, it can already query other databases such as sql server and azure SQL which would make it a good “low cost” candidate for some data virtualization cases.

  3. Here is a gap my company, Cloud Data Solutions has addressed. Azure Data Factory (ADF) has limitations in terms of managing and scheduling pipelines. We have developed ChillETL to address this gap. It is completely meta data driven which makes it possible to import many objects from different data sources with just a few pipelines.

  4. Microsoft lack a software retail till in their stack versus Oracle have Symphony and others and promote the benefits of their synergy and integration with the Fusion ERP. OK that’s not directly data …but sure generates plenty of it. 🙂

    I am a retail data specialst hence landing on this page at all. The above is bigger than any item in the data list in this sector due to its wider consequences. [with my apols for going slightly off beam]

Leave a Reply

Your email address will not be published. Required fields are marked *

HTML tags allowed in your comment: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>