So, in the Control-M for Database, as far as I know. It purely run queries/statements that is valid as SQL statement. However, the one that I am using which is SQLLDR is an independent cli tool for import the data(.csv) to a oracledb table.
So, I have already done importing data(.csv) to my oracle database(table). However, in the OS Command (using sqlldr) my credentials are exposed, in the OS command it looks like this.
“sqlldr username/password@smthng”
Is there any way to implement this import (.csv data) job successfully using the Control-M for Database or to an OS Command (using sqlldr) without exposing the credentials?
ps: I am currently just learning. So, the environment is also for testing, however I want to practice the best practices. I am open to any other ideas as well to improve my current method.