MicroStrategy Tool or SqlServerManagement studio connectivity to VDB

[sanjay_chaturvedi]

We have a data virtualization instance set up and running and it can be connected via Squirrel.

Can we connect this instance using BI tool like micro strategy tool ?

Can it be connectable from Sqlservermanagement studio.

Please suggest, If possible, then where to add JDBC/ODBC driver for this.

Thanks,

Sanjay

[rareddy]

Sanjay,

Yes, you can connect with the MicroStrategy using JDBC. This has been verified before. However I do not know about specifics on how to do this. You need to consult their documentation. SqlServer Management Studio, I have not heard of, if they support external sources using JDBC/ODBC driver then Yes, it should be possible.

Ramesh..

[m.ardito]

Can it be connectable from Sqlservermanagement studio.

If you wish to try this, you should explore the "linked servers" feature of SQL server management tools... you create a "Linked server" by establishing an ODBC connection (use postgresql ODBC driver to connect to Teiid server), then you can use it.

Imho, it is easy to setup, but all but simple to use this tool, though... it's not an integration tool, I tried but it then I gave up,also due to performances... I did differently. (Teiid is just magic, instead)

see Create Linked Servers (SQL Server Database Engine)

[sanjay_chaturvedi]

Well,  I got it working but option selection was different.

Select  Hadoop >> Impala >> Change the definition to put Teiid connection url and driver information. and it worked. Dont be confused with driver selected as ODBC.