Page History

...

For detailed information on the prerequisites involved please review the following sections:

• UI Configurations
• Browse Scripts

RED provides examples for each of the prerequisites above that all form a working example of an SQL ODBC connection utilizing these features. Please follow the instructions here to create each of the examples to build the set.

Creating Extensible Source Connections

After you set the prerequisites described above, add a new Extensible Source Connection by following these steps:

...

The Text Box Fields, List View Fields, and Numeric Fields displayed in the screenshot are field configurations taken from the examples found in Field Configuration JSON.

The Column UI Configuration selection is only available on Target Enabled Connections and not Extensible Source Connections. For more information, review Connection Target Settings.

Loading from Extensible Source Connections

...

This section steps through creating the example Extensible Source Connection set which provides the prerequisites mentioned earlier. The example set was designed to browse an SQL Server ODBC DSN but can be easily adapted to other ODBC based DSN’s also.

...

1. Create a new Connection Properties UI configuration from Maintain UI Configuration by selecting Tools>UI Configurations>Maintain UI Configurations
   
   
2. In the UI Configurations Maintenance dialog, click New.
   
3. Under the Edit UI Configuration, add a Name, Description, select a Configuration Type from the drop-down list, and click OK.
   
   
   
4. Empty the default script to enable the examples menu in the editor. Select Tools>Create Example Configuration>Connection Configuration
   
   
5. Repeat step 1 and step 2 to create the matching Load Table UI and Column UI Configurations.
6. Create a Connection Browse Script by following these steps:
   1. Right-click Host Script and select New Object.
      
   2. In the Add a New Metadata Object window, add an Object Name for the script, and click Add.
      
   3. The Host Script properties window opens, edit the options you need, and click OK.
      
   4. Open your Host Script in the script editor and select Tools>Create Example Browse Script
   5. After the Example Browse Script is created, click Save.

...