Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Microsoft SQL Azure

Has anybody connected qlikview with Microsoft SQL Azure with QVSource? I'm just thinking of strategies to use qlikview in tandem with a cloud solution.

Alex

7 Replies
chrisbrain
Valued Contributor

Microsoft SQL Azure

I haven't used MS SQL Azure yet but it does appear there is an OData service for it which can be enabled and QVSource does have an OData connector.

If you would like to contact me directly we can work with you to make sure it's working with SQL Azure as expected.

MVP
MVP

Microsoft SQL Azure

Hi Alex,

have you read this: Microsoft JDBC Driver 3.0 for SQL Server and SQL Azure

I would expect that this would work directly with our QlikView JDBC Connector:

http://community.qlik.com/docs/DOC-2438

It's just a matter of configuration. I can give you some support on this. Would be very interesting for us if this works.

- Ralf

Not applicable

Microsoft SQL Azure

Actually, I have read that before, but I'm not much of dev guy, so it's a little over my head. But I will take another look at it. Thanks for the resource.

chrisbrain
Valued Contributor

Microsoft SQL Azure

Yea the JDBC driver sounds like a better idea in this case.

MVP
MVP

Microsoft SQL Azure

As I said we would support you on this..

MVP
MVP

Microsoft SQL Azure

Btw. the regular way is to use an ODBC connect.

MVP
MVP

Re: Microsoft SQL Azure

If you have no ODBC driver (or to say you have no MS SQL license) it works with our QlikView JDBC Connector: http://jdbcconnector.com

and the MS SQL JDBC 4 driver.

Just see an exapmle here: http://twitpic.com/9099lj

- Ralf

Community Browser