poetic has asked for the wisdom of the Perl Monks concerning the following question:

Hello All, My name is Poetic I am new to the Perl world. I work withing the technical support areana and I am trying to create a single point of information gathering for all technical problems that have to be fixed by 1 of my teams. This single point platform must have the ability to push data onto various other Database systems such as iHeat, AcT etc.... Is this possible using Perl? Feedback on this will be appreciated, as we have just started the thinking stage of the design implementaion ;-#). Regards Poetic;

Replies are listed 'Best First'.
Re: pushing data
by Art_XIV (Hermit) on Dec 31, 2003 at 14:08 UTC

    I can't answer your question specifically since i've never dealt with iHeat or Act!, but I can offer some info that may be of use to you. Other monks might have better info.

    Perl can handle access to most common database engines using one of the DBI modules, and even a few other modules. Searching on 'DBI' on this site or google will render tons of info on that subject for you. Access via DBI depends upon the database engine that Act! and Heat use. The support people/site for the products should be able to tell you what the engines are. I'll bet a dollar that they use xBase engines. I can almost guarantee you that if the product is capable of ODBC, then you can use DBI with it, too.

    Perl is great for data slinging and munging. This is an area in which Perl truly shines.

    You might also want to google or check sourceforge to see if there are any projects that could provide a nice start/basis for your project.

    So, the short answer to your question is: Probably. ;) If there is any way to interface with product (via any language), then chances are that Perl can do it.

    Hanlon's Razor - "Never attribute to malice that which can be adequately explained by stupidity"
[reply]
Re: pushing data
by Roger (Parson) on Dec 31, 2003 at 13:45 UTC
    Yes this is possible using Perl.

    You will need to learn a lot of things first before you could tackle this task in Perl though, since you are new to Perl.

    On the database side, you need to learn how to use DBI and DBD::{Database}. There are a few database tutorials here at Perl Monks. You can find the tutorials if you browse under Tutorials.

[reply]

Back to Seekers of Perl Wisdom