IIDR MSSQL Agent Installation

For deployment model option 1, the IIDRClosed IBM Infosphere Data Replication. This is a solution to efficiently capture and replicate data, and changes made to the data, on relational source systems. Used to move data from DataBases to the In-Memory Data Grid. source database agent should be installed on a source database server.

The following instructions should be followed to complete the installation for the IIDR MSSQL Agent on the SQL Server database server.

The IIDR MSSQL Agent should be installed on the same server where MSSQL database is running

  1. Login to the server as the OS user that was defined in MSSQL Source Prerequisites

  2. Download the IIDR MSSQL software (ask Gigaspaces customer support for a most updated IIDR software download link). For example, the IIDR Agent of 11.4.0.4 version is delivered in a form of an exe file : setup-iidr-11.4.0.4-5672-x86.exe

  3. Perform the following steps to start the IIDR Agent installation

    1. Open an ms-dos command prompt and set the JAVA_TOOL_OPTIONS variable with the following value:

      set JAVA_TOOL_OPTIONS="-Dos.name=Windows Server 2016"
    2. From the same DOS session, start the IIDR Agent installer.

      C:\Users\dih\Downloads>setup-iidr-[version #].exe
  4. Now install the new product: Under Introduction, select Install new product:

  5. Under Select Datastore Type, select Microsoft SQL Server:

  6. Under Select Offering, select IBM InfoSphere Data Replication:

  7. Under Choose Install Folder, keep the default installation folder:

  8. Under, License Agreement accept the license terms agreement:

  9. Under Choose a Shortcut Folder, select On the Desktop for more convenient access:

  10. Under Choose Instance Folder, keep the default location for the creation of instance and product logs:

  11. Start the installation:

  12. At the conclusion of the IIDR software installation process, select Launch Configuration Tool as this must be launched:

     

Once the IIDR Agent instance configuration tool has been launched, complete the IIDR Agent configuration by following these steps:

  1. In the Instance Configuration tab, enter the following parameters in the Instance section:

    1. Name: MSSQL

    2. Staging Store Disk Quota (GB): Reduce from the default of 100GB to 1GB

  2. Define the encryption profile.

    1. Under Encryption profile, click Manage:

    2. Click Add to add a new encryption profile:

    3. For the new encryption profile, provide the following parameters:

    1. Profile name: dummy

    2. Encryption: Disabled

    3. Returning to the In the Instance Configuration tab, under Encryption profile, select dummyas the working encryption profile for this agent:

  3. In the Instance Configuration tab's Database section under the Database Authentication and Refresh Loader sections populate using the following parameters:

      1. Name: dev1 (for example)

      2. User and Password: Use those defined in the prerequisite step

      3. Refresh Loader Path: Choose a folder

      4. Start the IIDR Agent creation

        For the newly created MSSQL database you may get the following message at the end of the IIDR instance creation. This means that database requires a full backup. Ask the DBA to complete a full database backup.

  4. Start the IIDR Agent instance:

  5. A successfully started IIDR Agent instance will look similar to this:

Next step: Pipeline Setup Via Subscription Manager and SpaceDeck