nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to link database from SQLyog to BIRT Eclipse

DarkSilver

Hi guys, I am new to BIRT. Can you all please teach me on how to link database from SQLyog to BIRT Eclipse? I have created a store procedure in SQLyog but now I am confused on how to display the data in BIRT Report. I am sorry if there are anything wrong, I am really blurred now. Please help me. Thank you.

Find more posts tagged with

Comments

kclark

Were you able to create a data source and data set from your data?

DarkSilver

When I try to create new data source, in the drive, I only have 2 options (I think is the sample database: classic models & apache derby) so I dont know from where should I insert my database. But now I have more urgent problem, I cant open my eclipse. I think, the error start when I update my java. Now my java is 7.45. Eclipse, I used :eclipse-reporting-kepler-SR1-win32SQLyog, I used: SQLyog-11.2.7-0.x86Community And I have this error:

kclark

It sounds like you're needing to select JDBC as your data source, then you would need to specify what drivers you need to use.

DarkSilver

Dear clark,I have solved the above problem but now I have new problem.

kclark

Are you getting the same results when viewing the report in the web viewer instead of the preview tab?

DarkSilver

Yeah, [color=rgb(40,40,40);font-family:'Source Sans Pro', sans-serif;]At that time, I also couldn't view my report on the web viewer but I had already solved the problem.[/color]It was because I installed AVAST anti-virus, I am not sure why, maybe they are not compatible.After I uninstalled it, the preview and web viewer all are working already.Thank you for your time.

kclark

Thanks for the update! Maybe this will help someone who's running into the same thing.

Nithyasree Selvakumar

Hi EveryOne

I need to insert my database from sqlyog to Actuate Birt Designer..Can one help me..I am waiting... :ph34r:

JFreeman

How do you connect to sqlyog to retrieve data? 
Do you have JDBC driver to connect to sqlyog?
 
Most likely, you will need to obtain the sqlyog JDBC driver and add it into your BIRT designer. Then you will be able to connect to the database using a JDBC connection for your data source.