SSRS

[DMS]

PTX API

DMSPRO1DBA01

UI

DDeBroker

Least development

SSRS going forward?

Can run anytime - load on API?

No extra DB resource needed

Excel download

Snapshot - schedule?

SSIS

[DMS]

PTX API

DMSPRO1DBA01

DDeBroker

GENPRO1DBA01

Email

GENPRO1DBA01

?

Using Project model, needs CLR integration on DB engine

Possible just using DB?

Appropriate location?

SSIS going forward?

Potential to run all reports via same SSIS

Known schedule

Receive preferred format immediately

Easily accessible history

Maintainable across SSIS

Most development - SSIS, new tables, deployment