Taleo Connect Client - How to use Last Run Date (LRD) in TCC Export

Hello all, Happy Sunday!

Some time back i posted couple of videos on my YouTube channel talking about Taleo Connect Client (TCC) its export and import functionalities. 

Today i thought of sharing some more info in regard to a key feature when it comes to TCC exports - Last Run Date (LRD).

From Oracle to Outlook - automating SQL query output using Python - Part II

Ok, here is the second and final part of this topic. So lets resume from where we left off

Now that the building blocks are clear, let’s walk through what actually happens when you run the script

From Oracle to Outlook - automating SQL query output using Python - Part I

Hello all,

It's been a while since my last post. Things have been busy especially in Australian payroll legislation space - Payday Super, AU Legislative changes after budget, etc. etc. 📜

As I have got some breathing space for now, so here is an attempt from my end to share knowledge around how i have been using Python 🐍 to fetch data from on premise Oracle Database and then capturing the same in outlook email message.

This can be a very useful thing for anyone who want to send a summary email to his/her team or management. The design of my solution is quite generic and the good thing is, you can use the template and can add queries as per your requirement and the output will just get appended in the outlook mail body 

I have made this into a two-part blog post. In this first part i'll be writing about the building blocks and components. The next part will have details with a real example

From a high level, the flow is:

1. Setup logging and directories
2. Load database credentials
3. Open the Oracle connection
4. Build the list of SQL query definitions
5. Execute each SQL query and convert results to HTML
6. Assemble one HTML email body from all sections
7. Create an Outlook draft with that HTML content