Unable to connect to Teiid Instance from Designer

[klsateesh]

Hi All,

  I downloaded the latest versions of JBoss AS (7.1) and Teiid 8.0.0 and i have used the Designer to create a VDB and when i try to connect to the Teiid Instance from the Designer i cannot connect.

  Here are the steps i have followed.

1) started the JBoss AS using the command

 C:\apps\jboss-as-7.1.1.Final\bin> standalone.bat --server-config standalone-teiid.xml

   I have copied the Teiid Final Dist to Jboss AS 7.1

2) From the Designer i created a Teiid Instance and here are the properties i have set.

   

     I have the checked the file C:\apps\jboss-as-7.1.1.Final\modules\org\jboss\teiid\main\conf\teiid-security-users.properties and it has the proper user name and password defined.

    Not sure what i am missing.

Thanks

[klsateesh]

Also when i checked the deployment folder in the JBoss AS i only see the following.

C:\apps\jboss-as-7.1.1.Final\standalone\deployments> dir

teiid-connector-file.rar

teiid-connector-file.rar.deployed

teiid-connector-ldap.rar

teiid-connector-ldap.rar.deployed

teiid-connector-salesforce.rar

teiid-connector-salesforce.rar.deployed

teiid-connector-ws.rar

teiid-connector-ws.rar.deployed

Thanks

[rareddy]

Sateesh,

Teiid 8.0 does not work with Teiid Designer 7.7, for any preview query purposes. The compatible Teiid Designer 8.0 is currently in works. However, you can still use the Teiid Designer 7.7 to develop your VDB, then manully deploy into the Teiid 8.0 server and then connect with JDBC driver from your application.

Thanks

Ramesh..

[klsateesh]

Ramesh thanks for the info.

When i created the VDB's using Designer it created few files with .xmi and .vdb extensions.

Do i need to create a *vdb.xml in order to deploy this to Teiid ??

The documentation i have gone through so far talks about manually creating a *vdb.xml file and *vdb.xml.dodeployer files.

It looks like these are different versions all together. As the .xmi files generated have mmcore namespace prefix and none of the elements seems to match the elements  in the sample "*vdb.xml" files.

Thanks

Sateesh

[rareddy]

Sateesh,

Teiid support VDBs in two forms.

1. Dynamic VDB - Simple XML file based VDB
2. Designer Based VDB - Graphical tool which provides rich interface with lots of wizards to create a VDB archive.

The document you are looking at may be talking about (1). Take look at Quick Start Guide for example of this. For Designer based VDB take look at this article. 

Let us know if you have questions.

Ramesh..

[klsateesh]

Hi Ramesh,

  Yes i am working with Designer based VDBs. And using the Designer i am able to create the VDBs.

  But i couldn't find any info reg how i am going to deploy thses vbds into JBoss AS 7.1 + teiid 8.0.0 Run time.

  The Link you mentioned in your previous post talks about deploying these VDB through the Designer and in my case it is not supported (as i am using Teiid 8.0.0).

  If you can provide the info reg how one can deploy the Designer based VDB's to (JBoss AS 7.1 + teiid 8.0.0) manually that will be of great help.

Thanks

Sateesh 

[rareddy]

Sateesh,

Sure. Please the Teiid Admin Guide for details. Here is the relevant chapter you are looking for Deploying VDBs in Teiid8

Ramesh..

[klsateesh]

Thanks for the info Ramesh.