Update data source in Unica Insights report design files using Unica Insights utility

Once you copy db specific files as per the details mentioned above, you must update data sources which are required to run the reports using insightsdbutil.sh/bat located at <PLATFORM_HOME>/Insights/tools/bin.

The parameters required to run this utility are:

• ds for product datasource
• bPath for Unica Insights report design file path
• DBType for Unica Insights design file database type
• URL for JDBC url for database
• user for database user
• pwd for database user password

Sample command to update the parameters:

insightsDBUtil -ds=<datasource name>
        -bPath=<Report folder path> -DBType=<databasetype> [-URL=JDBC connection URL>] [-user=<database
        user>] [-pwd=<database password>] [-locale=<Locale>]

The following command allows you to view the utility usage.

insightsDBUtil -h

The following command allows you to view the usage for localize.

insightsDBUtil -h -locale=<Locale>

Instructions:

For the first time, all parameters are mandatory.

Users are required to provide all parameters and JDBC URL in expected format as mentioned in help for specific database.

• Update password : -ds, -DBType, -URL -bPath and -pwd is mandatory
• Update user name : -ds, -DBType, -URL -bPath and -user is mandatory
  Note: If username and password string contain any special characters, then please enclose them with double quotes(“).

Parameters help:

• bPath : Unica Insights report design file path :mandatory
• ds : This parameter is for product data source : mandatory
• ds: Available options (case sensitive)
• ds : Product : Campaign -> CampaignDS
• ds : Product : Deliver -> DeliverDS
• ds : Product : Plan -> PlanDS
• ds : Product : Interact -> InteractDTDS
• ds : Product : Interact -> InteractRTDS
• ds : Product : Interact -> InteractLearningDS
• ds : Product : Interact -> InteractETLDS
• ds : Product : Collaborate -> CampaignDS
• ds : Product : Collaborate -> CollaborateDS
• ds : Product : Collaborate -> CustomerDS
• DBType : This parameter is for Database type : mandatory

  DBType available options

• DBType : Database : Sql Server -> sqlserver
• DBType : Database : DB2 -> db2
• DBType : Database : Oracle -> oracle
• DBType : Database : MariaDB -> mariadb
• DBType : Database : OneDB -> onedb

  URL

• URL : This parameter is required for JDBC connection

URL is mandatory for the first time and when any parameter of JDBC URL changes.

URL Available options

• URL : Database : Sql Sever -> "jdbc:sqlserver://<HOST>:<PORT>;instance=<INSTANCE/OPTIONAL>;databaseName=<DB NAME>"
  Note: In case of Microsoft SQL Server, the URL must be enclosed within quotation marks (" "), as shown in the earlier examples. If you do not enclose the URL within quotation marks, you will see an error.
• URL : Database : DB2 -> jdbc:db2://<HOST>:<PORT>/<sid>
• URL : Database : Oracle -> jdbc:oracle:thin:@<HOST>:<PORT>:<sid>
• URL : Database : MariaDB -> jdbc:mariadb://<HOST>:<PORT>/<DATABASE>
• URL : Database : OneDB -> jdbc:informix-sqli://<HOST>:<PORT>/<DB Name>:DELIMIDENT=Y;DB_LOCALE=en_us.utf8
• user : Database user name
• pwd :Database password

Database : DB2 -> jdbc:db2://<HOST>:<PORT>/<sid>:
      useJDBC4ColumnNameAndLabelSemantics=false;