Adding Data Sources to BIRT iHub F-Type

I have successfully been able to upload and display my own reports in BIRT iHub F-Type. When I try to create a new report it only has the sample data available. I have searched all the documentation and I can't see how I can add a new Datasource to the iHub F-Type. Thanks

Find more posts tagged with

Comments

micajblock

The data provisioning for BIRT iHub F-Type is done via BIRT Designer Professional which you can download here:
<a data-ipb='nomediaparse' href='http://www.actuate.com/resources/product-downloads/'>http://www.actuate.com/resources/product-downloads/</a>
Documentation can be found here:
<a class="bbc_url" href="http://developer.actuate.com/be/documentation/ihub3-dev/DAG/index.html" title="">http://developer.actuate.com/be/documentation/ihub3-dev/DAG/index.html</a>
Also if you want to build reports using Studio (browser based) or dashboards you need to create Data Objects. Some good blogs on the subjects:
<a data-ipb='nomediaparse' href='http://blogs.actuate.com/birt-data-objects-more-than-meets-the-eye/'>http://blogs.actuate.com/birt-data-objects-more-than-meets-the-eye/</a>
<a data-ipb='nomediaparse' href='http://blogs.actuate.com/introducing-birt-ihub-f-type-connecting-to-data-and-creating-a-design/'>http://blogs.actuate.com/introducing-birt-ihub-f-type-connecting-to-data-and-creating-a-design/</a>

gjvanetten

How do you add Postgres drivers to ihub f type if you are using just the basic report designer?

micajblock

Postgres drivers should be included. Are you not able to run reports with Postgres?

gjvanetten

I published a report I designed in the BIRT basic report designer and I get cannot find Postgres driver errors.

micajblock

What OS did you install F-Type to?

gjvanetten

CentOS Linux 6.5

micajblock

Put your JDBC driver in:
 
<Actuate Home>/BIRTiHub/iHub/Jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_4.2.3.v20140709-0131/drivers

gjvanetten

I did
 
./BIRTiHub/iHub/jar/BIRT/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_4.2.3.v20140709-0131/drivers/postgresql-8.1-404.jdbc2.jar

micajblock

Did you restart the server after you put the JAR there?

gjvanetten

I sure did

micajblock

Start and stop scripts (startiHub.sh and stopiHub.sh) are in the BIRTiHub directory.

micajblock

Can you create a very simple design using the JDBC driver and post it here?

gjvanetten

I was looking at the xml version of the .rptdesign file noticed these properties:
 
 <property name="driverClass">org.postgresql.Driver</property> 
<property name="jarList">C:\Users\jvane\Downloads\postgresql-8.1-404.jdbc2.jar</property>
 
Do I need to modify the jarList to point to the right jar file?

micajblock

try taking out the path

Xiaoquan Wu

<blockquote class="ipsBlockquote" data-author="uvmowl" data-cid="130732" data-time="1410536794">
<div>
I have successfully been able to upload and display my own reports in BIRT iHub F-Type. When I try to create a new report it only has the sample data available. I have searched all the documentation and I can't see how I can add a new Datasource to the iHub F-Type. Thanks
</div>
</blockquote>
Did you solve this problemï¼ŸI also encountered the same problem,how did you add new Datasource to the iHub F-Type.

Xiaoquan Wu

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="130733" data-time="1410541373">
<div>
The data provisioning for BIRT iHub F-Type is done via BIRT Designer Professional which you can download here:
<a data-ipb='nomediaparse' href='http://www.actuate.com/resources/product-downloads/'>http://www.actuate.com/resources/product-downloads/</a>
Documentation can be found here:
<a class="bbc_url" href="http://developer.actuate.com/be/documentation/ihub3-dev/DAG/index.html" title="">http://developer.actuate.com/be/documentation/ihub3-dev/DAG/index.html</a>
Also if you want to build reports using Studio (browser based) or dashboards you need to create Data Objects. Some good blogs on the subjects:
<a data-ipb='nomediaparse' href='http://blogs.actuate.com/birt-data-objects-more-than-meets-the-eye/'>http://blogs.actuate.com/birt-data-objects-more-than-meets-the-eye/</a>
<a data-ipb='nomediaparse' href='http://blogs.actuate.com/introducing-birt-ihub-f-type-connecting-to-data-and-creating-a-design/'>http://blogs.actuate.com/introducing-birt-ihub-f-type-connecting-to-data-and-creating-a-design/</a>
</div>
</blockquote>
Hello,
 I also encountered the same problem,how did you add new Datasource to the iHub F-Type.Form <a data-ipb='nomediaparse' href='http://blogs.opentext.com/introducing-birt-ihub-f-type-connecting-to-data-and-creating-a-design/,we'>http://blogs.opentext.com/introducing-birt-ihub-f-type-connecting-to-data-and-creating-a-design/,we</a>can use Actuate BIRT Designer graphical user interface to create .datadesign and .data, But,II want to use my own code to generate *.datadesign file,how could I do?

micajblock

What is the use case? Why do you want to create a .datadesign file using code?

Qingnan Zhao

<blockquote class="ipsBlockquote" data-author="mblock" data-cid="142849" data-time="1458052106">
<div>
What is the use case? Why do you want to create a .datadesign file using code?
</div>
</blockquote>
In your website,I know I can upload **.datadesign file to BIRT iHub.But this way cannot directly access the local data source.Then I wonder if I can generate the data design file,it will be more comfortable for user.I just want to try.I want to make it come true.I wil be very thankful to get your advice.^-^

shiloam

Below is a link to an Eclipse project archive file for the project itself. It is self-contained for the most part and will produce a WAR file from the Eclipse Java EE perspective rather easily. I used the default iHub 3.1.1 installation paths for my build path for the project, so you may need to change those if they have their commercial BIRT platform directories in another location. 
 
<a data-ipb='nomediaparse' href='https://dl.dropboxusercontent.com/u/26831952/Dynamic BDO Web project backup.zip'>https://dl.dropboxusercontent.com/u/26831952/Dynamic BDO Web project backup.zip</a>
 
The created war file, along with the two files attached (you'll have to rename the filefolderlistcontent.txt to a .jsp) and specified below can be dropped onto any iHub deployment to immediately show an example of supporting user-supplied CSV files. But itâ€™s important to note that it is just an example.
 
Instructions:
 
Drop the war file produced into your Tomcat deployment directory, or add a context tag for it in the acpmdconfig.xml file:
 
Backup your filefolderlistcontent.jsp file in your BIRTiHubVisualization\modules\BIRTiHub\iHub\web\iportal\iportal\activePortal\private\filesfolders directory, and drop these two files in into the same folder:
 
filefolderlistcontent.jsp
uploadData.html
 
And then you may need to restart your iHub Tomcat instance depending on how you deployed the war.
 
And thatâ€™s it. You should have the new button. 
 
To note:
 
1) The username â€œAdministratorâ€ and a blank password (default for iHub) are hard-coded into the servlet code. You'll need to change it if you're using different usernames/passwords.
2) Right now the redirect occurs in the uploadData.html file. If you want to change it to use a fully qualified DNS name, youâ€™ll have to edit that file. Line # 197 is the one youâ€™ll want to edit.
 
And in general, I would strongly recommend using OpenText Services to help facilitate this type of functionality. The example is just that, an example, and is hardly production level code.
 
Thanks and enjoy!
 
The Lone Ranger

micajblock

P.S. I hope you are not using F-Type as this product has been discontinued.

coolcgp

Hi, all. I also want to use code to generate *.datadesign file instead of using graphical user interface in Actuate BIRT Designer. If I can do that, I will call my own code to create data source or data objects(*.datadesign file), then upload these datadesign files as data sources to "birt iHub" in web.