How do you load data from a postgreSQL dB?
Greetings everyone,
I'm a brand new user to BOARD software and am simply trying to connect to some of our various data sources including our IT Ticketing system powered by Service Desk Plus ManageEngine. I've downloaded and installed the PostgreSQL ODBC connectors and was successfully able to configure and test the connection within BOARD, however, the data will not load using the MDX Federator tool. Once I save and connect, I receive an error message stating: Cannot load cubes: empty or not available database. I previously have been able to connect via Sisense and Power BI so I know the dB is available and that the tables are loaded. I've attached a screen shot of the current configuration. Any help with this is greatly appreciated.
Thanks!
Ford Reid
Answers
-
Hi Ford,
Do not use the MDX Federator tool for this, honestly I have no idea what it is for. You want to use Data Readers for your upload. Have a look on the Board Help Website and look for Data Readers: Board 10
I have loaded Data from a postgreSQL DB before and that was no issue. Just make sure that the users you are using for ODBC has read and write access to the database.
Cheers,
Daniel
9 -
Hello,
the MDX federator is used for multidimensional database such as MS Analysis Service or SAP BW. Since PostgreSQL as far as I know is a relational database, you should just create an SQL Data reader in combination with your ODBC connection.
Hope this helps
Pietro
5 -
I haven’t used it much, but here is an article where folks are discussing when to use the mdx federator
Load data from Analysis Services using MDX Federator or OLEDB Connection
3 -
Thanks everyone! Turns out the original postgreSQL config I generated was correct, however, I just needed to build the connection on the BOARD server and not the desktop client. Once created there, this allowed me to see the postgres ODBC connection in the Date Reader/ODBC Drop down within the BOARD client.
This also brings up another question, do all server/local data source connections need to be configured through the BOARD server first as best practice? The only other data source connection adapters I see are the Cloud adapters found in the Extract manager in the Data Fast Track tool.
Again, all your replies and assistance are greatly appreciated.
Thanks!
Ford Reid
1
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 159 Academy
- 325 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 192 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 337 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP