Q-Integrate Installation Overview — Data Warehouse Consultants

Q-Integrate Installation Overview and Technical Info

This page provides an outline of the steps required to implement Q-integrate into your Oracle or SQL Server database environment.

Download the program files from www.dwconsultants.com/q-integrate-download.
Using Microsoft Internet Information Services (IIS) Manager, set up a website or virtual directory to hold the code.
- Define a new Application Pool for this website. Set the .NET CLR Version to “No Managed Code”. Managed Pipeline Mode is “Integrated”.
- Set the bindings to where you want the listener to be available. Note the URL for later use.
Unzip the archive you downloaded and copy all of the files to the home directory of the website you created in the previous step.
Verify your site is available. The site is running if you get this main page.
Define your database connection string for DBConn1 in the appsettings.json file. This tool currently supports Oracle and Microsoft SQLServer
- Oracle Example: Data Source= (DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = {HostName})(PORT = {Port}))(CONNECT_DATA =(SERVICE_NAME = {ServiceName})));User Id={User};Password={Password};
- SqlServer Example: Server={ServerName};Database={DatabaseName};User Id={User};Password={Password};
- Set the “DatabasePlatform” attribute to either Oracle or SqlServer as appropriate
Click this VERIFY link to check your database connection status. Look at the “Connection” attribute and
verify that isValid = true.
Once you have verified your connection string is valid, click INSTALL to install the required database components.
Click this VERIFY link again to verify all components are installed correctly.
Using Postman or a similar tool, submit a test Event Post to validate your installation.
- The REST method needs to be POST.
- The URL will be your server name with “/api/qualtrics/response”.
- The post method needs to be x-www-form-urlencoded.
- All Key/Value pairs need to be submitted.
Using your database client, validate the record you submitted in the step above is available.
- Check the target table and verify the data is presnet:
  SELECT * FROM qual_listener_response
Your setup is complete! You are now ready to subscribe to real-time events from Qualtrics. See the Qualtrics site for how to subscribe to these events.
Qualtrics API Documentation