How to Change Material of an Object through SQL database , How to Convert String to Material Interface

Please provide any Suggestion or Screen shot or any Code .

If you are avoiding C++ yourself then you will need a plugin like:

To handle http requests/etc. (Note, I found this with a cursory google so i don’t know anything about it other than people saying it worked and seeing it was recently updated to 4.16)

Once you have that you will need some identifier on the database to compare to a list of materials in Unreal.

There’s nothing built in to Blueprints to convert string->className that i know of. Essentially you need an Unreal datatable or array of sets that is essentially {id:String, materialToUse:MaterialInterface}. Compare id to database id and choose that material.

Alternatively if you just want to change material PARAMETERS then you can just pass strings from the database directly into the parameter name of a set material parameter node.