Create a SmartObject to expose data in a SQL table

I am trying to create a SmartObject as part of a workflow which will pull data from a SQL table such as employee #, name, etc. and show each individual employee specific information unique to them (by employee#). I see how to create a smart object from a table, but any pointers on how to have the SmartObject connect to this table then based on the employee ID it would reflect that employee's info?

Thanks

Mark