Create Path from Report Manager to read ODBC SQL database in Admin Manager

From Sage Intelligence Knowledgebase
Jump to: navigation, search

ISSUE:


STEPS TO MAKE A CONNECTION VIA THE ALCHEMEX ADMINISTRATOR USING ODBC DRIVER FOR SQL SERVER


RESOLUTION/WORKAROUND:


1. Launch Alchemex Administrator.


2. Double click Enterprise node.


0071.png



3. Right click ODBC Driver SQL Server connection and select Add connection.


0072.png



4. Populate the below fields with your SQL details.



0073.png



5. Now check test your connection.


0074.png


6. All reports that need to run off your SQL database connection would now need to be imported on to this connection (in my example test 3).


0075.png


7. Your reports will now run off your new SQL connection.


APPLIES TO:


Alchemex 6.8 and 7