Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
4415 Lượt xem

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

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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.

Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
0
thg 10 23
1197
0
thg 6 23
1705
1
thg 7 22
1765
2
thg 10 21
7004
0
thg 5 16
7636