How to create properites using ETL process

[eswar reddy]

hi

I am trying to load data from sql to orientdb using ETL process everything fine the data is loading  but the properties are not created (means columns are not showing)  any one help me please

thanks

[user.w...@gmail.com]

Hi,

you have to use

"dbAutoCreateProperties": true

see my example:

"loader" : {
        "orientdb" : {
            "dbURL" : "remote:localhost/property_etl",
            "dbUser" : "root",
            "dbPassword" : "root",
            "dbAutoCreate" : true,
            "tx" : false,
            "batchCommit" : 1000,
            "class" : "CARD",
            "dbType" : "graph",
            "serverUser" : "root",
            "serverPassword" : "root",
            "dbAutoCreateProperties": true,
            "classes": [ { "name": "CARD", "extends", "V" } ]
        }
    }

Hope it helps.

Regards,
Michela

[eswar reddy]

sorry no use .same issue coming...

[alessand...@gmail.com]

Hi,

I have tried with this code

{
 "config" : {
 "log" : "debug"
 },
 
 "begin" : [],
 
 "source" : {
 "file" : {
 "path" : "CARD.csv"
 }
 },
 "extractor": { "csv": {
 "ignoreEmptyLines": true,
                            "nullValue": "N/A",
                            "columnsOnFirstLine": true
                          }
                 },
    "transformers": [
            { "vertex": { "class": "CARD" } }
        ],
 "loader" : {
 "orientdb" : {
 "dbURL" : "remote:localhost/databases/ORDB",

 "dbUser" : "root",
 "dbPassword" : "root",
 "dbAutoCreate" : true,
 "tx" : false,
 "batchCommit" : 1000,
 "class" : "CARD",
 "dbType" : "graph",
 "serverUser" : "root",
 "serverPassword" : "root",
 "dbAutoCreateProperties": true,
 "classes": [ { "name": "CARD", "extends", "V" } ]
 }
 }
}

and this CARD.csv

ID,CARD_NAME,CATEGORY_NAME,TYPE_NAME,CARD_REF_NAME,INVENTORY_STATUS_CODE,EQUIPMENT_NAME,CHASSIS_NAME
889124,BLOCK B1,GENERIC,GENERIC,10 PR-C,IPL,DP:DATA:L3639664,chassis02

and it worked for me.

Hope it helps,

Alessandro