I want to perform a data extraction with SAP BW through the open hub service -- do I have to utilize a third-party tool like Informatica or Ascential? Or is this only needed if I'm sending data to database tables?
Data extraction with SAP BW doesn't require any third-party tools. Open hub service with infospoke can be used to extract data. Here are the steps:
* Transaction RSA1
* Go to Tools / Open hub service / Edit Infospoke
* Create Infospoke on cubes here which can be used to extract data
For more information, read another expert response on performing a data extraction from a Hyperion database to SAP BW.