SAS Visual Investigator is a cloud-ready investigation and incident management solution that combines large, disparate, structured and unstructured data sources. Users can define, create, triage and manage alerts; perform detailed investigations; and customize the platform to meet their individual and organizational needs.
SAS Visual Investigator Process Flow:
- Download PG Admin from as per the requirements.
- Data upload to the server library file or connect the server to SAS EG. Connect the server to pgdmin and make connection.
Connecting SAS VI Server to Postgres(PGAdmin)
libname <libref> Postgres server=”<server host>” Port=<server port> user=<DB User> password=<DB Password> database=<DB Name> schema=<Schema Name>;
By creating the connections between the PGAdmin and SAS Visual Investigator. It makes the bridge connection to upload the number of data in the SAS Visual Investigator with the help of PGAdmin.
- Connect PGAdmin with the Server by writing its credentials
By connecting with the PGAdmin Server the data columns are been uploaded in the server in the form of ddl. And create a database and the Schema in the PGAdmin.
Figure 2: Connecting SAS VI to PGAdmin
- Make a DDL and run in PGAdmin.
- Note 1]: DDL= Create only columns in SAS VI
- Note 2]: Constraint pkey (Primary Key) always be unique in every DDL of the data set to load the table in the PGAdmin.
- Making connection between SAS VI and PGAdmin by giving its credentials.
In the SAS VI in the Import Section connect the data source of PG Admin to the SAS VI by giving its credentials such as given below:
- Database Name
- Additional URL Parameters: SSL=true
- Authentication: User ID and Password
Connection of the uploaded data sets in the SAS vi can been seen by making the connection in the import tab of the SAS Visual Investigator by filling up the required details of the required server.
After connecting to the server, the data sets can be able to upload in the SAS vi and the uploaded data sets are been seen in the Data Object as shown in the below image.
Figure 3: Data Object (where the uploaded data is seen)
- Entity Type:
- External entity: External entities represent data from source systems external to SAS Visual Investigator (for example, an insurance policy, a bank account application, or a tax return).
- Internal entity: Internal entities represent data managed by SAS Visual Investigator (for example, an intelligence report or investigation).
- Child entity: The data describing an external or internal entity might be broken into multiple child entities. Each refers to a particular component, often an individual party, or can be used for repeating information.
- Resolved entity: The result of entity resolution is a new set of objects that are extracted from internal or external entities and combined to form a resolved entity. Resolved entities represent real world objects and are created using a combination of elements to create a compound.
Relationships can be defined between internal or external entities. Users can then relate entities using SAS Visual Investigator. The connection between internal or external entities is described as one-to-one, one-to-many, many-to-many, or many-to-one. For example, a customer might have many accounts and an account might have many owners (one-to-many sourced relationship). Another example is an intelligence report referencing a police report (one-to-one relationship).
Types of relationships:
From the Cardinality drop-down list, select One-to-One, One-to-Many, Many-to-One or Many-to-Many. If you selected One-to-One or Many-to-Many, you can select Symmetric (that is, the relationship is the same in both directions).
- Admin Scenario (Rules and Alerts are being made):
A flow is a top-level container that consists of the following items: one or more data sources to be evaluated for the behaviors of interest one or more scenarios in which parameters, properties, rules, and other items are defined optionally, one or more scorecards, by actionable entity.
Figure 4: The Scenario Administrator Process Flow