Spotfire - Triggers to DB via passing parameter from dxp

Spotfire can execute stored procedures and these procedures could be fetching data, or can be procedures that can be run Pre or Post running a query. You can then use procedures that basically update your database table or even inserts new rows in tables.

When using Spotfire information model it allows you to use these procedures which you can repurpose for updating your database.
Spotfire also understands inputs to a procedure and they can be mapped to your marked rows/filtered rows/ properties/constants etc from your analytics.

Steps to do that would be
1)Create a procedure that accepts inputs e.g. what is the value you want to update and some sort of key column(s) identifier for the record to update.
2) Create a Spotfire procedure element
3) Depending if you procedure is going to bring back some data or not, use the query or pre or post option correctly.
4) Create an Information Link that uses this Procedure element.
5) Ensure that your inputs to procedures are parameters and then use ?name syntax to map them to parameters.
6)Now in your analysis you can add this information link and chose to make it on demand.
7)Map you inputs to desired marking, filtering or property controls etc.
8) Generally I would recommend not using Automatic updates to avoid unnecessary write backs and also not select caching to ensure the procedure is run every time you need to.

9)Then the last step is writing a small ironpython script trigger the procedure whenever desired. Attach the script to a button or a link as desired in text area

if ondemandTable.IsRefreshable and ondemandTable.NeedsRefresh:
   ondemandTable.Refresh()
   dataTable.Refresh()

PL/SQL Tutorial

Learn PL/SQL in few days.

Learning PL/SQL is not a rocket science and you can easily learn it if you know a li'l bit of SQL.
Lets first talk about SQL.
SQL being a Fourth Generation Language can allow only customized operations related to data, like data design, data manipulation, data retrieval and data control. SQL has no provision for implementing application specific functionality. A procedural language was introduced by Oracle to enable users to write application-specific SQL oriented programs.Procedural Language/SQL, extends SQL by adding constructs found in other procedural languages and some of those constructs are like variable, data types control structure and functions as we are 
using in some programming language like C, C++ etc.


This is the basic overview of PL/SQL and will come back later with more fruitful stuff.


keep blogging ! Adios !
Have a nice day !

WHY OBJECTIVE C

We all have coded a lot in several languages such as C C++ C# , VB etc...just for making some apps or doing things because of we are working somewhere without knowing the base of it.


Can anyone tell me why we are doing it or purpose of doing for the very first time when you wrote a code ?

I will tell you why we choose OBJECTIVE C n what is the use of it.

Just wait n watch.


C YA guyzz n galss catch ya in our next post !!!!!

CODE - LEARN OBJECTIVE C

HI Folks,
Nowadayz  every experienced software engineer has heard about this term OBJECTIVE C.

Objective is a object oriented programming language. Today it is used in APPLE Mac OS and iOS . It comes into picture juzz because the apps we made from the language.

All most all IT companies got project on the basis of Objective C developers.

Want to learn Objective C . Please visit the below link.


http://tutorialsblogs.com/objective-c-programming-tutorial-65-videos-series/

MS - DOS

MS-DOS - Microsoft Disk Operating System

It was a operating system for IBM PC compatible personal computers in 1980's.
MS - DOS 1.0 was launched in 1982 and has 8 version but alas ceased in 2000 by the company itself.
Today, MS-DOS is rarely used for desktop computing because the release of Windows 95,Windows 95 was integrated as a full product used for bootstrapping and troubleshooting, and no longer released as a standalone product.

But still whenever we need to manage our PC or Computer registry file or  to access system directories we use console screen(DOS promt window) and shoot some COMMANDS in it.
So MS-DOS is all about the commands.

Command and Code

Command, First thing come up in our(IT engineers) mind is - Go to Run in windows type CMD hit enter and what ever you write in it is all Kcommands.
In a very formal way "Command - A statement in computer language"
In computing, a command is a directive to a computer program acting as an interpreter of some kind, in order to perform a specific task. Most commonly a command is a directive to some kind of command line interface, such as a shell.


Code, Ah ! It is the only word which we have heard hell lot of times.
Can write the code in every application such as notepad , CPP compiler etc.
"Code is set of rules for converting a piece of information into another from of meaningful representation"
 There is numerous languages for writing codes and it's too hard to understand.


Nowadays IT world is in between these two terms COMMAND n CODE.