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. A sample CSV file of transaction data can be downloaded and put into a SQL database of your choice to follow the walkthrough.

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

1. Select Property Graph, Next Step.

1. In IRI Configuration, select the Schema we created in the previous section and select Next Step. Selecting a schema here is not required to create a model. All following steps assumes you have created and selected a schema, however you can still follow along by manually entering all values.

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

NB. If running the SQL database on your local machine you will need to use the ip address of your machine rather than localhost as the docker container running the studio is on its own network.