Software as a Service (Saas) and Multi-tenant Architecture

[[email protected]]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Make sure you're getting the entire URL not stopping at db=opti

[Peter.Greulich]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Make sure you're getting the entire URL not stopping at db=opti

I'm just clicking on the link, but even if I manually copy the entire url = same problem.

[frankbicknell]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Bill, your site has the guest option disabled. Also, you get two error messages before the page initially loads.

Same for me.

[[email protected]]

Re: Software as a Service (Saas) and Multi-tenant Architecture

OK, I've changed the name to take out the space and added the port#.

http://72.45.168.163:80/fmi/iwp/cgi?...&-startsession

Bill

[Peter.Greulich]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Now I only get one error message, but you still can't select guest.

[[email protected]]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Peter, Are you trying to open Crime Tracker or Optitracker? Crime Tracker does not have the guest option enabled and is the default database if you're not getting to OptiTracker.

http://72.45.168.163/fmi/iwp/cgi?-db...&-startsession

Bill

[Peter.Greulich]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Peter, Are you trying to open Crime Tracker or Optitracker? Crime Tracker does not have the guest option enabled and is the default database if you're not getting to OptiTracker.

http://72.45.168.163/fmi/iwp/cgi?-db...&-startsession

Bill

Previously there was no Optitracker option visible. But this latest link works.

That's kind of nice. There is a certain simplicity (in the good sense) of a template driven database. But I can see where the price and configuration restrictions are a big stumbling block. Lack of printing capability is a huge disability as well. But I like the look and feel. Nice job.

[[email protected]]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Glad you finally got in! The look and feel is much nicer if you are using a filemaker client. The web (browser) client is a bit cheesy in comparison, but for data entry or lookups from the field it works.

Bill

[CharlesParker]

Re: Software as a Service (Saas) and Multi-tenant Architecture

I would also really appreciate some guidance on how to set permissions so that each user only sees their respective additions to the tables. In my tables I have a field for user_id named the same in the other tables, like user_id and invoice_id with the idea being that with one record of an invoice_id only belonging to ONE user_id the two would never get mixed up...but I am unsure how to exactly commit it to the user as well as how to make the relationship between tables where the same field would (or I would like) relate to the self same logged in user of my forms.

Does the form post to the user_id each time a record is submitted or does that get written once during sign up with the info magically cascading to all the other tables with the same field (relationship?)

I have been reading the forums and the documentation for several days and cannot figure it out. I get that you can filter tables or views to "see information" but how I relate it to the user I give up. I hope I am making sense to some of you guys who seem to just get it, I somehow seem to get lost in it. I strongly believe that this product is something I can learn, I just get lost somewhere in the mechanics of it.

I would also imagine that most of the guys who use this find my questions to be borderline retarded, but my brain can only hold so much information and I am really good at other things, lol.

Thanks in advance for your time.

[Peter.Greulich]

Re: Software as a Service (Saas) and Multi-tenant Architecture

I would also imagine that most of the guys who use this find my questions to be borderline retarded

Here we go again. Not picking on your Charles. Read post #11 above. It's not easy. There's no roadmap and you need xbasic skills to make it work in a multi-tenant situation.

[CharlesParker]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Agreed Peter it is not easy and I did read that, I think I am not asking the correct question. Let me try it another way, can anyone post some code from a grid in which a user (in a multi-tenant app) would get information from a specific row, meaning a row that pertained to them? I think if I had something to go by I could make it work.
A second alternative and possibly the best one - Should I just make the app for myself and hire an alpha 5 experienced programmer to turn it into a multi tenant app? I am not opposed to paying for help. I just wanted to do as much as I could to create and build this. I am very much a hands on need to know person, but realize my limitations when I meet them as impossible for me. I am ok with it once I decide I give up!
I really do believe that as much work went into alpha 5 that they are just a release away from a point and click multi-tenant security system as well...

Last question: wheres the xbasic for dummies website at? Thanks for the reply Pete!

[CharlesParker]

Re: Software as a Service (Saas) and Multi-tenant Architecture

Ok so I just bought the "xbasic for everyone" at www.libertymanuals.com, I will set to learnin and one day come back with my own post and hopefully help someone else out...thanks google

[kkfin]

Re: Software as a Service (Saas) and Multi-tenant Architecture

wheres the xbasic for dummies website?

It is here

[Terry]

Re: Software as a Service (Saas) and Multi-tenant Architecture

One word of caution about using "multi-tenant" databases - it can preclude the potential future use of an adhoc reporting tool. I helped an organization select a commercial SaaS CRM system for their use. One of the selling points was the ability to use an adhoc reporting tool to generate custom reports from the system. However, after buying into use of the system, the vendor indicated that use of the reporting tool required an organization specific instance of the MySQL database at significant additional cost (because they were using a multi-tenant structure). Bummer! The issue is that an adhoc reporting tool typically needs access to the schema that is not filtered by the value of a field in each table. While this may not currently be an issue with Alpha5, I will not be surprised to see an adhoc report writer included in Alpha5 at some point in the future. Even now, there are available open source report writers that will work with a MySQL database. Incorporation of an adhoc report writer in a multi-tenant system could require significant redesign of the database and rewrite of the application. For me, long term stability of the database design is paramount and for that reason I shy away from a multi-tenant database.

Terry

[Peter.Greulich]

Re: Software as a Service (Saas) and Multi-tenant Architecture

It is here

Kkfin's xbasic & Alpha's xbasic are two different languages and presumably mutually exclusive.