[IGNITE-8700] Support Uid/Pwd fields for authentication in DSN connection strings

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.5
• Component/s: odbc
• Assignee: Igor Sapego
• Reporter: Ilya Kasnacheev
• Created: 05/Jun/18 10:56
• Updated: 05/Jun/18 10:56

Description

I think Ignite should support Uid connection string field in addition to existing User, and Pwd in addition to Password. They should be interchangeable. This will improve user experience of tool users trying our ODBC.

I have reviewed several ODBC implementation for popular data bases WRT authentication.

Microsoft SQL Server uses Uid for username and Pwd for password

Oracle seems to prefer User Id and Password but also supports Uid and Pwd.

IBM DB2 uses UID and PWD.

MySQL seems to prefer User and Password, but seems to also accept Uid and Pwd.

PostgreSQL uses Uid and Pwd.

In short, everybody seems to support Uid and Pwd even if they have their own field names. Many tools (such as Informatica) rely on this convention, translating GUI inputs into Uid and Pwd connection parameters.