Category Archives: Data Connection

“Joining” Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

How to Create a Secure Gateway for Planning Analytics

There are a couple of elements that must be established to make the secure gateway work. There are server side and local side requirements. This post deals with what has to be done on the IBM server so you can connect it to your local data. For instructions on establishing the local side of the connection, please see this post. Server Side Configuration In the Welcome Kit from IBM, there is a … Continue Reading