Forum Discussion
Solved
DB2 IDAA
Please, does anybody know, whether and how you can enable the IBM DB2 Accelerator (IDAA) in the Advanced Editor of Power Query? I have the following: let Source = DB2.Database("Server", "Database",...
Our solution is to change the syntax in Power Query using Advanced Editor
= DB2.Database("server", "database", [HierarchicalNavigation=true, Implementation="Microsoft", Query="SET CURRENT QUERY ACCELERATION=ENABLE; SELECT * FROM database.table FOR READ ONLY;"])
I am looking for a feasibilty test to check if we can connect to the DB2 IDAA via Power BI, by looking at the question I do understand that we can connect to it but just for confirmation - we can connect to db2 IDAA enables via power just like the normal db2 connect and then in query mention that this should be processed via IDAA (which is the actual question of this post). This understading is correct?
Apologies in advance for the dumb question.