Extending Metadata

Types of advanced jobs & workflow

What is an Advanced Job?

There are certain tasks within ovaledge that need advanced algorithms to be used to get the desired results. The Advanced job feature enables the user to undertake tasks that cannot be accomplished using a traditional job. 

A good example of an Advanced job is building lineage from tableau reports, in here there will be a couple of traditional jobs like getting reports and then getting source code beneath the reports and then building the Lineage.

Everything is point-and-click i.e., you need to input the connection attributes (displayed under each advanced job in this section) and our algorithms will do the rest for you. 

This section provides the list of all Advanced jobs that can be executed in OvalEdge. 

Types of advanced jobs & workflow

 

Advanced Job Type Description

Process Importance Score

PROCESS_IMP_SCORE

The importance score of a table or a column tells us about the number of relations the selected data object has with other data objects. The purpose of this advanced job is to process the importance score of a table and its columns.

Reset Encryption-Decryption

ENCRYPT DECRYPT RESET

The purpose of this job is to reset the fields and provide them with a new encrypted-decrypt key.

Discover Primary and Foreign key relationship auto

DISCOVER_RELATIONSHIP

The purpose of this job is to automatically discover primary and foreign key relationships in the data that is profiled and brought into ovaledge.

Load oereportext table for reporting framework

LOADOEREPORTEXT

The purpose of this job is to enable the user to load sqls from staging tables to oereportext tables for the purpose of creating reporting frameworks.

Load Users Into Ovaledge

LOAD USERS TO OVALEDGE

The purpose of this job is to enable the creation of users in bulk using an external CSV file.

Creation and Deletion of Orphan ACLs

CREATE_DELETE_ORPHAN_ACL

This job is used for the creation and deletion of Access Control Lists for Orphaned objects.

Build BusinessGlossary for table column

BUILD BUSINESS GLOSSARY

This job is used for creating a business glossary for table columns. 

Discover relationships automatically

DISCOVER_RELATIONSHIP

The purpose of this job is to discover various relationships automatically.

Calculate relationships strength

CALCULATE_RELATIONSHIP

The purpose of this job is to calculate the strength of all relationships.

LDAP Connection Validate Service

LDAPConnectionValidateService

The purpose of this job is to validate the LDAP connections.

Get Relationships with Column Names

DISCOVER_RELATIONS

The purpose of this job is to discover the relationships between columns.

Project Level Relationships Building

PROJECTLEVEL_RELATIONSHIPS

The purpose of this job is to build project level relationships.

Populate Documented/UnDocumented Counts

BUILD_DOCUMENTED_OBJECTS

The purpose of this job is to populate documented/undocumented counts.

Create Security ACL Entries

Create ACL Entries For All Objects

The purpose of this job is to create the security ACL entries at all object levels.

Load Affected Objects For Table Columns

LoadAffectedColumns

The purpose of this job is to enable the user to load downstream affected objects at the column level by using CSV files.

Recommend Terms

AI_TERM_BUILD_SERVICE

The purpose of this object is to create a Business Glossary using Lineage and Object Name.

Build Lineage For Dremio

Dremio

This job will build lineage between sources and dremio

Process CouchDb Lineage

PROCESS_COUCHDB_LINEAGE

This job will build lineage for couchdb it takes one input attr, pass couchdb connectionid in attr1