Hello dear Apptio Community,  does anyone of you has experience with transferring costs from MongoDB to Apptio and distributing them across applications? How did you go about it? Do you have any tips on how to proceed? I will be very thankful for every piece of advice.

Hi @Lena Sidorencov, I haven't worked with MongoDB personally, but if you know the applications that use it, you could create a mapping, and then weight the cost of MongoDB going to the apps using the usage data.

Hello dear Apptio Community,  does anyone of you has experience with transferring costs from MongoDB to Apptio and distributing them across applications? How did you go about it? Do you have any tips on how to proceed? I will be very thankful for every piece of advice.

Hi @Jenny Franklin Thanks a lot for your reply!  I am aware of this option, but in the first step my IT Colleques asked me to find out if there is an opportunity for a direct data transfer from Mongo to Apptio, because it would be the easiest way. If it is not possible then we would probably go with the option you offered.

Hi @Lena Sidorencov, I haven't worked with MongoDB personally, but if you know the applications that use it, you could create a mapping, and then weight the cost of MongoDB going to the apps using the usage data.

Hello dear Apptio Community,  does anyone of you has experience with transferring costs from MongoDB to Apptio and distributing them across applications? How did you go about it? Do you have any tips on how to proceed? I will be very thankful for every piece of advice.

I don't know there exists a connector for MongoDB, but maybe the Apptio Datalink experts would know better.

Since you want to automate the whole process, @Lena Sidorencov, this is how I would do it:

1. Have the MongoDB people create a query that exports the data you want, presumably database size, number of records, or some such metric for every application. This/these numbers would be the allocation key for Cost Transparency (CT)
2. Create a local (=on-prem) Datalink connector. We use Local Filesystem connectors for similar purposes
3. Prepare the table in CT that will hold the allocation keys by application
4. When the connector runs, it would pick up the file and upload it to CT on its own to the table in step #3
5. Have some logic in the Applications object that reads the keys for each instance
6. Use that column in the allocation key, say from Databases to Applications, so that MongoDB costs go to each application proportionally to that value

We do this all the time for other purposes, e.g. downloading data from the CMDB, extracting information from monitoring systems, etc. By now we have about 20 such connectors.

Our process is semi-automated: I manually run a Python script that puts all the files in a given folder, and then run the connector group, also by hand. Of course, both steps could be automated.

I will write a blog post with more details, just in case you need them.

Good luck and do reach out if you need something else.

Hi @Jenny Franklin Thanks a lot for your reply!  I am aware of this option, but in the first step my IT Colleques asked me to find out if there is an opportunity for a direct data transfer from Mongo to Apptio, because it would be the easiest way. If it is not possible then we would probably go with the option you offered.

Hi @Lena Sidorencov, I haven't worked with MongoDB personally, but if you know the applications that use it, you could create a mapping, and then weight the cost of MongoDB going to the apps using the usage data.

Hello dear Apptio Community,  does anyone of you has experience with transferring costs from MongoDB to Apptio and distributing them across applications? How did you go about it? Do you have any tips on how to proceed? I will be very thankful for every piece of advice.

Hi @Guillermo Cuadrado, thank you so much  for the detailed answer! That is really helpful! It would be great if you could write a blog post with more details on this topic. 

Best Regards, Lena 

I don't know there exists a connector for MongoDB, but maybe the Apptio Datalink experts would know better.

Since you want to automate the whole process, @Lena Sidorencov, this is how I would do it:

1. Have the MongoDB people create a query that exports the data you want, presumably database size, number of records, or some such metric for every application. This/these numbers would be the allocation key for Cost Transparency (CT)
2. Create a local (=on-prem) Datalink connector. We use Local Filesystem connectors for similar purposes
3. Prepare the table in CT that will hold the allocation keys by application
4. When the connector runs, it would pick up the file and upload it to CT on its own to the table in step #3
5. Have some logic in the Applications object that reads the keys for each instance
6. Use that column in the allocation key, say from Databases to Applications, so that MongoDB costs go to each application proportionally to that value

We do this all the time for other purposes, e.g. downloading data from the CMDB, extracting information from monitoring systems, etc. By now we have about 20 such connectors.

Our process is semi-automated: I manually run a Python script that puts all the files in a given folder, and then run the connector group, also by hand. Of course, both steps could be automated.

I will write a blog post with more details, just in case you need them.

Good luck and do reach out if you need something else.

Hi @Jenny Franklin Thanks a lot for your reply!  I am aware of this option, but in the first step my IT Colleques asked me to find out if there is an opportunity for a direct data transfer from Mongo to Apptio, because it would be the easiest way. If it is not possible then we would probably go with the option you offered.

Hi @Lena Sidorencov, I haven't worked with MongoDB personally, but if you know the applications that use it, you could create a mapping, and then weight the cost of MongoDB going to the apps using the usage data.

Hello dear Apptio Community,  does anyone of you has experience with transferring costs from MongoDB to Apptio and distributing them across applications? How did you go about it? Do you have any tips on how to proceed? I will be very thankful for every piece of advice.

Hi @Guillermo Cuadrado, thank you so much  for the detailed answer! That is really helpful! It would be great if you could write a blog post with more details on this topic. 

Best Regards, Lena 

I don't know there exists a connector for MongoDB, but maybe the Apptio Datalink experts would know better.

Since you want to automate the whole process, @Lena Sidorencov, this is how I would do it:

1. Have the MongoDB people create a query that exports the data you want, presumably database size, number of records, or some such metric for every application. This/these numbers would be the allocation key for Cost Transparency (CT)
2. Create a local (=on-prem) Datalink connector. We use Local Filesystem connectors for similar purposes
3. Prepare the table in CT that will hold the allocation keys by application
4. When the connector runs, it would pick up the file and upload it to CT on its own to the table in step #3
5. Have some logic in the Applications object that reads the keys for each instance
6. Use that column in the allocation key, say from Databases to Applications, so that MongoDB costs go to each application proportionally to that value

We do this all the time for other purposes, e.g. downloading data from the CMDB, extracting information from monitoring systems, etc. By now we have about 20 such connectors.

Our process is semi-automated: I manually run a Python script that puts all the files in a given folder, and then run the connector group, also by hand. Of course, both steps could be automated.

I will write a blog post with more details, just in case you need them.

Good luck and do reach out if you need something else.

Hi @Jenny Franklin Thanks a lot for your reply!  I am aware of this option, but in the first step my IT Colleques asked me to find out if there is an opportunity for a direct data transfer from Mongo to Apptio, because it would be the easiest way. If it is not possible then we would probably go with the option you offered.

Hi @Lena Sidorencov, I haven't worked with MongoDB personally, but if you know the applications that use it, you could create a mapping, and then weight the cost of MongoDB going to the apps using the usage data.

Hello dear Apptio Community,  does anyone of you has experience with transferring costs from MongoDB to Apptio and distributing them across applications? How did you go about it? Do you have any tips on how to proceed? I will be very thankful for every piece of advice.