Create Datastore for MYSQL DB
Login to DS Designer with local repository credentials
In Local object, worry go to Datastore (Tab)
Right-click and select new Provide DST Name DSI Datastore
DST Type is a database.
DB Type MSSQL 2005
DB Server name DB
So will get stored procedures, physical tables, and template table
Double click on the physical table will get a list of tables which are related to our source database
Note: - We need to import only required tables rather than all tables to increase the performance
We can convert template tables to physical tables.
Inclined to build a profession as SAP HANA Developer? Then here is the blog post on, explore SAP HANA Training
SAP ERP is recognized in DS as SAP Application DST. From SAP Application DS we call use metadata which is in the form of
The above metadata can be extracted & loaded unto SAP BW and any DB
Log on DS designer with local reposting credentials In Local object Library go to the data store (tab) Right-click add select row Provide Datastore name
NOTE:- Normally when you read the data from SAP R3 system it is recommended to use ABAP dataflow Over normal dataflow If we want to store ABAP programmers in SAP systems we can select execute preloaded Celebrate & execute option the system generated ABAP code resides on DS and it will be reused for executions Whereas if you select execute preloaded then the ABAP code will be generated and reminds at SAP APPL servers DS uses 4 different data transfer methods
a) Direct directory Using DS Using RFC can
b) Shared directory Using SAP Transports
c) FTP Using Remote Server
d) Custom Transfer Using Auto Execute Program
Note When you don’t provide a surety profile DS will take SAP-ALL If we want to restrict we need to create a seared profile and provide here Ok After creating DS we can create metadata
a) Extractors [Set of the data source provided by B1 content/custom]
b) Functions [Set of functional mapping to ERP system is achieved by ABAP code this is reformed as a function module which can be extracted & loaded dumped into any forget SAP BW/Data based]
c) Hierarchies [During the preparation of the source system you map functional data to the SAP ERP system with a hierarchy
EX: - Cost center, GL amounts, eh, custom datastore
d) IDocs are preferred to load the data into the target system when we used to transfer the data file it is Sinclair to an on-directed staging area
e) Tables [SAP R3 DB tables]
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox