Additional Blogs by Members
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos
Steps in Installing and Achieving Database connectivity

Dependencies:

Reference:

  

Install DBSL





Step 2: Install the MS SQL Client on the Application Server.
Advised to Install the MS Client on Mixed Mode (Windows User and SQL user)
After the Installation of the Client, we can check the Database connection from the
Application Server by starting the SQL client and trying to connect the Target Database.
This helps to know that the network is clear and fine.


Step 3: Create a USER in MSSQL Server with “DDL_ADMIN “as the Role.
This gives the user rights to create tables and views.


Step 4: Create a view on the top of Tables to be extracted (use the newly created SQL User).The Columns Names should be kept CAPITAL



Reference:

  

Database Schema




Step 5: Create Source System for MS SQL Server




Reference:

  

Source System Creation





Step 6: Create Data Source:


a) Right Click on the created SQL Source System and select Database Tables





b) Select the Created View and Edit Data source





c) The extractor check is done by displaying Table contents.


d) Generate the Data Source





Here we get the Data Source in place. Now the rest is create a data flow and extract the data.

Note: BW 3.5 is taken as the reference system

2 Comments