Building the Data Experience (CinchyDXD)
This page outlines Step 1 of Deploying CinchyDXD: Building the Data Experience
Table of Contents
Table of Contents |
---|
Remember that all objects need to be created in one source environment (ex: DEV). From there, DXD will be used to push them into others (ex: SIT, UAT, Production).
1. Table Creation
Create your data experience (DX) in a virtual data network.
Log in to Cinchy: URL: <cinchy source URL> User ID: <source user id> Password: <source password>
From the Homepage, select Create
Select Table > From Scratch
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:
|
Description | This table is a test table for building and deploying a data experience for currency conversion |
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:
|
Column 2 | Column Name: Currency 2 Data Type: Text Advanced Settings:
|
Column 3 | Column Name: Rate Data Type: Number Advanced Settings:
|
8. Click the Save button to save your table
2. Enter Sample Data
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 |
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.
From the Homepage, select Create.
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)
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
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
6. Click the Execute (or play) icon to run the query (Image 6):
7. Test the query by entering in the following and clicking the submit button (Image 7):
@Amount: 100
@Currency_1: CAD
@Currency_2: USD
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 |
10. Click the Save button (Image 9).
Last updated