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.
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.
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.
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 184.108.40.20604
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)
Source & Reference
Continue Part 2 ->