Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How to Create report using external databse(Mysql)

By
chirra
on 8/6/15, 6:36 AM 571 views

Hi

I connected to external database(MySQL) and getting data from database,but my requirement is create report using external database data,how can i achieve this

pls help me

thanks

0
Sascha Pfeiffer
On 8/7/15, 3:05 AM

Idea 1) First of all, this idea is untested! Its not simple and requires some knowledge of postgres and creating own openerp moduls. The idea: Use postgres foreign data wrapper to connect to the mysql database tables. So you have all your tables from mysql in your postgres database. Then you create own models, with an ORM that reflects your mysql tables, define the proper fields for every column and so on.

Idea 2) Create the datastructure of your mysql database with an own module and write a data copy script to import your data.

In the next step (no matter which idea you chose before) you can define reports based on those ORM or define views on those other tables.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 8/6/15, 6:36 AM
Seen: 571 times
Last updated: 8/7/15, 3:07 AM