Database Automation- DSN

DSN

When to use DSN activity

A data source name (DSN) is a storage format that contains  information about a specific database which helps the Open Database Connectivity ( ODBC ) driver to connect the database.

Figure 1

Activity Name

Picture

DSN

a

Technical Reference

Figure 1.1

p

S.no

Description

1

Specify the password to access the DSN

2

Specify the UserName to access the DSN

3

Specify the DSN Filepath Name

4

Specify the DSN Name

5

Specify the query that needs to be updated

6

Query Types has the multiple options to choose from

  • Select
  • Update
  • Delete

7

Display Name property shows the action that the activity performs in the workflow

8

Specify whether to continue executing the workflow even if the activity fails

9

Enter the data-table variable created to return the value

10

Define the condition that you prefer to validate. It supports only Boolean value.

t     UserName & Password are mandatory for creating a DSN.
                
Either mention DSNName or DSNFilepathName.
                
If the QueryType is Select, the variable type should be declared as System.data.datatable.

Release date
Version
v4.0.7