Method and system for ssis password management integration

Patent metadata

Field	Value
Publication number	US-2020410086-A1
Application number	US-202016910530-A
Country	US
Kind code	A1
Filing date	Jun 24, 2020
Priority date	Jun 25, 2019
Publication date	Dec 31, 2020
Grant date	—

Abstract

A method for facilitating credential management in a Structured Query Language (SQL) Server Integration Services (SSIS) environment is provided. The method includes identifying a credential update trigger event; accessing a user credential at an electronic password vault (EPV) in response to the credential update trigger event, the user credential including at least one string; parsing the user credential to identify a username and a password that are associated with the user credential; splitting the user credential into the username and the password; updating the password; and storing the updated password in a SSIS database.

First claim

What is claimed is:

1 . A method for facilitating credential management in a Structured Query Language (SQL) Server Integration Services (SSIS) environment, the method being implemented by at least one processor, the method comprising:
identifying, by the at least one processor, at least one credential update trigger event; accessing, by the at least one processor, at least one user credential at an electronic password vault (EPV) in response to the at least one credential update trigger event, the at least one user credential including at least one string; parsing, by the at least one processor, the at least one user credential to identify a username and a password that are associated with the at least one user credential; splitting, by the at least one processor, the at least one user credential into the username and the password; updating, by the at least one processor, the password; and storing, by the at least one processor, the updated password in a SSIS database.

2 . The method of claim 1 , wherein the at least one credential update trigger event includes at least one from among a periodic credential update schedule and an episodic credential update schedule, the periodic credential update schedule including at least once every sixty days.

3 . The method of claim 1 , wherein the at least one string includes at least one from among a string of alphanumeric text and a string of character symbols.

4 . The method of claim 1 , wherein when the at least one credential update trigger event is identified, the method further comprises:
identifying, by the at least one processor, at least one job that is associated with the at least one user credential, the at least one job including a currently executing job; determining, by the at least one processor, a stopping point for the at least one job; disabling, by the at least one processor, the at least one job based on the determined stopping point; and preventing, by the at least one processor, at least one new job that is associated with the at least one user credential from executing.

5 . The method of claim 4 , wherein the stopping point includes a point in a process flow when the at least one job has completed at least one task.

6 . The method of claim 1 , wherein the updating further comprises:
decrypting, by the at least one processor, the password that is associated with the at least one user credential; automatically generating, by the at least one processor via a password generator, a new password based on a predetermined requirement; replacing, by the at least one processor, the decrypted password with the new password; and encrypting, by the at least one processor, the new password.

7 . The method of claim 6 , further comprising:
automatically generating, by the at least one processor, at least one electronic document that includes information relating to the updating, the information including a timestamp of when the updating occurred; and storing, by the at least one processor, the at least one electronic document in the SSIS database.

8 . The method of claim 7 , further comprising:
receiving, by the at least one processor via a graphical user interface, at least one request for a record of the updating; obtaining, by the at least one processor from the SSIS database, the at least one electronic document corresponding to the request; automatically generating, by the at least one processor, the record based on the obtained at least one electronic document; and displaying, by the at least one processor via the graphical user interface, the generated record.

9 . The method of claim 6 , wherein the predetermined requirement includes at least one from among a password length requirement, a password complexity requirement, and a previous use of the password requirement.

10 . The method of claim 1 , wherein the at least one user credential at the EPV is accessed by using an application programming interface (API) call.

11 . A computing device configured to implement an execution of a method for facilitating credential management in a Structured Query Language (SQL) Server Integration Services (SSIS) environment, the computing device comprising:
a processor; a memory; and a communication interface coupled to each of the processor and the memory, wherein the processor is configured to:
identify at least one credential update trigger event;
access at least one user credential at an electronic password vault (EPV) in response to the at least one credential update trigger event, the at least one user credential including at least one string;
parse the at least one user credential to identify a username and a password that are associated with the at least one user credential;
split the at least one user credential into the username and the password;
update the password; and
store the updated password in a SSIS database.

12 . The computing device of claim 11 , wherein the at least one credential update trigger event includes at least one from among a periodic credential update schedule and an episodic credential update schedule, the periodic credential update schedule including at least once every sixty days.

13 . The computing device of claim 11 , wherein the at least one string includes at least one from among a string of alphanumeric text and a string of character symbols.

14 . The computing device of claim 11 , wherein when the at least one credential update trigger event is identified, the processor is further configured to:
identify at least one job that is associated with the at least one user credential, the at least one job including a currently executing job; determining a stopping point for the at least one job; disable the at least one job based on the determined stopping point; and prevent at least one new job that is associated with the at least one user credential from executing.

15 . The computing device of claim 14 , wherein the stopping point includes a point in a process flow when the at least one job has completed at least one task.

16 . The computing device of claim 11 , wherein, for the updating, the processor is further configured to:
decrypt the password that is associated with the at least one user credential; automatically generate, via a password generator, a new password based on a predetermined requirement; replace the decrypted password with the new password; and encrypt the new password.

17 . The computing device of claim 16 , wherein the processor is further configured to:
automatically generate at least one electronic document that includes information relating to the updating, the information including a timestamp of when the updating occurred; and store the at least one electronic document in the SSIS database.

18 . The computing device of claim 17 , wherein the processor is further configured to:
receive, via a graphical user interface, at least one request for a record of the updating; obtain, from the SSIS database, the at least one electronic document corresponding to the request; automatically generate the record based on the obtained at least one electronic document; and display, via the graphical user interface, the generated record.

19 . The computing device of claim 16 , wherein the predetermined requirement includes at least one from among a password length requirement, a password complexity requirement, and a previous use of the password requirement.

20 . The computing device of claim 11 , wherein the processor is furt

Assignees

• Jpmorgan Chase Bank Na

Inventors

• Harmon Jason

Classifications

• G06F16/252

  between a Database Management System and a front-end application · CPC title

• G06F21/602

  Providing cryptographic facilities or services · CPC title

• G06F21/31

  User authentication · CPC title

• G06F21/6218

  to a system of files or objects, e.g. local or distributed file system or database · CPC title

• G06F21/46 Primary

  by designing passwords or checking the strength of passwords · CPC title