How to add datasource to reportserver.net?

Extracting from MySQL and PostgreSql database can be done via Reportserver.net. Other relational databases are also supported as of Reportserver.net version 4.

Configuration

Step 1: Login as administrator user

Step 2: In the menu choose "Datasources", then right click "Datasource Root" and right click to choose "Insert" ->"Relational Database".

Step 3: Enter the following and click "Apply"

• Name
• Description
• Database
• Username
• Password
• URL

The Permission tab provides better control for user to access.

Postgresql database URL

jdbc:postgresql://10.1.1.102/customers

MySQL database without SSL URL

jdbc:mysql://10.1.1.100:3306/customers?useSSL=false

MySQL database URL

jdbc:mysql://10.1.1.100:3306/customers

Details for other databases can be found at https://reportserver.net/en/guides/admin/chapters/Datasources/

Troubleshooting

Host 'host_name' is blocked in MySQL

Too many attempts made to the database can be caused by having or not having ssl. 

Solution:

Try to disable SSL protocol for the client.

Missing Relational Database Driver

Reportserver.net comes with several drivers. To customise datasource, 

Login as administrator and click "File System".

Click "Fileserver Root"->"etc"->"datasources"->"datasources".

Click on tab "Edit file".

It defaults to the following:

<?xml version="1.0" encoding="UTF-8"?>

<configuration>

   <datasource>

      <defaultDatasourceName>Demo Data</defaultDatasourceName>

      <!-- or access via ID -->

      <!-- <defaultDatasource>14</defaultDatasource> -->

   </datasource>

</configuration>

Reference: https://reportserver.net/en/guides/config/chapters/Manual-Installation/