Due to networking issues a few orchestrations failed around 5:15 PM PST.
The problem is resolved now, sorry for any inconvenience.
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.
(vokurka@keboola.com)
GoodData platform is experiencing some technical difficulties, details can be found here: https://support.gooddata.com/hc/en-us/articles/215573708
The problem affects access to some projects according to the statement but it looks that login to the frontend isn't working too. Some jobs of GoodData Writer may be also affected.
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)
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.
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).
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.
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.
Between 5:29pm CET and 5:46pm CET there was an outage in one of the Transformations components. All transformations starting, ending or going between phases during that period were terminated with an application error. All affected transformations were resumed and all other transformations remain unaffected.
We're sincerely sorry for this inconvenience!
It's difficult for me to write a quick summary about Dropbox Extractor - project that I had been developing and tuning for a while. But I'll try anyway and I am sure the wait for the result was worth it!
First of all, thank you for your patience! :-) The main reason for such a long development time was that I wanted to reach the best user experience I could. Of course, the first idea was to use a default GUI for Docker infrastructure. But I guess this approach would be enough only for specific connectors like iTunes Connect or Youtube Reporting Api, not for Dropbox, where a bigger adoption is expected (if the UX is good enough).
For that reason I was sure I wanted to write my own GUI that makes the work with the Dropbox very straightforward. The idea sounded great, but my problem was I had little (almost none, in other words) knowledge of frontend development and zero knowledge of React/Flux. However, my eagerness to reach a certain level of JavaScript full-stack development competence helped me to start with actual development and learn everything on the fly. And I never regret that decision, despite the fact, it took me a little bit more time to really understand what is going on, how to write a React/Flux code and how components in Keboola Connector are composed.
A month ago a production version was completed, but I still wanted to add some more features and improve the overall user-experience. Now I can proudly share the result of that effort. In a nutshell, you can simply select files from your Dropbox and upload them to your Keboola storage, but after a deeper look you will find features like:
- Selecting CSV files and assign them to various KBC buckets (one file can be assigned to multiple buckets).
- In case of selecting two files with the same name, they will either keep the actual name (if two different buckets had been selected) or distinguish between each other by adding a simple hash.
- Bulk or single file upload.
- Output table details in configuration list.
Well, I would love to say thanks to Keboola developers, to Martin Halamicek in particular. His hints and debugging skills helped to define what the Dropbox Extractor is now today and I just hope you enjoy it in the same way as I do! And of course, any feedback is welcome! Enjoy!