How can I create a connection to any external database in Mosaic?

Question

We are using Mosaic to load and read data from multiple sources like MySQL, SQL Server, Oracle in around 100 jobs using the reader node of Mosaic.

To configure this reader node to connect these databases, how to create a connection for each one of them? Are these connections globally available in Mosaic?

Answer 1

Mosaic Decisions supports a wide range of connectors.

You can create connections with different data assets by providing required connection details in the Publish tab under Manager Persona.

Publish allows you to create a connection with any available source system by providing necessary detail like IP, Port, username, password, and other such required details to register/publish the metadata from the source system.

Here connections are of two types:

1. Public: This connection will be available to all. No lock symbol specifies that it is a public connection.
2. Private: This will not be available to all users. To use this connection you must provide your username and password. If the details are correct, only then the connection can be used. A lock symbol specifies that it is a private connection.

Once the connection is created, its datasets can be published and the same can be used for further processing in Flows.

EDIT

When you click on the Publish tab in Manager persona, you will see a list of available connectors. Refer screenshot below: