Create Project (Synapse)

Overview

A Matillion ETL project is a logical grouping of configuration settings and resources—such as jobs—required to use Matillion ETL. When users first log in to their Matillion ETL instance, they will be required to click Confirm in the Product Improvement Metrics dialog, and then they must create a project when no existing projects are available to select.

To create a new project, there are two routes:

1. The first route is situated in the Join Project dialog, which will appear automatically upon first loading an instance.
2. The second route can be accessed by clicking Project, then clicking Switch Project, and then (for both methods) clicking Create Project.

Access the Project menu.

Creating a Synapse project on Azure

The following section describes how to create a Project in Matillion ETL for Synapse on Azure instances.

1. Project Details

• Project Group: Use the drop-down menu to specify an existing name for the project group. Projects are logically arranged in project groups.
• Project Name: Enter a suitable name for your new project.
• Project Description: Describe your project. This setting is optional.
• Private Project: Check this box to make this new project private. Only users granted access can view and work in this project.
• Include Samples: Untick this box if you do not want to include sample jobs in this project.

Project Details

2. Cloud Connection

• Environment Name: Enter a name for your new Matillion ETL environment.
• Azure Credentials: Use the drop-down menu to choose credentials for the Azure cloud platform. 'Instance Credentials' is selected by default. Click Manage to add a new set of credentials. Read Manage Credentials for more information.

Cloud Connection

3. Azure Synapse Connection

• Endpoint: Enter the URL of the Azure Synapse portal you want to connect to.
• Port: Enter the port number. This is typically 1433.
• Username: Enter your username for the environment connection.
• Password: Enter your password for the environment connection.

Azure Synapse Connection

• Advanced Connection Settings: Optionally, you can add additional connection options to your Synapse connection. Click Manage to open the JDBC Connection Attributes pop-up dialog. Use to add connection attributes, and enter Parameter and Value information in the fields provided. For more information, read JDBC Connection Strings.

Adding connection attributes.

4. Azure Synapse Defaults

• Default Database: Use the drop-down menu to specify the name of the database on your Synapse account to use by default.
• Default Schema: Use the drop-down menu to specify the schema you would like to use. If you have configured multiple schemas within your Synapse database, specify the schema you would like to use here.
• Concurrent Connections: Specify the number of configured, concurrent connections for existing jobs you want to use, that run in the Synapse environment. For more information, read Multiple Environment Connections.

Click Finish to create your project and environment.

Azure Synapse Defaults

Next Steps

When you first login to Matillion ETL, we recommend you replace your default username and password with your own secure login credentials. For more information about changing these credentials, read User Configuration in the Admin Menu.

Useful Links

• If you are new to Matillion ETL, we recommend reading the documentation target="blank">UI and Basic Functions.
• For more information about connecting to your instance, read Accessing the Matillion ETL Client.
• For more information about adding credentials, read Manage Credentials.