topic Re: Import SQL server table to Qlikview through C# in QlikView

Import SQL server table to Qlikview through C#

Wed, 27 Feb 2013 13:47:55 GMT

Hi,

I want to import a SQL server table to Qlikview using C#.net. Can someone please tell me, How can I use Qlikview API's to do this job?

Thank you in advance!

Srinivas N.

Re: Import SQL server table to Qlikview through C#

danielrozental — Thu, 28 Feb 2013 02:30:12 GMT

Why? That makes no sense.

You should read the SQL table directly.

Re: Import SQL server table to Qlikview through C#

Thu, 28 Feb 2013 04:39:36 GMT

Thanks for the reply. I don't want to do it directly because I want to automate the process of generating Qlikview documents from SQL server. We have so many tables in SQL server. Please let me know where can I get the APIs which can be used in C# app.

Best regards,

Srinivas.

Re: Import SQL server table to Qlikview through C#

jerrysvensson — Thu, 28 Feb 2013 09:52:22 GMT

The syntax for reading data into qlikview is:

SQL SELECT *

FROM <table>

;

Dump your tables to a textfile with this syntax and then you include that file in a qlikview application.

Re: Import SQL server table to Qlikview through C#

Thu, 28 Feb 2013 10:03:39 GMT

I want to perform below operaations in my C# code exactly.

1. Create a Clikview document through C# code after adding Qlikview API reference

2. Then open a connection SQL server

3. Execute SQL query (Ex: Select * from TableName) form my application.

4. Populate the result in the Qlikview doc and finally save.

Please tell me the API names? What is AxQlikOCXLib? Share the reference documents if any.

Thanks,

Srinivas.