Pros
- It's powerful yet simple way how connect all types or relational databases/sources including external ones such Amazon Redshift instance etc.and also has ability run complex queries without writing code if need is just create proper SQL script / stored procedure once :)
Cons
- Not much other than really good documentation when building up own connector