Version 15
    Item
    Content
    Note
    Install from source
    $ cd teiid
    $ mvn clean install -Dmaven.test.skip=true -P release -Dmaven.javadoc.skip=true -s settings.xml
    $ cd build/target/
    $ unzip teiid-8.13.0.Alpha2-SNAPSHOT-wildfly-server.zip
    $ cd teiid-8.13.0.Alpha2-SNAPSHOT/
    $ ./bin/standalone.sh
    $ ./bin/jboss-cli.sh --connect --file=bin/scripts/teiid-standalone-mode-install.cli
    $ ./bin/domain.sh
    $ ./bin/jboss-cli.sh --connect --file=bin/scripts/teiid-domain-mode-install.cli
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    Teiid Source Code
    Create User
    ./bin/add-user.sh -a -u dashboardAdmin -p password1! -g admin
    ./bin/add-user.sh -a -u teiidUser -p password1! -g user
    ./bin/add-user.sh -a -u restUser -p password1! -g rest
    ./bin/add-user.sh -a -u odataUser -p password1! -g odata
    ./bin/add-user.sh admin password1!
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    JDBC
    $ cd teiid-8.13.0.Alpha2-SNAPSHOT/
    $ cp -r ~/src/teiid-quickstarts/dynamicvdb-datafederation/src/teiidfiles/ ./
    $ cp ~/src/teiid-quickstarts/dynamicvdb-datafederation/src/scripts/setup.cli ./
    $ ./bin/jboss-cli.sh --connect --file=setup.cli
    $ cd standalone/deployments/
    $ cp ~/src/teiid-quickstarts/dynamicvdb-datafederation/src/vdb/portfolio-* ./
    
    
    
    
    
    
    
    
    
    
    
    

    The test includind: JDBC Translator, Excel Translator, Directly Query,

    Federation, Materialize, etc

    ws translator, ws resource adapter
    $ cd teiid-quickstarts/webservices-as-a-datasource/
    $ mvn clean install
    $ cp target/CustomerRESTWebSvc.war ~/teiid-8.13.0.Beta2-SNAPSHOT/standalone/deployments/
    $ cd teiid-8.13.0.Beta2-SNAPSHOT/
    $ cp ~/src/teiid-quickstarts/webservices-as-a-datasource/src/scripts/setup.cli ./
    $ ./bin/jboss-cli.sh --connect --file=setup.cli
    $ cd standalone/deployments/
    $ cp ~/src/teiid-quickstarts/webservices-as-a-datasource/src/vdb/webservice-vdb.xml* ./
    
    Cluster
    $ cd teiid-8.13.0.Alpha2-SNAPSHOT/
    $ cp -r ~/src/teiid-quickstarts/dynamicvdb-datafederation/src/teiidfiles/ ./
    $ cp ~/src/teiid-quickstarts/dynamicvdb-datafederation/src/scripts/setup-domain.cli ./
    $ ./bin/jboss-cli.sh --connect --file=setup-domain.cli
    $ ./bin/jboss-cli.sh --connect
    deploy ~/src/teiid-quickstarts/dynamicvdb-datafederation/src/vdb/portfolio-vdb.xml --server-groups=main-server-group
    
    
    
    
    
    
    Cluster in Teiid
    adminshell

    Install from source

    $ unzip teiid-8.13.0.Alpha2-SNAPSHOT-adminshell-dist.zip
    $ cd teiid-adminshell-8.13.0.Alpha2-SNAPSHOT
    ./adminshell.sh
    
    
    
    
    

    Basic Commands

    groovy:000> adminHelp();
    groovy:000> sqlHelp();
    groovy:000> sql = connect("jdbc:teiid:Portfolio@mm://localhost:31000", "teiidUser", "password1!");
    groovy:000> sql.eachRow("select * from Stock") { println "${it}" }
    
    
    
    

    Executing example files

    $ ./adminshell.sh -Dvdbname=sample -Dvdbfile=test-vdb.xml . ./examples/DeployAndVerifyVDB.groovy
    $ ./adminshell.sh -Djarfile=mysql-connector-java-5.1.30.jar . ./examples/DeployJar.groovy
    $ ./adminshell.sh -Dvdbname=Portfolio . ./examples/PrintVDBInfo.groovy
    $ ./adminshell.sh -Dvdbname=Portfolio . ./examples/PrintAllVDBAndDatasources.groovy
    $ ./adminshell.sh -Dvdbname=Portfolio . ./examples/RestartServer.groovy
    
    
    
    AdminShell - Teiid 9.0 (draft) - Project Documentation Editor
    REST

    Procedures

    $ cd standalone/deployments/
    $ cp ~/src/teiid-quickstarts//dynamicvdb-restservice/src/vdb/portfolio-rest-vdb.xml* ./
    
    
    
    
    
    
    
    
    
    

    Test API Doc

    Test API(Run client code under dynamicvdb-restservice)

    Odata

    Test API

     

    Note: All above test base on Linux Server and Java 8