You are not logged in.

Python Palo Interface - new release

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

barras

Intermediate

  • "barras" is male
  • "barras" started this thread

Posts: 9

Date of registration: Dec 12th 2007

Location: Milan

Occupation: web entrepreneur

Hobbies: web, music, economy

  • Send private message

1

Monday, February 9th 2009, 7:17pm

Python Palo Interface - new release

Hi all,

if someone had tried my wrapper, here's the new version of Python Palo Interface. I fixed some bug and added methods for create cube and dimension from scratch.

I would appreciate very much if anybody let me known their opinion on my wrapper.

Bye,

Fabio
barras has attached the following file:
  • PyPaloWebApi.zip (8.77 kB - 868 times downloaded - latest: May 20th 2013, 2:13pm)
Fabio Marras
http://about.me/fabio.marras

sajo

Intermediate

  • "sajo" is male

Posts: 15

Date of registration: Feb 11th 2009

  • Send private message

2

Wednesday, February 11th 2009, 10:56am

RE: Python Palo Interface - new release

Fabio,

I played around with your previous version. Worked well!

Will try out your updated version in the coming days.

Simon

csae1603

Intermediate

Posts: 15

Date of registration: Jun 28th 2008

  • Send private message

3

Wednesday, February 11th 2009, 1:40pm

RE: Python Palo Interface - new release

hi barras,

what for do you use a wrapper ????
what is the benefit for palo ??

greats,
markus

barras

Intermediate

  • "barras" is male
  • "barras" started this thread

Posts: 9

Date of registration: Dec 12th 2007

Location: Milan

Occupation: web entrepreneur

Hobbies: web, music, economy

  • Send private message

4

Monday, March 9th 2009, 10:38pm

RE: Python Palo Interface - new release

I am very sorry to reply after so long, but believe me, I was very busy. I decided to develop the wrapper in python because I'm one of the many enthusiasts of python and use python for proceedings ETL. Mainly I use the wrapper to transfer data from a datawarehouse to Palo dbs, and vice versa.

Bye,

Fabio
Fabio Marras
http://about.me/fabio.marras

zzr

Trainee

Posts: 2

Date of registration: Oct 13th 2008

  • Send private message

5

Friday, May 15th 2009, 1:56pm

RE: Python Palo Interface - new release

Quoted

... and use python for proceedings ETL. Mainly I use the wrapper to transfer data from a datawarehouse to Palo dbs, and vice versa.

Hi, Fabio! Can you please tell more about your ETL Python experience (tools, algorithms, caveats)?
I'm working on little"BI" system for our project and considering using Infobright Community Edition as data warehouse, palo as olap server, and python for etl and reporting, but where is a lack of information about this on the Internet :(

I will be very appreciated for your help

barras

Intermediate

  • "barras" is male
  • "barras" started this thread

Posts: 9

Date of registration: Dec 12th 2007

Location: Milan

Occupation: web entrepreneur

Hobbies: web, music, economy

  • Send private message

6

Saturday, May 23rd 2009, 12:41am

RE: Python Palo Interface - new release

I zzr,

as you, I work on a small BI system with MySQL as DW and Palo as OLAP server. I use Palo only to provide data to excel application. As I wrote, I use python for proceeding ETL, but I don't use a specific tool.
For some moth I've been trying to use SQLAlchemy - a python object Relational mapper (something like Hibernate) - and my first impression is very good. I did some test for putting togheter SQLAlchmey and my wrapper and the results are very promising. I never use python for reporting, but it seems that the best product is Reportlab.

I hope to have been useful.

Fabio
Fabio Marras
http://about.me/fabio.marras

sajo

Intermediate

  • "sajo" is male

Posts: 15

Date of registration: Feb 11th 2009

  • Send private message

7

Wednesday, March 23rd 2011, 2:25pm

RE: Python Palo Interface - new release

Fabio,

Your wrapper is FANTASTIC. I have been using it intensively over the past few weeks with Python 2.7.1 . Error free and far better to work with than the ETL server (doesn't crash!). Btw in combination with NumPy and other libraries allows endless ways to process data....

Thanks once again.

Simon

barras

Intermediate

  • "barras" is male
  • "barras" started this thread

Posts: 9

Date of registration: Dec 12th 2007

Location: Milan

Occupation: web entrepreneur

Hobbies: web, music, economy

  • Send private message

8

Wednesday, March 23rd 2011, 11:13pm

RE: Python Palo Interface - new release

Hi Simon, I'm very glad to hear that you appreciate my wrapper.

In the last two years I had to stop working with Palo, and so I stopped enhancing my wrapper, but I enjoyed very much to develop it.


Fabio
Fabio Marras
http://about.me/fabio.marras

fab10m

Intermediate

  • "fab10m" is male
  • "fab10m" started this thread

Posts: 9

Date of registration: Dec 12th 2007

Location: Milan

Occupation: web entrepreneur

Hobbies: web, music, economy

  • Send private message

9

Sunday, February 12th 2012, 6:18pm

Python Palo Interface - bug fix

This is a bug fix release.

Thanks to Brad: "I believe it is based on the number of connections. Your code works great and is well written... after doing some searches it looks like the problem is with urllib2 which has issues with threads and creates a separate connection with each call. Eventually the ports fill up and it throws the error (I found the same stack overflow article and some others that support this theory). I'm going to try to rewrite the code using urllib3 and see if it solves my problem" and "Upgrading to urllib3 did the trick (urllib3 handles threads and doesn't leave ports open like urllib2).
I took the liberty of renaming everything 'Palo' to 'Jedox' to keep things straight. Other than that it was a minor modification. The important part is the api interface you wrote which remained the same
with one exception. Urllib3 uses .data rather than .read() to retrieve the response. Not much else to report. It works for my test script where urllib2 failed...so problem solved (at least for now)."

Fabio
fab10m has attached the following file:
Fabio Marras
http://about.me/fabio.marras

Modzho

Intermediate

  • "Modzho" is male

Posts: 7

Date of registration: Jun 26th 2010

Location: Latvia

  • Send private message

10

Friday, May 25th 2012, 1:37am

Python Palo Interface MOD

Hi Fabio!

Very good wrapper. :thumbup: Easy to use. I develop small budgeting application using Qt PySide and this wrapper.
I modified it to suit my needs and added documentation in .chm and .pdf format.

Edit:
Update - unicode ( utf-8 ) support.

This post has been edited 1 times, last edit by "Modzho" (May 26th 2012, 2:46pm)

fab10m

Intermediate

  • "fab10m" is male
  • "fab10m" started this thread

Posts: 9

Date of registration: Dec 12th 2007

Location: Milan

Occupation: web entrepreneur

Hobbies: web, music, economy

  • Send private message

11

Friday, May 25th 2012, 10:47am

Python Palo Interface

Hi Modzho,

thank you very much for the compliments and for having mentioned me in your version of the wrapper.
I had a look at your documetation and the module PyJedoxWeb.py: great job!!

Fabio
Fabio Marras
http://about.me/fabio.marras
Rate this thread