Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Import SQL server table to Qlikview through C#

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.

4 Replies
danielrozental
Honored Contributor II

Re: Import SQL server table to Qlikview through C#

Why? That makes no sense.

You should read the SQL table directly.

Not applicable

Re: Import SQL server table to Qlikview through C#

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.

jerrysvensson
Valued Contributor II

Re: Import SQL server table to Qlikview through C#

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.

Not applicable

Re: Import SQL server table to Qlikview through C#

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.

Community Browser