DAC CONFIGURATION
- Extraction Of the Software
- Download the zipped DAC folder to the installation server from the windows virtual machine
- Extract the DAC folder to the /u02 directory.
- DAC Configuration
- Run the Dac Client by running the “Start client.bat” as follows
- From the dac client, Click the Configure button
- Select Create Connection option and click next
- Enter the details in the dialog that appears as follows and click on the “Authentication File” option.
- Select “Create Authentication File” in the dialog that appears and click ok.
- Provide the name for the Authentication file and save it.
- Give in the details regarding the DAC database user to generate the authentication key.
- After the configuration, click on the test connection to see if the details fed in are correct or not and click “Apply” to save the connection details; then click finish.
- Then select the connection created from the list, type in the username and password; Select the authentication type to DAC and click on login.
- Which leads to the requirement of tablespace name which is optional so we proceed with no value provided by clicking YES.
- Provide the user name and password for the DAC Repository and click OK.
- Where we will be prompted for login credentials preferred for the DAC.
- DAC Client will be started.
- DAC Server Configuration
- Click on Tools→ Dac-Repository → Import
- From the following dialog, select the appropriate containers for our test server.
Select the truncate Repository tables option and enable the bulk load option. After selecting the containers, Universal, Data Warehouse, Oracle 11.5.10, Oracle R12.
- When we are finished, click OK. Which gives rise to the following dialog. Give in the same seen in the dialog and click on Yes.
after which, the containers selected will be imported to the DAC server
- Select Tools → DAC server Management → Repository Configuration.
- In the repository configuration dialog, enter the host, alternate host, port details for the DAC server.
- Thus DAC server configuration is done.
- DAC SERVER START.
From the console environment, run standaloneServerSetupPrompt.sh and perform the following steps.
########This session was copied from the putty instance run from the VM 142#######
[dac@sss]$ ./standaloneServerSetupPrompt.sh
OS detected: Linux
Warning! Use this utility for standalone DAC only. Run Server Setup from DAC Client for web mode.
What can I do for you?
1 - Enter repository connection information
2 - Test repository connection
3 - Enter email account information
4 - Send test email
5 - Save changes
6 - Exit
Please make your selection: 1
These are your connection type choices:
1 - MSSQL
2 - DB2
3 - Oracle (OCI8)
4 - Oracle (Thin)
5 - Keep current ( Oracle (OCI8) )
Please make your selection: 4
Current value for Service name is orcl.
Press return to keep it or enter a new value.
> orcl
Please enter Database Host
> localhost
Please enter Database Port
> 1521
Please enter DB Driver (Optional)
>
Please enter DB URL (Optional)
>
Current value for Table owner name is DAC_REP.
Press return to keep it or enter a new value.
> DAC_REP
Press return to keep current Password, enter a new value otherwise.
> DAC_REP
Press return to keep current Encryption key, enter a new value otherwise.
> 52D973BFEA1A5B4A53192240AA4FEBA5
What can I do for you?
1 - Enter repository connection information
2 - Test repository connection
3 - Enter email account information
4 - Send test email
5 - Save changes
6 - Exit
Please make your selection: 5
What can I do for you?
1 - Enter repository connection information
2 - Test repository connection
3 - Enter email account information
4 - Send test email
5 - Save changes
6 - Exit
Please make your selection: 2
Connecting to repository...
Connection was successfully established!
Press enter to continue...
What can I do for you?
1 - Enter repository connection information
2 - Test repository connection
3 - Enter email account information
4 - Send test email
5 - Save changes
6 - Exit
Please make your selection: 6
[dac@sss]$
######################################################################
- After the successful configuration, start the DAC server by running the startserver.sh from console/putty.
- Informatica Configuration on DAC-TEST
- Click on the setup tab in the dac main window.
- Select the informatica server tab on the right pane and enter the details about the informatica Repository service by selecting it.
- Then click on test connection.
Since the test was successful, click OK and save the details. (The following is the details in the above dialog).
######################################################################
Connection to "INFORMATICA_REP_SERVER" successfully established!
Connectivity Information:
=====================================
STD OUTPUT
=====================================
Informatica(r) PMREP, version [9.0.1 HotFix2], build [242.1110], LINUX 64-bit
Copyright (c) Informatica Corporation 1994 - 2010
All Rights Reserved.
This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,254,590; 7,281,001; 7,421,458; and 7,584,422, international Patents and other Patents Pending.
Invoked at Thu Sep 19 04:35:37 2013
Connected to repository SYNA_BIDW_REP_TEST in Domain_usu-etls-test.synaptics.com as user Administrator
connect completed successfully.
Completed at Thu Sep 19 04:35:42 2013
=====================================
ERROR OUTPUT
=====================================
"INFORMATICA_REP_SERVER" – online
######################################################################
- Then select the informatica service from the list and enter the details as follows
- After which, test the connection which displayed the following dialog. Click OK and save the details.
- Database configuration
- Click on the physical datasources tab in the right pane of setup and fill in the details of the souce system details in the oracle 11.5.10(thin) as follows.
Later configure the details of the target in the data warehouse connection as follows
while installing dac,im getting error as
ReplyDeleteFailure connecting to "informatica_repository"!
ANOMALY INFO::: Error while pinging informatica repository server
MESSAGE:::D:\dac\log\pmrepConnect.log (The system cannot find the file specified)
EXCEPTION CLASS::: java.io.FileNotFoundException