Building the Data Experience (CinchyDXD)

This page outlines Step 1 of Deploying CinchyDXD: Building the Data Experience

Table of Contents

1. Table Creation

Create your data experience (DX) in a virtual data network.

  1. Log in to Cinchy: URL: <cinchy source URL> User ID: <source user id> Password: <source password>

  2. From the Homepage, select Create

  3. Select Table > From Scratch

  4. Create the table with the following properties (Image 1).

Table Details

Values

Table Name

Currency Exchange Rate

Icon + Colour

Choose your own icon

Domain

Sandbox (if the domain does not exist, create it)

To create a domain on the fly:

  1. Enter domain name in Domain field

  2. Hit enter on keyboard

  3. On the Confirm Domain window, click Yes

Description

This table is a test table for building and deploying a data experience for currency conversion

Image 1: Creating your Table

6. Click Columns in the left hand navigation to create the columns for the table

7. Click the “Click Here to Add” a column tab to add a column

Column Details

Values

Column 1

Column Name: Currency 1

Data Type: Text

Advanced Settings:

  • Select Mandatory

  • Leave all other defaults

Column 2

Column Name: Currency 2

Data Type: Text

Advanced Settings:

  • Select Mandatory

  • Leave all other defaults

Column 3

Column Name: Rate

Data Type: Number

Advanced Settings:

  • Set Decimal Places to 4

  • Select Mandatory

  • Leave all other defaults

8. Click the Save button to save your table

2. Enter Sample Data

  1. In your newly created table, enter the following sample data (Image 2).

Currency 1

Currency 2

Rate

CAD

USD

0.71

USD

CAD

1.40

Image 2: Filling in your table

3. Create the Query

Create a simple query that pulls information from the Currency Exchange Rate table that will allow a simple currency exchange calculation.

  1. From the Homepage, select Create.

  2. Select Query.

3. In the query builder locate the Currency Exchange Rate table and drag it to the “FROM” line (Image 3).

You will find the Currency Exchange Rate table in the “Sandbox” domain. To expand the “Sandbox” domain, click on the gray arrow (or double click)

Image 3: Creating your query

4. In the “SELECT” line drag and drop the “Rate” column and enter in the following (Image 4): SELECT [Rate] * @Amount AS 'Converted Amount'

You will find the Rate column by expanding the Currency Exchange Rate table, similarly to expanding the “Sandbox” domain

Image 4: Creating your query, cont.

5. Enter in the following for the WHERE clause (Image 5):

WHERE [Deleted] IS NULL AND [Currency 1] = @Currency_1 AND [Currency 2] = @Currency_2

Image 5: Creating your query, cont.

6. Click the Execute (or play) icon to run the query (Image 6):

Image 6: Creating your query, cont.

7. Test the query by entering in the following and clicking the submit button (Image 7):

@Amount: 100 @Currency_1: CAD @Currency_2: USD

Image 7: Testing your query

8. Save the Query by clicking on the Info tab (Left Navigation) 9. Enter in the following details for the query (Image 8):

Query Details

Values

Query Name

Currency Converter

Icon + Colour

Choose your own icon

Return

Query Results (Approved Data Only)

Domain

Sandbox

API Result Format

JSON

Description

This query is a test query for building and deploying a data experience for currency conversion

Image 8: Adding in info about your query

10. Click the Save button (Image 9).

Image 9: Saving your query

Last updated

Was this helpful?