Work with database connection and repository

In the chapter, you will learn to configure database connection in workflows and processes and also to integrate Process Studio repository with source code control systems, such as Git and SVN. If you need to get or send data to or from a database, you can do so by configuring a database connection in your workflow or process. There are steps or entries that can enable you to set the connection.

The chapter consists of the following topics:

• Create a database connection

• Connections

• Link a repository to Git and SVN

Create a database connection

You can configure database connection through Process Studio.

File menu

You have the option of configuring database connection through the File menu.

To configure a database connection:

1. Click File and select New. The sub-menu appears.

2. In the sub-menu, select Database Connection. The Database Connection dialog appears.

   

   note

   You can also configure database connection in the following ways:

   • Go to Tools 🡪 Wizard 🡪 Create Database Connection... or F3.
   • In the View tab:
   • Select Database Connection and right-click. In the contextual menu, select New or New Connection Wizard
   • Select existing database and right-click. In the contextual menu, select New.
   • In addition, use other menu options in the following ways: Edit to modify the database connection details. Duplicate to duplicate the existing database connection. Copy to clipboard to copy the existing database connection. Delete to remove the selected database connection from the project.

3. In the first pane, select the connection you want, that is, General or Advanced or Options or Pooling, or Clustering. The fields in the second and third pane of the dialog change depending on the connection selected.

4. Enter or select the details in the fields, as required.

   Field name	Description
   Connection Name	Enter a name for the database connection.
   Connection Type	Select the type of connection you want for the database. For example, PostgreSQL.
   Access	Select the type of access you want for the database. Available options are: - Native (JDBC) - OCI - JNDI - Connection String The availability of options depends on the type of connection selected. For example, when you select Connection String, the Connection String dialog appears. Enter the connection string and click Finish.
   Settings	Enter the field details, as required. - The fields available under Settings change depending on the type of connection and access selected. - The Query Timeout (in seconds) field is available only if you select Native (JDBC) or Connection String access option.

5. Click Test to verify that the database connection is complete.

6. Click Feature List to view the list of features.

7. Click Explore to view the components, such as tables and views of the selected database.

   note

   It may be possible to read from unsupported databases by using the generic database driver through JDBC connection. Contact AutomationEdge if you want to access a database type that is not yet in the list of supported components.

Connections

You can also configure shared database connections through Connections available in the Project Explorer.

Connections hold the project-level shared database connections. The shared database connections can be used across the workflows and processes under the selected project.

Configure new shared database

You can configure new shared database connections using any one of the following ways:

• In the Project Explorer, select Project 🡪 New 🡪 Database Connection

  

OR

• In the Project Explorer, select Workspace 🡪 Project 🡪 Right click on Connections 🡪 New Database Connection

  

OR

• In the Project Explorer, select Workspace -> Project -> Connections -> Right click on Database connection -> New Database Connection

  

OR

• In the Project Explorer, select Workspace 🡪 Project 🡪 Connections 🡪 Database 🡪 Right click on database connection 🡪 New

  

  note

  For details about configuring the database connection, see File menu

Edit shared database connection

To edit a shared database connection, in the Project Explorer go to Workspace 🡪 Project 🡪 Connections 🡪 Database 🡪 select database connection, and right click on the connection. In the contextual menu, select Edit and modify the details.

note

Updating or modifying the database connection will also update the shared database in all workflows and processes.

Delete shared database connection

To delete a shared database connection, in the Project Explorer go to Workspace 🡪 Project 🡪 Connections, and right click on database. In the contextual menu, select Delete all DB Connections.

note

Updating or modifying the database connection will also update the shared database in all workflows and processes.

Share a local database connection

To share a local database connection, right click on local connection -> Share.

note

If you duplicate a local connection and make it shared database connection, then the shared database connection overrides across the connection in workflows and processes in the project.

Link a repository to Git and SVN

Integrate Process Studio with source code control systems, such as Git and SVN. You can create and link to multiple repositories and maintain process and workflow versions.

Prerequisites

• For Git, initialize and update an online or local repository.

• For SVN, initialize a local or remote repository. There are additional prerequisites for SVN, such as

  - SlikSVN on Windows:

  • Download SlikSVN Windows Command Line Client,Slik-Subversion-1.9.7-x64 from (https://sliksvn.com/download/ or https://sliksvn.com/pub/) and install it.

  • Fetch a library file and copy C:\\Program Files\\SlikSvn\\bin\\libsvnjavahl-1.dll to Process Studio path libswt\\win64 (64-bit) or to libswt\\win32 (32-bit).

  - SlikSVN on Linux (Debian or Ubuntu):

  • \$ sudo apt-get install libsvn-java

  • Append /usr/lib/x86_64-linux-gnu/jni/ to LIBPATH in process-studio.sh as follows:

    LIBPATH=\$LIBPATH:/usr/lib/x86_64-linux-gnu/jni/

    export LIBPATH

note

For more information on how to install libsvn-java 1.9.X on Ubuntu 14.04, see < https://tecadmin.net/install-subversion-1-9-on-ubuntu/>.

To link a repository to Git and SVN:

1. Click View, and select Perspectives, the sub-menu appears.

   note

   You also select the perspective options using,

2. Select Git/SVN. If no repository is linked yet, a message asking for adding a repository appears.

3. Select Yes, and the Add Repository dialog appears.

   

4. Enter the details.

   Field name	Description
   Name	Enter a name of the repository.
   Description	Enter a description of the repository.
   Directory	Select the directory path where the local Git or SVN repository to be linked is present.
   Type	Select the type of linking you want, that is, Git or SVN.

   note

   If the repository is already linked then you can directly view the operations performed on the repository.

5. After linking the repository, a confirmation dialog appears. Click Yes, and you can view the operations performed on the repository.

Perspective toolbar

The section explains the tools used in the Git or SVN perspectives.

important

Access the GitHub site and follow the steps to generate the Personal access token (classic). Use the generated token as the password when performing actions, such as Push in Process Studio.

Enter the username and generated password as the credentials. Click to view the password.

Toolbar icon	Description
	Use to add, open, edit, clone, or remove a project. Following options are available: - Open - Add - Remove - Edit - Clone
	Use to provide the path of the remote repository. The name of the remote repository should be origin.
	Use to sync the opened, local, and remote repository, and is equivalent to git pull. NOTES: - In SVN, use Update instead of Pull. - The behavior of this tool varies depending on the configuration of origin and branches.
	Use to sync the opened, local, and remote repository, and is equivalent to git push. NOTES: - In SVN, the option is unavailable. - In Git, the behavior of this tool varies depending on the configuration of origin and branches.
	Use to checkout, create, delete, merge, and push branches. - Checkout: switch between branches. - Create: create a new branch. - Merge: merge multiple branches. Following are the options for merging: - Recursive - Ours - Theirs NOTES: - For a Git repository, files are saved as .ours or .theirs. - For SVN repository, files are saved as .mine, .rXX, and .rYY. - If there are conflicts when you merge the branches, you can resolve them by selecting the file in Changed files, and then selecting Stage. Commit these changes. To abort the merge, select Discard changes. - Delete: delete a branch. - Push: push a branch to origin or remote repository.
	Use to tag the branches. The functionalities are same as that of Branch. Merge option is unavailable.
	Use to refresh the view.

Changed files

In the section, you can work on the files in the repository.

You can view the new or modified files in the Changed files pane. A new file added to the repository has icon against it. A modified file has and removed file has icons against it, respectively.

To commit a file:

1. In the Changed files pane, select the checkbox against the files that you want to commit.

2. Select the file to view its details in the stage pane, then enter a comment in Commit Message.

   

3. Click Commit. The changes are committed to the working branch.

note

• In the SVN perspective, committing the file pushes the updates to the remote repository.
• In Git perspective, click Push, to commit the updated branch to the repository. The changes are now available in the remote repository.