DataFactory feature comparison

November 28, 2019


FeaturesDataStore CommunityDataFactory EnterpriseDataFactory Azure
DataStore
Database schemaYesYesYes
XSLT code transferYesYesYes
SQL code transferData quality SQL codeAll SQL code is disclosedNo, part of SaaS
Data pipelinesSSIS package for XML importSSIS; ADF pipelines optionalADF pipelines
Common Data Model and Power Apps
Data import from Dynamics 365 appsNoNoYes
Data import from CRMNoNoYes
Data import from ERPNoNoYes
Data import from a websiteNoNoYes
Data import from HRMNoNoYes
Data import from a service desk appNoNoYes
Power BI integrationNoYesYes
Custom Microsoft Power AppsNoNoYes
Machine learning
‘Classic’ ML algorithmsNoYesNo
Deep learning algorithmsNoLimited number of deep netsYes
Sample trained models and pipelinesNoYes, part of deliveryMost modern deep nets
Model deployment options
SQL Server Machine Learning ServicesNoYesYes, part of SaaS
Microsoft Machine Learning ServerNoYesBeta version
Azure Machine Learning StudioNoOptional hybrid deploymentR & Python. Selected algorithms
Azure Machine Learning ServiceNoOptional hybrid deploymentPython only. Most algorithms