Connect to CSV file

I am not able to import huge size csv file into mysql database, also can’t find direct option to connect CSV with the application what to do ?

Hi Anu,

Yes, you will not find a UI to connect to CSV as of now. We are working on the same. But you can still be able to connect to CSV by following the below-mentioned steps.

  1. You need to create a JSON file which allows you to connect with your CSV file. Make sure the CSV file must already by uploaded to the BI repository.

//CSV_Employee.json
inline: {
version: ‘1.0’,
defaultSchema: ‘Employees’,
schemas: [
{
name: ‘Employees’,
type: ‘custom’,
factory: ‘org.apache.calcite.adapter.csv.CsvSchemaFactory’,
operand: {
directory: ‘/home/helical/hdidev/HelicalDemo/Employees’
}
}
]
}
//end of CSV_Employee.json

  1. Make necessary changes in the above file like directory variable configure it with the actual CSV directory. Similarly, change the default schema (defaultSchema) and schema name (name). Note that these changes are important to access the data from the CSV.
  2. Make sure that the CSV file has a header in it. For example,

EMPNO:int,NAME:string,DEPTNO:int,GENDER:string,CITY:string,EMPID:int,AGE:int,SLACKER:boolean,MANAGER:boolean,JOINEDAT:date

  1. Configure a new connection inside efwd. Read more on how to configure efwd here http://www.helicalinsight.com/technical-guide/efw-for-dashboard-creation/
    use this settings
sample/CSV_Employee.json org.apache.calcite.jdbc.Driver
  1. Now you can go to quick report and select unmanged connection and select this “CSV Employee” ( connection 1) from the same directory.

let me know if you are facing any problems.

Thanks,
Nitin Sahu
Helical Insight Creator