Create a New Mapping

To design and generate a SQL Transformation mapping, a running SQL Transformer must be running and connected to the Studio. Please refer to the Connecting Transformers page if not already done so.

1. Select Graph.Build, SQL Models, ensure a Transformer is selected from the dropdown, New Model.

1. Select Semantic Graph, Next Step.

1. In IRI Configuration, select the ontology created in the previous section and the prefixes will be automatically populated with those used in the ontology.

   Selecting an ontology here is not required to create a model. All following steps assumes you have created and selected an ontology, however you can still follow along by manually entering all values. To add additional prefixes, use the typeahead search to suggest other commonly used namespaces.

   Once done, select Next Step.

1. Name your visualisation Transactions and provide the connection details and credentials for the SQL database being used for the source data, then select Finish Setting Up.