New CSV datasource in Design studio 1.6

With the new Design Studio 1.6 release, it is now possible to create an application on CSV datasources for offline dashboarding and demos

However, the process is not as simple as said. This document is intended to provide step by step guide on how to use CSV as a datasource

Whenever we try to add a CSV as a data source, the application will not initialize the data source as it needs a metadata file along with actual CSV file. Below are the steps to easily create the CSV files for design studio usage

Step 1) Login to Design studio platform and create a data source(In the below screenshot connection is based on BICS )

Step 2) click on edit initial view ( Drag and drop the objects needed for CSV file)

Step 2- CSV design studio

 

Step 3) You will see new “ Extract to CSV” option in the query designer

Step 3- CSV design studio

 

Step 4) Select a folder to save the files

Step 4- CSV design studio

 

Step 5) 3 new files will be created under the folder specified in the previous step

Step 5- CSV design studio

 

Step 6) Now close and open the design studio in Local mode

Step 6- CSV design studio

 

Step 7) create a new data source “ select Add CSV Datasource” , navigate to the .CSV file created above

Step 7- CSV design studio

Step 7 A- CSV design studio

 

 

Step 8) files will be copied to application.

 

Step 8- CSV design studio

Happy Designing J

-Karthik Addula

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s