Moved to Teiid forum.
To load translator, first you care your JAR file for the translator, then you can do one of these
1) Create "module" for it in the "modules" directory and then edit the standalone-teid.xml file and add the "translator" definition to it and restart.
2) Use CLI/web-console/admin-api to deploy the JAR file into JBoss AS.
(1) is recommended, but you can also use (2) if you are making it programmatically available.