Developer Edition

How to Create, Deploy & Connect Your First Model

This Demo is part of a How To video series to help users get started with the AtScale Developer Edition.

Video play button

How to Create, Deploy & Connect Your First Model on the AtScale Developer Edition

Overview:

Now that you have the Developer Edition of AtScale up and running, we will look at how to connect a business intelligence tool and run a query against AtScale. In the AtScale Developer Edition, there are three pre-installed tutorial data models, so new users can start querying immediately.

In this article, we’ll look at how to do that using Tableau.

Prerequisite:

Create and Deploy a Data Model

  1. Open AtScale.
  2. Click the ellipsis next to the AtScale icon at the top left of your screen.
    AtScale Design Center - Click AtScale Icon
  3. Under Design Center, select Repo Browser. Alternatively, simply click the Repo Browser icon.Note: The Repo Browser contains the source code for the models and the modeling effort.
    Under Design Center, select Repo Browser
  4. Click on the Preview tool. This will show you what users will see when they open a business intelligence tool like Tableau and connect to AtScale.
    Note:
    When you first open AtScale, this is where you will see the AtScale and the tutorial three data models — Internet Sales, TPC-DS Benchmark Model, and Worldwide Importers.

    AtScale Design Center - Preview Tool
  5. In order to query an AtScale model, you must first deploy it. To do this, click the Deploy icon. You will see the Query Name “sml-models_main”, and the three tutorial models in the Catalog Models field.
    Note:
    When you build your own models, you must deploy them before they can be queried. Similarly, if you’re working or editing a model, you will need to deploy in order for those changes to be seen by the BI tool.
    AtScale Design Center - Click Deploy
  6. Click the Deploy button at the bottom of the panel. When AtScale has prepared the three models to be deployed, Deploy Successful should appear at the bottom right of your screen.
    AtScale Design Center - Deploy Button

Connect Your Models to Your BI Tool

  1. Click on the Deployed catalogs icon in the left sidebar.
    AtScale Design Center - Deployed Catalogs
  2. Double-click on sml-models_main. This will bring up all the connection information to use to connect a BI tool to these AtScale models.
    Note:
    JDBC, MDX, and ODBC & SQL connection strings will be displayed.
    AtScale Design Center - sml-models_main
  3. Under Downloads, you will see the Tableau Data Source (TDS) files for the three tutorial data sets. Click on the .tds download button of the dataset you want to work with.
    AtScale Design Center - .tds download
  4. In the Save As field, you can change the file name. Select the location to save the file and click Save. The .tds file will now download.
    Save SML file
  5. From your downloads folder, or the saved file location, open this .tds file.
  6. The Tableau sign-in panel will open. Type in the username “admin”.
  7. Type in the same password you use to log in to AtScale Developer Edition.
    Note:
    When you set up AtScale Developer Edition, you were prompted to change the admin password. This is the password you should enter here.
    Sign-in to Tableau
  8. Tableau will now open up on a new page.
    Note:
    Notice that the folders in the left sidebar correspond to the Preview screen in AtScale.
    Tableau

Run Your First Query

  1. From the Folders menu in Tableau, expand a data folder by clicking the ellipsis. Here, we will use the Sales Metrics folder.
    Expand folders in Tableau
  2. Click on the metric you want to query and drag it to the Rows or Columns field, depending on how you want your query to be displayed. Here, we have dragged the Sales Amount into the Rows field.
    Tableau - drag sales amount to rows
  3. Your query will now run against the AtScale data, and the data (here, Sales Amount sum) will be displayed in the Tableau sheet.
    AtScale Data in Tableau
  4. To see how the query is reflected in AtScale, go back to AtScale Developer Edition and click the ellipsis next to the AtScale icon. Select Queries.
    AtScale Design Center - Queries
  5. This will display a list of all the queries that have been run against the data model.Note: If you have just run a query, you may need to refresh the page to see that query displayed. It can be a useful practice to move back and forth between your BI tool and AtScale to monitor the details and performance of your data models.
    AtScale Design Center - Queries List

Congratulations! You’ve now run your first query in AtScale Developer Edition.

Watch all of the Developer Edition demo videos on demand.

Start Building with the Developer Edition

Build and share semantic models with the community