Creating MSSQL as Source System

[Former Member]

Hi All,

I can't find any notes how to create MS SQL Server as source system in BW. Could anyone write me how to fill these fields?:

- Logical System Name

- Source System Name

- Conn. info

I will be grateful for any example of correct configuration of MSSQL InfoSource.

Regards,

Maciek

[Former Member · Accepted solution]

Hi Maciej,

Create the logical system name in BD54.

Now go to RSA1 -> Source System -> Create -> Select SAP DB Connect -> Give the logical system name -> DSource System name(any text) -> Fill the details like user name and password. Connection info in case of Oracle is the TNS name. Not sure for MS SQL.

Hope it helps.

Bye

Dinesh

[Former Member · Accepted solution]

Hi Dinesh,

I did steps You wrote, but I have an error. I paste a piece of System Log (SM21) below. Can You look at it?:

Time Ty. Nr Cl. User Tcod MNo Text

08:00:04 DIA 001 000 SAPSYS R4F Failed to write to file, error 0028

08:00:04 DIA 001 000 SAPSYS R2A > File: /usr/sap/BWT/DVEBMGS00/data/stat

08:55:10 DIA 000 630 MJANIK R2G HTTP/RFC session has been deleted following timeout

09:00:04 DIA 001 000 SAPSYS R4F Failed to write to file, error 0028

09:00:04 DIA 001 000 SAPSYS R2A > File: /usr/sap/BWT/DVEBMGS00/data/stat

09:50:22 DIA 000 630 MJANIK RSA1 BYG No shared library found for the database with ID MSSQL_SKM

[Former Member]

Thanks Maciej...

[Former Member]

Hi Maciej,

Not much idea..I obtained the below info from SAP Help..

+The database library is made available in the SAP Service Marketplace in the SAR archives LIB_DBSL.SAR, in the patch directories, which are independent of database manufacturer.

You can access the required directory via the Software Center of the SAP Service Marketplace in the Internet, via the following address: http://service.sap.com/swcenter-main ® SAP Web AS ® Relevant SAP Web AS Release ® Binary Patches ® Relevant SAP Kernel Release ® BW Application Server Operating System ® Source-Database Management System® LIB_DBSL.SAR.

Load the file into the directory indicated by the environment variable DIR_LIBRARY.

The file LIB_DBSL.SAR forms a complete SAP kernel patch together with the database-independent DW.SAR archive. (SAP Note 19466 - Downloading SAP Kernel Patches describes how kernel patches are imported).

Next, unpack the SAR archive with the SAPCAR tool. Before doing so, refer to note 212876- The New Archiving Tool SAPCAR

We recommend you also download the latest DBSL from the SAP Service Marketplace for SAP DB databases.+

Bye

Dinesh

Do not forget to assign points to all the people who helped you!!!

[Former Member]

Thanks for help Dinesh

I have already rated all posts.

Bye and regards,

Maciek

[Former Member]

Hi Maciej,

Refer to OSS Note - <b>512739</b>.

Also see notes 323151 & 178949.

Bye

Dinesh

[Former Member]

Hi Maciej,

Is the Database Shared Library installed on your BW server. Check this with your BASIS. For more info refer the following link:

http://help.sap.com/saphelp_nw04/helpdata/en/58/54f9c1562d104c9465dabd816f3f24/content.htm

Bye

Dinesh

[Former Member]

Hi,

my BASIS said that we have only Database Shared Library installed for MaxDB (our database for SAP BW). He said there is not DSL for MSSQL Server to be installed on AIX System. Probably we will have to pay for such interface. Is it true?

Regards,

Maciek

[Former Member]

Its very similar to creating a logical system.

Here are the steps, gurus check me if am not right!

Creating a Source System

A brief procedure for creating an R/3 source system involves these steps:

1.Creating a logical system for the R/3 client

2.Creating a logical system for the BW client

3.Naming background users

4.Creating the R/3 source system in BW

If you havent found an answer yet, i can briefly go thru the steps.

Let me know ASAP.