mdahlman

These sample reports are available to help users who are new to Jaspersoft technologies to be able to connect to data in Hadoop. Loading Sample Data to Hadoop Hive Copy the data file to HDFS filesystem, change the paths according to your filesystem. hadoop fs -copyFromLocal $LOCAL_PATH/accounts.csv /user/hdfs Start hive as hdfs user sudo -u hdfs hive Create the table accounts on Hive CREATE TABLE accounts (id STRING,date_entered STRING,date_modified STRING,modified_user_id STRING,assigned_user_id STRING,created_by STRING,name STRING,parent_id STRING,account_type STRING,industry STRING,annual_revenue STRING,phone_fax STRING,billing_address_street STRING,billing_address_city STRING,billing_address_state STRING,billing_address_postalcode STRING,billing_address_country STRING,description STRING,rating STRING,phone_office STRING,phone_alternate STRING,email1 STRING,email2 STRING,website STRING,ownership STRING,employees STRING,sic_code STRING,ticker_symbol STRING,shipping_address_street STRING,shipping_address_city STRING,shipping_address_state STRING,shipping_address_postalcode STRING,shipping_address_country STRING,deleted BOOLEAN)ROW FORMAT DELIMITED FIELDS TERMINATED BY ';'STORED AS TEXTFILE; Fill the table with the data stored in accounts.csv LOAD DATA INPATH '/user/hdfs/accounts.csv' OVERWRITE INTO TABLE accounts; Running the report in iReportIn order to run the Sample report you will need to create a Hadoop Hive Connection first. First test the connection to make sure it's working. Now, you should use Hive SQL to query your Hadoop Hive data source. This is an example that loads all the records from the sample data. Then, you should choose which fields are you planning to have in your report. You may need all or few fields depending on the report design. After that, you should compile the report by clicking the previiew button. It may take few minutes until the report is generated.

Jaspersoft for AWS Main PageJaspersoft BI for AWS FAQ- What is the difference between Jaspersoft for AWS BYOL and Hourly?The BYOL (Bring Your Own License) version provides: Access to additional features, including Multi-tenancy for larger server sizes, OLAP and ETLA premium level of support including options for phone-based support - not available with the hourly AMI, andA discounted annual price rateThe BYOL AMI requires an annual subscription that can be purchased from Jaspersoft. The table on our Cloud page provides a good summary of the differences between these options. Please contact us for more information on the BYOL option. - How do I load my license for BYOL?You can refer to this wiki article, or watch this video. - What is the Auto-Connect for RDS and Redshift feature?Jaspersoft worked with AWS to make it very easy to connect to your Amazon RDS and Redshift data sources. Using the EC2 instance credentials you provide, the auto-connect feature in Jaspersoft for AWS will automatically find and connect to your RDS and Redshift data sources so you don’t have to be a DBA to quickly connect to and start analyzing your data. This is possible because the IAM Role associated with the EC2 instance is allowed to execute the actions "rds:Describe*" and "redshift:Describe*". It pre-populates the Database Name, Driver, and URL. The auto-connect feature only works if you have launched the Jaspersoft instance using our Amazon CloudFormation template. You can learn how to launch the Jaspersoft instance with CloudFormation in this step-by-step guide. - Why do I see an error when using Amazon RDS as a data source?If you select the RDS Data Source and the driver is missing, you will see an error. If you do not have access to a copy, you can download the relevant driver from the following wiki page: Downloading and Installing Database Drivers - Does Jaspersoft BI for AWS support multi-tenancy?Yes. Multi-tenancy is available by the hour for the entry-level server size. Larger server sizes with multi-tenancy are available as an annual subscription. For more details, refer to the Cloud Features table. - Is this SaaS? Or a hosted service?No. This is a preconfigured instance that's ready to run, but you will fully own and manage it. Read about what AWS Marketplace is. - How do I load data from RDS into Redshift?One good solution is AWS Data Pipeline. It allows you to move transactional data from RDS into a Redshift data warehouse. But there are many factors to consider, so there's no recommendation that covers all use cases. - Is SSL (https) available?Yes. Since you own and control the server, it's not possible for Jaspersoft to provide a certificate for you ahead of time. But you may configure SSL on your Jaspersoft BI for AWS instance exactly as you do on other servers. For more information, refer to the JasperReports Server Ultimate Guide, Chapter 8: Application Security. - How do I deploy reports?There are two ways to populate JasperReports Server with reports. The easiest is to create ad hoc reports from within JasperReports Server and saving them to the repository. In this case, everything occurs through the web UI. For more sophisticated report development, you can get Jaspersoft Studio Professional (JSS Pro) by enrolling for free or paid support at https://www.jaspersoft.com/store/aws-support. JSS Pro is a client software, and the professional license file can then be downloaded from the Jaspersoft web site at https://www.jaspersoft.com/user. You create the reports locally using the JSS Pro client and then use the JasperReports Server repository plugin to upload reports to JasperReports Server running on AWS. - How do I get Jaspersoft Studio Professional (JSS Pro)?You can get Jaspersoft Studio Professional by enrolling for free or paid support. The software and professional license file can then be downloaded from the Jaspersoft web site at https://www.jaspersoft.com/user. - How do upgrades work?Jaspersoft recommends that you create a new instance with the lastest Jaspersoft BI for AWS AMI. Export and then import the Jaspersoft repository from the existing instance (e.g., version 5.n) into the newly launched instance (running for example, version 5.n+1). You now have two instances running, which allows you to test the new version before making it live for your users. Once you are satisified with how the new version runs, you will want to alert your users to a maintenance window, during which you export the current repository from the old instance into the new instance. If you are using elastic IP, you will want to update it. Otherwise, alert the users to the new URL. To save on AWS services costs, don't forget to de-provision the older instance when you are confident that the new server is running to your satisfaction. For additional information, refer to the Jaspersoft Professional AWS User Guide, section 2.3: Upgrading Your Instance. - Can I connect to on-premises databases?Yes. The ability to connect to on-premises JDBC data sources is important. It requires configuring a Virtual Private Cloud (VPC) which is a type of Virtual Private Network. This can be securely configured so that the BI server can access your local resources, but the rest of the internet cannot access your data. More details are here: http://aws.amazon.com/vpc/. - Can I connect directly to the Jaspersoft for AWS server file system?Yes. Sometimes you may need to connect to the server's file system to retrieve log files, upload licenses, edit configuration files, or run commands from a console interface. To learn how, please read this wiki article.

Related PagesJaspersoft BI for AWS OverviewAWS: Remote Machine Login and File Transfer[[jaspersoft-aws-faq|Jaspersoft for AWS FAQ]]SeachURL:Keywords:Wiki,AWSIs it really BI for a little over $1 hour?Yes. But let's break that down into some tangible scenarios. (Prices are accurate as of 31 August 2023.) There are a huge number of variations for EC2 pricing. Here are a few examples. m5.large Software cost: $1.24/hour EC2 cost $0.096/hour Total hourly cost: $1.336 This works out to be an annual cost of US $11,703.36 You can further reduce this by getting an annual license for Jaspersoft for $9600, which reduces your total annual cost for BI (Software plus EC2) to about $10441, or $1.19/hr m5a.xlarge Software cost: $2.24/hour EC2 cost $0.172/hour Total hourly cost: $2.41 This works out to be an annual cost of US $21,130 You can further reduce this by getting an annual license for Jaspersoft for $17,270, which reduces your total annual cost for BI (Software plus EC2) to about $18,777, or $2.14/hr The Jaspersoft BI for AWS AMI includes a PostgreSQL repository database.