I come from an Oracle background and we currently use flat files extracted from the database to populate our QVD's and applications but I'm just about to embark on a project to integrate one of our sister companies into Qlikview and they've suggested that we use SAP connector to retreive the data. I appologies for my ignorance but why do you need a SAP connector rather than getting flat files out of SAP?
Your thoughts and opinions would be gratefully recevied.
I don't really get your point. In my point of view it's a question about your strategy how to retrieve data from a system. Your way is to 'push' data out of the system. Using SAP Connector it is the other war round 'pulling' the data out of the system.
So if I want to 'push' my data out of SAP is that going to be quite simple for someone with no experience of a SAP database? I'm not familiar with the database structure but I've heard that some of it's in German and the data can be replicated in a variety of tables which can make it difficult to extract correctly.
i think the language is not an issue. You don't need german skills to get data out of SAP. But you need ABAP skills to write some program that retrieves data from the reevant tables and creates the export files.