What is the definition of erwin connector- Standard connector vs. smart connector?
The terminology can vary and probably need case by case detailed discussion with erwin DISuite Automation team, but in general:
Standard Connectors are OOB functionality that document data at rest. DB's, Flat Files, XSD, JSON Schema etc. into the Metadata Manager module.
Smart Connectors are created using the Automation Framework and are primarily (but not solely) used to document data in motion (SQL, ETL, BI Reports, etc.) in the form of Source to Target mappings in the Mapping Manager module.