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