1) There are no upper limits in number of tables that can be imported from MySQL or any other database.
2) You can connect to any type of MySQL engine. No restrictions. We used MyIsan, InnoDB before without any issues.
Based on your comments look like you have to sort of some user permission issues between your two instances of MySQL.
Thanks for your reply.
It seems that the VDB and datasource is actually working and i can perform the test query on it.
It is just the JBoss EAP could not display the DDL schema for those datasource.
Are there any configuration property i could set to make the DDL Schema in JBoss EAP work again?
There is no separate configuration for it, are you working with a Dynamic VDB or you built your VDB with Designer? were there any errors in log? If the VDB is working then metadata is loaded and it should provide the DDL without any issues.