Designing for nicknames

No matter what data model your source uses to present its data, you must map it to a relational model. This relational model is then provided to the federated server by a user, a database administrator, or an application through the CREATE NICKNAME DDL statement specific to your data source.