Hi Dev, welcome to JavaRanch!
Yes, you can certainly have multiple data sources. You will need a special type of
JDBC driver, called an XA driver, if you want to coordinate transactions across the multiple data sources. If you don't have that requirement, then the normal drivers will be fine.