MySQL sandbox server outage

The MySQL sandbox server (sh-tapi.keboola.com) is currently not available, we're investigating the cause.

Update Jan 20 5:35pm CET

The backup MySQL sandbox server tapi-sandbox-fallback-3.keboola.com is up and serving all sandbox requests. All previous sandboxes were deleted and all credentials cleared. We'll be transitioning back to the original server sh-tapi.keboola.com tomorrow. Please check your sandbox credentials to be sure you're logging on the right server.

We're sorry for this inconvenience and thanks for your understanding

Update Jan 21 5.33pm CET

The original MySQL sandbox server (sh-tapi.keboola.com) is back up. All new sandboxes will be created on this server, all currently existing sandboxes will remain on tapi-sandbox-fallback-3.keboola.com and will be purged on Sunday night.

End of Life Announcement for Sardine

Over the past few years, we’ve introduced several standalone Keboola Connection Applications that accomplish specific tasks. With our focus shifting to core Keboola Connection, we’ve made the decision to discontinue support for the Sardine App. This means that as of today, January 15th, 2016, we won't be making any further Sardine improvements or updates.  As of April 15th, 2016, support for Sardine will be completely discontinued.  

What will happen after April 15th, 2016?

You can expect that Sardine will continue to work as normal for some time. However, future updates of related APIs might result in certain features breaking. Since Sardine will no longer be supported, we won't be updating it in these cases.

Suggested Alternative

For clients using Sardine to provision users for their GoodData's projects, we suggest you to switch to the 3rd party Keboola Connection application made by BizzTreat.com. You can find it in Applications. Please don't hesitate to contact BizzTreat.com with feature suggestions or for help with implementation.

For clients using Sardine for GoodData access via a branded UI, we suggest using the http://www.dashboardizer.com/ developed by Slowpath.com. Feel free to contact them directly for a quote.

Zuora Extractor

Zuora is a subscription management platform that spans across commerce, billing, and finance.

The brand new Zuora Extractor can download all the available data in their API using the Aggregated Query API. Just create the query with all the data you need for analysis or reporting and boom! You have it in KBC. Simple as that.

This extractor is developed independently by Singapore Keboola office. For more information on how to use the extractor, please refer to the documentation. In case you run into some issues or you have more questions, please contact me directly. 

Vojtech Kurka

(vokurka@keboola.com)

Silverpop Extractor

Following the good news about Silverpop Writer, I am very proud to present you with its companion, the Silverpop Extractor.  This closes the data flow loop for improved handling of your Silverpop audiences.

With this new component you can easily download aggregated reports of recipient engagement as well as complete raw contact and event lists.

This powerful combination allows you to create simple reports as well as advanced analytics of your e-mail campaign metrics. A simple configuration gets you up and analysing the data in just a few minutes. Try it out!

This extractor is developed independently by the Singapore Keboola office. For more information on how to use the extractor, please refer to the documentation. In case you run into some issues or you have more questions, please contact me directly. 

Vojtech Kurka (vokurka@keboola.com)

SilverPop Writer

IBM Silverpop Engage is powerful cloud-based digital marketing platform that provides email marketing and lead management solutions. It allows to create effective email marketing campaigns leveraging behavior-based customer insights. Silverpop provides an XML API interface allowing integration with other systems such as KBC which allowed the creation of this component.

The new SilverPop writer component allows you to update various contact data for your Silverpop email marketing campaigns directly from KBC. It uses Silevrpop's asynchronous API calls allowing you to easily add or update large volumes of data directly in the specified Engage database or contact list(s). 

You can easily upload data from any of your out. tables by specifying it in the Table Input Mapping section. Then you need to provide your login credentials for the Silverpop Engage portal along with Url's of the API endpoint and sftp server in the configuration parameters.

There are various configuration parameters that can be set. You can set columns you want to export, mapping of the exported columns to the Engage database, contact list id's and many others. All of the configuration parameters are thoroughly described in the documentation on github repository.

The component was developed as a 3rd party extension to KBC. If you have any questions regarding the component, please do not hesitate to contact me at esnerda@gmail.com.


AdForm Master Data extractor

This new extractor now makes it possible to retrieve data from AdForm Master Data service and store them in KBC for further analysis. Importing any of the specified tables within required interval is easily done just by specifying their prefixes in configuration parameters. 

You can either retrieve just fact tables or include metadata tables of your choice as well. All you need to do is to specify login credentials, the name of a bucket, list of table/metadata prefixes and time interval in the configuration. The tables will then be imported into the specified bucket,

Note that the primary indexes of the imported tables need to be set manually in KBC. More information on the component and configuration settings can be found here.

The component was developed as an 3rd party extension to KBC. If you have any questions regarding the component, please do not hesitate to contact me at (esnerda@gmail.com).

Some failing data uploads in GoodData Writer

In last days several errors with message like "Could not export table out.c-main.products from Storage API: Table Activities not found in bucket out.c-main." appeared unexpectedly. It is direct consequence of this change from December. When you call upload project or load-data and load-data-multi API calls without parameter tables, Writer takes all configured tables and tries to upload them. But when some table is missing from Storage API and still has configuration in the writer, this failure happens. And it didn't happen earlier because Writer automatically removed configuration for deleted SAPI tables.

But because this problem confused several of our clients, we decided to make this behaviour more comfortable. Now if you call upload project or load-data and load-data-multi without parameter tables, Writer will ignore configurations of non-existing tables and won't fail. However if you call load-data or load-data-multi with explicitly listed tables (in parameter tables) and some of these tables doesn't exist, the job will still fail.

We apologize for the confusion.

SFTP/WebDAV Writer

I am happy to announce another component for Keboola Connection, a SFTP/WebDAV Writer, created in our company - Blue Sky Media. For those of you who haven't met me yet, let me introduce myself. My name is Radek Tomasek and I want to write a quick summary about this extension.

A long story short, this component allows you to upload data from Keboola Storage to your SFTP/WebDAV location.

The configuration is very straightforward. There is a Table Input Mapping helper which helps you select tables from Keboola Storage and prepare them for the upload. The rest of the configuration is about adding a few parameters to the Input Parameters component. A complete specification is available in the documentation.

In case of any issue/question, don't hesitate to contact me (radek@bluesky.pro). I am more than happy to help you with the configuration.