Welcome to the Exasol Community!
1. Be respectful
Everyone in the community comes from a different background, which should be celebrated! Respect each other's time and attention by thinking and searching before you post, asking well-thought-out questions, and sharing what you've learned so far in your experience. Offer honest help where you can, keep a positive and constructive tone, and be patient! Remember, not everyone has the same expertise as you do!
2. Be relevant
Off-topic conversations have a certain time and place, but your posts and contributions should be on-topic and relevant, based on the area of the community. Please avoid asking duplicate questions in different areas of the community. If you want to ask a new question, it's best to start a new topic instead of asking it in the middle of an ongoing thread.
3. Keep your word
Don't post anything that would violate any contractual agreements (copyright, trade secret or otherwise) or nondisclosure agreements to which you are a party.
4. Protect Privacy
Don't share anything about yourself or your organization that you would not want to see on a road-side billboard. Share your business email address if you wish, but don't post personal information-your own or anyone else's- including contact information or any content that you receive in one-to-one communications without the author's consent. Please be mindful of what data you attach! Log files contain very sensitive information about yourself and your business. For that reason, attaching log files is forbidden. Please keep in mind that query profiles and SQL Text/DDL may also be considered sensitive information by your company.
5. Remember this is user-generated content
You'll find plenty of good advice here, but remember that your situation, configuration, or implementation may vary from that of the individual sharing a solution. Some advice you find here may even be wrong. Apply the same good judgment here that you would apply to information anywhere on the Internet.
6. Appreciate others
Show your gratitude to those who have helped or inspired you. If you find a contribution helpful, please give it a like or accept it as a solution to your problem. Likes & solutions will help boost the value of contributions, making them easier for others to discover and enhance the reputation of their authors.
7. Moderator rights
Exasol reserves the right of its moderators to edit, move, block, or remove discussions, signatures or images that they consider inappropriate or disturbing to our community. We may also ban any member at our sole discretion. We will always communicate with you via private messages to provide coaching or inform you of a decision. We ask that you do the same if you need to comment on a moderation action as to not disrupt the rest of the community. Don’t hesitate to send us a private message.
If it’s relevant to the conversation, share information about products and services you love. But please don’t use the Exasol Community to prospect or advertise. If you have something you want members to join, participate in, or buy, ask us first.
If you recognize any violation of these guidelines, please notify us within the community by choosing "Report Inappropriate Content" from the message's Options menu and let us know why you feel the content is inappropriate.
The Exasol Logo
You may notice that some users have the Exasol X ( ) next to their name. This means they are Exasol Employees.
Like you, they are members of the community, and we encourage them to share their knowledge and opinions here.
Feedback & Ideas
At Exasol, we're all about improving your experience. So, let us know what you think or how we can help improve your experience in the community by posting in the Discussion Forum or emailing us!
We know that you have tons of ideas to improve Exasol. If you are an Exasol Customer or Partner, be sure to create an idea to submit new feature requests or enhancements. Please review our idea submissions guidelines before posting
If you have any questions that cannot be discussed in the community:
Email us for all questions concerning the community
Contact Exasol Support for technical quesionts
First and foremost, welcome to the Exasol Community! We're happy to have you!
The Exasol Community is your one-stop-shop for all things Exasol. It's a place to engage and collaborate with your peers. It's a place for education and thought leadership on best practices. And it's also a place where we can exchange with you directly on how to improve and extend the product.
We want your experience in the community to be the best it can be, so we put together this guide to get you familiar with the community quickly. We hope these are helpful!
Once you've registered and confirmed your e-mail address, you're ready to go! The below steps will help you get started in the community
Check out the Community Guidelines to see what's expected of community members.
Head over to My Settings to customize your profile and notification settings and make it your own!
For Exasol Customers and Partners, you should upgrade to a MyExasol Account to get expanded access. More info here.
Introduce yourself! We'd love to get to know you and welcome you properly, so head over here to say a few words about yourself and get to know the other community members
Check out additional Community Resources and our FAQ Page for more information on how the community works.
The community is centered around three overarching themes:
What you'll find here
Official Exasol Documentation including Syntax Diagrams, Installation Instructions, Update Guides, and more
Articles written and maintained by Exasol and the Community. This content goes hand in hand with our official documentation and includes supplementary information like How-to's, best practices, tips and tricks, and more.
The latest releases and updates to our Database and Github Projects
Each week our team of tech writers will be grappling with all the burning issues around data analytics and finding practical solutions– so you don’t have to.
Information and discussions on Exasol's Training Program
What we are working on, what we released recently, and what we consider doing next. (only available with a MyExasol Account).
Whitepapers, case studies, reports, and more
What you'll find here
All the resources you need to get started in the community (like this!) and a place to introduce yourself
The meat and potatoes of the community. Do you have a question about Exasol, need help, or want to get advice from other users? then you're in the right place.
User Groups centered around a topic or location - you can also find content and information about the next meet-ups!
Help shape the future of Exasol by creating and voting on ideas (only available with a MyExasol Account).
Information about the support process and contacting support
What you'll find here
Try out Exasol for free
Exasol in the Cloud
Deploy Exasol in the Cloud using our Cloud Deployment Wizard
Installation packages, driver and client downloads, and more
SQL Clients & Open Source
A list of commonly-used SQL clients and a link to our various Github downloads.
We hope you enjoy your time here and look forward to seeing you around 😀
Whether you are using Communities for years (remember dial up communities?) or brand new to the World of Communities. We hope these tips help with your Exasol Community experience.
1. Community Guidelines - knowing the guidelines to the Exasol Community is a great way for you to know what's allowed so that you and others play safe.
2. Explore - The Exasol Community has something for everyone! From Best Practices content in our Knowledge Base to our popular Usergroups happening online and locally around the globe. Make sure you check out what Exasol Community has to offer.
3. Introduce yourself to the Community - Knowing a little about you helps start relationships and bring down barriers. Tell the Community what you do, how you use Exasol and what you would like to become an expert in. Tell us about you!
4. Like Posts - Give credit to the Community members for helping out! Kudos are the lifeblood of any community
5. Ask Questions - We know a lot of people come to the Community to browse and find answers without posting, but did you know that the Exasol Community usually is quite fast to respond? If you post with all the appropriate Exasol information needed, you will get a response! Our Community loves to help each other. Once you post, pass it forward by answering questions yourself. Find out how to post here.
6. Provide a lot of Information - Our Community of Exasol Experts needs as much information as possible to help you as quickly as possible. Remember, the more information you provide and the clearer you are as to what you want to accomplish will get you a faster answer. Community members use Exasol for many reasons, but many won't know your industry or use case, but they know the tools.
We hope these tips provide some guidance for a great Exasol Community experience. If you're unsure or need help, just ask the Community and we'll help you out!
What is a MyExasol Account?
A MyExasol Account is a special account that is only for valid Exasol Customers and Partners. These accounts have "expanded" access in the community and can do the following:
Follow your and your company's support tickets
Explore our Roadmap
Check support statistics or statistics on your individual database instances
Submit and vote for ideas
Download update or installation packages
Join the Early Access Program
How to sign up for a MyExasol Account
With the introduction of the Community, this account will also grant you additional privileges in the Community. Therefore, the method of signing up depends on if you already signed up for a MyExasol Account in the past or not.
You have a MyExasol Account if you have done one of the following in the past:
Signed up for an account using your company PIN
Logged into Jira (exasol.com/support)
Downloaded update packages from the download portal
If you have a MyExasol Account already, just register for the community here. Your account will be automatically upgraded within 1 business day.
To register for a MyExasol Account, first register for the community. Once you've registered, click your avatar in the top right corner and click on "My Profile"
Once in your profile, click on the blue button that says "Upgrade to MyExasol Account".
Next, fill out the form with your information and company PIN. Don't know your company PIN? Click here!
You may receive an email asking you to confirm your email address. Please click the link in the email to confirm your address again. That's it!
What happens next
If you have signed up with a correct company PIN, your MyExasol User Manager will receive an e-mail asking to confirm your registration. This person will confirm your registration, and afterward, you will receive an e-mail with a username and password. These are your MyExasol credentials and do not replace your username/password that you use in the community! More info here.
After the confirmation of your user manager, you will get access to Jira, Ideas, and the download portal immediately. Your community account will be upgraded within a few days.
How do I know if my account is upgraded?
If your community account is upgraded, the blue button from your profile page will be greyed out.
MyExasol User Manager & PIN
To ensure confidentiality and transparency, each customer or partner must select MyExasol User Managers to be responsible to approve or deny requests to be associated with a customer account. Since Exasol is not aware of who exactly needs to have access to support, ideas, and more, the MyExasol User Manager takes over this role. For that purpose, a MyEXASOL user manager must be named during the OnBoarding process. Exasol is not allowed to manually sign users up for any accounts.
If you are trying to register, but don't know the PIN, you should contact the person responsible for your Exasol installation at your company. They will find the PIN in their Onboarding document. The MyEXASOL User Manager receives a company PIN and forwards it to all the users who should be granted access to a MyExasol Account. Still having trouble? Let us know!
As a user manager, you will be informed each time that somebody registers by using your company PIN. You have the possibility to confirm the registration or to reject it. After the registration, you can also "un-register" users anytime they are no longer authorized to access company issues. To do so, please go to https://www.exasol.com/portal/display/EXA/User+Management and choose the appropriate registration and click on "Remove MyEXASOL User". This user's community privileges will also be revoked a short time later.
After signing up for a MyExasol Account, you now have two types of accounts that are used in different places. The credentials are completely separate and a password change in one will not affect the other.
Username created during registration
Support Ticketing System (Jira)
Company E-mail address
MyExasol portal (including Ideas)
After periods of inactivity, your MyExasol Account may expire and needs to be re-activated by support. If you have a MyExasol Account and reset your password, but still cannot log in to the User Portal or to Jira, your account may be expired and needs to be re-activated. To do this, please contact Support .
If you have any questions or issues, don't hesitate to reach out to us!
Table of Contents:
What are accepted solutions?
Accepted solutions denote to other community members that the question you asked has been answered by someone in one of the comments. Anyone looking at the thread will immediately see that this question was answered and a link to the correct answer at the top of the thread, so they don't have sift through a long thread to find the answer they need.
Why should I accept a solution?
There are a few reasons. First, it notifies the community that this question was answered, and it's much easier to find the answer in the course of the thread because the answer appears at the top. Second, it's a way to recognize the help another community member received. The more accepted solutions a user has, the quicker they will rank up! Third, well, isn't there something so satisfying as marking a problem as solved? Maybe that's just me...
How to accept a solution
Scroll to whatever comment answers your question the best and click on the "Accept as solution" button. That's it! Now, the person who wrote the comment can pat themselves on the back for a job well done! Don't forget to show your appreciation by giving some Kudos on the comment!
Table of Contents:
What is the Knowledge Base?
The Knowledge Base is a collection of living documents maintained by Exasol and the Community. These documents can be how-to guides, explanations, best practices, or anything that you think might be useful for someone else to know. Formerly, it was called the solution center and is split up into 4 different categories:
Connect with Exasol
This category contains articles describing how to connect to and from Exasol with various third parties, for example ETL, connecting to other databases, connecting to BI Tools, using the Exasol Drivers, ETL UDF's and more.
This category contains articles describing how to work with core database features, including best practices, SQL, Lua Scripting, performance, transactions, users & roles, DBA tools, and more.
This category contains articles describing how to use Exasol for Data Science, including guides using various programming languages, best practices for UDF's, and more.
This category contains articles describing how to manage the environment around the database, but not the database itself, including topics like managing hardware, Exasol in the Cloud, Exaoperation, monitoring tools, Linux administration, installation & upgrades, plugins, and more.
How can I contribute?
There are many ways that the community can contribute to the Knowledge Base. Generally, we try to update articles anytime that we come across a problem and notice that something needs to updated, but it's also very likely that community members may notice improvements to articles or want to add new content. In that sense, the Knowledge Base will continue to expand, and each article can be further improved. You can contribute in the following ways:
Nominate topics to the Knowledge Base
If you find that a thread is particularly helpful, you can nominate the thread to the be basis for a knowledge base article. To do this, just click "Options" on the right side of the screen and select "Nominate to Knowledge Base".
Once it's nominated, another member of the community can approve the topic and start working on the article.
Kudos are extremely important because it signifies to other community members that the content is helpful. The more Kudos an article, the more likely it is to show up elsewhere in the community and can help others. If an article helped you, please click the "Kudos" button!
Comment on Knowledge Base Articles
If you notice a problem, you can also comment directly on the article itself and let the author know that something might need to be changed or that something didn't work as you expected. Then the author can go and update the article accordingly.
Edit Knowledge Base Articles
Once you reach a certain rank in the community, you can edit some articles yourself. To do this, just click on Options and click "Edit Article". When editing an article, you are creating a brand new version, so any changes you make won't be visible right away. When you are done, you can Request to Publish and a member of Exasol can finally publish the newer version, replacing the older one.
Create Knowledge Base Articles
Once you reach a certain rank, you'll also be able to create new Knowledge Base Articles yourself. The article will be published in your name, and you can share helpful tips and tricks that you've learned while using Exasol. To create an article, go to the category that you think is most appropriate for your article and click on the "Start an article" button on the right:
Once you're happy with your article, click on "Save and Request Publication". Our team will take a final look at the article for completeness of the content, and can finally publish it and open it to the community. If there's any problems that we spot during the review process, the reviewer will work with the author to improve the content where needed.
Tips for creating Knowledge Base Articles
A great Knowledge Base Article should be clear enough that someone who is just getting started can follow it and understand what the content is. With that in mind, keep these things in mind when creating and editing your Knowledge Base Articles:
Choose the correct category (see a description above)
Follow a pre-formatted template
Choose Labels that are most appropriate for your article
Use Labels to show which versions are compatible with the article
Add additional references and links to other articles where applicable
Create a nice teaser to show in the list - a little taste of what's to come
Add as much context to the problem as possible - articles with just a string of queries and commands aren't very useful if you don't know why they are there in the first place.
Pictures tell a thousand words - they are highly recommended, and help break up the article into legible chunks
Create a table of content at the top
With your help, the Knowledge Base will be a wealth of information for all Exasol users!
You might notice that there is a small title next to your username. This is your rank! For example, mine is "Community Manager".
Ranks are a fun way to incentivize participation, reward engagement, and establish your reputation in the community. Every member of the community is assigned a rank based on their contributions.
The ranks are ordered in the following way:
Welcome (everyone starts with this rank)
Single Node Master
Wealth of Information
Exa-Hero (The highest rank!)
What does it mean to rank up?
Ranking up comes with certain privileges! We don't want to spoil all of the surprises, but as you rank up, you will be allowed to do more and more in the community. Ranks are determined by several different metrics that determine your level of activity in the community.
How do I rank up?
The formulas are locked away in our super-secret-exa-vault. The gremlins guarding it won't let us in to retrieve the formulas! 😉
Are there special ranks?
Yes, of course. Community Managers, Moderators, Exasol Employees, and our Xperts have special ranks to denote their status.
Have fun ranking up!
I want to post a topic, but don't know where to post it. Where should I post it?
The Exasol Community is structured in such a way that there is one central discussion forum for nearly all technical topics and discussions.
Discussion Forum - The home for all technical topics. If it has anything to do with Exasol, databases, best practices, advice, etc, then the discussion forum is the place to be. If you have a question you need to be answered by the community, this is where it goes.
Welcome & Introductions - This is where you can introduce yourself, welcome new members, or ask a question about the community.
Training Forum - When working on the Exacademy, you might come across problems with certain exercises or questions that aren't working like you expect. If you have any questions or problems when going through a training, you can ask our training team directly in this forum.
Of course, if you accidentally post in the wrong forum, it's no problem! An admin or moderator can move it to the appropriate space!
There are two types of people in this world: those who clean out their inbox so that there are no new e-mails in there and all e-mails are moved to certain folders and those that keep every e-mail possible in their inbox.
I'm somewhere in between - I have rules which automatically put e-mails into certain folders, yet my inbox still has about 3000 e-mails sitting there, waiting to be organized.
Nobody likes to be spammed by thousands of e-mails that you don't want, and this is true for the community too. Fortunately, you can control which e-mails you get from the community very easily!
Changing Notification Preferences
1. Open up "My Settings" by clicking your avatar in the top right corner of the page
2. Click on the "Subscriptions & Notifications" tab and choose "Notification Settings". On this page, you see a large list of various notification settings and can change any of them to fit your needs. If you want, you can even turn off all email notifications by checking the appropriate box (we don't recommend this).
3. Change your notifications based on your needs - you can choose to be notified immediately for certain actions, and then notified only once a day or week for other actions. It all depends on how quickly you want to receive the notification. You may see some fields using the word "Subscriptions" - more on that in a minute.
To help filter out some of the e-mails, you can subscribe to boards, knowledge bases, and topics. Depending on your notification settings, you will get notified of any new content in the area you are subscribed in. To subscribe to a board, knowledge base, or topic, click on "Options" dropdown on the left hand side and choose "Subscribe"
You can also subscribe to labels that are associated within certain categories. For example, if you want to be notified of any new release, you can subscribe to the entire "Product News" Blog. But, if you only want to be notified of the latest 6.2 releases, instead of subscribing to the entire blog, you can click on the Label, and subscribe to that instead.
This way you can subscribe to the content you really want to see instead of getting notified for every new post that might not interest you. You can also customize if you are automatically subscribed to topics that you are a part of by going to "My Subscriptions" in the drop-down menu after clicking your avatar and removing subscriptions that you don't wany any more.
We hope these tips will help control the flow of e-mails in your inbox and bring peace, happiness, and order to your inbox. ☮️
Welcome to the Exasol Community. Join us for a brief introduction to the new portal. Register now and learn more about how to use the portal, post topics, kudo and get seen. See you on May 28th 17:00 CET. https://exasol.webex.com/exasol/onstage/g.php?MTID=eeae3858cd0a13b2ba160feeee675548e
Using Direct Messages in the Community
Using a direct message is an easy way to follow up on a question, or comment on an article or going deeper without being too public. (Don't spam and please remember the Community Guidelines) There are a few simple steps to follow to enable you to send messages
1. Make sure Direct Messages work for your account
Direct messaging is enabled for all users that have a verified e-Mail Adress. So, first we need to make sure your account is able to send and receive Messages:
There are three simple steps to ensure you have the right to send messages. If you see the envelope beside your Profile Picture on top of the page, you are already enabled. If not...
Verify your account
- Klick on the Profile Icon and select "mySettings", you can also change the picture if you want.
- Check if "Email verification status" is on verified and "Don't send me any communication emails" is not ticked.
- If your account is not verifies, press "Send me the verification e-mail again" and proceed.
(if this does not work or you have any other issue - send an e-mail to Community@exasol.com and we will help you.
- Verify your E-Mail (might be in your Spam)
- you should now see the Envelope beside your Profile Picture (you changed it, didn't you?)
2. See you inbox and checking Messages
Checking your inbox
- Usually you should now see the Envelope on top of your page and it has a red number indicating the number of unread direct messages.
- If you click on the Symbol it takes you to your direct messaging inbox
- to read any of the messages, just klick on the message header "Congratulations...." and it will take you to the message
- the Options menue gives you further actions on the mail box
3. Reply to a Message
Reply to a message
- as soon you have opened the Message with a klick on the Header, you will find the Delete and Reply Buttons at the End of the message
- Reply will take you to the compose message page, the text of the last message will be at the end of the page
4. Sending a new Message
Write a new message
- If you have hit 'Reply' the Sent To box will be automatically populated, if not or if you want to add additional recipients. Start typing the username. As soon as you enter three or more characters it will provide you with a list of potential users. (users without enabled messaging will not be shown)
- If you need more options to format your message you will find three little dots in the message body to give you access to more options.
- You need write more than fits your message window. The triangle at the bottom right of the window allows you to scale the window
- Done? Just Cancel 😉 or send your message.
Message from Profile
You have seen an article, or a reply that sparks your interest. But you do not want to ask in public?
- Klick on the Username of the User you want to contact
- Klick on "Send Message" and you can reach out to them directly
I hope this helps you using the Direct Messaging System in the community. If you have any further questions, just send me a Direct Message...
hmmm. or may be a mail to email@example.com if the messaging does not work.
We're happy to get your experiences and feedback on this article below!