Connect Datamaker to the Repository

After you install the product, you must configure a connection to the repository for the product to function. 
tdm49
After you install the product, you must configure a connection to the repository for the product to function. 
 
 
Connect Datamaker to a Microsoft SQL Server Repository
To connect Datamaker to a Microsoft SQL Server repository, you configure an ODBC connection.
 
Follow these steps:
 
  1. Launch Datamaker with the 
    GT
     
    Datamaker
     icon on the Desktop.
    The first time you launch Datamaker, the '
    Create connection profile for Test Data Repository
    ' dialog should open automatically. If it does not, click the Yellow button on the main Datamaker dialog.
  2. Select '
    I need to provide credentials for my Test Data Repository
    ', select Microsoft SQL Server, and click the blue arrow at the bottom right.
    Unless you have already created an ODBC connection, a Not Found dialog opens.
  3. Click 
    OK
    .
  4. Click the icon next to the 
    ODBC Sources
     drop down list to create a new ODBC connection for the repository.
     If you are using a 64-bit Windows system, launch the ODBC administrator separately from C:\Windows\SysWOW64\odbcad32.exe.
    The ODBC Data Source Administrator dialog opens.
  5. Select the System DSN tab and click 
    Add
    .
    The 
    Create New Data Source
     dialog opens.
  6. Select SQL Server Native Client 10.0 and click 
    Finish
    .
    The 
    Create a New Data Source to SQL Server
     dialog opens.
  7. Give the repository a name and a description, select the SQL Server that contains the repository, and click 
    Next
    .
  8. Select the SQL Server authentication option, enter valid login credentials to the database server, and click 
    Next
    .
    Note:
     You can also use an Active Directory (AD) account for connecting to the Microsoft SQL Server repository in Datamaker. For more information about setting up integrated security to connect to the Microsoft SQL Server repository, see Enable Integrated Security for Repository Access in Datamaker.
  9. Specify gtrep as the default database, select both ANSI check boxes, and click 
    Next
    .
  10. Leave the defaults on the final page and click 
    Finish
    .
    A setup page opens that summarizes your settings.
  11. Click 
    Test Data Source
     and confirm that the connection is successful.
  12. Click 
    OK
    , verify that the repository data source you created appears on the
     System DSN
     tab of the 
    ODBC Data Source Administrator
    , and click 
    OK
     again.
    You are back to the Database Details tab where you have to select the ODBC connection for the repository.
  13. Click the Refresh button next to the drop-down list, select the ODBC source you just created, and click the blue arrow at the bottom right.
    The 
    User Details
     tab opens.
  14. Select '
    Use specified login details
    ', enter valid database credentials, select 
    Store Password
    , enter the default schema (gtrep), and click the green button at the bottom right.
    This runs a connection test.
  15. After you get a successful connection test, click the green check mark at the bottom right.
  16. Enter a name for the repository that you will remember, such as Repository or Test Repository, and click 
    OK.
     
  17. Click 
    Yes
     to confirm your profile name
    .
    The repository profile you created should appear on the main Datamaker page.
Connect Datamaker to an Oracle Repository
To connect Datamaker to an Oracle repository, you provide valid database connection credentials to Datamaker.
 
Follow these steps:
 
  1. Launch Datamaker from the 
    GT
     
    Datamaker
     icon on the Desktop.
    If you are launching Datamaker for the first time, the '
    Create connection profile for Test Data Repository
    ' dialog should open automatically. If it does not, click the Yellow button on the main Datamaker dialog.
  2. Select '
    I need to provide credentials for my Test Data Repository
    ', select Oracle, and click the blue arrow at the bottom right.
  3. In the 
    Database Details
     tab, select your database from the drop down list, or use Search button to browse.
  4. In 
    User Details
     tab, select 
    'Use specified login details'
    , enter valid database credentials, select 
    Store Password
    , enter the default schema (gtrep), and click the green button at the bottom right.
    This runs a connection test.
  5. After you get a successful connection test, click the green check mark at the bottom right.
  6. Enter a name for the repository that you will remember, such as Repository or Test Repository, and click 
    OK.
     
  7. Click 
    Yes
     to confirm your profile name
    .
    The repository profile you created should appear on the main Datamaker page.