# What is the best practice in handling customer credentials.

Let's say you have 1000 instances all with different credentials and URLs. You want to store those in Frends so you can either loop all of them through one by one or search them by some ID or name. Customer data should also be easy to manage and one customer should have atleast: ID, name, URL, port, username, password, office, language

##### Post Metadata
- Posted at: about 4 years ago
- Author title: Integration specialist
- Net upvotes: 1


## Comments
### Comment 1

Usually the recommended way of storing sensitive information is to use Environment Variables in Frends.

Unfortunately, if you group credentials for each customer under groups in Environment Variables you are not able to loop over them easily.

If you store them in lists in Environment Variables you are not able to search them easily. 

In theory, you could save them e.g. is JSON structure under Eviroment Variables, but I don't know does that statisfy "easy to manage" requirement. 

Other option is to use external database or somethoing like Azure Key Vault.

##### Comment Metadata
- Posted at: about 4 years ago




## Related Product
[Frends](https://www.g2.com/products/frends/reviews)

## Related Category
[iPaaS](https://www.g2.com/categories/ipaas)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: about 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: about 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: about 13 years ago
  - Comments: 4