What is the difference between using the BI integrator and using PI SQL Client to get data in a BI tool? is one preferred over the other.
The preferred method really depends on your use case, how and when you see the views being created, and what type of queries expect to be made. From the end user's point of view it doesn't matter as they will be able to access data in their BI tools using the same method either way.
Below are some general points comparing the two methods. If you are comfortable sharing more information about your use case on a public forum we may be able to give you more detailed advice, otherwise, your account manager would be able to have a discussion with you about the pros and cons as they relate to your industry and use case.
My general advice would be to consider the users who will be creating the views for consumption in the BI tool. If they do not have much SQL experience then I would recommend the integrator due to the ease of creating views and that it allows for a self-service method of accessing data. If these users are comfortable writing SQL queries then the PI SQL Client is an option, though it's not clear which is the better option without more information.
Retrieving data ...