Thursday, January 29, 2015

Getting started with Taleo Connect Client (TCC)

 

 

I have recently switched tracks to the cloud world of enterprise computing, and am going through Taleo. It is Oracle's recruiting/onboarding HR system, which has still not been fully integrated to HCM Cloud. Taleo Enterprise Edition runs on the web in any browser, however for batch integration purposes, it provides a standalone executable program called the Taleo Connect Client ie; TCC. (The last TCC I knew was the Turbo C Compiler from Borland Systems). If you need to import/export records in Taleo in bulk, TCC is the way you go.

 

1: First, log on to Oracle eDelivery, and choose the Taleo family of products. I am choosing the 32 bit windows version, because I can.

 

image

 

2: The current & latest version of Taleo, as of writing this, is 14A. You see, Taleo pushes three fixes in a year, and call them A,B and C. Be sure to click the link "Oracle Taleo Enterprise Editoin 14A", the other links are for older releases. The latest release came out just yesterday !

 

image

3) On the next page, you will see multiple links, and have to choose only two. Choose the windows version of the Application Installer and Data Model.

 

 

image

4) Now unzip the files and run the installers. I am going to run the top two installables in the screenshot above.

 

image

5) First install the data model. The Application installer requires the path were the data model is installed.

 

image

 

image

 

6) After running both installers, start the Taleo Connect Client.

image

 

 

image

 

7) OK, you will now get this window to start using the Tool. All the fields above need to be filled.

 

image

8)  Choose a product name from the latest version, don't worry, you can always change the product later.

The Protocol will be HTTPS.

The Host will be the address of your cloud instance. You need to register with Oracle to get this. It is also the place where you will configure and use the Taleo Application. Choose 443 as the port value.

Authentication:  I chose User Name Token authentication.

Now enter the credentials of the user allowed to use Taleo Integration Services, usually the administrator login.

 

image

9) Ahaa…Finally. The TCC window opens up.  But there is still lot of steps involved to start exporting/importing data to the system.

Saturday, January 10, 2015

Siebel BIP Performance Tuning

 

1) Increasing the amount of heap memory available to the Java Virtual Machine (JVM)

Increasing the memory available to the JVM can improve the performance of the report generation and ensure that this error is not encountered.

"C:\OraHome_1\jdk\bin\java" -XX:MaxPermSize=128m -Xms512m -Xmx512m -Duser.language=en -Duser.dir=C:\OraHome_1\oc4j_bi\bin -Duser.country=US -jar "%OC4J_JAR%" %CMDARGS%

OS

Memory Value

Windows (32-Bit)

Any value of up to 1.4GB (based on available RAM)

Windows (64-Bit)   

1.4 GB or higher (based on available RAM

2) Changing the Server Request Processor DB Polling Interval

By decreasing the polling interval the Server Request Processor can check the S_SRM_REQUEST table more regularly thereby reducing the period before the request processing is started. Once the change has been made it is necessary to shutdown and restart the affected Siebel Server before the change will take effect.It is recommended that this change be made only on the Siebel Servers hosting the XMLPReportServer component as this change will result in an increased number of queries being issued against the S_SRM_REQUEST table in the database.

change param PollIntvl=1 for comp SRProc

3) Minimize the size of Integration Objects/Components

An excessive number of unrequired fields in the report will lead to increased data generation times from the XMLPReportServer component and will result in an increased data file size for BI Publisher to process.

4) Minimal Force Active fields on  BC-

Ensuring that a minimal number of fields are flagged as Force Active will help to ensure that the number of fields being returned when querying against the Integration Component for report generation is further reduced.

5) XMLPReportServer PreloadSRF parameter to TRUE

Prelolading the SRF into the process ensures that any performance overhead during the SRF load is encountered during component startup and not during report processing. This parameter is listed under Advanced tab.

6) Inactive Web Services not used in Enterprise

Due to Bug 10587893 at present the component will load all of the active webservices configured in the enterprise rather than just those which it may access, such as PublicReportService or PublicReportService_v11. This leads to a performance overhead during the first report request for any process as these can take a significant period of time to load. In order to reduce the impact of this loading process review the webservices configured as 'Active' in the Siebel Enterprise through the Administration - WebServices > Outbound Webservices and Inbound Webservices views.  Set any webservices which are not used in the enterprise to 'Inactive'..

7) Minimize logging levels on all report generation components

This will include the requesting Object Manager, the XMLPReportServer component, the EAI Object Manager, the File System Manager component, and the BI Publisher Server itself.

8) Eliminate any un-necessary scripting during report generation

 

9) Create Separate Named Datasource For Siebel BI Publisher Reports With Large Data Volume

Generating Large Reports (over 10,000 records) - When running report generation there may be scenarios in which more than 10,000 records need to be retrieved. The standard ServerDataSrc within the Siebel Enterprise has a row limit of 10,000 for any single query and therefore in order to support large report generation a custom data source is required without this restriction.

Wednesday, January 7, 2015

IP 2014 - Aurora theme

 

 

This is my reaction on seeing the new Aurora theme in Siebel IP 2014.

mark-13

Cisco VPN Auto Connect

 

Happy New Year !

I was hoping the new year brings some change in my professional or personal life, and looks like things are changing. I have wrapped up another Siebel + BIP On Premise deployment and now moving onto the cloud. We were having some bad network related issues on the last project, the VPN would timeout sporadically. Then we would have to open it up and again enter the VPN credentials to get back in.

Here is a BAT file I wrote to automate the connection sequence. Save the following into a text file with .bat extension.

-----------------------------------------------------------------------

 

cd "C:\Program Files\Cisco Systems\VPN Client"

start vpngui.exe

vpnclient.exe connect <VPN Connection entry> user <userid> pwd <password>

 

-------------------------------------------------------------------------

 

Assumption is that Cisco VPN software is installed on your C: drive.

The executable vpnclient.exe is the actual software which makes the connection, but then, it does not put an icon in the taskbar. So when the connection terminates, it does not tell you so. That's why we open the vpngui.exe windows executable as well. This tool will show the connection status in your taskbar, so you will alert you when the VPN disconnects.

image

Hope it helps !

Friday, January 2, 2015

Siebel Quizzes !

 

If you haven't already checked out SiebelHub.com, I suggest you head there right now. Specially their Quiz section. Its the best place to brush up your brain cells, and learn of the latest happening in the Siebel world. You will need a linkedin account to participate.

Good Luck Quizzing !