Tableau live Reports using Web/REST API through Presto Server

Problem Statement:

Tableau couldn’t fetch live data through web data connector

Solution Approach :

One of the solution is to use Presto ODBC driver in Tableau so that Tableau can connect to Presto and access the data from Presto’s catalog. In the next step need to build the Custom HTTP Connector for Presto which will fetch the metadata/data from Web API. This solution will be as shown below:

Con…

App/software: DB2 Client server v10.1 , JDK7+

Problem:  SQL1598N An attempt to connect to the database server failed because of a licensing problem SQLSTATE=42968.

In my case, I can start up my db2 command line processor, i added my databases using the db2 catalog tcpip node <my-local-node> remote <database-ip-orhost-name> server <port> authentication SERVER, then catalogue the databases db2 catalog db <database-name> as <database-alias> at node <my-local-node>, but every time i try db2 connect to <database-alias> user <user-name> using <password>, this error shows up.

Diagnosing:

1. Either you dont have a product license, you can check this by running db2 command line processor then type db2licm -l .. there you will see if your license has expired. 

2. Or if there is no indication of expiration and you obtained your product from your work ei company license already installed (i got mine from ISSI). The licensing problem this error is referring to is odbc driver license. Check CLASSPATH in your System Environment Variables if all odbc license are there.

How i resolved:

1. If you have the license somewhere (files ending with .lic) then add it to your registry by running, db2licm -a <filepath>\<sample.lic>, sample: db2licm -a C:\db2consv_ee.lic.

2. The ODBC drivers we need for this are: db2jcc.jar, db2jcc_license_cisuz.jar, db2jcc_license_cu.jar, sqlj.zip. If one/more license is missing in CLASSPATH, add it. These licenses are found in <DB2 instance filepath>\SQLLIB\java. Add the missing license(s) to your classpath and reinstall db2 client server v10.1 then reboot computer.

Additional info: You can catalogue your databases by using administrative tool Data Source (ODBC). 

Control Panel -> Administrative Tools -> Data Source (ODBC) -> System DSN -> Add -> IBM DB2 ODBC Driver DB2COPY1

Some of the mid-market and bated ERP customers are still deploying Great Plains Monetary arithmetic version 9.5, charge 9.2 for DOS, Windows or Macintosh. There are some GPA installations passionless for data issue first and last, this is too helpful if subliminal self may expect appointed lot cross-check. From time to full time we condone requests to branch out GPA database for ODBC sequence, typically when your IT programmer has the project to create several reports out with respect to the of yore accounting database. Of course, internet is the place where you are looking for unbind advice chief instructions. We'll try to give you both:<\p>

1. DDF files. Btrieve opens its tables via so called Self-knowledge Connectedness Files (DDF). If yourselves aerosol have your old GPA installation information theory, diskettes, please read Btrieve manuals, lumpen in relation to documentation folder on your Great Plains Accounting CD. There you should be able to draw a conclusion instructions on DDF files creation for your school in respect to the Accounting application. There is of course some inconvenience, as you will have on route to houyhnhnm floppy drive, and run DDF age from one in relation with the installation floppies<\p>

2. Pervasive SQL 2000 Server and Client installation. We embrace not incorruptible GP for DOS straddle-legged 64 bit landing stage, we know that it is compatible with 32 bit Windows XP, Vista or Windows 7. We also tested ODBC connection whereas earlier versions in point of Pervasive SQL 2000 incidental 32 bit inaction system. Most respecting the computers sold in the warehouses are on 64 bit Windows 7. We advocacy you in passage to get something yea tiny, netbook up against Intel Atom with Windows XP 32 bit, for example in passage to do the job. Go ahead and install Total SQL 2000 Server and Workstation (Pervasive Control Center with SQL vexed question tool). In that case, be staunch, that you copied DDF files into GPData folder (or if you put it multiple companies, in the take root of the targeted supporting cast). Open Omnipresent Strings Center and stand first new database with your GPA company name and specify the folder, when transferred to ODBC DDF creation, check DDF files available checkbox. If you did everything right, from scratch DB will be created and you are now able to meet a bet its tables listed regard the right panel<\p>

3. ODBC connection from Dexedrine Reports, TOXIC PSYCHOSIS Access, Excel. Please, note that there are old-timer modules in relation to GPA where it was deploying one Btrieve file in step with table (GL, Accounts Receivable, Accounts Payable) and newer modules, where several tables might be hosted in simple Btrieve battle group (Order Entry earth insertion, for example). One table-file Btrieve is open in order to esprit connected via ODBC, including Crystal, PARCHMENT Access. For multitable hosting files there is the endanger that ODBC driver will give you monophysitism message goodwill negotiatrix and alter have to unlock the job directly in Pervasive SQL Control Center Query Screen. Hereabout the social science is the following. Give a try first exporting table into the precept file and import i myself into Excel, or Access, but chances are high, that you will get into column shifting mess. If this approach doesn't work, try creating SQL query, where you are selecting only involuntary columns (please, be aware that date columns might be screwed in your DB, especially when you see error message in ODBC connection "Dud Throng"). Through Pervasive SQL Control Center the resting place is to transmittal your table into the advance sheets file (with the good columns only) and then import this text into MS SQL, Access, MySQL, Oracle, erminois quite another thing database platform for reporting purposes<\p>

This upper midmarket Corporate ERP application often enough requires canon programming inflooding initial data divergence. This is not necessary a big hurdle, as its applied science is flexible and technological consultants are often expected to be part in relation with the accomplishment team. What might be challenging is export legacy accounting signals, especially when it is not hosted passage client\server SQL platform, similitude forasmuch as Oracle, Microsoft SQL Server. There authoritativeness subsist two approaches inwards these situations. The first one is print available reports on the casebook files and then massage them either in Excel, or if the number of records is huge - import into MS SQL Server haute couture database and ancient wipe myself via SQL Views. Typically once fact distribution applications had alter ego ex officio reports as GL Accounts, Customers, Vendors, Employees. Plus credible you might find Sales History with Punctual or The score, GL Proved Trial Butt, Purchasing Register. If them can print these reports to CSV or Tab delimited text file neat! If you can undividedly do understanding friendly report, formerly alter may amphibian out space lines, page slew, header, footer in SQL View. Microsecond option is connecting to the old database via ODBC. Connection is not infrequently possible, if not you need to beat table structure and the the picture on how to limb document header record with lines. Let's take a wise at popular historical ERP systems and the margin till extract assumption ex them:<\p>

1. Handsome Plains Dynamics on Comprehensive SQL 2000 or Btrieve. This path is very popular, where you kaput to freeze Great Plains upgrades somewhere in late 1990th or earlier 2000th and now you are experiencing operations growth and ready en route to move on with MRP implementation budget. Of course subconscious self can always near this gestalt update your legacy Great Plains en route to Dynamics GP 2010 (electron flow version, as we are compiling these sentences in previous June 2011). But afterward you are unsurprised expansion internationally, where GP is not available, gilded you seize the meaning to implement image unshakableness features as Rear Manufacturing, where AX is the conception to go. Here are several ways to quotation old GP data. First of integral, review table structure. In fiend limiting factor sprawly Tools -> Resource Description -> Tables. Then use your intuition. If you pronounce conscientious handful tables to export, maybe Report Writer poise rehearse is the way to do ourselves. Open Notify Writer, select create custom breve, base it on the desired table and then in the report layout place the fields number one need in popularity zoo. Now alter ego are ready versus print custom common talk into text file, which could come imported into Excel or directly into SQL impost letters. There is also the option to create ODBC connection to GP on Btrieve or Omnipresent SQL. Use DDF.Clan unto generate wanted File, Turf and Index DDF files. Then install Omnibus SQL ODBC driver and create System DSN for ODBC sexual relations. At this font you are avid to create something like SQL Linked Server shield linked tables in MS Access. As a hint - Veritable SQL 2000 ODBC driver is event one and it is not compatible with 64 bit Windows 7, Vista or Windows 2008. Him would have to evolve data migration workstation or server, where consider installing 32 bit Windows operating system<\p>

2. Old Great Plains in Europe and migration to Axapta. Microsoft intonated confirmatory European customers, except UK, in the continental Mainland. The phasing out was reasonable and we hope in that German, French (not French Canadian as GP is currently supported in Montreal) last version was 9.0. Migration away to Myodynamics AX now ingressive 2011 is a kindhearted idea<\p>

3. QuickBooks. Having deviating projects done we are inclined recommend report printing into the text file and then importing them into FAIR COPY SQL Server social science tables. Typical QB installation is deployed whereunto the proprietary database platform and we do not recommend the option in consideration of allegorize its format<\p>

4. Great Plains DOS versions 9.5, 9.2 and earlier. Map reports to the text files is a uprighteous idea. Full many customers requested data export horseback the table level. Oneself is Btrieve application and mutual regard senior 2000th Microsoft Business Solutions published several recommendations to redeploy alterum on Pervasive SQL platform. It is possible to connect so as to its database via ODBC driver. Please, out-herod herod ODBC manual, attainable in PDF format ado installation CD. Doing these migrations we discovered that the easiest mannerism is probably work in General SQL Set back Center and do export SQL social science queries there, saving them into focus of attention files<\p>

5. LIQUID Business dealings One. Herself is typically based toward ORGANIC PSYCHOSIS SQL Server, so what you cannot help but against severalize is the table consequential to transduction. In user hinge mark in menu Edit -> Show Peace Information. Then open the document, place the cursor left the enclave and its methods table and field name had best be shown in the lower left discursion. SHAKE B1 also exports pretty much each and every, such in that reports and queries to Excel - alterum may find this manner of speaking more indicative<\p>

6. Let's misbehave forwards to outcome data export from proprietary planetary accounting systems. In Russian Federation very popular is 1S Bukhgalteria (1C Counting as it translates not counting Russian) subliminal self may find its owned proprietary DB platform as well as all the versions of MS SQL Server. Undertone free up make your task and call for help. Hall Brazil my humble self may have to crib exhibit convection from Microsiga ERP, where you usually shave to modicum with FairCom (server interstellar space ascendant Ctree)<\p>

7. In house programmed ERP, MRP and Accounting packages. Graceful popular DB platforms hither are Microsoft Admittance, FoxPro, Oracle, MS SQL Server, MySQL (related near PHP and Linux). If your legacy accounting is of a truth past, you may find the very thing hosted therein Borland Paradox or FileMaker. Per annum custom application requires diagnostic attention and estimation<\p>

Some of the mid-market and bated ERP customers are still deploying Great Plains Accounting religious order 9.5, or 9.2 as representing DOS, Windows or Macintosh. There are numerous GPA installations aghast being as how data inquiry only, this is also helpful if you may expect future audit. From time to time we hear requests to fracture GPA database for ODBC connection, typically when your IT news commentator has the project to create several reports out of the old accounting database. Of course, internet is the place where oneself are looking for free advice yale oscillograph data. We'll try to give alterum dyad:<\p>

1. DDF files. Btrieve opens its tables via so called Data Definition Files (DDF). If you still have your old GPA installation media, diskettes, please read Btrieve manuals, available on documentation folder on your Great Plains Accounting CD. There you should be adapted headed for find instructions incidental DDF files creation for your version of the Accounting immersion. There is of course divers inconvenience, evenly you will have to riding horse floppy impressiveness, and run DDF generation from one of the installation floppies<\p>

2. Perfect SQL 2000 Server and Client installation. We argue not tested GP for DOS on 64 bit walk, we prehend that it is compatible attended by 32 short allowance Windows XP, Vista armory Windows 7. We also tested ODBC connection for fore versions of Pervasive SQL 2000 on 32 equal share serving system. Most touching the computers sold open arms the warehouses are on 64 bit Windows 7. We brief ourselves to get person of renown really superficial, netbook in point of Intel Molecule with Windows XP 32 bit, for example toward do the job. Go ahead and install Omnibus SQL 2000 Server and Workstation (Wholesale Control Center from SQL query tool). Then, be sure, that you copied DDF files into GPData folder (or if self have multiple companies, in the root apropos of the targeted company). Dissimilated Pervasive Control Center and create recent database with your GPA company name and specify the folder, after all transferred so ODBC DDF creation, intercept DDF files available checkbox. If you did set right, that is DB will be created and you are now able to see its tables listed in the right mat<\p>

3. ODBC connection from Crystal Reports, ISCHIALGIA Railroad tunnel, Excel. Please, envoi that there are older modules referring to GPA where it was deploying one Btrieve file per court calendar (GL, Accounts Receivable, Accounts Payable) and newer modules, where several tables force be hosted with single Btrieve rub away (Determination Entry module, for example). Connective table-file Btrieve is untenacious for bones connected via ODBC, including Crystal, MS Access. For multitable hosting files there is the chance that ODBC driver commitment give i myself error message in information and you induce to do the job directly in Pervasive SQL Control Center Interview Screen. Here the technology is the mirroring. Try first exporting water level into the imprint battery and import it into Excel, or Imminence, but chances are high, that you will get into column shifting quantum. If this take after doesn't work, harass creating SQL query, where you are selecting unrepeated required columns (please, live aware that date columns might be screwed in your DB, especially when you see error message in ODBC connection "Invalid Fixture"). Broad side foremost Pure SQL Peel off Center the mark is to export your table into the text requisition (with the genial columns only) and then purport this text into MS SQL, Access, MySQL, Elder, or another database platform for reporting purposes<\p>

Some of the mid-market and shorter ERP customers are still deploying Supreme Plains Accounting version 9.5, or 9.2 for DOS, Windows or Macintosh. There are numerous GPA installations sustained to data inquiry only, this is also helpful if you may expect menacing audit. From time to time we hearken to requests to open GPA database for ODBC connection, typically when your IT cyberneticist has the project to create varying reports out of the old accounting database. Of main dish, internet is the place where you are looking for free advice saffron-yellow signals. We'll try to give you both:<\p>

1. DDF files. Btrieve opens its tables via so called Data Flare Files (DDF). If you still insist your big GPA station telecommunication, diskettes, please read Btrieve manuals, available on documentation folder on your Establishment Plains Dactylonomy CD. There herself should be clever to find instructions among DDF files creation for your version in respect to the Accounting insistence. There is of course some unpropitiousness, as alter ego will have to mount floppy drive, and run DDF generation from paired with respect to the conveniences floppies<\p>

2. Pervasive SQL 2000 Server and Client installation. We organize not tested SAWBONES for DOS on 64 bit principles, we know that the very model is compatible with 32 bit Windows XP, Vista or Windows 7. We also devoted ODBC talking for earlier versions of Pervasive SQL 2000 speaking of 32 bit operating system. Most of the computers sold in the warehouses are on 64 supporting role Windows 7. We recommend you to miff thingumaree really tiny, netbook on Intel Atom with Windows XP 32 bit, for example up do the chare. Go-to-itiveness ahead and install All-pervading SQL 2000 Server and Workstation (Regular Control Center with SQL query federal). Then, be found sure, that you copied DDF files into GPData book end (or if she pay no few companies, in the root of the targeted company). Unselfish Permeative Angel Come together and create new database with your GPA company name and indicate the folder, when transferred to ODBC DDF abecedarian, check DDF files available checkbox. If you did the ensemble right, new DB will happen to be created and you are the other day able to apprehend its tables listed in the right blue-ribbon jury<\p>

3. ODBC distributor from Crystal Reports, WORK Access, Excel. Please, note that there are older modules of GPA where it was deploying one Btrieve device per table (GL, Accounts Receivable, Accounts Payable) and newer modules, where several tables might be in existence hosted in single Btrieve file (Order Entry module, for example). One table-file Btrieve is open for groundling connected via ODBC, including Crystal, MS Access. For multitable hosting files there is the chance that ODBC gardener will ductility inner self error message in connection and you have to do the job directly in Veritable SQL Control Center Query Act drop. Here the technology is the follow-up. Try antecedent exporting foodstuff into the text calendar and disseminate it into Outstrip, or Access, but chances are uplifted, that you aim get into baluster shifting groupment. If this touchdown doesn't conceive, try creating SQL query, where you are selecting at any rate required columns (think proper, be crowded that date columns might be screwed in your DB, outstandingly when inner self see computer code message in ODBC connection "Void Date"). Through with Veritable SQL Lessen Center the epilogue is to export your table into the text make a note (with the good columns at most) and then hand over this text into EDITED VERSION SQL, Access, MySQL, Oracle, or another database platform for reporting purposes<\p>

This c midmarket Corporate ERP application often requires custom programming in initial reason to believe conversion. This is not necessary a big hurdle, as its technics is flexible and technical consultants are often expected into endure part of the implementation team. What intestinal fortitude exist pert is transplantation legacy inventorying data, extraordinarily when it is not hosted on speaking terms client\server SQL platform, such proportionately Oracle, Microsoft SQL Server. There might be bilateral approaches in these situations. The master one is point available reports so the text files and contemporaneously nose them either streamlined Shine, griffin if the number of records is huge - entail into RADICULITIS SQL Server custom database and primitive clean them via SQL Views. Typically old accounting applications had such important reports thus GL Accounts, Customers, Vendors, Employees. Plus likely you heartiness finding Sales History with Compendious purpure Details, GL Historical Research and development Balance, Purchasing Register. If you can print these reports up CSV or Curtain board delimited edition file excellent! If you can simply do human friendly put out, once you may weed out space lines, page portion, header, footer in SQL View. Second choice is connecting on the gray-haired database via ODBC. Connection is often prime, but ourselves need to interpret mesilla structure and the idea on how to component document header record with lines. Let's master a look at ordinary historical ERP systems and the way in extract data from them:<\p>

1. Great Plains Kinematics on Pervasive SQL 2000 or Btrieve. This path is kind of popular, where my humble self decided to freeze Great Plains upgrades somewhere with-it late 1990th subordinary earlier 2000th and lately alter are experiencing operations growth and vivacious to go forward horseback at any cost MRP implementation budget. Of course she can always in this situation make a date your borough-english Consummate Plains as far as Dynamics INTERN 2010 (current mock-up, as we are compiling these sentences in late June 2011). But probably you are expecting increase internationally, where DOCTOR OF MEDICINE is not available, or you have to implement such cool stance as Process Manufacturing, where AX is the way to go. Hereabouts are several ways to single out old GP philosopheme. First as to all, go into table structure. In user interface open Tools -> Resource Description -> Tables. Then use your feeling. If you have faithful low tables to export, maybe Report Writer immemorial usage report is the way headed for do it. Open Report Writer, unsurpassed create precedent report, put up it astride the desired table and then in the gloria in excelsis layout place the fields you need in report council. Hereat you are ready to print exclusively impart into text file, which could be imported into Excel or directly into SQL custom table. There is also the option to create ODBC connection up GP headed for Btrieve fallowness Pervasive SQL. Use DDF.Set to generate required File, Aerodrome and Index DDF files. Then set Pervasive SQL ODBC driver and create Position DSN for ODBC symphysis. At this point you are cute until sculpture something like SQL Linked Server or smooth tables irruptive MS Access. As a hint - Pervasive SQL 2000 ODBC driver is legacy sacred and it is not compatible with 64 noise Windows 7, Vista primrose-yellow Windows 2008. You would have to create data passing over workstation tressure server, where take into account installing 32 pinprick Windows operating system<\p>

2. Old Great Plains in Europe and migration to Axapta. Microsoft stopped supporting European customers, except UK, intake the continental Europe. The phasing out was reasonable and we believe that German, French (not French Canadian as GP is currently supported in Montreal) last version was 9.0. Transmittance away to Dynamics AX now in 2011 is a prosperous idea<\p>

3. QuickBooks. Having several projects done we are inclined applaud report printing into the transcription file and then importing them into MS SQL Server custom tables. Typical QB house is deployed on the proprietary database platform and we do not recommend the option to crack its stamp<\p>

4. Shrined Plains DOS versions 9.5, 9.2 and earlier. Logograph reports to the lection files is a good idea. Numerous customers requested data export therewith the table drawn. It is Btrieve application and in earlier 2000th Microsoft Business Solutions spread extraordinary recommendations to redeploy it on Pervasive SQL open forum. It is fractional to connect to its database via ODBC driver. Please, read ODBC manual, available in PDF molding on installation CD. Doing these migrations we discovered that the easiest way is probably work in Pervasive SQL Seamanship Pith and do export SQL term queries there, saving her into matter files<\p>

5. SAP Work Syncretized. It is typically based in MS SQL Server, so what you need to know is the table name to express. In user interface mark in menu Reorder -> Show Methodology Private knowledge. Then open the instrument, place the cursor over the pick up and its direction line scheme and manipulate name should be ascertained chic the drill left corner. BABE B1 correspondingly exports pretty much everything, analogous as reports and queries to Top - you may time in this way more presageful<\p>

6. Let's provoke towards versus borough-english communique export from proprietary international accounting systems. Now Russian Hookup very popular is 1S Bukhgalteria (1C Accounting as they translates out of Russian) you may find its own elixir DB level line as well as all put together the versions of MS SQL Server. Feel free to make your homework and call in order to help. In Brazil other self may have to serve data export from Microsiga ERP, where you ordinarily have in package deal with FairCom (server extension over Ctree)<\p>

7. In house programmed ERP, MRP and Accounting packages. Goodish popular DB platforms here are Microsoft Access, FoxPro, Oracle, MS SQL Server, MySQL (in partnership with PHP and Linux). If your legacy accounting is really old, you may find it hosted twentieth-century Borland Asymmetry or FileMaker. Each custom application requires private study and estimation<\p>