asked
extract data from TOAD and SAPBW to SQL
HI , I want to extract data from TOAD and SAPBW to SQL is possible to do this. If Yes,Please help me how to do it. Regards, Kandan.M
I don't know much about those tools but this is a very vague question so far. Can you explain a bit more? What data? Where is it currently? Is this a one-off copy or will it need to be regular? More information will improve your chances of getting some answers.
Hi David, My Data Sources are TOAD and SAPBW,Few region sales data where stored in TOAD and few in SAPBW. I have to combine both sets of data then I have to do some data massaging process in SSIS then it has to stored SQL table. I have no Idea how to create a source connection to Toad and SAPBW in SSIS or Sql. I hope above information will help you to understand my scenario
Surely Toad is a client tool, not a database. Isn't the data you're looking at in Toad actually stored somewhere else?
It looks like there's an SSIS connector for SAP BW:
https://msdn.microsoft.com/en-us/library/hh245078.aspx.
Yes,your correct, Master source is SAP BW.
18 People are following this question.
