on 08-21-2007 5:51 AM
Hi All
I have created the tables in MaxDB by using Sql queries.Now i want to get the data from there to BI ... so what should i use..? can i do this by using UD Connect ..or there exist some other way of doing this?
Any suggestion will be highly helpful.
Thanks & Regards
Shivanjali
Hi All
This is the way i followed and successfully created the connection....
To Configure UD Connect on the J2EE Server for JDBC Access to External Databases
i followed this PDF
Now to create Driver on JDBC side
http://help.sap.com/saphelp_nw70/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm
Configuring the BI Java Connectors
http://help.sap.com/saphelp_nw70/helpdata/en/43/e35b3315bb2d57e10000000a422035/frameset.htm
Then to extract data use this...
Before you can transfer data from UD Connect sources into BI, you have to generate the metadata (the information about the source object and source object elements) in BI, in the form of a DataSource with a function module for extraction.
If your dataflow is modeled with objects based on the old concept (InfoSource 3.x, transfer rules 3.x, update rules 3.x), you can generate a DataSource 3.x for transferring data into BI from a database source system.
Prerequisites
You have modeled the InfoObjects that you want to use in the InfoSource and the data target or InfoProvider according to the UD Connect source object elements.
Note the following background information:
Using InfoObjects with UD Connect
Data Types and Their Conversion
Using the SAP Namespace for Generated Objects
Procedure
You are in the Modeling InfoSource tree of the Administrator Workbench. First create in InfoSource and activate the communication structure. Then generate the generic DataSource using the wizard in the InfoSource maintenance.
1. Choose InfoSources ® Your Application Component ® Context Menu (right mouse click) ® Create InfoSource.
2. Select the type of the InfoSource.
3. Under InfoSource, enter the technical name of the InfoSource, and assign a description and choose Continue.
The system creates an InfoSource and shows it in the InfoSource tree under your application components.
4. In the context menu of the InfoSource, choose Change .
The communication structure maintenance screen appears.
5. Using the previously modeled InfoObjects, create the communication structure (see Communication Structure).
6. Save and activate your communication structure
7. In the dialog box that follows you will be asked whether you wish to activate the dependent transfer program. Choose No.
8. In the InfoSource menu, choose Extras ® Create BW DataSource with UD Connect.
You get to the dialog box where you can assign a UD Connect source object to a DataSource and then generate the DataSource with the extractor. The fields for the DataSource are already being displayed in the table on the left side of the screen. The fields have the same name as the InfoObjects that you have used in the InfoSource.
9. Select the RFC Destination for the J2EE Engine.
Make sure that the local server is running. If the local server is running and you cannot open the table for RFC destinations, start the local server again.
10. Choose the UD Connect Source in which the data that you wish to access is located.
All available sources that are connected to the J2EE Engine are provided for selection in the input help. n instances are available per adapter.
11. Select the UD Connect Source Object.
All available source objects that are available in the selected UD Connect source are provided for selection in the input help. Source objects can be multi-dimensional storage or relational objects.
The system generates the name of the DataSource in the namespace 6B.
The DataSource is then replicated in BI.
The myself system is assigned to the InfoSource as source system as well as the DataSource.
The system generates a proposal for the transfer rules.
Since the DDIC structure and the function module are located in the SAP namespace, the following entries can be requested during generation:
Developer and object key or
Developer key or
Object key and
Transport request
If you do not make the requested entries, the generated infrastructure is not usable.
14. Change or complete the transfer rules as needed. For example, if a source object element is not assigned to a unit InfoObject, you can determine a constant for the unit, such as EUR for 0LOC_CURRCY (local currency).
15. Save and activate your transfer rules.
Recognizing Manual Entries
You can enter and change the RFC Destination, UD Connect Source and UD Connect Source Object manually. In order to validate these entries and the ones that depend on them, choose Recognize Manual Entries. For example, if you change the selected RFC destination, all of the field contents (US Connect Source, UD Connect Source Object, list of the source object elements) are invalid. If you choose Recognize Manual Entries, the dependent field contents are initialized and have to be maintained again.
Result
You have created the InfoSource and DataSource for data transfer with UD Connect. In the DataSource overview for the myself system, you can display the DataSource under the application components Non-Assigned Nodes.
When modeling InfoObjects in BI, note that the InfoObjects have to correspond to the source object elements with regard to the type description and length description. For more information about data type compatibility, see Data Types and Their Conversion.
The following restrictions apply when using InfoObjects:
Alpha conversion is not supported
The use of conversion routines is not supported
Upper and lower case must be enabled
These InfoObject settings are checked when they are generated.
Based on the large number of possible UD Connect sources, the most diverse data types are possible in the output system. For this reason, a compatibility check is made at the time of generation of the UD Connect DataSource that is based on the type information supplied by the source systems. This attempts to decrease the probability of errors during the extraction process.
Following data type assignments are permitted:
Data Type in SAP BW
Data Type in the UD Connect Source
ACCP
C
CHAR
All except X and b
CUKY
C
CURR
P, I
DATS
D, g
DEC
P, I
FLTP
F, I
INT1
B
INT2
S
INT4
I
LCHR
G, V
NUMC
I
PREC
b
QUAN
I, P
SSTR
C
STRG
g
TIMS
T
VARC
All except X, P, F
UNIT
C, g
Abbreviations for the data types of UD Connect sources:
C character
X hexadecimal
P packed decimal, decimal
I integer
n numeric string
D date
b tiny int
g, G long string
F float
s small int
V variable character
T time
All the things i get from sdn...
Thanks & regards
Shivanjali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.