3 Replies Latest reply on Nov 5, 2013 8:12 AM by Ramesh Reddy

    teiid vdb with mysql data source

    Raymond Ng Newbie

      Hi i am new to Teiid and trying to build a MySQL data sources with vdb connect to these db servers.

       

      So far i could get the data source and vdb running but for some DB, the vdb is fail to build the DDL schema for the mysql database, it show "No Content Available" in the JBoss Admin Panel model DDL tab, and show no error in server start up and reload VDB. The vdb is working fine if i change to other mysql schema with same mysql user and connection. 1. Are there a upper limit on the number of tables inside the MySQL schema? 2. will the mysql table engine type or encoding affect the Teiid on building the vdb?

       

      Thanks a lot.