How to create SAP BODS Profiler Repository
A profiler repository is a special repository that contains the profiling information for the objects.
Among other things, this repository stores the column level details including cardinality/ max, min
and Null values etc. A job server needs to be associated with the profiler repository.
Next we will see how to configure a profiler repository. Go to SAP BODS Repository Manager
and enter the following information to configure the metadata of the Profiler Repository:
Among other things, this repository stores the column level details including cardinality/ max, min
and Null values etc. A job server needs to be associated with the profiler repository.
Next we will see how to configure a profiler repository. Go to SAP BODS Repository Manager
and enter the following information to configure the metadata of the Profiler Repository:
Repository type: Central
Check Enable Security
Database type: Oracle
Database server name: EDWDEVETL
Database connection name: ORCL
User name: DEVETLREPO_PROFILER
Password: (your password here)
Click on Get Version button, first to check it is able to connect to database.
Next Click on Create button to create the metadata tables.
Next Click on Create button to create the metadata tables.
Profiler Repository was successfully created.
Note:- Profile repository is used for the sole purpose of performing column level profiling
of the DW tables. You must configure or associate a Job Server with the Profiler Repository.
of the DW tables. You must configure or associate a Job Server with the Profiler Repository.
Next we will learn how to CONFIGURE JOB SERVER USING DS SERVER MANAGER for
the Profiler repository.
the Profiler repository.
