apalonquantum

(Version 9.6.0) Installation and Upgrade Guide. Informatica PowerCenter Express Installation and Upgrade Guide. Informatica, Informatica Platform. This blog is a step by step guide for Informatica installation and helps you to configure its services required for a complete functioning of PowerCenter. Hi, Is it possible to install Informatica powercenter 9.0.1 services on windows 7 home basic? I refered pc901_installationAndConfiguration_en file, in.

The post has been successfully mailed. Email this Post 22.8K • • Informatica provides the market’s leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform interoperates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today’s market as a leader in the data integration platform. In this blog, I will help you with Informatica installation and configuration of its services. Let’s begin by setting up of Oracle database as our primary database on your system.

In case you have already installed and configured the Oracle Database and SQL Developer, you can proceed directly to Oracle Database Installation To commence with the Oracle installation, begin by downloading the setup zip file from the link below. Step 1: Download Oracle Database Express Edition from the below link (I am installing on a Windows 64 bit OS, so I have selected windows 64): • (64 bit) • (32bit) Step 2: Once the file download is complete, extract the file: Step 3: After extracting the file you will get DISK1 folder, Open the folder.

Step 4: Double click on setup to start installation: Click on Next. Step 5: Accept the terms and click on Next. Click on Next. Step 6: Specify the Database Password. • Enter Password: oracle123 Note: If you are choosing your own password so please make a note, we will need this password again. 1000x1000x1000 Rubik S Cube Software on this page. Note: The Default port in which Oracle listens is 1521. Click on Install.

This may take a while. Step 7: Click on finish to complete the installation. Configuration of Oracle SQL Developer Before beginning the SQL developer installation, make sure you have started the database. If the database isn’t started, the connection between the SQL developer and database will fail. To start the database: Go to Start ->Oracle Database 11g Express Edition ->Click on Start database.

Now we can begin the Configuration of Oracle SQL Developer: Step 1: Begin by downloading Oracle SQL Developer zip file. I recommend you use SQL Developer 3.2.20 as the later versions require you to install Java 1.8 and manually set the path. You can download the file from the link below: • Step 2: Once the download is complete, extract the downloaded file.

Step 3: After the extraction is complete, you will get sqldeveloper – 3.2.20.09.87 folder. Enter the sqldeveloper – 3.2.20.09.87 folder and double click on click on sqldeveloper to start configuration. Note: If we go for the version 4.0 or higher of SQL Developer we need to install JDK 1.8 and we have to manually configure the complete path so we will recommend to go with version 3.2 itself. Step 4: Once the initialization is completed, you will get to the home screen below. Do not select any configure file type association, directly click on cancel.

Step 5: To establish the connection, start by right clicking on connections and Click on New Connections. Step 6: We will now connect to the Oracle Database. Enter the following details as below: • Connection Name: ORACLEXE • Username: sys • Password: oracle123 (here we have to specify the same password that was set while database installation) • Role: SYSDBA Click on Save ->Test ->Connect Once we will click on connect we can see the Connection is added in the list. Step 7: Now click on the Plus icon next to ORACLEXE to get the screen below: Step 8: Now we have to create 2 users. • INFA_DOM (For Domain) • INFA_REP (For Repository) Right click on Other Users to create user.

Click on Create User. Step 9: We will now be creating the user for domain. Enter the following User details: • User Name: INFA_DOM • Password: INFA_DOM • Default Tablespace: USERS • Temporary Tablespace: TEMP Note: After specifying all the details do not click on Apply Step 10: Click on roles tab to define the roles of the user.

Step 11: We have to assign the Domain user complete permissions for: • DBA • CONNECT • RESOURCE Scroll down for to find resources role: Step 12: Now Click on Quotas tab to assign tablespace area: Step 13: Select USERS and assign the unlimited option. Click on Apply Click on Close. User INFA_DOM has successfully been created. Step 14: Now we will click on Connection and New Connection to connect to Domain user. Step 15: Enter the following user details: • Connection Name: INFA_DOM • Username: INFA_DOM • Password: INFA_DOM • Connection Type: Basic • Role: Default Click on Save ->Test ->Connect Once we will click on connect we can see the User is added in the list Step 16: We will now add Repository user in the similar manner. Click on other user and add users under ORACLEXE. Step 17: Enter the following details for Repository user: Username: INFA_REP Password: INFA_REP Default Tablespace: USERS Temporary Tablespace: TEMP Step 18: As in Domain user, provide the Repository user with complete permission for following roles under R oles tab: • DBA • CONNECT • RESOURCE Step 19: Click on Quotas tab and select unlimited option for Users as seen below: Click on Close.