> Can I use javax.sql.DataSource in TeiidEmbeddedServer.SimpleConnectionFactoryProvider?
Yes, that is what the JDBC translator expects to see.
You can also use the method EmbeddedServer.addConnectionFactory which will do the wrapping for you.
> org.teiid.translator.TranslatorException: TEIID31097 Metadata load requires a connection factory
Does the connection name on the source match the name of the connection factory provider? Can you show the relevant vdb configuration?
Actually, it worked after I switched to use EmbeddedServer.addConnectionFactory. Thanks for the suggestion.