Skip to main content

Configure Language Captions for a Jet Data Warehouse

Overview

This article will outline the steps to create language captions to be used in the Jet Excel Add-in when using the Jet Data Warehouse data source.  You can use the Database Caption Editor to add language captions to other data sources too.

Process

  1. Disconnect from the Service Tier.

    1. If you do not use the Service Tier you can skip to step number 2.

    1. On Jet ribbon, navigate to the Settings > Application Settings > Settings LocationThen chose Local user profile and close the window.

    1. Next you will need to create a local data source for the data warehouse.  From the Settings button, click Data Source Settings. From the displayed dialog, click Add.

    1. In Data Source Initial Configuration window, choose I want to configure my data source(s) and click Next.

    After clicking Next, the New Data Source box will appear.

    1. Type in the Name, choose a Database Type, and Connection Method. Then Click OK.

    1. Once you click OK , go to the Connection tab for you new data source and fill out the Server and Database fields.

    Once you have filled those out, make sure to click Test Connection to verify everything was typed in correctly.

  2. Using the Database Caption Editor

    Open the Database Caption Editor. This application is installed with Jet. You may need to open the Start menu and search for the application by typing in "Database Caption Editor".

    Once the application has been opened, set your Data Source to the desired option. In this example it is DWH for the Jet Data Warehouse. Next choose the language you'd like to use for your captions. In this example we are choosing German.

    After you have added all your captions, click Save in the lower right-hand corner.

  3. Reconnecting to the Service Tier

    If you do not have the Service Tier proceed to Step 4.

    To reconnect to the Service Tier, open Excel, click the Jet ribbon, and click Settings > Application Settings.

    The on the left-hand side click the Settings Location tab. Choose Jet Service Tier. And test the connection to ensure connectivity.

    Next we need to enable the captions we just created in Data Source Settings. To open the Data Source Settings window, go to the Jet ribbon and click the Settings > Data Source Settings option.

    In the upper left-hand corner of the Data Source Settings window, choose the correct data source. In this Example we are using the Demo DWH, which is the same data source we setup previously in the article. Click the Display tab. Check the Enable language captions for this data source box. Choose a Language and Display format. Then click OK.

    Next open the Jet Admin Console. click Data Sources and choose the correct data source. click Display. Check the Enable language captions for this data source and type in the Language you used before. Display format should be Captions.

    Next click Edit Scopes at the top of the Jet Admin Console.

    Make sure that the highlighted rows are set to User. This will then give the user an option to use English or German. If you do not want the users to have a choice change the selection from User to Shared. This will force all users to only see the language captions you just setup. After you are finished, make sure to click Save

  4. Enabling the language captions

    Users can switch between English and and the language captions you created in the Data Source Settings. Go Settings > Data Source Settings.

    Check the Enable language captions for this data source box and then select the Language option you want from the drop down menu.

Was this article helpful?

We're sorry to hear that.