Skip to main content
Mitratech Success Center

Create the External Table

In this article you will learn how to create the External Table.

The database table used in this example is:
image

Note: Every row must have a unique ID column with the name PK_idRow.

  • The AccountNumber column contains the account numbers for all the bank statements which are being stored in DataStoreDSX.
  • The Active column contains Yes for active bank accounts and No for dormant bank accounts.