ODBC Connections and Outside Apps

edited 12/09/19 in API & Developers

Hi all,  Hoping i can find some recommendations that can assist with an app development.  I am creating a simple VS2010 Visual Basic app and report that will create purchase orders using smartsheet as the database back end.  

I have unlocked the smartsheet potential in ODBC connection but I am wondering if anyone has recommendations on ODBC login using API SSO as the login instead of username and password?

I am also wondering if anyone has had success in writing back to smartsheet the results (in my case some basic order header details)

Thanks in advance.