Based on the Microsoft Azure HDInsight platform, with infrastructure based on Apache Kylin, Kyligence Cloud provides an elastic computing architecture and a pay-as-you-go price model, suiting dynamic computing use cases, and reducing operational costs to accelerate business development through cloud technology.
The Kyligence Cloud connector enables connectivity to Strategy Web, enhancing the Strategy product with support for Kyligence Cloud.
For more information please refer to http://kyligence.io/
 

Table of Contents

1. Prerequisites
   
2. Installation
   
1. Update Database Object
   
2. Update data type mapping on Intelligence Server
   
3. Install Connector in all MicroStrategy Web Machines in the Cluster
   
4. Install connector in MicroStrategy Workstation/Desktop
   
3. Validating Correct Installation
   
4. Uninstall
   
5. Remove Database Object
   
6. Remove connector from MicroStrategy Web
   

1. Prerequisites

1. Strategy Secure Enterprise should be installed and configured, including an instance of Strategy Developer, Strategy Web, and the Strategy Intelligence Server.
2. The Kyligence ODBC driver has been installed on the machine containing your Strategy Intelligence Server.
3. Download and decompress the KyligenceConnectorFiles.zip file attached to this article below.

Please refer to the following links to download and install Kyligence ODBC driver:

• http://download.kyligence.io/
• http://docs.kyligence.io/v2.5/en/driver/kyligence_odbc.en.html

2. Installation

The installation of this connector comprises of 4 steps.

1. Update DBMS object
2. Update data type mapping
3. Install connector in Strategy Web
4. Install connector in Strategy Workstation and/or Strategy Desktop

2a. Update DBMS object

1. Copy DATABASE_KAP.PDS file onto a machine with Strategy Developer installed.
2. Follow the steps in KB43537  to load the DBMS object in the DATABASE_KAP.PDS file into Strategy metadata.

KB43537: How to install DBMS objects provided by Strategy Technical Support
 

2b. Update data type mapping on Intelligence Server

1. Copy the file DTMAPPING.xslt and AddConnector.jar files to all the Intelligence Server machines that need to be upgraded
2. Find the location of the DTMAPPING.pds file of the Intelligence Server installation
   
• On Windows the default location is C:\Program Files (x86)\Common Files\Strategy, also referred to in the  $MSTR_CLASSPATH environment variable
3. Run the following command replacing <location> with the folder where dtmapping.pds file is located.
   
• Note: Running the command requires the privileges to copy and modify the existing dtmapping.pds file.
• Note: the command will create a backup of the original file in <location>.

java -jar AddConnector.jar --target “<location>\ DTMAPPING.pds” --file DTMAPPING.xslt

1. Restart Intelligence Server.

2c. Install connector in all Strategy Web machines in the cluster

1. Copy the file DBproperties.xslt and AddConnector.jar files to all the machines that run Strategy Web. Use the location of the files to replace <location1> for the command in step 3.
2. Find the location of the DBProperties.xml file. Use this location to replace <location2> as the path to the DBProperties.xml file in the command in step 3. The file can be found in the directory where Strategy Web is deployed. This path will be different depending on the application server used. The following are common examples:
   
• Microsoft IIS: C:\Program Files (x86)\MicroStrategy\Web ASPx\WEB-INF\xml\DBproperties.xml
• Tomcat (on Windows): C:\Program Files (x86)\Common Files\MicroStrategy\Tomcat\apache-tomcat-8.0.30\webapps\MicroStrategy\WEB-INF\xml\DBProperties.xml
• Tomcat (on Linux): /opt/apache/tomcat/apache-tomcat-8.0.43/webapps/MicroStrategy/WEB-INF/xml/DBproperties.xml
3. Run the following command replacing <location2> with the folder where DBProperties.xml file is located.
   
• Note: Running the command requires the privileges to copy and modify the existing DBproperties.xml file
• Note: on Windows the <location> needs to finish with a backslash (“\”) on Linux with a forward slash (“/”) character
• Note: the command will create a backup of the original DBProperties file in <location2>.

 
java -jar <location1>AddConnector.jar --target <location2>DBProperties.xml --file <location2> DBproperties.xsl

1. After running the above command, please restart your application server.
2. For configuring the connector icon:
   
• By default, the icon in Data Import home page is general icon for Database like below

• To customize your own icon, put the below image found in the KyligenceConnectorFiles.zip file as "Kyligence.png" in the location <MSTR_WEB_SERVER>\javascript\mojo\css\images\DI\connectors\

2d. Install connector in Strategy Workstation/Desktop

1. Follow the two steps in Web platform configuration to update DBProperties.xml file
2. Update DBProperties.json
   
1. Decompress the utils.zip found attached
2. Run the run.bat script as administrator from the command line on windows, and note that running the script requires that you install JRE 8 or above
3. After running the script, the tool will automatically convert original DBProperties.xml into two new files -- DBProperties.json32 and DBProperties.json64, rename DBProperties.json64 to DBProperties.json and replace the old file in workstation/Desktop with this new file
   
• Old File location: <MSTR_WINDOWS_WORKSTATION/Desktop>\code\config for Windows Platform.
3. To customize your own icon, put the icon image named "Kyligence.png" in the location <MSTR_WINDOWS_WORKSTATION>\code\javascript\mojo\css\images\DI\connectors\ for Windows Workstation.
4. Replace the DATABASE.PDS and DTMapping.PDS in workstation with the two files you configured in previous steps.
   
• DATABASE.PDS and DTMapping.PDS location: C:\Program Files (x86)\Common Files\Strategy
  
5. Restart Workstation/Desktop.
6. Notice that Kyligence is not available in Mac Workstation yet since Kyligence JDBC driver is not supportive at this stage.

3. Validating correct installation

1. Connect to Strategy web, click “Add external data”, type “Kyligence” in filtering bar at the upper-right corner, and you will find Kyligence lists in the main panel.
2. Choosing a query type (Select Tables, Type a Query, Build a Query)
3. Choose the radio button for DSN-less Data Sources
4. Open the “Database” drop down list. You should be able to see Kyligence as an option.

4. Uninstall

To remove the installation of this connector it is necessary to reverse the installation steps.

1. Remove database object
2. Remove connector from Strategy Web

5. Remove Database Object

1. Open Strategy Developer
2. Remove any dependency on the connector. This might require modifying or deleting any Database Instance that uses this connector.
3. Open any DB instance for editing, click on Upgrade
4. Select the database object from the list of available database objects on the lower right panel
5. Click on the “left arrow” to remove the database object
    

6. Remove connector from Strategy Web

1. Connect to Strategy Web machine and find the backup file created as part of the installation of this connector. E.g. DBProperties.xml.bak20180302161908
2. Remove file DBProperties.xml
3. Rename DBProperties.xml.bak20180302161908 to DBProperties.xml
4. Restart Application Server