What is the use of DB connection in SAP BW data acquisition?

1.	What is the use of DB connection in SAP BW data acquisition?
Answer» DB connect is used to define other database connection in addition to default connection and these connections are used to transfer data into BI system from tables or views. To connect an external database, you should have below information − Tools Source Application knowledge SQL syntax in Database Database functions

Answer»

DB connect is used to define other database connection in addition to default connection and these connections are used to transfer data into BI system from tables or views.

To connect an external database, you should have below information −

Tools
Source Application knowledge
SQL syntax in Database
Database functions

Discussion

No Comment Found

Related InterviewSolutions

What is UD connect in SAP BW system? How does it allow reporting in BI system?
What is the use of DB connection in SAP BW data acquisition?
How data is stored in PSA?
In SAP BW, is it possible to have multiple data sources have one InfoSource?
To load the data from a file source system, what is requirement in BI system?
While loading data from flat files, when separators are used inconstantly. How this will read in BI load?
What is the use of Navigational attributes?
Explain the difference between InfoCube and ODS?
What is Partition of an InfoCube?
How can you achieve performance optimization in SAP Data Warehouse?

What is the use of DB connection in SAP BW data acquisition?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment