Can anybody help on the single sign on solution without using the third party identity provider?
Can you give us more details about how you are hoping to set things up? Do you have an SSO that you are using for other applications at your institution?
A "single sign-on" is an authentication provider that is shared by many applications, so it is a "third party" (outside of Canvas) by definition. Canvas is able to integrate with many standard SSO types like SAML and CAS without too much difficulty, if you are already using one of those.
Retrieving data ...