SAP Data Services Repositories Definition and Configuration Part 1

SAP Business Objects Data Services Repository

The SAP Data Services repository is a set of tables that hold user-created and predefined system objects, source and target metadata, and transformation rules. Set up repositories on an open client/server platform to facilitate sharing metadata with other enterprise tools. Each repository must be stored on an existing RDBMS and registered in the Central Management Console (CMC).

Each repository is associated with one or more Job Servers which run the jobs you create.

Repository Types:

There are three types of repositories:

Local Repository

A local repository is used by an application designer to store definitions of objects (like jobs, data flow, workflows, and projects) and source & target metadata.

Central Repository

A central repository is an optional component that can be used to support multi-user development. The central repository provides a shared object library allowing developers to check objects in and out of their local repositories.

While each user works on applications in a unique local repository, the team uses a central repository to store the master copy of the entire project. The central repository preserves all versions of an application’s objects, so you can revert to a previous version if needed. Multi-user development includes other advanced features such as labeling and filtering to provide you with more flexibility and control in managing application objects.

Profiler Repository

A profiler repository is a special repository that contains the profiling information for the objects. The profiler repository is used by the Profile Server for doing Data profiling (statistical analysis and insight into the data content and relationship, Min/Max, Null values etc, Frequency Distribution, Pattern Analysis) and Data Quality Assessment tasks.

We can create SAP BODS repository time of Installation (local repository) and After Installation also. We can possible to create N number of repository.

For Example:

Database – Sybase SQL Anywhere

Data Service: SAP Data Services 4.2 SP4

Database SID: BI4_DSD

ODBC Connection Name: BI4_DSD_DSN

If we select Install with Default Configuration before we need created Database for Data Services Repository.

We can take an example for SAP SQL Anywhere Database.

Creating Database in SAP SQL Anywhere in Interactive SQL:

Three way of Database Creation in SQL Anywhere.

Sybase Central – http://scn.sap.com/docs/DOC-50289 ( Patrick Perrier)

2. Command Line

3. Interactive SQL

Create a new Database (Command Line)

Already Existing Databases in SQL Anywhere

Create BI4_DSD database using below command

_______________________________________________________________________________________________________________________________

C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\BIN64>dbinit -dba dba,Sapbw1 -p 8192 -z UTF8BIN -zn UTF8BIN “C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_DSD.db”

SQL Anywhere Initialization Utility Version 12.0.1.4104

CHAR collation sequence: UTF8BIN(CaseSensitivity=Ignore)

CHAR character set encoding: UTF-8

NCHAR collation sequence: UTF8BIN(CaseSensitivity=Ignore)

NCHAR character set encoding: UTF-8

Creating system tables

Creating system views

Setting option values

Database “C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_DSD.db” created successfully

C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\BIN64>

________________________________________________________________________________________________________________________________

Creating Database server by using below command

C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\BIN64>dbsrv12.exe -n “BODS” -x tcpip(PORT=2637;DoBroadcast=NO;BroadcastListener=NO) “C:\Program Files (x86)\SAP BusinessObjects\sqlanywhere\database\BI4_DSD.db”

Create ODBC Connection to Access RDBMS Data Source (DSD)