Crystal Reports create ODBC connection in AWS
- Knowledge Assistant
- Moriah Yorkey
User needs ODBC connection to run Crystal Reports against EERP database hosted in AWS
Crystal reports
ODBC
Enterprise ERP database
Enterprise ERP any version
SaaS clients
User needs ODBC connection created to use Crystal reports
Pre-requisites:
User must have a valid Reporting account (ie. 1234janedoe) prior to the connection.
For AWS hosted clients: You MUST have the F5 SSL VPN(2secure.tylerhost.net) connected unless a Cyral connection is configured for VPN-less access.
To create an ODBC connection:
Click on the Windows icon in taskbar and type ODBC in the search box.
From the results, click on ODBC Data Sources(32-bit) to open ODBC Data Source Administrator (32-bit) window.
Select User DSN tab and click on Add.
In the popup window, select SQL Server at the end and click Finish
If that is not an option please download it from the Microsoft
In the Name text field, type a name for this connection.
Description field is optional and can be left blank.
In the Server text field, type the server name.
Note: If Server name couldn't be found in site report, please reach out to EERP TSM SaaS support team.
Click Next >
Select the following check boxes and click Next
With SQL Server authentication using a login ID and password entered by the user
Connect to SQL Server to obtain default settings for the additional configuration options
Select the first check box to choose your production database name from the dropdown
Database name is usually munXXXXprod where XXXX is the first 4 digits of reporting account.
Click Next >.
Click Finish.
In the popup window Click on Test Data Source button in the bottom.
Click Ok.
A new connection will be added to the list in User Data Sources section.
In Step-10, if production database is not listed in dropdown, please reach out to Tyler Reporting Services Support as the default database needs to be changed for reporting account.