Welcome to the Exasol Community! From all of us at Exasol, we're happy to have you here! What is the Exasol Community? The Exasol Community is your one-stop-shop for all things Exasol. It's a place to engage 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.  While our community was designed with Exasol users in mind, we welcome everyone with an interest in data, advanced analytics, and sharing insights as long as you observe our community rules and abide by our Terms of Use and Privacy Policy.    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.   8. Advertising 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.   Inappropriate Content 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   Contact 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
View full article
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!    First Steps 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. Community Structure The community is centered around three overarching themes:  Learn Engage Get it Learn Name What you'll find here Documentation Official Exasol Documentation including Syntax Diagrams, Installation Instructions, Update Guides, and more Knowledge Base 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. Product News The latest releases and updates to our Database and Github Projects Tech Blog 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. Training Information and discussions on Exasol's Training Program Exasol Roadmap What we are working on, what we released recently, and what we consider doing next. (only available with a MyExasol Account). Resources Whitepapers, case studies, reports, and more   Engage Name What you'll find here Getting Started All the resources you need to get started in the community (like this!) and a place to introduce yourself Discussion Forum 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 User Groups centered around a topic or location - you can also find content and information about the next meet-ups! Ideas Help shape the future of Exasol by creating and voting on ideas (only available with a MyExasol Account). Support Information about the support process and contacting support   Get it Name What you'll find here Free Trial Try out Exasol for free  Exasol in the Cloud Deploy Exasol in the Cloud using our Cloud Deployment Wizard Download Center 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  😀
View full article
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!
View full article
This article will give you some basic information on how to start a new topic or article in the Exasol Community
View full article
  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 Existing Users If you have a MyExasol Account already, just register for the community here and send an email to the community team with your username and your company name. We will verify your account and upgrade it.    New Users 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.    Credentials 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.  System Name URL User Name Password Exasol Community https://community.exasol.com/... Username created during registration Community Password Support Ticketing System (Jira) https://exasol.com/support/... Company E-mail address MyExasol Password User Portal https://exasol.com/portal/... Company E-mail address (same as above) MyExasol Password (same as above)   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!
View full article
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!         
View full article
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:   Category Content 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.  Database Features 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. Data Science 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. Environment Management 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.   Give Kudos! 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!  
View full article
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) Just Joined Settling In Just Browsing Hanging Out Observer Padawan Contributor SQL-Fighter Single Node Master Rising Star Performance Tuner Platform Juggler Cluster King Wealth of Information Rockstar Problem Solver Troubleshooter Superstar Legend 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! 
View full article
Question I want to post a topic, but don't know where to post it. Where should I post it? Answer 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!
View full article
  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.   Subscriptions 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.  ☮️  
View full article
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
View full article
Top Contributors