The Jet Data Manager has the ability to change the collation of the staging, data warehouse, and OLAP databases. As a best practice, the collation of all three databases should be set to the same collation setting.
How to Specify the Database Collation
1. Right-click the database you would like to specify the collation for and select " Edit "
2. From the Collation drop-down, choose the desired collation;
a. <Application Default> will use
as the collation setting
b. <Server Default> will inherit the collation of the specified server
c. Alternatively, choose a collation setting from the drop-down list
3. Click OK .