How to show data stored in Liferay database in another website?


Problem :

I'm developing a WordPress website in which I have to show data/information stored inside a Liferay database. I am new to Liferay, so I don't know the best practices to access data stored into Liferay's DB and show them to my website.

I want to know if there are some guides or documentation that can explain to me how I can access data, in the same way that I access a MySQL DB with PHP. I also took a look at the official Liferay documentation, but it only describes accesses through the usage of PHP portlets.

Is there another way to connect to database and get back data from a query, or do I have to perform a sort of "middleware" translation from data in Liferay to my website?

My CMS contains data formatted in XML, so have I to do a translation from XML to PHP-style variables? Also, do I need to create a sort of correspondence from XML objects to PHP variables?



Solution :

I can think of three ways you can get data from Liferay to display in your website:

  1. Directly through Liferay database, if you have access.

    But to get data directly from the Database tables of liferay you should have a fair amount of understanding as to what each table is for. Liferay DB schema would have been helpful but I think Liferay likes providing puzzles to its users ;-). Still the tables and columns are not so complex to understand if you can give some time. Or post a specific query and will answer if I know about it.

  2. Another recommended way of accessing liferay's data is through Liferay web-services, all the assets, users, organizations and sites are available as services. So you can build web-service clients and consume the data.

  3. Another way is through Sharing of Portlets. The User-guide will help you understand this. You can directly embed portlets in your site just like we can embed video player from youtube in any site with youtube's embed script.

Hope I have understood what you require and hope this helps.


Mysql Tutorials

Mysql Howto..

How to set up a database and API web page to accept POST updates from iPhone?

How to implement a nested comment system?

How to parse data from a mysql tracking db?

how to store object type field in mysql using sails

How to insert data into mySQL table with java [closed]

MySql how to not show blank spaces using PHP?

MySQL C API: How to work with row from mysql_fetch_row()?

When creating a view in MySQL, how to define a column as the result of calculations using other columns in the same view?

How to read data from Excel spreadsheet and store into MySQL database [closed]

How to display multiple rows of comma separated values from mysql db

how to set triggers with the dynamic values in mysql?

How to prevent/restrict blank values from being added to a mysql database in java?

How to access MySQL Python Connector with Python 2.7.8 and Sublime Text 3 on OS X 10.9

How to update fields that is the aggregate result of another table in MySQL?

How to optimize this query with multiple substring and subquery

Convert Date to a number in mysql (Like how a date converts in Excel)

How to work out a small Adobe AIR Application?

how to get all the records from MySQL table in php web services

How to order my MySQL records ? | MySQL - WordPress

How to use foreign keys and a spatial index inside a MySQL table?

How to create an insert Form with TextInput containing ComboBox provided by mySQL Database Table

How to use ReportViewer in VS 2012 Express from MySQL

How to get values for an android application

How to generate the highest number from one column in mysql database with php

How to get particular date in mysql?

how to import excel file in mysql database using php? [closed]

How to use mysql full text search when title and text are in two separate tables?

How to bind MySQL table to datagrid in WPF app

How do I get PHP to convert a blank field in MySQL to “0”?

How to make my query working (query on multiple tables)