1 Reply Latest reply: Jan 30, 2017 6:12 AM by hannachi mohamed RSS

    SQL WriteBack Deployement

    hannachi mohamed

      Hello,
      I have use SQL Writeback from Qlikview Extension Object (https://community.qlik.com/docs/DOC-5970#start=25)
      The extension use WCF web Service to take data from QlikView and transform it to Insert SQL Query.


      The extension work when I start le WCF web Service Manually (with Visual Studio for Web).


      The Problem is how I can start the WCF Web Service automaticly ? I need to deploy it in QlikView Server (with IIS or as a Windows Service) ?

        • Re: SQL WriteBack Deployement
          hannachi mohamed

          Hello, i have solved it, WCF Web service can be hosted by IIS.
          You can create new web site IIS in your server: New_web_Site:PortNumber

          1. Open IIS Manager.
          2. In the Connections pane, right-click the Sites node in the tree, and then click Add Web Site.
          3. In the Add Web Site dialog box, type a friendly name for your Web site in the Web site name box.
          4. Click Select if you want to select a different application pool than the one listed in the Application Pool box. In the Select Application Pool dialog box, select an application pool from the Application Pool list and then click OK.
          5. In the Physical path box, type the physical path of the Web site's folder, or click the browse button (...) to navigate the file system to find the folder.
          6. If the physical path that you entered in step 5 is to a remote share, click Connect as to specify credentials that have permission to access the path. If you do not use specific credentials, select the Application user (pass-through authentication) option in the Connect As dialog box.
          7. Select the protocol for the Web site from the Type list.
          8. The default value in the IP address box is All Unassigned. If you must specify a static IP address for the Web site, type the IP address in the IP address box.
          9. Type a port number in the Port text box.
          10. Optionally, type a host header name for the Web site in the Host Header box.
          11. If you do not have to make any changes to the site, and you want the Web site to be immediately available, select the Start Web site immediately check box.
          12. Click OK.