How to connect Teiid Designer with dockerized Teiid instance

[dieman.one]

Hello,

Can Teiid Designer work with dockerized standalone Teiid instance?

If yes, is there any manual describing config steps in detail?

Just following the same sequence of steps as with locally installed Teiid doesn't seem to work.

One obvious contradiction: as soon as the docker container starts, Teiid server is up, but the Teiid designer would show it as a server that is down and ask to start it, and this doesn't work. 

Thanks!

[rareddy]

If you are starting Teiid in Docker, then you need to expose the management and JDBC ports on docker then configure Designer to connect to an external server using those exposed ports.

[dieman.one]

Is there any documentation describing these steps?

It is easier said than done, I am afraid...so far I was not able to control a docker-based Teiid from the Designer app

[rareddy]

Follow below.

# Pull the docker image from the Docker Hub
$docker pull jboss/teiid

# Start the Docker Image
$docker run -p 8080:8080 -p 9990:9990 -p 31000:31000  -p 35432:35432 --name myteiid -it jboss/teiid

# Connect to the docker image, we need to create an admin and application user
$docker exec -it myteiid sh
sh-4.2$
sh-4.2$ wildfly/bin/add-user.sh 

What type of user do you wish to add?
a) Management User (mgmt-users.properties)
b) Application User (application-users.properties)
(a): a

Enter the details of the new user to add.
Using realm 'ManagementRealm' as discovered from the existing property files.
Username : admin
User 'admin' already exists and is disabled, would you like to...
a) Update the existing user password and roles
b) Enable the existing user
c) Type a new username
(a): a
Password :
Are you sure you want to use the password entered yes/no? yes
Re-enter Password :
What groups do you want this user to belong to? (Please enter a comma separated list, or leave blank for none)[  ]:
Is this new user going to be used for one AS process to connect to another AS process?
e.g. for a slave host controller connecting to the master or for a Remoting connection for server to server EJB calls.
yes/no? no
sh-4.2$
sh-4.2$ wildfly/bin/add-user.sh

What type of user do you wish to add?
a) Management User (mgmt-users.properties)
b) Application User (application-users.properties)
(a): b

Enter the details of the new user to add.
Using realm 'ApplicationRealm' as discovered from the existing property files.
Username : user
Password :
Are you sure you want to use the password entered yes/no? yes
Re-enter Password :
What groups do you want this user to belong to? (Please enter a comma separated list, or leave blank for none)[  ]: odata
About to add user 'user' for realm 'ApplicationRealm'
Is this correct yes/no? yes
Is this new user going to be used for one AS process to connect to another AS process?
e.g. for a slave host controller connecting to the master or for a Remoting connection for server to server EJB calls.
yes/no? no
sh-4.2$
sh-4.2$ exi

ttt

Now remember the user names and passwords from above. Look at last comment in this form thread and configure an external Teiid Server.

Remote connection to teiid server from designer

There may be other ways to create the users so that you do not recreate after starting the container, but this may be easiest for now.