Blog

Installing and Configuring Data Integrator Client Using SQL Server as the repository

Follow these instructions before installing the Data Integrator client on the new users machine.

1. Give the user rights to the SQL Server database repository server.
boxi2.1Open SQL Server Enterprise Manager – Connect to the Database Repository Server. Ex: DIServer
Expand Security and right click on Logins – Select New Login
Select Search to find the user in active directory and add them

 

 

 

 

 

2. Create the Repository Database for the user

boxi2.2

Open SQL Server Enterprise Manager – Connect to the Database Repository Server. Ex: DIServer

Expand Security and right click on Databases – Select New Database
Following the naming convention for the database name
Ex: BODI_REPO_DEV_USER
The Owner should be the database user you just added to SQL Server
Ex: DOMAIN\UserName
Set the data file to 30mb

 

 

3. Create the repository tables in Data Integrator
boxi2.3Open the Data Integrator Repository Manager (You should have this app on your machine.
Database Type: Microsoft_SQL_Server
Database Server Name: Ex: DIServer
Database Name: Ex: BODI_REPO_DEV_USER
Check Windows Authentication

 

 

 

 

4. Select Create – If you get an error check the spelling of your Database server name and database name.

5. Setting up the Job Server – Each user will need a repository connection to the job server. This is setup in the server manager.

boxi2.4If you do not have Data Integrator Server Manager installed on your machine you will need to remote desktop to the Data Integrator Job Server machine.
Example: DIServer Open the Data Integrator Server Manager

Select Edit Job Server Config
Highlight one of the job servers and select edit

 

 

 

 

6. Select Add in the Job Server Properties Box

boxi2.5Database Type: Microsoft_SQL_Server
Database Server Name: localhost – Because you are on the repository server
Database name: Ex: BODI_REPO_DEV_USER
Check Windows Authenication

Then Select Apply and OK
Select OK on the Job Server Configuration Editor
Check with all DI users to make sure no one is running any jobs. Then select

 
7. Restart on the Data Integrator Server manager.

Select OKboxi2.6.
Install Data Integrator software on the users machine
Make sure you have admin rights to the users machine or the install will fail.

Oracle user rights needed for creating a local reporitory for a Data Integrator Job Server User

In Oracle:
A local or central Data Integrator Repository requires that you
Create a dedicated database and define a user with the right to:
Role
Connect
System
Create Sequence
Create Session
Create Table
Create View
Use the DI_Job_Server role which contains these rights.
Quota
Local_Rep Unlimited
Temp Unlimited

Under quota give them unlimited space to the tablespaces they will use always give them unlimited to the temp tablespace
Grant the user the connect and resource roles.

Installing the Data Integrator client software

From the Data Integrator CD, select Install Data Integrator.
Type in your name, company. For the client, don’t worry about the Host ID (which is mainly for the job server)
Continue through the installation until the license information page. Create a folder and store the license files in them. Browse and make sure the path is correct. Click Next.

boxi 6.5

 

 

 

 

 

 


boxi 6.5.2

 

 

 
Continue through the next page; do not worry about the code page.

Backup the control file

The trace file is created in the USER_DUMP_DEST Initialization parameter with a filename such as sid_ora_pid.trc
In SQLPLUS run the following command:

ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Oracle RMAN 11g backup and recovery

Backup and Restore using RMAN on Windows

Backup
Open a command prompt

  1. c:\>RMAN
  2. RMAN>connect target username/password@database
  3. RMAN>shutdown immediate
  4. RMAN> startup mount
  5. run {
    allocate channel Channel1 type disk format ‘c:\backup\oracle\%d_%T’;
    backup
    ( database include current controlfile );
    }

Restore

  1. Open a command prompt
  2. c:\>RMAN
  3. RMAN>connect target username/password@database
  4. RMAN>shutdown immediate
  5. RMAN>startup mount
  6. run {
    allocate channel Channel1 type disk format ‘C:\backup\orcle\%d_%T’; use the database file name
    restore ( database);
    }
  7. RMAN>recover database;
  8. RMAN>alter database open;
  9. If you receive the message “already restored to file” this means RMAN thinks the database files are in a correct state. Use the following command to overwrite the files Restore Force (database); instead of restore (database);.

New Restore
RMAN>Shutdown immediate
RMAN>Startup nomount
RMAN>restore controlfile from ‘c:\backup\oracle\DB_20050214’;

RMAN>Shutdown immediate
RMAN>Startup mount

run {
allocate channel Channel1 type disk format ‘C:\backup\oracle\%d_%T’; use the database file name
restore ( database);
}

RMAN>recover database;
RMAN>alter database open resetlogs;

Enable the hidden local administrator account in Windows 7

In Windows 7 and Windows Vista the local administrator account is disabled. Here are the following ways to enable the account. I recommend enabling this account if the computer will be part of a domain. You must be a logged in as a local administrator or know a local admin username and password.

Command Line
The nice thing about the command is that you can script enabling this account.
Select Start >Accessories > Right click on the Command Prompt > Run as Administrator
In the command prompt type the following command. This will enable the administrator account.
c:\> net user administrator /active:yes
Set a password for the administrator account. Replace the <password> with your own password.
c:\> net user administrator <password>

Computer Management
Select Start > Right Click on Computer > Manage
Computer management will load. Select Local Users and Groups > Users > Double Click on Administrator
Uncheck Account is disabled

Set the password in Computer Management
Right Click on the Administrator Account > Set Password

Installing a package or software on Linux

Package Management in Linux

Debian and Ubuntu

Install a Package

$ apt-get install <package>
Example: $ apt-get install tree
tree is the package that is installed.
Check if a specific package is installed

$ dpkg -l | grep <package>

List all packages installed

$ dpkg –print-avail <package>
or
$ apt-cache show <package>

Find the location of files within a package

$ dkpg -L <package>
Redhat

You can manage packages using yum or rpm

Install a package

$ yum install <package>

Installing apache: $ yum install httpd

Upgrading a package

$ yum update <package>

Uninstalling a package

$ yum remove <package>

Installing a package with rpm

$ rpm -ivh <packagename.rpm>

Upgrading a package with rpm

$ rpm -uvh <packagename.rpm>

Remove a package with rpm

$ rpm -ev <package>

How to insert an image in Adobe Acrobat

Open the PDF document in Adobe Acrobat Professional. Go to “Tools,” select “Comment and Markup,” and choose “Stamps.” Click on “Create Custom Stamp.”
Click the “Browse” button to select your image.
In the “Show” drop-down menu, make sure to select the format that your image is in.
Locate your image on your computer. Click “Select” and then click “OK.”
In the “Category” field, enter “My Stamps.” In the “Name” field, enter an easy to remember name for your image. Click “OK.”

1. Go back to “Tools,” then “Comment and Markup,” and select “Stamps.” Navigate to “My Stamps,” the new category you created. Select your image.

You should now see your image overlaying your PDF document. Move your mouse to the general area where you want your image and click. Your image is now stamped onto your document.
Click once on your image to select it. There should be a light blue border around the image. You can now use your mouse to re-size the image or drag it to a different part of your PDF document.

How to enable Air Drop MAC OS X

Air Drop is a great feature that allows you to easily transfer file between computers without having to know that name of the computer or the IP address. Air drop will automatically detect all other Macs on the same LAN running air drop.

Air Drop is not supported on older MACS even if you have OSX Lion or newer.

Figuring out if your MAC supports Air Drop:

If you Mac is the same or newer than the list below then your MAC supports Air drop. Running OSX Lion or newer.

MacBook Pro (Late 2008 or newer)*
MacBook Air (Late 2010 or newer)
MacBook (Late 2008 or newer)*
iMac (Early 2009 or newer)
Mac Mini (Mid 2010 or newer)
Mac Pro (Early 2009 with AirPort Extreme card, or Mid 2010)
* The MacBook Pro (17-Inch Late 2008) and the white MacBook (Late 2008) do not support AirDrop.

Good news is that you can enable Air Drop on an older MAC that is running OSX Lion or newer running the following command inTerminal.

Accessing Terminal:
In the Finder Applications>Utilities>Terminal

In the command line in terminal type the following command:
# defaults write com.apple.NetworkBrowser BrowseAllInterfaces 1
terminal_mac

Disabling the Remote on your MAC

Go to Settings – Security and Privacy – Firewall – Advanced – Check Disable Remote Control Infrared Receiver.

Disable Infrared Receiver, disable IR Receiver, disable mac remote