Modules ? System ? Setup ? Reporting services integration ? Management
On this page, you can create data sources or modify existing ones. The local data source will be automatically created when the settings for Reporting Services Integration are defined and the local data source does not exist yet. The credentials used for the local data source are copied from the settings. However, if you want to display reports on other data sources besides on Exact Synergy Enterprise, for example on Exact Globe Next, you will need to create the data sources.
Users with the Administrator role can create and modify data sources. Users with the Report Manager role can also create and modify data sources.
Note:
The information in this document is applicable to product update 258 and higher. If you have versions lower than this, certain features explained here will not be applicable.
Keep in mind: All fields with the “!” icon are mandatory.
Click this to save the data source.
Click this to save the data source and create another data source.
Note: This is available only if you are creating anew data source.
Click this to delete the data source.
Note: This is available only if you are modifying an existing data source.
Click this to exit.
Type a name for the data source. This is mandatory.
Type the description for the data source.
Select Microsoft SQL Server, Microsoft SQL Azure, OLE DB, Microsoft SQL Server Analysis Services, or ODBC to specify the type of the data source.
This displays the status of the deployment. When a data source has been deployed to the Report Server, will be displayed. Otherwise, will be displayed.
Type the connection string to connect to the data source. This is mandatory. See The Connection Strings Reference.
Note: This is available only if you have selected the type ODBC or OLE DB.
Type the name of the server for the data source. This is mandatory.
Type the name of the database for the data source. This is mandatory.
Type the user name to specify the user who will read the data from the data source. To be able to read the data from a data source, this user should have rights to read data from the data source. This is mandatory.
Type the password of the user. This is mandatory.
Type the name of the domain for the user. If it is a local user, you can specify the machine name. This is mandatory.
Note: This is not available if Microsoft SQL Azure is selected at Type.