Alteryx aims to be the launchpad for automation breakthroughs. Be it for personal growth, achieving transformative digital outcomes, or rapid innovation, Alteryx converges analytics, data science and process automation to enable users across organizations to make business-altering breakthroughs. Alteryx Designer can be used to automate every analytics step — from data prep to data science. Access any data source or type, then blend via drag-and-drop interface.…
N/A
ER/Studio Data Architect
Score 9.9 out of 10
N/A
ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.
$1,470.40
one-time fee per user
Pricing
Alteryx
ER/Studio Data Architect
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Alteryx
ER/Studio Data Architect
Free Trial
Yes
Yes
Free/Freemium Version
No
No
Premium Consulting/Integration Services
Yes
No
Entry-level Setup Fee
No setup fee
No setup fee
Additional Details
—
Pricing for new customers only, first year maintenance included. Maintenance includes access to technical support and product updates for the defined period of the agreement.
We're trying right now to get more people using it at our company so we can send management documented cases for how we can expand and purchase Alteryx Server which will extend the capabilities even more and across more departments. It's been well suited for pretty much everything we do on a repeating schedule. It's worth the time to set up the workflows. When Treasury sends me the bank download now - I save it to a folder and run our workflows and send back 2 journal entries in .9 seconds. (yes - in less than a second it's finished running)
Data Architect is well suited at organizations of all sizes. It is never too early or unnecessary to enforce proper modelling and design standards on data solutions, and this tool will help that greatly by providing an industry leading data modelling tool, ability to import ETL mappings for data lineage, enforcing and managing naming conventions through the naming convention tool, and publishing of data dictionaries through the report publisher. I was successfully able to build models, provide traceability, and document source to target with lineage throughout for both the business (by providing business definitions in the descriptions), and technical teams (by documenting ETL instructions in text fields) along with field level mapping (by creating "Attachments" representing data sources, tables, and fields) providing easy search capabilities using business friendly terms
Pulling data from multiple disparate data sources.
Allows users to see the data at every step of the workflow to be able to cleanse, analyze, and optimize the data.
Provides an analytics platform that is easy for users of all levels to thrive in whether they are just starting out in their analytics journey or they have a master's degree in Data Science.
ER/Studio has the ability to provide consistent field names and data types through domains, which are templates. This provides a way to have consistent naming of common fields, like CreatedBy and the data types for the fields. They also have the ability to change all the fields that use that domain to a different data type.
ER/Studio provides the ability to create custom macros. These macros can be used to apply everything from standard fields based on domains to naming all constraints and indexes. I've also used a macro that comes with ER/Studio to spell check field and table names.
My favorite feature is the ability to compare your data model to databases for deployments of changes, and to other data models.
Steeper Learning Curve: Alteryx can have a steep learning curve for users who are new to the platform or have limited experience with data analytics. Enhancements to the user interface and user onboarding resources could help make the learning process more intuitive and accessible to a wider range of users.
Enhanced Data Visualization Capabilities: Alteryx offers basic data visualization capabilities, but there is room for improvement in terms of advanced visualizations and interactive dashboarding features. Adding more sophisticated chart types, interactive widgets, and customization options would enhance the data visualization capabilities within the platform.
Improved Error Handling and Debugging: Alteryx provides error handling mechanisms, but enhancing the error reporting and debugging capabilities would be beneficial. Improved error messages, better visibility into data flow, and debugging tools could help users troubleshoot and resolve issues more efficiently.
ER\Studio licensing can be cumbersome and upgrading from one version to another usually takes several phone calls and emails to the licensing group to get the update installed and running.
The repository can be slow when the model count gets larger. By large I mean 20 to 30 models.
A nice feature that I would like to see is table comments be displayed on the model along with the attributes. Currently you have to choose between the two.
We've developed a working partnership with Alteryx. As an enablement suite, we're continuing to innovate and deliver great products with use of Alteryx in our solutions. Alteryx use expands to our global product development teams and is in use in multiple parts of our organization. Alteryx also delivers Experian demographic content to other clients in their product offering. We're highly likely to renew, but that decision is way above my pay grade.
I've found that while some things might take a little longer to create, the flexibility of Alteryx allows you to perform any function needed. I haven't found a use that was not available in Alteryx yet. APIs and XMLs can be created to perform certain functions. In addition, CMD line commands can be sent using Alteryx to perform certain functions as well.
I use many programs and compared to others, Alteryx virtually never goes down, freezes up or gives an application error. Over a 4 year time period that I have used this program, any of these may have happened 3 times. It is an incredibly stable program that I feel completely confident in.
Alteryx is an extremely reliable platform. If there is an error in my workflow, I feel pretty strongly it was probably my fault. The platform also handles large amounts of data very quickly and can join/match, sort, filter, calculate on that data quickly as well. One of my favorite things to build into a workflow are the messages based on data/metadata and error messages based on errors I have come across before.
Stellar, bar-none. Some of the best support folks of any vendor. The Alteryx Community is the most responsive and supportive. On the rare occasion of a release issue or bug, we've been able to get quick help to solve the core problem. Alteryx does not play the blame game. They genuinely help the users solve their issues or respond to questions
I can call or email support and both get quick turn around. The only issue is they are on the west coast (US) and have a west coast work schedule and I'm on the East coast.
1st level of trainings which I've attended in Paris was easy and I was already knowing %90, that learning could have been an e-learning instead of in-person
Very good, detailed online trainings which you can take at your own pace, and strong certifications exists, certifications are extremely detailed and hard...
There is really not much to it (the installation, that is). Once you get it installed, along with any of the add-ons (demographics, R, etc.), you are up and running almost immediately. There is really no additional setup. You can immediately begin blending data, running demographics, performing spatial queries, running predictive analysis, etc. And for many of these functions, the learning curve is quite easy.
Alteryx is MUCH more user friendly. both provide the ability to code within them, but Alteryx has much nicer interface. The formula tools have a more simple language that is easier to learn than formulae in SSIS. Alteryx is easy to read with multi colored tools identifying what each one does. It also allows for macros. You can build your own tool to process records of data or batch records together.
Individual analysts can quickly generate results using their own copy of Alteryx Designer. But using the Server and developing macros for more complex needs can be time consuming.
Error handling - allows controls to be built into workflows easily and allows them to be isolated and spat into control reports that can be easily reviewed and audited, thanks to the ability to create multiple outputs in one go.
Time-saving - saved huge amounts of time, especially when moving Excel processes into Alteryx.
Product development - allowed my firm to create products that we have been able to market and sell to clients.
ER/Studio has had a positive impact on my project as we can develop the data model and have a clear understanding of business needs before we continue with the development phase.
