Design Studio Preferences¶
The Design Studio has a local configuration page where you can configure several settings like connection settings between this Design Studio and Virtual DataPort, Kerberos authentication, etc.
This configuration is located in the endpoint denodo-design-studio/#/web-local-login
. To access this page, go to one of these URLs:
Design Studio of the Solution Manager:
https://denodo-solution-manager.acme.com:19443/denodo-design-studio/#/web-local-login
Design Studio of a Denodo Platform installation:
https://denodo-server.acme.com:9443/denodo-design-studio/#/web-local-login

Web local login¶
These settings affect all the users of this Design Studio.
The password to log in is local to this application (by default “admin”). This gives you access to this configuration page. Note that this local account does not give actual access to the main functionalities of the Design Studio, only to its local configuration.
In the menu Configuration, you will find these submenus:
Change password: in this wizard you can change the password to log in to the Preferences section of Design Studio.
Connection options: see section Connection Options.
Kerberos settings: see section Kerberos Settings.
Informative message: see section Informative Message.
Connection Options¶
In this dialog, you can configure the following parameters of the connection between the Design Studio and Virtual DataPort.

Connection options¶
Query timeout (milliseconds): Maximum time the Design Studio will wait for a query to finish. If zero, it will wait indefinitely until the sentence ends.
Chunk Timeout (milliseconds): It establishes the maximum time that the Server waits before returning a new block to the Design Studio. When this time is surpassed, the Server sends the current block even if it does not contain the number of results specified in the Chunk Size parameter.
Note
If Chunk size and Chunk timeout are zero, the Server returns all the results in a single block. If both values are different from 0, the Server returns a chunk whenever one of these conditions happen:
The chunk is filled (Chunk size)
Or, after a certain time of not sending any chunk to the client (Chunk timeout).
Chunk size (rows): The results obtained by executing a sentence can be divided into blocks (chunks), so the Virtual DataPort Server does not have to wait until a sentence ends, to send the processed tuples to the Design Studio.
This parameter establishes the maximum number of results that a block can contain.
When the Server obtains enough results to complete a block, it sends this block to the client and continues processing the next results.
Maximum number of active connections: maximum number of active connections opened by the Design Studio.
Maximum waiting time to obtain a connection: maximum time in milliseconds the Design Studio will wait for a connection before showing an error. If
-1
, the Design Studio will wait indefinitely.Use WAN optimized communications: If selected, the communications with the server will be optimized for high latency networks. May reduce performance if used in LAN environments.
Use only SSL communications: If selected, the communication with the server will be forced to be secured. If SSL is disabled on the Virtual DataPort server, the communication will fail.
Use browser user-agent: If enabled, the Design Studio will transmit the user-agent header of the client’s browser to the Virtual DataPort server. To ensure a consistent value is sent by the Design Studio, uncheck this option and enter a custom value in the input field Custom user agent (false by default).
Custom user agent: Personalized user agent the Design Studio sends to the Virtual DataPort server if Use browser user-agent is unchecked (Denodo-Web-Design-Studio by default).
Connect only to allowed Virtual DataPort Server hostnames: If selected, the Design Studio will only allow users to connect to the Virtual DataPort servers list of Allowed Virtual DataPort Server hostnames.
Allowed Virtual DataPort Server hostnames: List of allowed URLs the Design Studio can connect to. Use the button Add to define multiple URLs. The the URLs mut follow the format
hostname[port]
. For example:denodo-server1.acme.com:9999
,denodo-server2.acme.com:9999
, etc.
Kerberos Settings¶
Note
This section only applies if you connect directly to the Design Studio of the Denodo Platform installation
(e.g. http://denodo-server.acme.com:9443/denodo-design-studio/
) and you want to use Kerberos authentication.
We recommend using the Design Studio of the Solution Manager (https://solution-manager.acme.com:19443/denodo-design-studio/
) because the Solution Manager provides a single point of access to all the Denodo components, not just the Design Studio. In addition, users will be able to use more Single Sign On protocols like OAuth or SAML, not just Kerberos, to log in to Design Studio. In this case and if you enabled Single Sign On (SSO) on the Solution Manager, these steps are unnecessary. The
Solution Manager provides a menu to configure Kerberos for all components included with the Solution Manager
Installation, including the Design Studio. The Kerberos Configuration describes how to
configure the Kerberos authentication using the Solution Manager.
In this wizard you will be able configure Single Sign On (SSO) on the Design Studio using Kerberos authentication when you access the Design Studio of a Denodo Platform installation.
Important
To enable single sign-on (SSO), you have to enable Kerberos in both Design Studio and the Virtual DataPort server. This section describes de configuration options for the Design Studio. To enable Kerberos authentication in the Virtual DataPort server follow the instructions of the section Kerberos Authentication of the Virtual DataPort Administration Guide.

Kerberos settings¶
Select Use Kerberos to enable Kerberos.
In the box Server Principal, enter the “Service Principal Name” (SPN) used to create the keytab file. That is, the SPN with the Fully Qualified Domain Name (FQDN) of the server where the Web Administration Tool is running. For example, “HTTP/denodo-prod.subnet1.contoso.com@CONTOSO.COM”.
In the field Keytab file, drag and drop the keytab file over the specified area or click it to open a file explorer to select the file. If a key tab file was previously uploaded, it will be shown and you could use the trash icon to delete it.
Leave the Kerberos configuration file box empty unless the host where this Design Studio runs does not belong to a Kerberos realm (e.g., a Windows Active Directory domain). If this host does not belong to a Kerberos realm, do one of the following:
a. Drag and drop the
krb5.conf
orkrb5.ini
file with the Kerberos settings over the specified area or click it to open a file explorer to select the file. If a configuration file was previously uploaded, it will be shown and you could use the trash icon to delete it. b. Or follow the steps described in the appendix Enabling Kerberos Authentication Without Joining a Kerberos Realm.We recommend selecting the check box Activate Kerberos debug mode the first time you set up Kerberos in case you run into any issues. Once Kerberos is working, disable this.
When this option is enabled, check the appendix How to Debug Kerberos in Web Applications of the Installation Guide to learn how to see the debug information.
After saving the Kerberos configuration, restart the Design Studio to have these changes take effect. The next time
the users access the Design Studio, they will not need to provide their user name and password, because the browser
will send the Kerberos credentials of their system. In order for this to work, they need to access using the full
qualified URL (FQDN) configured in step 2. For example,
https://denodo-prod.subnet1.contoso.com:9443/denodo-design-studio/
.

Authentication dialog with Single Sign-On¶
The users can provide the URI of the Virtual DataPort server adding the uri
parameter to the URL. If they do it,
the Design Studio will try to authenticate them against that server without showing authentication page. For example:
https://denodo-prod.subnet1.contoso.com:9443/denodo-design-studio/?uri=//localhost:9999/admin#/
Informative Message¶
You can add an informative message that will be displayed to all users when they log in to the Design Studio. The message can be used to display a welcome message, inform users when the service is expected to be down for maintenance, legal disclaimers, etc.

Informative Message Set-Up¶
To customize the message you can use the editor with the tools available. If you feel more comfortable working with HTML,
you can click on the source code icon to see and edit the HTML. After editing, click Ok to save the
modifications.
The configured message will show up at the top of the page.

Informative Message¶
Application Settings¶
In this dialog you can configure several settings of Design Studio.
Enable community resources: with this feature, you can enable or disable the suggestions that could be shown when you click on the help button
.
Note
The suggestions could include documentation, expert trails, KB documents, videos, tutorials, test drives, free trials, training courses, certification exams or blog posts.
This is enabled by default.
Enable browser storage: with this feature, Design Studio will store in the local storage of the browser, for each user, several user preferences.
Note
The stored information includes last executed queries and their results, opened tabs, etc…
This is enabled by default.
Maximum number of rows displayed: with this feature, Design Studio will establish a limit to the number of rows that can be retrieved on the VQL Shells and execution panels of views.
Note
This option is set to 1000 by default.
Important
This setting will only affect VQL Shells and execution panels of views, so more rows can be retrieved using the Execute and Download feature.
Disable “Execute and download” feature: with this feature, the “Execute and Download” option will be disabled on VQL Shells for all users.
Note
This is disabled by default.
Maximum number of rows returned by the “Execute and download” feature: with this feature, you can set a limit on the amount of rows the “Execute and Download” option will retrieve.
Note
This option is set to 500000 by default.