Skip to main content

Posts

Tableau and MariaDB connectivity issues

I am trying to connect Tableau Desktop (tried version 9.2 and 2018.1 both) with MariaDB (Server version: 10.0.20-MariaDB-log MariaDB Server). I am selecting MySQL in the list of data source servers in Tableau. The connection is getting established but 1. Databases are not visible 2. Custom SQL is not available Data refresh 3. Live or extract options are not visible What am I doing wrong? Solved Almost all the posts mention that connecting to MySQL data source works perfectly fine if we need to connect to MariaDB. There are, however, few differences. Follow these steps in case of similar problem: In connecting to the data source, select Other Databases (ODBC) Select Driver and choose MySQL ODBC 5.3 Unicode Driver Provide connection details like server IP, port, username and password that is used to connect with MariaDB That's it.
Post a Comment
Read more
Recent posts

how to get substring in soy template?

I have soy template in which I want only 28 character if the length is more than 30 characters? how to get that? {if $attributes.subAccountNumber.length {$attributes.subAccountNumber} {else} {$attributes.subAccountNumber.substring(0,28)} {/if} But on compilation it throws exception, Exception in thread "main" com.google.template.soy.base.SoySyntaxException: In file war/js/Application/Reports/ViewTemplates/ReportsViewTemplate.soy:518, template acti.workflow.reports.transcriptCard: Not all code is in Soy V2 syntax (found tag {$attributes.subAccountNumber.substring(0,28)} not in Soy V2 syntax). at com.google.template.soy.base.SoySyntaxException.createWithoutMetaInfo(SoySyntaxException.java:52) at com.google.template.soy.soytree.SoySyntaxExceptionUtils.createWithNode(SoySyntaxExceptionUtils.java:48) at com.google.template.soy.sharedpasses.Assert...
Post a Comment
Read more

Use a second AWS account for s3 files in laravel

I am using laravel and need to use a second aws account for publishing to an s3 bucket. I have been using some s3 buckets for internal use in the framework, however I have another external aws account I need to use and send files to. Of course I have the access key and secret for this new account, just not quite sure how to setup the config, etc in laravel. Using laravel 4. Solved Found a way to do this without using the config settings using the factory: `$s3 = \Aws\S3\S3Client::factory(array( 'region' => 'region-name', 'key' => 'key', 'secret' => 'secret' ));`
Post a Comment
Read more

Having Issue With pulseaudio Under Ubuntu 16.04

I am having an issue that my pulseaudio application in my machine running Ubuntu 16.04 cannot detect the location of the modules, and thus cannot load them and subsequently cannot detect any sound hardware (even though my sound cards are all detected, say, using this command: lspci -v | grep -A7 -i "audio" ). For instance, it cannot detect module-udev-detect unless I provide it with the absolute path in the default.pa file, and if I do so, I will be able to see a "Dummy Output" sound device, but that's not enough because module-alsa-card is not loaded. I have tried almost every solution out there, including the original Ubuntu wiki pages and those pages that direct me to remove, purge, and install the pulseaudio and alsa-base packages again. I believe the problem lies specifically in not finding the modules path in the first place, and I would like to know if I can fix this somehow?
Post a Comment
Read more