<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tt/onlinemanual/100014" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">To define database information</Title>
		<Keyword ContextSensitive="No"><Level1>database</Level1>
		</Keyword>
	</Header>
	<GeneralSection><List><ListIntro>The <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> information consists of:</ListIntro>
			<ListItem>The database type(s) available on the system</ListItem>
			<ListItem>Parameters and database copies of the database type(s)</ListItem>
			<ListItem>The tables assigned to databases</ListItem>
			<ListItem>Logical tables</ListItem>
			<ListItem>Remote databases</ListItem>
		</List>
		<Paragraph class="Default">The <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">databases</Link> are used to store <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">tables</Link>. You can use different database types, for example, ORACLE, Informix, and so on. Tables can also be located on a remote system in a distributed database environment.</Paragraph>
		<Note><SectionTitle>
                                 Note
                              </SectionTitle>
			<Paragraph class="Default">For technical details on database management and database tools refer to the <DocRef>Infor Enterprise Server 8.5 Technical Manual (U8172 US)</DocRef>.</Paragraph>
		</Note>
		<GeneralSection><SectionTitle>PLACE OF BUSINESS OBJECT</SectionTitle>
			<Paragraph class="Default">Before you define the database information you must know what database type(s) are installed on your system. For each database type you can assign tables, which means you must also know which tables are present.</Paragraph>
			<Paragraph class="Default">After defining databases, you must convert the changed data to the Run-Time Data Dictionary in the several sessions. Then you can create the tables for a company in the <GUIRef href="/baanerp/tt/aad/ttaad4230m000" role="session">Create Tables (ttaad4230m000)</GUIRef> session.</Paragraph>
			<Paragraph class="Default">Complete the following steps to define database data. Assume that database information has not yet been specified.</Paragraph>
			<ProcedureList><ListItem><GUIRef href="/baanerp/tt/aad/ttaad4510m000" role="session">Database Definitions (ttaad4510m000)</GUIRef> Use this session to specify local or remote databases. Databases are identified by their database codes. For local databases you can specify the database type, parameters, and audit trail. Parameters for ORACLE and Informix indicate the place of the tables in that database. For remote databases you can enter the name of the remote system in the <GUIRef href="/baanerp/tt/aad/ttaad4510m000#ttaad410.syst" role="manual">System Name</GUIRef> field.</ListItem>
				<ListItem><GUIRef href="/baanerp/tt/aad/ttaad4112s000" role="session">Database Definitions (Copies/Alternatives) (ttaad4112s000)</GUIRef> Use this session to specify copies of your database.</ListItem>
				<ListItem><GUIRef href="/baanerp/tt/aad/ttaad4111m000" role="session">Tables by Database (ttaad4111m000)</GUIRef> After you have defined the database codes, use this session to assign tables to the database. You can specify per company which tables belong to which database (type).</ListItem>
				<ListItem><GUIRef href="/baanerp/tt/aad/ttaad4120m000" role="session">Logical Tables (ttaad4120m000)</GUIRef> Use this session to define the logical table structure. You can define that the set of tables in a logical company must be stored under another physical company. In this way, you are able to store, for example, your item data and bill of materials only once in your system, while your financial data is stored in different financial companies.</ListItem>
			</ProcedureList>
		</GeneralSection>
	</GeneralSection>
</ManualTopic>
