Are the tables all in a single DB? Accessed via a single JDBC connection? If so, then I believe you can use a BatchInsertSQL service. The restriction of the BatchInsertSQL is that the connection must use LOCAL_TRANSACTION. A single transaction context can use only one LOCAL_TRANSACTION connection–but you can access any number of tables within that connection.
If the tables are in different databases, or accessed via different JDBC connections, you cannot use a BatchInsertSQL service but you can use InsertSQL, CustomSQL, or DynamicSQL services. Use JDBC connections that are configured to use XA_TRANSACTION.
Be sure to review the JDBC Adapter User’s Guide thoroughly to make sure you get things set up to do what you need.
Someone please jump in to correct me if I got any of this incorrect.