I thought that the solution for this problem is we have one option is there in connection pool i.e "Required fully qualified table names" . we have to check this option.Then we can onnect to the multiple schemas using a single connection pool.
I dont think fully qualified names will not work here please correct if I am wrong. Rather shared logon guess should work but did not in my case.
The fully qualified names are based on the physical object names in the repository. If you are querying the same tables from which the physical layer metadata was imported, you can safely check the option. If you have migrated your repository from one physical database to another physical database that has different database and schema names, the fully qualified names would be invalid in the newly migrated database. In this case, if you do not select this option, the queries will succeed against the new database objects.
For some data sources, fully qualified names might be safer because they guarantee that the queries are directed to the desired tables in the desired database. For example, if the RDBMS supports a master database concept, a query against a table named foo first looks for that table in the master database, and then looks for it in the specified database. If the table named foo exists in the master database, that table is queried, not the table named foo in the specified database.