SQL Server can be used as either a Source or Target Server (subject to Licencing). If used as a target tables the Precision Bridge Archiving Wizard can be uset to generate target tables (see related link below)
SQL Server can also be used as an external lookup server or reporting target (see related links below)
To use SQL Server as the Source Server, select SQL Server from the Source Server Type dropdown.
To use SQL Server as the Target Server, select SQL Server from the Target Server Type dropdown.
Pre-requisite:
SQL Server JDBC Driver; First check that you have setup the path to the corresponding JDBC driver (under File->Configure->Application).
The connection details will be displayed and must be completed as follows:
Data Source: The name of your Database Server or IP address.
Database Name: The name of the SQL Server Database.
Port: The port number for SQL Server (default 1433).
User Name: The name of the SQL Server user to connect with.
Password: The SQL Server password for this user.
Schema (optional): The schema for which you want to limit table access. For Archiving Projects where you use Precision Bridge to generate the target tables, this is the Schema they will be created in.
DB Type: The type of database you are connecting to, either Sharepoint 2010, HP Service Management or ‘Other’. For more information regarding migrating HP Service Management data see the section Migrating Data from HP Service Manager Database to Service Now.
Define Connection String: For advanced connection configuration, you can define a custom JDBC connection string. This allows additional connection options to be defined.
Note that if Schema is left blank then all tables owned by the connected user are presented within Precision Bridge for data mappings. If Schema is set to ‘ALL’, then all tables including system tables that the user has read access to are presented within Precision Bridge for data mappings.
If you want to retain the login details, select the Save Authentication option. After selecting this option, the username and password are stored and do not need to be entered again the next time you open the same project from the same client machine. Otherwise you will need to re-enter them each time you open the project.
In order to check that the relevant servers can be accessed using the credentials provided, click on the Test button on the right for each connection.
If the selected server is reachable then a confirmation message will be displayed. If the server is not reachable then a failure/timeout message will be displayed. Correct the Server name/IP Address, Port, User Name and Password and try the test again. If the SQL Server server is not reachable, check that you can connect using the same credentials from a native SQL Server client application such as SQL Management Studio.
Related Articles
Configuring access to SQL Server Data
The Precision Bridge Archiving Wizard
Configuring an External Lookup Server Connection
Writing Migration Reports to Database Tables
Migrating Data from HP Service Manager Database to Service Now
Comments
0 comments
Please sign in to leave a comment.