Build Your Own Enterprise Data Warehouse

Ingredients:

• 1 Teradata 
• 1 Oracle
• 1 Informatica

Teradata Express 13 for Windows:

• Sign up, get email link from Teradata and download and install: http://www.teradata.com/t/teradata-express-13-0-windows/
• Get the FAQ: http://www.teradata.com/t/express-faq.aspx?id=12290
• Teradata Education Network:
•  http://www.teradata.com/t/ten-lander.aspx?id=5690
• Teradata, creating tables: http://developer.teradata.com/database/articles/what-you-need-to-know-before-creating-a-table-in-teradata
• Teradata Data Mover (TDM): A tool for moving database objects: http://developer.teradata.com/tools/articles/intro-to-tdm-create-your-first-job

Teradata Support Links and User Forums:
Teradata Support Links

• http://www.teradata.com/t/
• http://www.teradata.com/DownloadCenter/
• http://www.info.teradata.com/
• http://www.teradatamagazine.com/
• http://www.teradata.com/t/demos/
• https://tays.teradata.com/web/guest/home

Teradata User forms

• http://developer.teradata.com/
• http://www.teradata.com/t/user-groups//
• http://www.teradataforum.com/
• http://www.tek-tips.com/

 
Oracle 10g for Windows (or Linux):

Obtain and install from you company or get an easy Express edition: http://www.oracle.com/technetwork/database/express-edition/downloads/index.html

 

 
 
Informatica:

• Obtain download from your company or download 8.1 through Oracle and install.
• Known as Hyperion Data Integration Management Release 11.1.1.1.0 Informatica Power Center 8.1.1
• These are 2 large files requiring acceptance agreement.
• Keys are free from Oracle here: http://www.oracle.com/ocom/groups/public/@ocom/documents/webcontent/161646.zip Derived from this page here: http://www.oracle.com/us/support/licensecodes/hyperion/index.html

 
Hard Part--Configuring the connection string to Oracle for the repository and editing the tnsnames.ora. You won't know you have problems with this untill you are installing the Informatica and it is trying to connect to your existing Oracle.
 

Tips:

1. Alias HAS to be FULL domain name (i.e. ms.aus.amer.dell.com)
2. Service name HAS to be FULL domain.  (i.e. ms.aus.amer.dell.com)
3. Instance = name only (i.e. ms)
4. All this can be changed in text only in the tnsnames.ora file
5. Configing the install though requires ONLY the full name.  (i.e. ms.aus.amer.dell.com) since SERVICE_NAME and ALIAS are now the same.
6. DO NOT use the help in Informatica on this suggesting "World", etc. It only confuses the issue.
7. A good resource on this is http://www.databasejournal.com/features/oracle/article.php/3092461/Connecting-with-Oracle.htm
8. Many many googled people have this problem and I found no real solid answers. (lots of different answers)
9. Example  tnsnames.ora file:

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

EXTPROC_CONNECTION_DATA.amer.microsoft.com=

  (DESCRIPTION=

    (ADDRESS=

      (PROTOCOL=IPC)

      (KEY=EXTPROC0)

    )

    (CONNECT_DATA=

      (PRESENTATION=RO)

      (SID=PLSExtProc)

    )

  )

ms.amer.microsoft.com=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = mycomputer.amer.microsoft.com)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = ms.amer.microsoft.com)

      (INSTANCE_NAME = ms)

    )

  )

Useful tools:

CMD LINE:

• TNSPING <alias in tnsnames file>
• LSNRCTL <enter>
• LSNRCTL help <enter>
• http://ora-12154.ora-code.com/

Install tips:

• Uninstall any previous Oracles and delete all registry keys, reboot then delete all folder structures and temp files.
• During install uncheck the "Create Starter Database".
• Take in all defaults except switch to character sets to UTF-8 under tab option.
• When completed, run the Database Configuration Assistant in program files from Windows Start.
• Next run the Net Config Assistant. Walk through defaults and Finish!
• Check services.msc and see if Oracle products are running.
• If included in license, log on to your admin through browser with http://machine_name.domain_if_included:1158/em

Running:

• First thing I do is log in through browser and copy the SYSMAN user and give my self a new login. Simple name with same password. Add rights if wanted.
• Then I fire up TOAD (software frontend for Oracle) and configure it to my new database.
• Schema = Login name; Instance
• This is where you get to config your tnsname.ora file. This guides your TOAD to services. Examples are in sample folder.
• Port = 1521; Server = <full name from set up>; Config for the Listener can be found in web front-end on front page link. It gives the network data needed for tnsnames.ora file.
• Example: (ADDRESS=(PROTOCOL=TCP)(HOST= mycomputer.amer.microsoft.com)(PORT=1521))

Help:

Some help and guidance available here but I don't recommend going the Windows Server 2003 and VMWARE route as described.

http://jiri.wordpress.com/2010/03/17/informatica-powercenter-up-and-running-in-less-than-30-minutes-and-yes-its-free/