Skip to content

Data Source

Set the physical database environment information for querying and entering the data of the Business Object. Manage information related to the connection and account of the DB. This can be selected and used when defining Tables and Columns.

Image

  • How-To Create
  1. In the Object Explorer, click the Physical Layer > Data Source menu.

  2. In the Data Source List, click New, then enter and select the information such as Name, Host, Port, DB Name, UserID, Password, and Engine Type in the popup window that appears, and then save.
    Appendix

How to register Data Source and Table of DBMS composed of Multi Database and Schema

[Image1. Application DBMS configuration example]

[Image2. Data Source information that need to be registered]

[image3. Table Registration Method]

  1. When the Default database and schemas are set in application.

    • Do not register a Data Source.
    • Do not register Data Source and schema information in the Table input information.
  2. When the default schema differs in the default database:

    • Do not register a Data Source.
    • Only input the schema in the Table input information.
  3. When using a Multi-DB with a different default Database and Schema

    • Register a Data Source
    • Register the Data Source selected in the Table input information. In this case, the DB Name of the Data Source is specified as the schema.
  4. When the Data Source registered in case 3 and the DB are the same but the Schema is different.

    • Register a new Data Source
    • Select and register a new registered Data Source in the Table input information.