Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Why? That makes no sense.
You should read the SQL table directly.
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.
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.
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.