Do you know you can create a B.I. platform using C...
# adobe
c
Do you know you can create a B.I. platform using ColdFusion and Lucee instead of Python, R, Scala and Apache Spark? Our technology has its features and much more... I'd like teaching B.I.
šŸ‘šŸ¼ 1
j
BI is a hardware and language feature. It isn't just math functions or logic statements. CF & Lucee to my knowledge don't have BI built in. They are build on top of Java. Go to this Wiki page ( https://en.wikipedia.org/wiki/Apache_Spark ) and search for Java would be my recommendation for non-standard language features in CFML today. Again, it depends what you are trying to do. AI is a very broad brush. AI you need and IA a tool performs can be a hit or miss situation.
c
B.I. is not a language, neither a hardware feature! B.I. is a strategic concept as E.R.P., C.R.M. and S.C.M. are, attending Operation, Controlling and Financial Management! MicroStrategy and Microsoft Power BI are tools developed using .NET! QlikSense and tableau are BI softwares based on Java and C++. Alteryx, KNIME and telend are an E.T.L. tools developed using R and Python. I recommend you reading what is B.I. itself before argumenting... https://en.wikipedia.org/wiki/Business_intelligence
p
When you say "our technology" what are you referring to? Do you have a company, a website that explains your offering or what?
j
No, CFML servers = our technology. I was thinking more AI than BI. Correct @Christian Figueiredo. Those solutions you mentioned do not compare to ColdFusion or Lucee. ColdFusion and Lucee would be more like C# in that scenario. I am just not following your thinking on this. Can you restate your first post. What did you mean by "I'd like teaching B.I.?"
p
Sounded like a business pitch to me that he has a company that offers something using Lucee BI etc... I am lost.
šŸ‘ 1
e
Without knowing more than the flow chart, it looks like they are using CFML to manipulate MS SQL Reporting Services to publish to power apps bi, a Microsoft cloud product.
c
About the flowchart, ColdFusion and Lucee acts as an E.T.L. platform that receives data from a lot of sources (databases, worksheets, csv files, json or other docs encapsulated in zip files), treat them and export data to an unique B.I. data source named Data Warehouse. In that Data Warehouse, each entity (a table or a group of tables formed to supply an unique select statement) are named Data Lakes... After treated data in Data Warehouse, all the related B.I. presentations extract them periodically (each 30 min. or an hour... it depends on each business plan)...
p
Are you just here telling us random info on how we "could" use Lucee; or are you trying to sell a platform setup that your business sells? Still not clear
c
j
Same here, I am not clear on what we are aiming to discuss.
c
@johnfarrar did you try using Microsoft Power BI?
That's a first walkthrough that I can present the magical world of BI
First of all, forget building the HTML reports
j
Did you answer Patrick's question, if not could you answer that first?
p
Yea @Christian Figueiredo you are making no sense other than telling the community some random idea you have. OR are you selling us some business service that does this??????
🤣 1
z
i think what's he saying is we can do these things with cf, while many ppl (not so much the cfml crew) assume you need to use the typical stack he mentioned
j
If so, having worked as an enterprise architect, that was not something we found as a road blocker to CFML. Not saying others have not, but that is not where we found objections. There is the aspect that those tools are supposed to be pre-tunned to a task. That is where we brought in architects to validate those assumptions applied to our use case.
p
Shrug to this thread, poor communication of why he posted this and like John said, technology needs applied in a use case scenario not just a default platform. (HA Salesforce, etc...eye roll)
šŸ–• 1
c
Do you know your real problem @Patrick? You are not a systems analyst, neither an architecht, engineer or a functional analyst. You are just a programmer. You can not explore necessities to find a solution. You do not have creativity for it. You are just a guy that knows yourself how coding... Just it!
šŸ˜‚ 2
🤣 1
@zackster I used Lucee for a solution I've reported to @madmike_de... That was one of my best projects. I created a fitted solution to an Autoparts manufacturer that was in a hell stage! My manager decided to buy a software named Alteryx. My project made him rethinking... Try quoting Alteryx then mind yourself if no one can create a similar, but lower cost solution? Obviously we can!
m
I got a really detailed description of the project he did and what the different systems he put together. Unfortunately it's not a software or platform he wrote to make it available to other users. It seems to be a really big project he did, but it's a specific one. Or as we say here in this group: Daily business. But telling someone with more than 20 years of experience with CFML he's "just a programmer" - well, you're really brave, Christian.
c
No, not brave. To put down someone that critizises you (without knowing anything about that person) is just insulting and behaving bad
šŸ‘šŸ» 1
z
eh? since when is being just a programmer a problem? šŸ˜‰
j
A programmer is a programmer. If someone has different skills that doesn't make the other person
just
anything. My opinion as an application architect is this.
We know more than me.
c
@johnfarrar your problem as same as @Patrick is trying to opine about something you haven't experienced! We have to sum efforts, not creating fightings! If I needed to create a fighting, I wouldn't spend my time creating the flowchart. Nowadays we don't need a fight! We need unite our skills approaching what is trending! A current trending is B.I. that has been leading by Python, R and NodeJS. The job market approached by ColdFusion in Brazil is getting tinier... Now are less than 10 companies using ColdFusion in Brazil. What do I have to do? Moving to another country?
j
OK, the frustration with a thinner job market expresses something valuable. Are you saying people are missing out on ColdFusion when it offers a win. If so, completely agree it is challenging for career options. If you were showing where it can fit in that people miss it makes more sense. We were not trying to fight, we were trying to understand what you were aiming at. P.S. Hopefully there is more family and culture in Brazil that would compel you to stay than moving to another country. But, if there is a winning reason to move in addition to ColdFusion then consider it. ColdFusion is awesome, but limited in scope that might motivate leaving one's country.
c
Thanks a lot @johnfarrar for your considerations, although that was not your discourse in this conversation's beginning. Continuing, ColdFusion needs to be considered not just a middleware for web applications. When mobile technology was emerging, ColdFusion was considered an obsolete architecture in South America due to not providing features such as Web Sockets and RESTful. Smartly, ColdFusion architects and engineers created RESTful Services and Web Socket Channels through Components and event handlers. More than it, ColdFusion engineers created PhoneGap software to develop mobile applications able to connect through ColdFusion REST services and Web Sockets, offering the possibility to ColdFusion developers creating P.W.A. (hybrid applications). Unfortunately PhoneGap was discontinued, but that was a great idea. Nowadays we have the opportunity to create applications using VueJS as the most effective front end framework (in my opinion) for ColdFusion.
Parallelly that, ColdFusion is able and ready to approach the E.T.L. (extract, transform and load) concept that pulls data from a lot of sources (databases, APIs, Excel Worksheets, CSV sheets and documents such as Word or PDF), consolidating that data through sanitization and SQL statement preparation, then transferring all that treated interesting data to a Data Warehouse (a B.I. platform unique database) that let it prepared for cloud B.I. presentation taking it periodically.
A great tip that makes it interesting: you can create a Power BI dashboard then publish it to a cloud service that can be accessed everywhere (app.powerbi.com). After publishing, you install Microsoft On-Premises Data Gateway that makes Power BI cloud app accessing that data warehouse remotely! After installing it, you can configure the data source connection then set the updating frequency at cloud Power BI app! Depending on Microsoft Power BI's plan, all dashboards' data can be automatically updated 8x or 48x a day through that gateway!
Another great tip: you can create a bulk insert scripting that makes INSERT statement much faster! Unfortunately, Microsoft SQL Server allows just 10 INSERT statements containing 1.000 rows each one. To avoid its limitation, you can paginate that procedure to a 10.000 rows package then creating a <cftransaction> for each package processing... It works!
j
• What do you believe gives ColdFusion a larger market footprint? • Likewise, what reduces the footprint? • How do we validate our assumptions?
(this is my bias, not saying it is right... just not hiding my bias) Customers don't buy and stay with iPhone or Android because it does something the other does not, or the other lacks things their phone does. Customers like what their phone does for them. Features the phone provides that don't impact them, doesn't impact them. Yes, there are some slick marketing techniques used to influence at time of purchase like phones that open up. I have never heard any of my friends who have those phones speak to it making their experience better. At the end of the day, it just cost more. We will see if they repurchase or not that more expensive style.
My point, and the above questions. Your theories are logical. How do we validate the market would shift via E.T.L.? If we have solid proof, then we can sell it as a fact vs a standard. ColdFusion is like the smart phone. If we talk about how thin the chips are, the majority of the market really doesn't care. It may impact the market, but if not for the end buyers... who needs the message and how do we tell them, with proof, why it matters. Proof of it's impact is my focus, the need for impact in Brazil is a different discussion.