Create a remote table

Create a remote table so that you can see the data that you retrieved from an external source.

Before you begin

Role required: admin

About this task

When you designate a table as a remote table, keep the following points in mind:

• You can create a remote table using this form, or by using the standard Create Tables form that you access from System Definition > Tables.
  Note:

  To learn more about creating tables in an instance, see Create a table.
• Before you create a remote table, you must have a good understanding of external data sources.

  For example, if you want to retrieve CRM data for use in Customer Service Management, you must understand how the data is structured in the external CRM source.

• Unlike standard internal tables, you can't extend a remote table from another table.
• A remote table needs an external primary key to relate its temporary data to the data that is stored in the external source. When you designate a table as remote, only a sys_id field is auto-generated and appears in the Columns section, which it uses as its primary key for use in Glide records. All external table primary key values are converted to string values. CRUD (Create, Read, Update, Delete) fields are not generated for a remote table, as they are for standard internal tables.

Procedure

1. Navigate to System Definition > Remote Tables > Tables.
2. Click New.
3. On the form, fill in the fields.
   Note:

   You create a remote table in the same manner as a normal table, but designate it as a remote table. The following controls differ in how they operate and what you enter into them when you create a remote table:

   Control	Description
   Name	Table name, which is automatically populated based on the table label and a prefix as follows: For a remote table in a scoped application, the name is prefixed with a namespace identifier and the string st_ to indicate that it is remote and part of an application. For a remote table in the global application, the name is prefixed with the string u_st_. You can't modify the prefix; however, you can modify the rest of the table name. The name can contain only lowercase, alphanumeric ASCII characters and underscores (_).
   Extends Table	Option that is not available if you select the Remote Table option to designate that this table is remote. It no longer appears because you can't extend remote tables from other tables.
   Remote Table	Option to designate this table as a remote table. A remote table is a table to which you can associate a script definition for retrieval of data from an external data source. Unlike a standard internal table, the data does not come from records in the current instance. To learn more about remote tables, see Remote tables.

4. In the Columns section, use the Table Columns embedded list to add columns to the remote table like you do when you create columns for a standard internal table.
5. In the Controls section, define additional remote table options like you do when you define additional table options for a normal table.
6. In the Application Access section, define the scope protection for the remote table like you do when you define additional table options for a normal table.
   For more information, see Application access settings.
7. Click Submit.

Result

A remote table is created in the instance.