How to update mongosqld system variables?

I want to change the default value of max_num_global_tables. I followed this document And as mentioned I installed MySQL client, connected to bi connector, and used set global max_num_global_tables=10000; and then I connected MySQL again. Now I checked show variables; and it’s showing the updated value for max_num_global_tables. Now I restarted the bi connector inorder to re-map the DBS but then the value went back to the default value. So how can I change it in bi connector itself? (because the default value is 4000, its not mapping all the dbs and collection we have in mongo)

I have posted a question in stackoverflow for the same with more info: