Unable to establish jdbc connection for Teiid Installation in Teiid Designer

[pawansharma]

Hello,

I am using Teiid Designer 11.0 with wildfly 10.x and teiid runtime 9.2.6. Teiid designer throws an exception when I try to fetch data either from flat file or Oracle with invalid teiid JDBC credentials. It says username and password is incorrect for JDBC. Even when I try to test JDBC connection for Teiid runtime with default credentials user/user it says unable to connect. Can you please help me with this.

Thanks.

[rareddy]

In your WildFly/Teiid Server installation directory there is file "bin/adduser.sh" or "bin/adduser.bat" to create an "application" realm user, then use those credentials in the Teiid Designer. You can input those on Server Connection Panel. That will solve the issue.

[pawansharma]

Thank You. It Worked