You can also add a new data source manually.

  1. Click File  New  Data  Source
  2. If you want the system to assign a name to the data sources, select Generate  unique name  based  on  the  alias  or  the  host  name.
    If you want to enter the data source name, deselect Generate  unique  name  based  on the  alias  or  the  host  name and then in the Data  source  name field, enter the data source name. 
  3. In the Select  server  type area, select the type you want to add. 
  4. In the Select  data  source  group area, select the data source group where you want the new data source to appear in the Data Source Explorer. 
  5. If you want to assign the new data source to a category, useful if you have a large number of data sources to manage, click the Select  category list and choose one of the categories. 

    Categorized data sources appear with the color for the designated category on the bottom left of the data source icon in the bottom of such as  for the Test category and  for the Production category.

    For information on adding custom categories, see Customizing data source categories


    When you open a tuning job or SQL Editor window to create SQL for the categorized data source you will see that the category color is applied to the top of the window, as follows. 

  6. Click Next

  7. Complete the data source configuration and then click Test Connection. This will ensure your configuration is correct. If the connection test fails, make the necessary corrections and then click Finish.
    The new data source appears in the Data Source Explorer


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal
  • No labels