Tuesday 21 March 2017

Exploring the SDL Mobile Devices Database

It is possible to query the SDL Mobile Devices database by using a tool such as RazorSQL.

  • Download and start RazorSQL
  • Select Connections/Connect from the main menu
  • Click the Add Connection Profile tab
  • Select HSQLDB / HyperSQL as the database type as shown below.






























  • Click Continue
  • Set a Profile Name of your choice
  • Enter value "sa" as the Login
  • Leave the Password empty
  • Click the browse button to select the Database Script File
  • Select the sdl-context-repository script file as shown below.























Your new connection profile details should now appear as follows.


































Click the Connect button to access the database. You can start querying the devices database. Below are a few examples.

Select the device names per vendor showing the default width/height information













































Select the list of OS names













































Select the list of Browser names













































Conclusion

The ability to query the devices database helps to find out which values will be set in the ADF content store. This may assist the creation of conditional logic in your implementation as well as setting up Promotions in SDL Experience Optimization (SmartTarget).

No comments:

Post a Comment