|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
DB Connect Usage in SAP BI 7.0
By Arun Bala Ganesan, Wipro Technologies
In SAP Net weaver BI 7.0, we’ll study how to
implement DB Connect, rather than common usage of flat files. Using DB Connect,
BI offers flexible options for extracting data directly into BI from tables and
views in database management systems that are connected to BI using connections
other than default connection.
The DB Connect enhancements to database interface
allow you to transfer data straight into BI from the database tables or views of
external applications. You can use tables and views in database management
systems that are supported by SAP to transfer data. You use Data Sources to make
the data known to BI. The data is processed in BI in the same way as data from
all other sources.
It’s to be noted that SAP DB
Connect only supports certain Database Management systems (DBMS)
The following are the list of DBMS
There are 2 types of
classification. One is the BI DBMS & the other is source DBMS.
The main thing which is, both these
DBMS are supported on their respective operating system versions, only if SAP
has released a DBSL. If not, they don’t meet the requirements & hence
can’t perform DB Connect.
In this process we use a Data
source, to make the data available to BI & transfer the data to the
respective Info providers defined in BI system. Further, using the usual data
accusation process we transfer data from DBs to BI system.
Using this SAP provides options for
extracting data from external systems, in addition to extracting data using
standard connection; you can extract data from tables/views in database
management systems (DBMS)
Loading data from SAP Supporting DBMS into BI
Steps are as follows:-
Go to RSA1 à Source Systems à DB Connect à Create
Now, create the source system using
System Name à
System Name à
MS SQL DB Connect
Now, Under DB Connect, we can see the name of our
Source System (MS SQL DB Connect)
The logical DB Connect name is MSSQL
In Data sources we need to create an Application
Component area to continue with the export
Goto RSA1 à
Data sources à
Create Application Component
creating an Application Component Area called “ac_test_check”, we now have
to create a Data source in the component area. So right click the Application
component area à
Create Data source (as in below figure).
The Data source name here is “ds_ac_tech”
The Source System here is the defined “MSSQL”
The type of data type data source that we have here
is “Master Data Attributes”
below screen shot describes how to perform extraction or loading using a
Table/View. As the standard adapter is “Database Table” (by
default), we can specify the Table/View here
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards