Create SSRS connection

To create a connection to your system, follow these steps:

1. Navigate to Settings  > Data Ingestion > Connections.
2. In the top-right corner, click New connection, find your system, and click Connect.

General configuration

In the general connection configuration step:

1. Nameyour connection for easier identification in Dawiso.
   • Use a unique and descriptive name like the combination of the server name and your local environment naming (e.g., server1_prod).
2. Provide a description (purpose of the connection).
3. Select a Connection type.
   • Shared: Source is accessible from the public internet and you can share your credentials with Dawiso.
   • Private: Source is not accessible from the public internet and you cannot share your credentials with Dawiso. For more information, see the Create a private connection article.
4. Click Next.

Server configuration

In the server configuration step, provide the following information:

1. Server Name: The host name of your SQL Server instance.
   • You can use one of the following formats:
     • DNS name (e.g., server1.mycompany.com)
     • IP address (e.g., 100.100.100.100)
     • For Azure SQL: Server name (e.g., mycompany.database.windows.net)
   • If your instance is configured to listen on a port different from the default one (1433), add the port number to the host name after a comma (e.g., server1.mycompany.com,1234)
2. Authentication credentials:
   1. User Name: Your SQL Server login name with permissions to connect to the server. To set up a user with sufficient permissions, refer to Prepare for SSRS integration
   2. Password: Valid password to your login.

Security

On this step, you can also configure your Security settings.

• Encrypt: Check this option if your instance is configured for SSL encrypted connection. This does not apply for Azure SQL servers.
• Trust Server Certificate: Allow bypassing the certificate validation chain. Allows the connection to be established when a self-signed certificate is used to encrypt the SSL channel.

Optional and additional settings

[Optional steps] Configure Optional and Additional Settings for your connection:

• Optional settings: Specify options supported by the provider in JSON format.
• Additional Settings: Recommended to leave empty unless our Dawiso support team suggests otherwise. Here, you can add a JSON formatted list of additional settings for troubleshooting or advanced connection configuration.

When adding optional settings, make sure the value is in a valid JSON.

Test and save connection

If your connection is shared, click on Test connection and wait for a few seconds.

• If successful, there will be a green checkmark next to the button.
• In case of failure, there will be a red error icon. Hover over it for a detailed error message. For more information, see the troubleshooting section. You will still be able to save your connection.

Finally, Save the connection and proceed to the next step: using the connection to create a data source. During this process, you will specify what metadata to ingest.