+91 79-2979-8090
1023, 10th Floor, Shivalik Satyamev, Sardar Patel Ring Rd, Ahmedabad-380058

Blog Details

Introduction to SAS Visual Investigator

Introduction:

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.

Figure 1: Process Flow
SAS Visual Investigator Process Flow:
1. Download PG Admin from as per the requirements.
2. 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 Postgres server=”” Port= user= password= database= schema=;

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.

3. 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
4. Make a DDL and run in PGAdmin.
  1. Note 1]: DDL= Create only columns in SAS VI
  2. Note 2]: Constraint pkey (Primary Key) always be unique in every DDL of the data set to load the table in the PGAdmin.

5. 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:

  1. Name
  2. Type
  3. Hostname
  4. Port
  5. Database Name
  6. Schema
  7. Additional URL Parameters: SSL=true
  8. 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)
6. Entity Type:
  1. 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).
  2. Internal entity: Internal entities represent data managed by SAS Visual Investigator (for example, an intelligence report or investigation).
  3. 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.
  4. 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.
7. Relationships:

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).

8. 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
Written by,
Deepak Kumar Chaudhary
SAS Consultant
Nupeak IT solutions LLP

Comments (2)

  • Obila Doe

    November 26, 2021 - 2:19 pm

    Our infrastructure management approach is holistic, addressing capacity monitoring, data storage, network utilisation, asset lifecycles, software patching, wired and wireless networking and more.

  • James Weighell

    November 26, 2021 - 2:21 pm

    A hosted desktop solution allows for the delivery of a consistent and scalable IT experience for all users in an organisation. With this solution, users gain access via a desktop icon or link.

Leave A Comment